trees
2,180 rows where qSpecies_id = 57 sorted by PlotSize descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
65728 | 226675 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 127 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 9ft | 6005684.59904 | 2100199.28079 | 37.7470688251863 | -122.423083100303 | (37.7470688251863, -122.423083100303) | 2 | 7 | 5 | 28859 | 22 | |||
61601 | 226683 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 160 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 8ft | 6005478.66525 | 2100234.88341 | 37.7471549586505 | -122.423797733972 | (37.7471549586505, -122.423797733972) | 2 | 7 | 5 | 28859 | 22 | |||
67498 | 207978 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 155 Burnside Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 8ft | 6001108.30575 | 2095400.37488 | 37.7336328494621 | -122.438563716151 | (37.7336328494621, -122.438563716151) | 9 | 7 | 5 | 63 | 40 | |||
95579 | 227330 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 221 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 8ft | 5998955.44589 | 2106862.78019 | 37.7649831206943 | -122.446831256578 | (37.7649831206943, -122.446831256578) | 15 | 5 | 11 | 29492 | 9 | |||
105416 | 226684 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 178 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 8ft | 6005368.88002 | 2100227.87789 | 37.7471295249048 | -122.424176864772 | (37.7471295249048, -122.424176864772) | 2 | 7 | 5 | 28859 | 22 | |||
147397 | 177091 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 Santa Barbara Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 8ft | 5993412.52644 | 2086599.2418 | 37.7090262894008 | -122.464531221158 | (37.7090262894008, -122.464531221158) | 9 | 8 | 6 | 28861 | 25 | |||
149178 | 227331 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 225 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 8ft | 5998958.50232 | 2106842.59497 | 37.7649278717579 | -122.446819232638 | (37.7649278717579, -122.446819232638) | 15 | 5 | 11 | 29492 | 9 | |||
153953 | 177094 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 Santa Barbara Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 8ft | 5993369.32747 | 2086575.0773 | 37.7089574490044 | -122.464678768412 | (37.7089574490044, -122.464678768412) | 9 | 8 | 6 | 28861 | 25 | |||
171634 | 177092 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 Santa Barbara Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 8ft | 5993402.95207 | 2086595.08273 | 37.7090143176374 | -122.464564009531 | (37.7090143176374, -122.464564009531) | 9 | 8 | 6 | 28861 | 25 | |||
173104 | 177093 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 Santa Barbara Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 8ft | 5993374.13741 | 2086578.2467 | 37.7089664287264 | -122.464662374692 | (37.7089664287264, -122.464662374692) | 9 | 8 | 6 | 28861 | 25 | |||
176216 | 207979 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 6 Nordhoff St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | Width 8ft | 6000455.91103 | 2095286.74911 | 37.7332837263556 | -122.440811080593 | (37.7332837263556, -122.440811080593) | 9 | 7 | 5 | 63 | 40 | |||
191537 | 207380 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1251 Funston Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 8ft | 5992036.83974 | 2106822.46143 | 37.7644747447354 | -122.470757824839 | (37.7644747447354, -122.470757824839) | 11 | 8 | 11 | 56 | 12 | |||
2778 | 227271 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 739 27th St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 7ft | 6001729.31648 | 2099973.25035 | 37.7462242052805 | -122.436743934384 | (37.7462242052805, -122.436743934384) | 2 | 7 | 5 | 63 | 22 | |||
21372 | 207376 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1200 14th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 7ft | 5991774.71222 | 2107128.83955 | 37.7653008152139 | -122.471686772321 | (37.7653008152139, -122.471686772321) | 11 | 8 | 11 | 56 | 12 | |||
39407 | 227268 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 739 27th St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 7ft | 6001722.7938 | 2099972.97988 | 37.7462230919366 | -122.436766469611 | (37.7462230919366, -122.436766469611) | 2 | 7 | 5 | 63 | 22 | |||
63813 | 227269 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 739 27th St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 7ft | 6001725.03317 | 2099972.93353 | 37.7462230919389 | -122.436758722841 | (37.7462230919389, -122.436758722841) | 2 | 7 | 5 | 63 | 22 | |||
82534 | 249628 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2450 Golden Gate Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 7ft | 5997613.51975 | 2111318.82879 | 37.7771415320813 | -122.45179410234 | (37.7771415320813, -122.45179410234) | 15 | 6 | 2 | 54 | 16 | |||
116353 | 227267 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 739 27th St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 7ft | 6001720.54184 | 2099972.41794 | 37.7462214209976 | -122.436774216378 | (37.7462214209976, -122.436774216378) | 2 | 7 | 5 | 63 | 22 | |||
139885 | 249626 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2450 Golden Gate Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 25 | Width 7ft | 5997629.20154 | 2111320.8976 | 37.7771481106256 | -122.451740003622 | (37.7771481106256, -122.451740003622) | 15 | 6 | 2 | 54 | 16 | |||
151301 | 226674 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 145 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2015 12:00:00 AM | 18 | Width 7ft | Permit Number 21993 | 6005571.69833 | 2100193.82022 | 37.747047459974 | -122.423473113803 | (37.747047459974, -122.423473113803) | 2 | 7 | 5 | 28859 | 22 | |
171355 | 227270 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 739 27th St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 7ft | 6001726.6658 | 2099973.10248 | 37.7462236486214 | -122.43675308951 | (37.7462236486214, -122.43675308951) | 2 | 7 | 5 | 63 | 22 | |||
185700 | 249627 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2450 Golden Gate Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 27 | Width 7ft | 5997621.56946 | 2111320.25827 | 37.777145918089 | -122.451766359136 | (37.777145918089, -122.451766359136) | 15 | 6 | 2 | 54 | 16 | |||
4136 | 247842 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 74 Nevada St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 6ft | 6009022.44109 | 2098193.50191 | 37.7417491904794 | -122.411399399688 | (37.7417491904794, -122.411399399688) | 10 | 7 | 7 | 28859 | 2 | |||
26978 | 226736 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3652 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 6ft | 6005358.92953 | 2102566.09607 | 37.7535491707736 | -122.424377554773 | (37.7535491707736, -122.424377554773) | 2 | 4 | 5 | 28859 | 19 | |||
37244 | 177142 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 417 Rolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 6ft | 6002087.33741 | 2087757.61933 | 37.7127032044557 | -122.434632613123 | (37.7127032044557, -122.434632613123) | 9 | 7 | 6 | 28861 | 5 | |||
43401 | 226689 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1298 Vermont St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 6ft | 6011390.67503 | 2102355.0144 | 37.7533083467103 | -122.403503500497 | (37.7533083467103, -122.403503500497) | 10 | 4 | 8 | 28859 | 19 | |||
53204 | 226720 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1127 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6010300.3347 | 2102457.66674 | 37.7535292444798 | -122.407281376151 | (37.7535292444798, -122.407281376151) | 10 | 4 | 7 | 28859 | 19 | |||
57591 | 207856 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 494 Victoria St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 6ft | 5993273.29613 | 2090436.09778 | 37.7195533503791 | -122.465290932448 | (37.7195533503791, -122.465290932448) | 9 | 8 | 6 | 64 | 24 | |||
61147 | 177040 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 50 Rome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 6ft | 5999261.05656 | 2089438.38497 | 37.7171573523208 | -122.444521826318 | (37.7171573523208, -122.444521826318) | 9 | 7 | 6 | 28861 | 25 | |||
85180 | 226677 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 23 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 6ft | 6006022.72622 | 2100220.75054 | 37.7471468512526 | -122.421915407963 | (37.7471468512526, -122.421915407963) | 2 | 7 | 5 | 28859 | 22 | |||
90182 | 227302 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1287 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 6ft | 6003266.52543 | 2100725.05977 | 37.7483757406618 | -122.431482119803 | (37.7483757406618, -122.431482119803) | 2 | 4 | 5 | 28862 | 22 | |||
115045 | 207857 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 494 Victoria St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 6ft | 5993273.27728 | 2090450.48631 | 37.7195928567171 | -122.465292042207 | (37.7195928567171, -122.465292042207) | 9 | 8 | 6 | 64 | 24 | |||
119662 | 207980 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 341 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 5999148.95483 | 2095220.44107 | 37.733027140778 | -122.445324804895 | (37.733027140778, -122.445324804895) | 9 | 7 | 4 | 59 | 40 | |||
136619 | 226688 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1298 Vermont St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 6ft | 6011388.93256 | 2102376.14008 | 37.7533662558597 | -122.403511012536 | (37.7533662558597, -122.403511012536) | 10 | 4 | 8 | 28859 | 19 | |||
141861 | 207981 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 337 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 5999172.91711 | 2095220.21411 | 37.7330278854235 | -122.445241944983 | (37.7330278854235, -122.445241944983) | 9 | 7 | 4 | 59 | 40 | |||
143034 | 226682 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 154 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 6ft | 6005514.67234 | 2100235.81354 | 37.7471595451765 | -122.423673290311 | (37.7471595451765, -122.423673290311) | 2 | 7 | 5 | 28859 | 22 | |||
151900 | 226672 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1327 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 6ft | 6010353.59256 | 2101481.11421 | 37.7508508278045 | -122.407028370771 | (37.7508508278045, -122.407028370771) | 10 | 4 | 7 | 28859 | 19 | |||
159878 | 248212 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 67 Fair Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 45 | Width 6ft | 6007009.12213 | 2099449.33024 | 37.7450842849241 | -122.418449831818 | (37.7450842849241, -122.418449831818) | 2 | 7 | 7 | 28859 | 2 | |||
171591 | 207863 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 40 Lagunitas Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 5991134.49125 | 2095574.87688 | 37.7335395798715 | -122.47305847768 | (37.7335395798715, -122.47305847768) | 1 | 8 | 4 | 64 | 40 | |||
177239 | 207988 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 843 Detroit St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 5999421.70434 | 2095638.92389 | 37.7341917619256 | -122.444411905811 | (37.7341917619256, -122.444411905811) | 9 | 7 | 4 | 59 | 40 | |||
190827 | 177041 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 36 Rome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 5999256.25941 | 2089431.5407 | 37.7171382857881 | -122.444537916099 | (37.7171382857881, -122.444537916099) | 9 | 7 | 6 | 28861 | 25 | |||
193998 | 207855 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 494 Victoria St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 6ft | 5993274.09777 | 2090428.40721 | 37.719532280163 | -122.465287603161 | (37.719532280163, -122.465287603161) | 9 | 8 | 6 | 64 | 24 | |||
6081 | 227347 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 236 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 5ft | 6006705.44249 | 2097738.30194 | 37.7403690845706 | -122.419378544583 | (37.7403690845706, -122.419378544583) | 2 | 7 | 7 | 28859 | 2 | |||
7918 | 129616 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6007378.23169 | 2111027.62658 | 37.7768963760054 | -122.417994148015 | (37.7768963760054, -122.417994148015) | 7 | 9 | 9 | 28852 | 36 | |||
14994 | 207379 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1251 Funston Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 5ft | 5992036.47883 | 2106848.63378 | 37.7645465861817 | -122.470760979659 | (37.7645465861817, -122.470760979659) | 11 | 8 | 11 | 56 | 12 | |||
18794 | 177112 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 401 Ocean Ave | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 5ft | 5998995.97899 | 2091518.17463 | 37.7228528478523 | -122.445587543638 | (37.7228528478523, -122.445587543638) | 9 | 7 | 6 | 28861 | 25 | |||
36628 | 177109 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 401 Ocean Ave | 16 | Sidewalk: Property side : Yard | Tree | MTA 3 | 6 | Width 5ft | 5998958.08532 | 2091518.52367 | 37.7228516427597 | -122.445718558684 | (37.7228516427597, -122.445718558684) | 9 | 7 | 6 | 28861 | 25 | |||
43775 | 177066 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 573 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6002664.89947 | 2090416.35383 | 37.7200362746301 | -122.432826194382 | (37.7200362746301, -122.432826194382) | 9 | 7 | 6 | 28861 | 5 | |||
47041 | 177110 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 401 Ocean Ave | 17 | Sidewalk: Property side : Yard | Tree | MTA 3 | 6 | Width 5ft | 5998978.57855 | 2091518.53644 | 37.722852847868 | -122.445647719081 | (37.722852847868, -122.445647719081) | 9 | 7 | 6 | 28861 | 25 | |||
49633 | 177105 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 401 Ocean Ave | 12 | Sidewalk: Property side : Yard | Tree | MTA 3 | 4 | Width 5ft | 5998924.5969 | 2091518.78116 | 37.7228504376811 | -122.445834339179 | (37.7228504376811, -122.445834339179) | 9 | 7 | 6 | 28861 | 25 | |||
56278 | 227508 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 41 Brady St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 5ft | 6006644.81895 | 2109605.92162 | 37.7729514108221 | -122.420430313409 | (37.7729514108221, -122.420430313409) | 8 | 2 | 9 | 28853 | 19 | |||
57339 | 177108 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 401 Ocean Ave | 15 | Sidewalk: Property side : Yard | Tree | MTA 3 | 5 | Width 5ft | 5998950.80755 | 2091518.23612 | 37.7228504376851 | -122.44574369564 | (37.7228504376851, -122.44574369564) | 9 | 7 | 6 | 28861 | 25 | |||
63651 | 177111 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 401 Ocean Ave | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 5ft | 5998987.39789 | 2091518.79195 | 37.7228540529596 | -122.445617250956 | (37.7228540529596, -122.445617250956) | 9 | 7 | 6 | 28861 | 25 | |||
64179 | 226735 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 160 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 6005280.38747 | 2104021.86948 | 37.7575419493218 | -122.424752726758 | (37.7575419493218, -122.424752726758) | 2 | 4 | 5 | 28859 | 19 | |||
68645 | 226757 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 209 Day St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 6004291.47259 | 2098662.30016 | 37.7427699165123 | -122.427790919941 | (37.7427699165123, -122.427790919941) | 2 | 7 | 5 | 63 | 22 | |||
71491 | 227274 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1533 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6002044.25876 | 2099560.43078 | 37.7451085935954 | -122.435625375609 | (37.7451085935954, -122.435625375609) | 2 | 7 | 5 | 63 | 22 | |||
72191 | 226700 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 68 Ramona Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 5ft | 6005192.67136 | 2107448.02367 | 37.7669444026985 | -122.425299885982 | (37.7669444026985, -122.425299885982) | 8 | 4 | 5 | 28853 | 19 | |||
78388 | 177061 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 550 Geneva Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 5ft | 5999007.90612 | 2090532.0864 | 37.7201459577571 | -122.44547544316 | (37.7201459577571, -122.44547544316) | 9 | 7 | 6 | 28861 | 25 | |||
80623 | 177063 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 550 Geneva Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 5999015.35979 | 2090528.72065 | 37.7201371416945 | -122.445449436536 | (37.7201371416945, -122.445449436536) | 9 | 7 | 6 | 28861 | 25 | |||
86795 | 177126 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 100 Yale St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6006914.16107 | 2093507.15679 | 37.7287630439686 | -122.418356948033 | (37.7287630439686, -122.418356948033) | 9 | 3 | 7 | 309 | 5 | |||
93093 | 226679 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 136 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6005601.15773 | 2100240.79001 | 37.747178090992 | -122.42337458408 | (37.747178090992, -122.42337458408) | 2 | 7 | 5 | 28859 | 22 | |||
97076 | 227383 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2930 22nd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 6008681.22938 | 2103336.88405 | 37.7558526268097 | -122.412942772087 | (37.7558526268097, -122.412942772087) | 2 | 4 | 7 | 28859 | 19 | |||
100752 | 227237 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2707 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6008953.6424 | 2102708.04088 | 37.754141252929 | -122.411956239197 | (37.754141252929, -122.411956239197) | 2 | 4 | 7 | 28859 | 19 | |||
104597 | 177060 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 550 Geneva Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 5999004.71102 | 2090533.49079 | 37.7201496314864 | -122.445486588437 | (37.7201496314864, -122.445486588437) | 9 | 7 | 6 | 28861 | 25 | |||
110031 | 177059 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 550 Geneva Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 5999000.98419 | 2090535.17383 | 37.7201540399677 | -122.445499591747 | (37.7201540399677, -122.445499591747) | 9 | 7 | 6 | 28861 | 25 | |||
110433 | 226721 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1123 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 5ft | 6010296.19253 | 2102509.90887 | 37.753672457944 | -122.407299383281 | (37.753672457944, -122.407299383281) | 10 | 4 | 7 | 28859 | 19 | |||
110775 | 129642 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1161 Greenwich St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 5ft | 6007337.31848 | 2119837.29751 | 37.8010832638317 | -122.418760599735 | (37.8010832638317, -122.418760599735) | 5 | 1 | 1 | 28858 | 32 | |||
110964 | 177062 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 550 Geneva Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 5999011.63296 | 2090530.40369 | 37.7201415501799 | -122.445462439842 | (37.7201415501799, -122.445462439842) | 9 | 7 | 6 | 28861 | 25 | |||
113916 | 227283 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 4412 23rd St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 5ft | 6000531.63027 | 2102304.55034 | 37.7525572554152 | -122.441052598925 | (37.7525572554152, -122.441052598925) | 2 | 4 | 5 | 28862 | 22 | |||
118018 | 207989 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 843 Detroit St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 5999418.49849 | 2095586.86925 | 37.7340486492241 | -122.444419249659 | (37.7340486492241, -122.444419249659) | 9 | 7 | 4 | 59 | 40 | |||
120391 | 226717 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1266 Hampshire St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 6010290.67208 | 2101875.60001 | 37.7519304774296 | -122.407273762489 | (37.7519304774296, -122.407273762489) | 2 | 4 | 7 | 28859 | 19 | |||
130501 | 226716 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1266 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 5ft | 6010288.92678 | 2101895.83233 | 37.751985933225 | -122.407281224142 | (37.751985933225, -122.407281224142) | 2 | 4 | 7 | 28859 | 19 | |||
130926 | 177067 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 573 Edinburgh St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 5ft | 6002673.20995 | 2090427.02699 | 37.7200660520992 | -122.432798229977 | (37.7200660520992, -122.432798229977) | 9 | 7 | 6 | 28861 | 5 | |||
131753 | 191447 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300 Phelps St | 10 | : | Tree | Private 2 | 15 | Width 5ft | 6014017.68905 | 2096332.11237 | 37.7369171097253 | -122.393997082801 | (37.7369171097253, -122.393997082801) | 10 | 3 | 8 | 58 | 1 | |||
140699 | 207375 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1240 14th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 5ft | 5991777.76001 | 2107019.09717 | 37.7649996682339 | -122.471668232808 | (37.7649996682339, -122.471668232808) | 11 | 8 | 11 | 56 | 12 | |||
156399 | 226756 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 209 Day St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6004170.54319 | 2098656.13064 | 37.7427461348209 | -122.428208619938 | (37.7427461348209, -122.428208619938) | 2 | 7 | 5 | 63 | 22 | |||
159719 | 191439 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2205 25th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 27 | Width 5ft | 6012190.61304 | 2101859.85462 | 37.7519933949033 | -122.400702349738 | (37.7519933949033, -122.400702349738) | 10 | 3 | 8 | 28856 | 29 | |||
160869 | 129590 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1870 Sacramento St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 5ft | 6005845.5146 | 2116275.22301 | 37.7912186002945 | -122.423669483476 | (37.7912186002945, -122.423669483476) | 13 | 9 | 1 | 28858 | 27 | |||
165567 | 177107 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 401 Ocean Ave | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 5998942.44698 | 2091518.84886 | 37.7228516427689 | -122.445772640307 | (37.7228516427689, -122.445772640307) | 9 | 7 | 6 | 28861 | 25 | |||
167471 | 129617 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6007383.9261 | 2110990.71861 | 37.776795356048 | -122.417971832253 | (37.776795356048, -122.417971832253) | 7 | 9 | 9 | 28852 | 36 | |||
173815 | 177104 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 401 Ocean Ave | 11 | Sidewalk: Property side : Yard | Tree | MTA 3 | 4 | Width 5ft | 5998921.08183 | 2091519.29315 | 37.7228516427808 | -122.445846526795 | (37.7228516427808, -122.445846526795) | 9 | 7 | 6 | 28861 | 25 | |||
174539 | 129589 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1870 Sacramento St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 5ft | 6005852.90495 | 2116274.14842 | 37.7912160669044 | -122.423643836609 | (37.7912160669044, -122.423643836609) | 13 | 9 | 1 | 28858 | 27 | |||
174783 | 227318 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 4346 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 5ft | 6000939.47796 | 2102320.11678 | 37.7526232188869 | -122.439643310892 | (37.7526232188869, -122.439643310892) | 2 | 4 | 5 | 28862 | 22 | |||
176521 | 177106 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 401 Ocean Ave | 13 | Sidewalk: Property side : Yard | Tree | MTA 3 | 7 | Width 5ft | 5998933.17773 | 2091518.16383 | 37.7228492325857 | -122.445804632792 | (37.7228492325857, -122.445804632792) | 9 | 7 | 6 | 28861 | 25 | |||
183341 | 227282 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 4412 23rd St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 5ft | 6000544.37543 | 2102304.8503 | 37.7525588049644 | -122.441008545612 | (37.7525588049644, -122.441008545612) | 2 | 4 | 5 | 28862 | 22 | |||
185359 | 227454 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 31 Henry St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6003284.13027 | 2107394.52295 | 37.7666894934374 | -122.431897401555 | (37.7666894934374, -122.431897401555) | 15 | 5 | 5 | 28862 | 3 | |||
2105 | 227358 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 99X Ogden Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6007594.39314 | 2096161.75328 | 37.7360902568635 | -122.416193267317 | (37.7360902568635, -122.416193267317) | 2 | 7 | 7 | 28859 | 2 | |||
2410 | 207916 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 Pacheco St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5994697.35407 | 2099701.10711 | 37.7450748213407 | -122.461039698642 | (37.7450748213407, -122.461039698642) | 1 | 8 | 4 | 59 | 40 | |||
11598 | 227356 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 99X Ogden Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6007559.31004 | 2096165.80664 | 37.7360994137559 | -122.416314851151 | (37.7360994137559, -122.416314851151) | 2 | 7 | 7 | 28859 | 2 | |||
14969 | 191498 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1198 La Salle Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | Width 4ft | 6016692.24365 | 2094766.72457 | 37.7327671503753 | -122.384640862701 | (37.7327671503753, -122.384640862701) | 10 | 3 | 8 | 58 | 1 | |||
15724 | 227357 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 99X Ogden Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6007581.53732 | 2096160.90491 | 37.736087204549 | -122.416237655152 | (37.736087204549, -122.416237655152) | 2 | 7 | 7 | 28859 | 2 | |||
15786 | 129665 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2300 Powell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6009349.70654 | 2121620.88667 | 37.8060936540688 | -122.411922953492 | (37.8060936540688, -122.411922953492) | 3 | 1 | 10 | 308 | 23 | |||
16019 | 226708 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1098 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6005707.60508 | 2102663.54756 | 37.7538364331257 | -122.423178683847 | (37.7538364331257, -122.423178683847) | 2 | 4 | 5 | 28859 | 19 | |||
17812 | 129601 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2230 Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6005516.81947 | 2117765.82234 | 37.7952928511338 | -122.424912856464 | (37.7952928511338, -122.424912856464) | 13 | 9 | 1 | 28858 | 27 | |||
19703 | 129607 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2101 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6005934.12087 | 2117690.49416 | 37.7951095809901 | -122.42346356661 | (37.7951095809901, -122.42346356661) | 13 | 9 | 1 | 28858 | 27 | |||
20436 | 227185 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 979 Ashbury St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5999188.84742 | 2106648.55947 | 37.764408255174 | -122.446008572935 | (37.764408255174, -122.446008572935) | 15 | 5 | 11 | 29492 | 9 | |||
21415 | 227187 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 298 Upper Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5999316.38206 | 2105982.07335 | 37.7625855326061 | -122.445519538714 | (37.7625855326061, -122.445519538714) | 15 | 5 | 5 | 29492 | 9 | |||
21673 | 129611 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1700 Pacific Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6005874.36357 | 2117588.54131 | 37.7948262711743 | -122.423663083898 | (37.7948262711743, -122.423663083898) | 13 | 9 | 1 | 28858 | 27 | |||
21862 | 191445 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1451 19th St | 3 | : | Tree | Private 2 | 4 | Width 4ft | 6013335.75988 | 2105192.04749 | 37.7612066758622 | -122.396975847857 | (37.7612066758622, -122.396975847857) | 10 | 3 | 8 | 28856 | 29 | |||
22005 | 227490 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1893 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6004623.20474 | 2097581.86585 | 37.7398220503353 | -122.426566965987 | (37.7398220503353, -122.426566965987) | 2 | 7 | 5 | 63 | 7 |
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) );