trees

244 rows where qCaretaker_id = 2 and qSpecies_id = 35 sorted by Latitude

✎ View and edit SQL

This data as json, CSV (advanced)

qCaretaker_id ✖

  • Private · 144 ✖
rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude ▼ Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
106955 211009 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 500 Junipero Serra Blvd 25 : Tree Private 2     4 Width 0ft   5991341.55983 2093667.80622 37.728315229259 -122.472203623507 (37.728315229259, -122.472203623507) 9 8 4 64 40
85596 87013 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1184 Oakdale Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   12/05/2007 12:00:00 AM     Permit Number 49946 6017813.5 2093492.6 37.7293305991048 -122.380675823117 (37.7293305991048, -122.380675823117) 10 3 8 58 1
54367 253555 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 27 Ceres St 1 Front Yard : Yard Tree Private 2 FUF         6013919.66127 2093997.42296 37.7305010827376 -122.394172607985 (37.7305010827376, -122.394172607985) 10 3 8 58 1
42016 87018 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1200 Oakdale Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   12/05/2007 12:00:00 AM     Permit Number 49948 6017188.8 2093995.7 37.7306775177665 -122.382870487304 (37.7306775177665, -122.382870487304) 10 3 8 58 1
165176 87017 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1200 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/05/2007 12:00:00 AM     Permit Number 49948 6017188.8 2093995.7 37.7306775177665 -122.382870487304 (37.7306775177665, -122.382870487304) 10 3 8 58 1
21134 87016 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 35 Whitfield Ct 3 Sidewalk: Curb side : Cutout Tree Private 2   12/05/2007 12:00:00 AM     Permit Number 49947 6017543.1 2094109.3 37.7310090102049 -122.381653502791 (37.7310090102049, -122.381653502791) 10 3 8 58 1
109718 87015 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 35 Whitfield Ct 2 Sidewalk: Curb side : Cutout Tree Private 2   12/05/2007 12:00:00 AM     Permit Number 49947 6017543.1 2094109.3 37.7310090102049 -122.381653502791 (37.7310090102049, -122.381653502791) 10 3 8 58 1
160963 87014 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 35 Whitfield Ct 1 Sidewalk: Curb side : Cutout Tree Private 2   12/05/2007 12:00:00 AM     Permit Number 49947 6017543.1 2094109.3 37.7310090102049 -122.381653502791 (37.7310090102049, -122.381653502791) 10 3 8 58 1
99863 114934 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 4400x OCEAN AVE 10 Front Yard : Cutout Tree Private 2   02/17/2016 12:00:00 AM 3 3x3 Permit Number 777127 5985931 2095134 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892) 1 8 4 64 35
113218 114925 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 4400x OCEAN AVE 3 Front Yard : Cutout Tree Private 2   02/17/2016 12:00:00 AM 3 3x3 Permit Number 777127 5985931 2095134 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892) 1 8 4 64 35
6708 256455 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 2901 Sunset Blvd 4 Median : Yard Tree Private 2       3x3   5984945 2095183 37.7321032922905 -122.494428131787 (37.7321032922905, -122.494428131787) 1 8 4 64 35
81883 106311 Significant Tree 6 Pinus canariensis :: Canary Island Pine 35 99X Clearfield Dr 5 Sidewalk: Property side : Yard Tree Private 2   04/15/2014 12:00:00 AM     Permit Number 772542 5985798.26078 2095453.46484 37.7328958169551 -122.491498163849 (37.7328958169551, -122.491498163849) 1 8 4 64 35
181784 106310 Significant Tree 6 Pinus canariensis :: Canary Island Pine 35 99X Clearfield Dr 4 Sidewalk: Property side : Yard Tree Private 2   04/15/2014 12:00:00 AM     Permit Number 772542 5985798.26078 2095453.46484 37.7328958169551 -122.491498163849 (37.7328958169551, -122.491498163849) 1 8 4 64 35
126819 257966 Significant Tree 6 Pinus canariensis :: Canary Island Pine 35 98X Clearfield Dr 1 Side Yard : Yard Tree Private 2       3x3 Permit Number 782748 5986022 2095487 37.7330009680725 -122.490727117227 (37.7330009680725, -122.490727117227) 1 8 4 64 35
18682 91505 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1501@Clearfield Sloat Blvd 21 Sidewalk: Curb side : Cutout Tree Private 2   05/04/2009 12:00:00 AM   3x3 Permit Number 52122 5986316.3 2095724.7 37.7336708170949 -122.489727133621 (37.7336708170949, -122.489727133621) 1 8 4 64 35
62197 94233 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1501@Ocean Sloat Blvd 15 Sidewalk: Property side : Yard Tree Private 2   06/28/2010 12:00:00 AM 12   Permit Number 53611 5986316.3 2095724.7 37.7336708170949 -122.489727133621 (37.7336708170949, -122.489727133621) 1 8 4 64 35
132634 94230 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1501@Everglade Sloat Blvd 9 Sidewalk: Property side : Yard Tree Private 2   06/28/2010 12:00:00 AM 12   Permit Number 53611 5986316.3 2095724.7 37.7336708170949 -122.489727133621 (37.7336708170949, -122.489727133621) 1 8 4 64 35
11838 94234 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1501@Clearfield Sloat Blvd 22 Sidewalk: Property side : Yard Tree Private 2   06/28/2010 12:00:00 AM 14   Permit Number 53611 5986536.9 2095861.8 37.7340601352242 -122.488974540344 (37.7340601352242, -122.488974540344) 1 8 4 64 35
42301 87834 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1501@Ocean Sloat Blvd 10 Sidewalk: Curb side : Cutout Tree Private 2   06/06/2008 12:00:00 AM   3x3 Permit Number 50721 5986536.9 2095861.8 37.7340601352242 -122.488974540344 (37.7340601352242, -122.488974540344) 1 8 4 64 35
44422 94231 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1501@Ocean Sloat Blvd 9 Sidewalk: Property side : Yard Tree Private 2   06/28/2010 12:00:00 AM 24   Permit Number 53611 5986536.9 2095861.8 37.7340601352242 -122.488974540344 (37.7340601352242, -122.488974540344) 1 8 4 64 35
53868 91504 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1501@Clearfield Sloat Blvd 18 Sidewalk: Curb side : Cutout Tree Private 2   05/04/2009 12:00:00 AM   3x3 Permit Number 52122 5986536.9 2095861.8 37.7340601352242 -122.488974540344 (37.7340601352242, -122.488974540344) 1 8 4 64 35
72849 91503 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1501@Clearfield Sloat Blvd 15 Sidewalk: Curb side : Cutout Tree Private 2   05/04/2009 12:00:00 AM   3x3 Permit Number 52122 5986536.9 2095861.8 37.7340601352242 -122.488974540344 (37.7340601352242, -122.488974540344) 1 8 4 64 35
125671 91502 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1501@Clearfield Sloat Blvd 12 Sidewalk: Curb side : Cutout Tree Private 2   05/04/2009 12:00:00 AM   3x3 Permit Number 52122 5986536.9 2095861.8 37.7340601352242 -122.488974540344 (37.7340601352242, -122.488974540344) 1 8 4 64 35
134883 87835 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1501@Ocean Sloat Blvd 11 Sidewalk: Curb side : Cutout Tree Private 2   06/06/2008 12:00:00 AM   3x3 Permit Number 50721 5986536.9 2095861.8 37.7340601352242 -122.488974540344 (37.7340601352242, -122.488974540344) 1 8 4 64 35
139760 94232 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1501@Ocean Sloat Blvd 12 Sidewalk: Property side : Yard Tree Private 2   06/28/2010 12:00:00 AM 14   Permit Number 53611 5986536.9 2095861.8 37.7340601352242 -122.488974540344 (37.7340601352242, -122.488974540344) 1 8 4 64 35
185823 94235 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1501@Clearfield Sloat Blvd 9 Sidewalk: Property side : Yard Tree Private 2   06/28/2010 12:00:00 AM 27   Permit Number 53611 5986536.9 2095861.8 37.7340601352242 -122.488974540344 (37.7340601352242, -122.488974540344) 1 8 4 64 35
87610 185118 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2850 35th Ave 1 Sidewalk: Property side : Yard Tree Private 2     21 Width 0ft   5985615.0479 2096000.8357 37.7343880441022 -122.492171858431 (37.7343880441022, -122.492171858431) 1 8 3 29491 35
83823 211035 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 61 Burnside Ave 1 Sidewalk: Property side : Yard Tree Private 2     20     6001198.5187 2095714.51341 37.7345005324595 -122.438274321504 (37.7345005324595, -122.438274321504) 2 7 5 63 7
20168 211040 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 52 Burnside Ave 11 Sidewalk: Property side : Yard Tree Private 2     24     6001161.45161 2095717.92279 37.7345077855016 -122.438402718629 (37.7345077855016, -122.438402718629) 9 7 5 63 7
36557 211039 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 52 Burnside Ave 10 Sidewalk: Property side : Yard Tree Private 2     23     6001157.31367 2095726.26325 37.7345304511011 -122.438417622186 (37.7345304511011, -122.438417622186) 9 7 5 63 7
39027 211036 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 61 Burnside Ave 3 Sidewalk: Property side : Yard Tree Private 2     14     6001192.69302 2095737.41742 37.7345630902121 -122.438296103083 (37.7345630902121, -122.438296103083) 2 7 5 63 7
69893 211037 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 61 Burnside Ave 4 Sidewalk: Property side : Yard Tree Private 2     16     6001183.29295 2095747.84811 37.7345911958118 -122.438329349227 (37.7345911958118, -122.438329349227) 2 7 5 63 7
161876 211038 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 52 Burnside Ave 1 Sidewalk: Property side : Yard Tree Private 2     36     6001171.81546 2095754.02956 37.7346075158123 -122.438369473392 (37.7346075158123, -122.438369473392) 2 7 5 63 7
130337 186855 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2700 Sunset Blvd 4 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5985186.2801 2096278.9071 37.7351264799029 -122.49367471051 (37.7351264799029, -122.49367471051) 1 8 3 29491 35
165017 185033 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2701 Sunset Blvd 59 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5985049.8565 2096299.4419 37.7351748809707 -122.494147882197 (37.7351748809707, -122.494147882197) 1 8 3 29491 35
53240 185023 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2701 Sunset Blvd 49 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5985046.088 2096329.59 37.7352574390957 -122.494163132435 (37.7352574390957, -122.494163132435) 1 8 3 29491 35
11755 186875 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2700 Sunset Blvd 24 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5985206.2214 2096387.7822 37.7354265885186 -122.493613787113 (37.7354265885186, -122.493613787113) 1 8 3 29491 35
173124 186878 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2700 Sunset Blvd 27 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5985170.4646 2096439.5838 37.7355667300556 -122.493741225987 (37.7355667300556, -122.493741225987) 1 8 3 29491 35
134727 186880 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2700 Sunset Blvd 29 Sidewalk: Property side : Yard Tree Private 2     14 Width 0ft   5985201.1788 2096460.2128 37.7356251686507 -122.49363655642 (37.7356251686507, -122.49363655642) 1 8 3 29491 35
189697 234478 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 398 Surrey St 2 Sidewalk: Property side : Yard Tree Private 2     30 Width 5ft   6001098.40077 2096167.19905 37.7357378071451 -122.43865288754 (37.7357378071451, -122.43865288754) 2 7 5 63 7
191503 186889 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2700 Sunset Blvd 38 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5985183.3004 2096502.846 37.7357411821318 -122.493701508581 (37.7357411821318, -122.493701508581) 1 8 3 29491 35
55245 186890 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2700 Sunset Blvd 39 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5985200.262 2096503.3044 37.7357434330648 -122.493642900348 (37.7357434330648, -122.493642900348) 1 8 3 29491 35
133423 186893 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2700 Sunset Blvd 42 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5985181.9251 2096557.8565 37.7358921458374 -122.493710315825 (37.7358921458374, -122.493710315825) 1 8 3 29491 35
128912 184982 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2701 Sunset Blvd 8 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984985.373 2096691.786 37.7362483795762 -122.494399733702 (37.7362483795762, -122.494399733702) 1 8 3 29491 35
147596 234475 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 378 Highland Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6007368.44216 2096501.62636 37.7370107660349 -122.416998547241 (37.7370107660349, -122.416998547241) 2 7 7 28859 2
60102 185310 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2601 Sunset Blvd 35 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984962.2385 2097256.121 37.7377965384833 -122.494521307154 (37.7377965384833, -122.494521307154) 1 8 3 29491 35
158532 185308 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2601 Sunset Blvd 33 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5985001.1798 2097292.5499 37.7378988415191 -122.494389354717 (37.7378988415191, -122.494389354717) 1 8 3 29491 35
12887 185307 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2601 Sunset Blvd 32 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984973.1253 2097316.8359 37.7379638824881 -122.494488141215 (37.7379638824881, -122.494488141215) 1 8 3 29491 35
41826 187121 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2600 Sunset Blvd 57 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5985174.7424 2097328.4139 37.7380074703554 -122.493791914706 (37.7380074703554, -122.493791914706) 1 8 3 29491 35
143757 185290 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2601 Sunset Blvd 15 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984983.8028 2097379.2257 37.738135813056 -122.494455822202 (37.738135813056, -122.494455822202) 1 8 3 29491 35
102914 187129 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2600 Sunset Blvd 65 Sidewalk: Property side : Yard Tree Private 2     24 Width 0ft   5985149.8207 2097410.2322 37.7382306634066 -122.493884107972 (37.7382306634066, -122.493884107972) 1 8 3 29491 35
97343 187133 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2600 Sunset Blvd 69 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5985163.4571 2097445.4987 37.7383282936023 -122.493839558913 (37.7383282936023, -122.493839558913) 1 8 3 29491 35
120683 255712 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 618x Mendell St 6 Front Yard : Yard Tree Private 2       3x3 Permit Number 781846 6016234 2097322 37.7397580688138 -122.386403238688 (37.7397580688138, -122.386403238688) 10 3 8 58 1
170250 234474 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 72 Santa Marina St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6006078.82979 2097595.56477 37.7399418481504 -122.421534992063 (37.7399418481504, -122.421534992063) 2 7 7 28859 2
127400 187193 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2301 Sunset Blvd 55 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984945.2043 2099085.395 37.7428182353231 -122.494715027467 (37.7428182353231, -122.494715027467) 1 8 3 29491 35
137465 234473 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 99 Elsie St 2 Sidewalk: Curb side : Pot Tree Private 2     16     6007295.70063 2098744.01488 37.7431637754778 -122.417408915989 (37.7431637754778, -122.417408915989) 2 7 7 28859 2
1190 107158 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 101x Elsie St 1 Unaccepted Street : Yard Tree Private 2     20     6007300 2098759 37.7432051631731 -122.417395111614 (37.7432051631731, -122.417395111614) 2 7 7 28859 2
22467 211031 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2375 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   5992617.61467 2099318.2887 37.7439038024205 -122.468203163863 (37.7439038024205, -122.468203163863) 1 8 4 29491 40
153599 185439 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2300 Sunset Blvd 57 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5985094.1378 2099479.3093 37.74390853381 -122.494229093058 (37.74390853381, -122.494229093058) 1 8 3 29491 35
162497 211001 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700 Portola Dr 4 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5996755.51144 2099350.67627 37.7442308453761 -122.45389769125 (37.7442308453761, -122.45389769125) 1 7 4 59 40
77378 211002 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700 Portola Dr 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5996779.38475 2099373.51377 37.744294920285 -122.453816791818 (37.744294920285, -122.453816791818) 1 7 4 59 40
1053 211003 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700 Portola Dr 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5996800.72253 2099394.55039 37.7443539050009 -122.453744529511 (37.7443539050009, -122.453744529511) 1 7 4 59 40
49925 211004 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700 Portola Dr 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5996822.63607 2099410.87592 37.7443999871842 -122.453669936126 (37.7443999871842, -122.453669936126) 1 7 4 59 40
30409 185563 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2201 Sunset Blvd 47 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984887.6667 2099768.5458 37.7446906142612 -122.494964334306 (37.7446906142612, -122.494964334306) 1 8 3 29491 35
56939 185562 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2201 Sunset Blvd 46 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984881.299 2099768.8111 37.7446909699364 -122.494986371806 (37.7446909699364, -122.494986371806) 1 8 3 29491 35
141879 211032 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 297 Dorantes Ave 1 Sidewalk: Curb side : Yard Tree Private 2     12 Width 3ft   5993259.54182 2099680.27875 37.7449347888095 -122.466009845078 (37.7449347888095, -122.466009845078) 1 8 4 29491 40
121416 185539 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2201 Sunset Blvd 23 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984878.3804 2100042.8891 37.7454433428019 -122.495016669314 (37.7454433428019, -122.495016669314) 1 8 3 29491 35
96104 234476 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 784 Duncan St 2 Sidewalk: Property side : Yard Tree Private 2     2 Width 6ft   6001432.63511 2099723.41327 37.7455213464352 -122.437751929628 (37.7455213464352, -122.437751929628) 2 7 5 63 22
68405 185535 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2201 Sunset Blvd 19 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984921.0973 2100070.748 37.7455223363848 -122.494871016971 (37.7455223363848, -122.494871016971) 1 8 3 29491 35
47104 187385 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2200 Sunset Blvd 71 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5985037.3743 2100116.159 37.7456538284953 -122.494472302074 (37.7456538284953, -122.494472302074) 1 8 3 29491 35
7563 187388 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2200 Sunset Blvd 74 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5985049.5619 2100144.9354 37.7457335539505 -122.49443228067 (37.7457335539505, -122.49443228067) 1 8 3 29491 35
65461 185709 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2101 Sunset Blvd 41 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984908.4893 2100423.9717 37.7464914545154 -122.494940652646 (37.7464914545154, -122.494940652646) 1 8 3 29491 35
130934 185700 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2101 Sunset Blvd 32 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984899.9898 2100515.832 37.7467431803198 -122.494976814737 (37.7467431803198, -122.494976814737) 1 8 3 29491 35
105094 96843 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 417 Dewey Blvd 3 Sidewalk: Curb side : Cutout Tree Private 2           5995136 2100316.9 37.7467908665237 -122.459567540316 (37.7467908665237, -122.459567540316) 1 8 4 59 40
122904 96844 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 417 Dewey Blvd 4 Sidewalk: Curb side : Cutout Tree Private 2           5995136 2100316.9 37.7467908665237 -122.459567540316 (37.7467908665237, -122.459567540316) 1 8 4 59 40
52814 211034 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 417 Dewey Blvd 2 Sidewalk: Curb side : Yard Tree Private 2     15 Width 3ft   5995115.07777 2100328.51022 37.7468215422 -122.45964072765 (37.7468215422, -122.45964072765) 1 8 4 59 40
168170 211033 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 417 Dewey Blvd 3 Sidewalk: Curb side : Yard Tree Private 2     17 Width 3ft   5995123.84893 2100332.44688 37.7468328556504 -122.459610683101 (37.7468328556504, -122.459610683101) 1 8 4 59 40
120441 234471 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1350 Noe St 5 Sidewalk: Property side : Yard Tree Private 2     16     6003196.85258 2100348.13678 37.7473368492221 -122.431696139568 (37.7473368492221, -122.431696139568) 2 4 5 63 22
75002 185676 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2101 Sunset Blvd 8 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984839.349 2100771.308 37.7474410976212 -122.495205338122 (37.7474410976212, -122.495205338122) 1 8 3 29491 35
101060 185902 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2000 Sunset Blvd 45 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5985031.1855 2101301.2352 37.7489073626901 -122.494581050501 (37.7489073626901, -122.494581050501) 1 8 3 29491 35
119669 185964 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2001 Sunset Blvd 23 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984823.122 2101326.4259 37.7489643495953 -122.495302381208 (37.7489643495953, -122.495302381208) 1 8 3 29491 35
116100 185960 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2001 Sunset Blvd 19 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984855.8243 2101346.8117 37.7490222380818 -122.495190801303 (37.7490222380818, -122.495190801303) 1 8 3 29491 35
104913 185906 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2000 Sunset Blvd 49 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5985026.2976 2101345.2263 37.7490278641469 -122.49460119526 (37.7490278641469, -122.49460119526) 1 8 3 29491 35
23395 185955 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2001 Sunset Blvd 14 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984875.9978 2101408.1817 37.7491919243755 -122.495125567093 (37.7491919243755, -122.495125567093) 1 8 3 29491 35
5669 185954 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2001 Sunset Blvd 13 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984829.7049 2101412.004 37.7491997090577 -122.495285928093 (37.7491997090577, -122.495285928093) 1 8 3 29491 35
114736 185930 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2000 Sunset Blvd 73 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5985039.332 2101497.8374 37.7494476553955 -122.494567371863 (37.7494476553955, -122.494567371863) 1 8 3 29491 35
172096 185932 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2000 Sunset Blvd 75 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984999.1426 2101513.5873 37.7494885480173 -122.494707506851 (37.7494885480173, -122.494707506851) 1 8 3 29491 35
15433 186081 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1901 Sunset Blvd 27 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984821.8866 2101948.8735 37.7506733477582 -122.495352551899 (37.7506733477582, -122.495352551899) 1 8 3 29491 35
97315 186080 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1901 Sunset Blvd 26 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984851.2986 2101988.3321 37.7507834123081 -122.495253753816 (37.7507834123081, -122.495253753816) 1 8 3 29491 35
71549 234477 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 500 Grand View Ave 4 Front Yard : Yard Tree Private 2     3     5999979.48342 2101750.0189 37.7510031819599 -122.442922193204 (37.7510031819599, -122.442922193204) 2 4 5 28862 22
61408 186038 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1900 Sunset Blvd 33 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984981.8854 2102120.1374 37.7511529582795 -122.494811896529 (37.7511529582795, -122.494811896529) 1 8 3 29491 35
92103 186040 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1900 Sunset Blvd 35 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5985014.7934 2102133.6877 37.7511920899125 -122.49469909774 (37.7511920899125, -122.49469909774) 1 8 3 29491 35
186953 173744 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 500X Grand View Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000114 2102099 37.7519690677882 -122.442482075417 (37.7519690677882, -122.442482075417) 2 4 5 28862 22
33869 186381 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1801 Sunset Blvd 48 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984844.8943 2102435.3563 37.7520104429492 -122.495308863381 (37.7520104429492, -122.495308863381) 1 8 3 56 35
69193 186380 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1801 Sunset Blvd 47 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984843.2782 2102467.9478 37.7520998356184 -122.495316855331 (37.7520998356184, -122.495316855331) 1 8 3 56 35
163252 186251 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1701 Sunset Blvd 62 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984830.2927 2103110.5403 37.7538634572036 -122.495409148018 (37.7538634572036, -122.495409148018) 1 8 3 56 35
146921 186247 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1701 Sunset Blvd 58 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984819.3113 2103171.6078 37.7540304886989 -122.495451627268 (37.7540304886989, -122.495451627268) 1 8 3 56 35
156752 186238 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1701 Sunset Blvd 49 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984762.5292 2103340.0793 37.7544897398871 -122.495660416165 (37.7544897398871, -122.495660416165) 1 8 3 56 35
123530 186167 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1700 Sunset Blvd 52 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984926.5892 2103481.0156 37.7548863180592 -122.495103454208 (37.7548863180592, -122.495103454208) 1 8 3 56 35
88636 186468 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1601 Sunset Blvd 56 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984781.1405 2103769.7876 37.7556706898247 -122.495627747424 (37.7556706898247, -122.495627747424) 1 8 3 56 35

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);