trees
665 rows where qSpecies_id = 89 sorted by TreeID
This data as json, CSV (advanced)
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
78343 | 101466 | Significant Tree 6 | Afrocarpus gracilior :: Fern Pine 89 | 301 Hazelwood Ave | 1 | Front Yard : Yard | Tree | Private 2 | 5996219.7 | 2095283.8 | 37.7330334614805 | -122.455456526637 | (37.7330334614805, -122.455456526637) | 9 | 7 | 4 | 59 | 40 | |||||
155948 | 102478 | Significant Tree 6 | Afrocarpus gracilior :: Fern Pine 89 | 760 Victoria St | 4 | Front Yard : Yard | Tree | Private 2 | 5993664.7 | 2092172.3 | 37.7243431058269 | -122.464063971167 | (37.7243431058269, -122.464063971167) | 9 | 8 | 4 | 59 | 40 | |||||
51778 | 102757 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2807 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6002051.95846 | 2117801.73169 | 37.7951951298959 | -122.436904386043 | (37.7951951298959, -122.436904386043) | 13 | 9 | 1 | 57 | 27 | |||
64387 | 104356 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1671 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/2013 12:00:00 AM | 3 | Permit Number 770626 | 6004967.00865 | 2119154.82266 | 37.7990756208885 | -122.426914264396 | (37.7990756208885, -122.426914264396) | 13 | 9 | 1 | 57 | 17 | ||
61578 | 106492 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1747 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2018 12:00:00 AM | 12 | 3x3 | Permit Number 773396 | 6000787.4 | 2111331.2 | 37.7773567666582 | -122.440815564147 | (37.7773567666582, -122.440815564147) | 15 | 5 | 11 | 29492 | 41 | |
80070 | 107943 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 44x MacOndray Ln | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6008438.53642 | 2119159.8208 | 37.7992850226339 | -122.41490192268 | (37.7992850226339, -122.41490192268) | 5 | 1 | 10 | 308 | 32 | |||
70271 | 110030 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 327 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/19/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774319 | 6003526.63098 | 2091782.51819 | 37.7238362969822 | -122.429944883475 | (37.7238362969822, -122.429944883475) | 9 | 7 | 6 | 28861 | 5 |
149655 | 111999 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2414 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/04/2015 12:00:00 AM | 24 | 4x4 | Permit Number 776155 | 6003178.79126 | 2117077.11494 | 37.7932694988467 | -122.432953577047 | (37.7932694988467, -122.432953577047) | 13 | 9 | 1 | 29490 | 27 | |
125349 | 113957 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1644 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2015 12:00:00 AM | 1 | 3x3 | 6008801.14182 | 2118530.39041 | 37.7975771309301 | -122.413602635263 | (37.7975771309301, -122.413602635263) | 3 | 1 | 10 | 308 | 21 | ||
185797 | 114540 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 804 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 1 | 3x3 | Permit Number 774890 | 6012104.44502 | 2104594.78019 | 37.7594980943773 | -122.401192496453 | (37.7594980943773, -122.401192496453) | 10 | 3 | 8 | 28856 | 29 | |
89640 | 116047 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 650x Kansas St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11 | 5x12 | 6011496.1211 | 2105415.82819 | 37.761718552879 | -122.403354153666 | (37.761718552879, -122.403354153666) | 10 | 3 | 8 | 28856 | 29 | ||
98062 | 117918 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 731 41st Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 5983185.43658 | 2110793.02592 | 37.7748609268346 | -122.501665678898 | (37.7748609268346, -122.501665678898) | 11 | 6 | 2 | 55 | 26 | |||
34435 | 118571 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 7940 Geary Blvd | 1 | Back Yard : Yard | Tree | Private 2 | 6 | 5982344.86422 | 2112440.78156 | 37.7793357732303 | -122.504695460976 | (37.7793357732303, -122.504695460976) | 11 | 6 | 2 | 55 | 26 | ||||
27231 | 118929 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 875 La Playa | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 5980750.23602 | 2109645.2788 | 37.7715662158284 | -122.510004109936 | (37.7715662158284, -122.510004109936) | 11 | 6 | 2 | 55 | 26 | |||
110279 | 119343 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 462 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5985960.41468 | 2112779.42827 | 37.7804776215792 | -122.492212879632 | (37.7804776215792, -122.492212879632) | 11 | 6 | 2 | 55 | 26 | |||
45630 | 120025 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 743 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5987224.82866 | 2110876.63769 | 37.7753269317853 | -122.487698901899 | (37.7753269317853, -122.487698901899) | 11 | 6 | 2 | 55 | 26 | |||
44125 | 120266 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 100 24th Ave | 2 | Side Yard : Yard | Tree | Private 2 | 5 | 5988365.77159 | 2115120.59325 | 37.7870461179038 | -122.484063450514 | (37.7870461179038, -122.484063450514) | 11 | 6 | 1 | 55 | 33 | ||||
7190 | 120690 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 358 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/14/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 782203 | 5989057.83806 | 2112937.05315 | 37.7810910000946 | -122.481509105367 | (37.7810910000946, -122.481509105367) | 11 | 6 | 2 | 55 | 26 | |
131258 | 123145 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 562 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5992857.65671 | 2111637.48406 | 37.7777429430313 | -122.468269178657 | (37.7777429430313, -122.468269178657) | 11 | 6 | 2 | 54 | 11 | |||
124092 | 123452 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 735 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5995332.97895 | 2110593.9249 | 37.7750202604257 | -122.459630642924 | (37.7750202604257, -122.459630642924) | 11 | 6 | 2 | 54 | 11 | |||
182821 | 123467 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 708 02nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5995387.69315 | 2110690.84094 | 37.775289512367 | -122.459448396296 | (37.775289512367, -122.459448396296) | 11 | 6 | 2 | 54 | 11 | |||
129795 | 125436 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3157 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6001892.57083 | 2119015.7946 | 37.798519569189 | -122.437542875929 | (37.798519569189, -122.437542875929) | 13 | 9 | 1 | 57 | 17 | |||
46336 | 125437 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1921 Jefferson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6000052.89269 | 2121248.37983 | 37.8045448847905 | -122.444069220022 | (37.8045448847905, -122.444069220022) | 13 | 9 | 1 | 57 | 17 | |||
63927 | 125438 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 250 Euclid Ave | 0 | Front Yard : Yard | Tree | Private 2 | 15 | 5998091.24108 | 2114006.24691 | 37.78454782955 | -122.450335292242 | (37.78454782955, -122.450335292242) | 15 | 6 | 1 | 54 | 31 | ||||
170340 | 125439 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 99 Collins St | 0 | Side Yard : Yard | Tree | Private 2 | 7 | 5998117.25486 | 2114050.06951 | 37.7846696436241 | -122.450248453727 | (37.7846696436241, -122.450248453727) | 15 | 6 | 1 | 54 | 31 | ||||
40160 | 125440 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3517 Divisadero St | 1 | : | Tree | Private 2 | 4 | Width 2ft | 6000220.82214 | 2120372.11662 | 37.8021484793247 | -122.443425105788 | (37.8021484793247, -122.443425105788) | 13 | 9 | 1 | 57 | 17 | |||
82326 | 125441 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3517 Divisadero St | 2 | : | Tree | Private 2 | 4 | Width 2ft | 6000221.62171 | 2120363.59067 | 37.8021251149445 | -122.443421726125 | (37.8021251149445, -122.443421726125) | 13 | 9 | 1 | 57 | 17 | |||
183777 | 125442 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3719 Scott St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6000612.64349 | 2121133.322 | 37.8042608824853 | -122.442123892024 | (37.8042608824853, -122.442123892024) | 13 | 9 | 1 | 57 | 17 | |||
64715 | 125443 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2298 Beach St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 5999265.80635 | 2120844.85189 | 37.8033919746241 | -122.446763941418 | (37.8033919746241, -122.446763941418) | 13 | 9 | 1 | 57 | 17 | |||
159536 | 125444 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3676 Fillmore St | 3 | : | Tree | Private 2 | 6 | Width 2ft | 6002146.17897 | 2121077.47724 | 37.8041948227854 | -122.436812979831 | (37.8041948227854, -122.436812979831) | 13 | 9 | 1 | 57 | 17 | |||
170059 | 125445 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3615 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003103.29494 | 2120784.42 | 37.8034445139256 | -122.433479854917 | (37.8034445139256, -122.433479854917) | 13 | 9 | 1 | 57 | 17 | |||
74610 | 125446 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3615 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003103.60158 | 2120772.63456 | 37.8034121715947 | -122.433477951057 | (37.8034121715947, -122.433477951057) | 13 | 9 | 1 | 57 | 17 | |||
145970 | 125447 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3057 Franklin St | 1 | : | Tree | Private 2 | 5 | Width 2ft | 6005068.76254 | 2120514.19483 | 37.8028138607435 | -122.426659015206 | (37.8028138607435, -122.426659015206) | 13 | 9 | 1 | 57 | 17 | |||
116562 | 125448 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3057 Franklin St | 2 | : | Tree | Private 2 | 5 | Width 2ft | 6005070.86935 | 2120497.70862 | 37.8027687129688 | -122.426650549882 | (37.8027687129688, -122.426650549882) | 13 | 9 | 1 | 57 | 17 | |||
138499 | 125449 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3101 Clay St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5999876.27718 | 2115725.03781 | 37.7893691777902 | -122.444283251471 | (37.7893691777902, -122.444283251471) | 13 | 6 | 1 | 29490 | 27 | |||
132440 | 125450 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 44 Normandie Ter | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6000949.24806 | 2117425.20451 | 37.7940985496517 | -122.44069290605 | (37.7940985496517, -122.44069290605) | 13 | 9 | 1 | 57 | 27 | |||
143706 | 125451 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2601 Vallejo St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6001095.19419 | 2117566.78183 | 37.7944955940578 | -122.440198075675 | (37.7944955940578, -122.440198075675) | 13 | 9 | 1 | 57 | 27 | |||
59297 | 125452 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2401 Broadway | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6002068.61749 | 2117342.59163 | 37.7939353973611 | -122.436813859368 | (37.7939353973611, -122.436813859368) | 13 | 9 | 1 | 29490 | 27 | |||
86571 | 125453 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2401 Broadway | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6002078.25785 | 2117342.70193 | 37.793936248105 | -122.436780510733 | (37.793936248105, -122.436780510733) | 13 | 9 | 1 | 29490 | 27 | |||
70682 | 125454 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2401 Broadway | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6002093.86703 | 2117345.78422 | 37.7939455983674 | -122.43672672227 | (37.7939455983674, -122.43672672227) | 13 | 9 | 1 | 29490 | 27 | |||
130988 | 125455 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2401 Broadway | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6002099.50591 | 2117347.8348 | 37.7939515491883 | -122.436707358076 | (37.7939515491883, -122.436707358076) | 13 | 9 | 1 | 29490 | 27 | |||
97812 | 125456 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2401 Broadway | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6002104.20596 | 2117349.59529 | 37.7939566501408 | -122.436691221543 | (37.7939566501408, -122.436691221543) | 13 | 9 | 1 | 29490 | 27 | |||
90579 | 125457 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2807 Steiner St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 4ft | 6002053.50035 | 2117793.13608 | 37.7951716162211 | -122.436898435221 | (37.7951716162211, -122.436898435221) | 13 | 9 | 1 | 57 | 27 | |||
76702 | 125458 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2371 Broadway | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6002284.26434 | 2117368.32549 | 37.7940183094364 | -122.436069543591 | (37.7940183094364, -122.436069543591) | 13 | 9 | 1 | 29490 | 27 | |||
182415 | 125459 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2371 Broadway | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6002302.24315 | 2117372.64149 | 37.7940311814406 | -122.436007644151 | (37.7940311814406, -122.436007644151) | 13 | 9 | 1 | 29490 | 27 | |||
54441 | 125460 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2416 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6003175.77984 | 2117097.00502 | 37.7933239410913 | -122.432965418428 | (37.7933239410913, -122.432965418428) | 13 | 9 | 1 | 29490 | 27 | |||
162245 | 125461 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1845 Green St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6004195.45414 | 2118342.02418 | 37.7968002290978 | -122.429526106064 | (37.7968002290978, -122.429526106064) | 13 | 9 | 1 | 57 | 17 | |||
90041 | 125462 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 125 Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 52121 | 6009895.29665 | 2113891.24599 | 37.7849005400769 | -122.409488968035 | (37.7849005400769, -122.409488968035) | 14 | 10 | 9 | 28852 | 36 | |
99030 | 125463 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 935 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6006804.24109 | 2113922.09635 | 37.7848115656375 | -122.420185233786 | (37.7848115656375, -122.420185233786) | 7 | 9 | 9 | 28858 | 36 | |||
48506 | 125464 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 887 Eddy St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6006280.54306 | 2113153.33425 | 37.7826712115607 | -122.4219424317 | (37.7826712115607, -122.4219424317) | 7 | 9 | 11 | 28852 | 41 | |||
193513 | 125465 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1177 California St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 4ft | 6008661.04402 | 2116264.72933 | 37.7913483149251 | -122.413927056694 | (37.7913483149251, -122.413927056694) | 5 | 1 | 10 | 28857 | 21 | |||
125968 | 125466 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1177 California St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6008683.65979 | 2116266.52541 | 37.7913545166392 | -122.413848933479 | (37.7913545166392, -122.413848933479) | 5 | 1 | 10 | 28857 | 21 | |||
182154 | 125467 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1177 California St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 4ft | 6008702.23207 | 2116269.4831 | 37.7913636807268 | -122.413784882888 | (37.7913636807268, -122.413784882888) | 5 | 1 | 10 | 28857 | 21 | |||
29202 | 125468 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1177 California St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 4ft | 6008726.14199 | 2116272.16952 | 37.7913723996763 | -122.413702344902 | (37.7913723996763, -122.413702344902) | 5 | 1 | 10 | 28857 | 21 | |||
106323 | 125469 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1177 California St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 4ft | 6008779.73096 | 2116281.55689 | 37.7914011842588 | -122.413517591782 | (37.7914011842588, -122.413517591782) | 5 | 1 | 10 | 28857 | 21 | |||
55157 | 125470 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 655 Powell St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 6010075.12389 | 2116032.87575 | 37.7907910167417 | -122.409017984115 | (37.7907910167417, -122.409017984115) | 5 | 1 | 10 | 28857 | 21 | |||
157337 | 125471 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 655 Powell St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 6010076.95545 | 2116019.41648 | 37.7907541634305 | -122.409010696908 | (37.7907541634305, -122.409010696908) | 5 | 1 | 10 | 28857 | 21 | |||
191914 | 125472 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 655 Powell St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6010077.81978 | 2116010.1713 | 37.7907288268122 | -122.409007053754 | (37.7907288268122, -122.409007053754) | 5 | 1 | 10 | 28857 | 21 | |||
131179 | 125473 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 655 Powell St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 6010077.67437 | 2116003.04391 | 37.7907092485717 | -122.409007053757 | (37.7907092485717, -122.409007053757) | 5 | 1 | 10 | 28857 | 21 | |||
101180 | 125474 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 150 Sproule Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6009252.35721 | 2116781.07333 | 37.792799261332 | -122.411917622313 | (37.792799261332, -122.411917622313) | 3 | 1 | 10 | 28857 | 21 | |||
87547 | 125475 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 150 Sproule Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6009249.92549 | 2116801.26294 | 37.7928545606515 | -122.411927463576 | (37.7928545606515, -122.411927463576) | 3 | 1 | 10 | 28857 | 21 | |||
115820 | 125476 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 150 Sproule Ln | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6009246.74599 | 2116823.51326 | 37.7929154762237 | -122.41194003791 | (37.7929154762237, -122.41194003791) | 3 | 1 | 10 | 28857 | 21 | |||
37925 | 125477 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 150 Sproule Ln | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6009239.02025 | 2116870.71678 | 37.793044652131 | -122.411970106748 | (37.793044652131, -122.411970106748) | 3 | 1 | 10 | 28857 | 21 | |||
137492 | 125478 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 150 Sproule Ln | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6009235.21214 | 2116893.1375 | 37.7931060003053 | -122.411984868232 | (37.7931060003053, -122.411984868232) | 3 | 1 | 10 | 28857 | 21 | |||
104422 | 125479 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1133 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009244.74147 | 2117035.03683 | 37.7934961558667 | -122.411961928316 | (37.7934961558667, -122.411961928316) | 3 | 1 | 10 | 28857 | 21 | |||
24271 | 125480 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 70 Pleasant St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 6008592.70141 | 2116811.84206 | 37.7928467140568 | -122.414202246537 | (37.7928467140568, -122.414202246537) | 5 | 1 | 10 | 28857 | 21 | |||
153761 | 125481 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Nob Hill Pl | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 1ft | 6009481.63749 | 2116293.53202 | 37.7914734519756 | -122.411089845832 | (37.7914734519756, -122.411089845832) | 5 | 1 | 10 | 28857 | 21 | |||
34872 | 125482 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Nob Hill Pl | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 1ft | 6009469.59091 | 2116291.78471 | 37.7914679787239 | -122.411131403485 | (37.7914679787239, -122.411131403485) | 5 | 1 | 10 | 28857 | 21 | |||
24487 | 125483 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1471 Washington St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6007681.40554 | 2117137.66068 | 37.7936901018702 | -122.417378482047 | (37.7936901018702, -122.417378482047) | 5 | 1 | 10 | 28858 | 32 | |||
142938 | 125484 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1237x Robert C Levy Tunl | 1 | Median : Yard | Tree | DPW 1 | 18 | 6007648.69076 | 2118115.73393 | 37.796373807471 | -122.417561030927 | (37.796373807471, -122.417561030927) | 5 | 1 | 10 | 28858 | 32 | ||||
51653 | 125485 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1237x Robert C Levy Tunl | 3 | Median : Yard | Tree | DPW 1 | 10 | 6007640.9414 | 2118138.07584 | 37.796434716745 | -122.417589429708 | (37.796434716745, -122.417589429708) | 5 | 1 | 10 | 28858 | 32 | ||||
169681 | 125486 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1237x Robert C Levy Tunl | 4 | Median : Yard | Tree | DPW 1 | 6 | 6007645.27033 | 2118136.8198 | 37.7964315115565 | -122.417574361577 | (37.7964315115565, -122.417574361577) | 5 | 1 | 10 | 28858 | 32 | ||||
148426 | 125487 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1322 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007652.60673 | 2115828.99311 | 37.7900952031746 | -122.417385342985 | (37.7900952031746, -122.417385342985) | 13 | 1 | 10 | 28858 | 21 | |||
88407 | 125488 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1322 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007633.45937 | 2115824.47806 | 37.7900817286446 | -122.417451271357 | (37.7900817286446, -122.417451271357) | 13 | 1 | 10 | 28858 | 21 | |||
132125 | 125489 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1322 Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007615.82669 | 2115821.73144 | 37.7900731949784 | -122.417512084408 | (37.7900731949784, -122.417512084408) | 13 | 1 | 10 | 28858 | 21 | |||
121928 | 125490 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1322 Pine St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007597.86895 | 2115819.15526 | 37.7900651109764 | -122.417574034214 | (37.7900651109764, -122.417574034214) | 13 | 1 | 10 | 28858 | 21 | |||
34992 | 125491 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1207 Chestnut St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6005994.09185 | 2120329.47146 | 37.8023589278732 | -122.423443758146 | (37.8023589278732, -122.423443758146) | 5 | 9 | 1 | 28858 | 32 | |||
149402 | 125492 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1207 Chestnut St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6006010.16913 | 2120331.72981 | 37.8023660361287 | -122.423388283439 | (37.8023660361287, -122.423388283439) | 5 | 9 | 1 | 28858 | 32 | |||
51637 | 125493 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1207 Chestnut St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6006021.47381 | 2120333.65457 | 37.8023719590496 | -122.423349300554 | (37.8023719590496, -122.423349300554) | 5 | 9 | 1 | 28858 | 32 | |||
121196 | 125494 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1207 Chestnut St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6006034.74479 | 2120336.40198 | 37.8023802517163 | -122.423303571803 | (37.8023802517163, -122.423303571803) | 5 | 9 | 1 | 28858 | 32 | |||
87363 | 125495 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1207 Chestnut St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6006051.2199 | 2120336.9264 | 37.8023826214287 | -122.423246597049 | (37.8023826214287, -122.423246597049) | 5 | 9 | 1 | 28858 | 32 | |||
73410 | 125496 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1207 Chestnut St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6006063.84143 | 2120339.68716 | 37.8023909140602 | -122.423203116649 | (37.8023909140602, -122.423203116649) | 5 | 9 | 1 | 28858 | 32 | |||
113174 | 125497 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1154 Chestnut St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6006282.86688 | 2120431.59702 | 37.8026556331117 | -122.422451714169 | (37.8026556331117, -122.422451714169) | 5 | 9 | 1 | 28858 | 32 | |||
194134 | 125498 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1154 Chestnut St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6006270.07079 | 2120429.11585 | 37.8026480985929 | -122.422495818752 | (37.8026480985929, -122.422495818752) | 5 | 9 | 1 | 28858 | 32 | |||
1264 | 125499 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 10 Hastings Ter | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6007355.47144 | 2119286.08851 | 37.7995708047014 | -122.418658671469 | (37.7995708047014, -122.418658671469) | 5 | 1 | 1 | 28858 | 32 | ||||
6257 | 125500 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 12 Hastings Ter | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6007269.76384 | 2119273.06582 | 37.7995302219096 | -122.418954327193 | (37.7995302219096, -122.418954327193) | 5 | 1 | 1 | 28858 | 32 | ||||
23673 | 125501 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1115 Filbert St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 4ft | 6007553.74728 | 2119514.62481 | 37.8002094690578 | -122.417988773678 | (37.8002094690578, -122.417988773678) | 5 | 1 | 1 | 28858 | 32 | |||
64447 | 125502 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1001 Lombard St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 7ft | 6007468.42884 | 2120195.87716 | 37.8020752142594 | -122.418332338987 | (37.8020752142594, -122.418332338987) | 5 | 1 | 1 | 28858 | 32 | |||
178268 | 125503 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1001 Lombard St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 7ft | 6007472.5485 | 2120196.70062 | 37.8020777071716 | -122.418318141382 | (37.8020777071716, -122.418318141382) | 5 | 1 | 1 | 28858 | 32 | |||
84618 | 125504 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1001 Lombard St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 7ft | 6007489.69173 | 2120199.07294 | 37.8020851859507 | -122.418258985774 | (37.8020851859507, -122.418258985774) | 5 | 1 | 1 | 28858 | 32 | |||
35518 | 125505 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 45 Havens St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 6007613.99229 | 2119386.63886 | 37.7998614422209 | -122.41777122496 | (37.7998614422209, -122.41777122496) | 5 | 1 | 1 | 28858 | 32 | ||||
3711 | 125506 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 7 Fallon Pl | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 4ft | 6008920.97468 | 2118571.47788 | 37.7976966751291 | -122.413190886946 | (37.7976966751291, -122.413190886946) | 3 | 1 | 10 | 308 | 21 | |||
190539 | 125507 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 7 Fallon Pl | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6008925.22265 | 2118571.08085 | 37.7976958234636 | -122.413176159668 | (37.7976958234636, -122.413176159668) | 3 | 1 | 10 | 308 | 21 | |||
80095 | 125508 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 7 Fallon Pl | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 6008930.42147 | 2118571.4914 | 37.7976972425915 | -122.413158199313 | (37.7976972425915, -122.413158199313) | 3 | 1 | 10 | 308 | 21 | |||
51514 | 125509 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 5ft | 6008633.29576 | 2119030.27082 | 37.7989402522368 | -122.414218814773 | (37.7989402522368, -122.414218814773) | 5 | 1 | 10 | 308 | 32 | |||
71615 | 125510 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 6008630.57528 | 2119029.65242 | 37.7989384014533 | -122.414228184789 | (37.7989384014533, -122.414228184789) | 5 | 1 | 10 | 308 | 32 | |||
55814 | 125511 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 5ft | 6008625.76186 | 2119029.22421 | 37.7989369553212 | -122.414244810558 | (37.7989369553212, -122.414244810558) | 5 | 1 | 10 | 308 | 32 | |||
64779 | 125512 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 6008620.72695 | 2119028.05639 | 37.7989334659598 | -122.414262150401 | (37.7989334659598, -122.414262150401) | 5 | 1 | 10 | 308 | 32 | |||
72741 | 125513 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 6008593.29487 | 2119027.33171 | 37.798929935227 | -122.414357023482 | (37.798929935227, -122.414357023482) | 5 | 1 | 10 | 308 | 32 | |||
24813 | 125514 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 5ft | 6008590.31929 | 2119027.39259 | 37.7989299352366 | -122.414367324317 | (37.7989299352366, -122.414367324317) | 5 | 1 | 10 | 308 | 32 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );