trees
2,180 rows where qSpecies_id = 57 sorted by SiteOrder
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
36032 | 227407 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 4081 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6002697.30984 | 2101792.98793 | 37.7512757413015 | -122.433526759971 | (37.7512757413015, -122.433526759971) | 2 | 4 | 5 | 28862 | 22 | |||
36185 | 226697 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 20 Ramona Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6005179.7337 | 2107663.13063 | 37.767534303997 | -122.425359944512 | (37.767534303997, -122.425359944512) | 8 | 4 | 5 | 28853 | 19 | |||
36321 | 191463 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 54 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6014423.52986 | 2112756.14838 | 37.7820365051332 | -122.393743143935 | (37.7820365051332, -122.393743143935) | 6 | 2 | 9 | 28856 | 6 | |||
36663 | 142060 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1100 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004266.4173 | 2112234.0727 | 37.7800333508893 | -122.428844891753 | (37.7800333508893, -122.428844891753) | 7 | 9 | 11 | 29490 | 41 | |||
36670 | 87156 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 237 Rivoli St | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 50138 | 5997662 | 2105892 | 37.7622436280127 | -122.451234923187 | (37.7622436280127, -122.451234923187) | 15 | 5 | 11 | 29492 | 9 | ||||
36797 | 207940 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2120 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5992601.59183 | 2100997.50746 | 37.7485135824496 | -122.468380708921 | (37.7485135824496, -122.468380708921) | 1 | 8 | 4 | 29491 | 40 | |||
36939 | 226702 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1840 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6005169.02744 | 2107248.98052 | 37.7663965419853 | -122.425367500632 | (37.7663965419853, -122.425367500632) | 8 | 4 | 5 | 28853 | 19 | |||
37009 | 226745 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 45 Mullen Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009514.45698 | 2099883.60533 | 37.7464174282201 | -122.409817438224 | (37.7464174282201, -122.409817438224) | 2 | 7 | 7 | 28859 | 2 | |||
37048 | 129586 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1915 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6004232.4663 | 2118008.34749 | 37.795886133905 | -122.429374228549 | (37.795886133905, -122.429374228549) | 13 | 9 | 1 | 28858 | 27 | |||
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 | |||
37287 | 118089 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 7049 Geary Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 1ft | 5985075.84275 | 2112426.03783 | 37.7794555626476 | -122.495246917032 | (37.7794555626476, -122.495246917032) | 11 | 6 | 2 | 55 | 26 | |||
37311 | 60032 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 301 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1982 12:00:00 AM | Permit Number 19520 | 6014916.63829129 | 2112653.79570554 | 37.7817828574395 | -122.39203004009 | (37.7817828574395, -122.39203004009) | 6 | 2 | 9 | 28856 | 6 | ||
37883 | 191433 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 394 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6011433.59566 | 2106622.69628 | 37.7650288494299 | -122.403655324029 | (37.7650288494299, -122.403655324029) | 8 | 3 | 8 | 28853 | 20 | |||
38100 | 226730 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3523 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006086.82358 | 2104904.02653 | 37.7600096611364 | -122.422026407688 | (37.7600096611364, -122.422026407688) | 2 | 4 | 5 | 28859 | 19 | |||
38133 | 177079 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 411 Blanken Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6012724.51952 | 2087052.83346 | 37.7113661383121 | -122.397817475721 | (37.7113661383121, -122.397817475721) | 10 | 3 | 8 | 309 | 1 | |||
38220 | 137559 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1224 PIERCE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6002326.9591 | 2112731.4947 | 37.7812891828305 | -122.435589937755 | (37.7812891828305, -122.435589937755) | 15 | 5 | 11 | 29490 | 41 | |||
38475 | 10230 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1426 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 2x3 | 6005817.36142 | 2100645.21865 | 37.7483007596771 | -122.422655702902 | (37.7483007596771, -122.422655702902) | 2 | 4 | 5 | 28859 | 19 | |||
38548 | 207371 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1406 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5992131.14604 | 2105828.32493 | 37.7617505624579 | -122.470359244405 | (37.7617505624579, -122.470359244405) | 1 | 8 | 4 | 56 | 12 | |||
38760 | 207973 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 Cresta Vista Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5995100.87909 | 2096206.06428 | 37.7355015111722 | -122.459391325848 | (37.7355015111722, -122.459391325848) | 9 | 7 | 4 | 59 | 40 | |||
38764 | 207881 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1631 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5992440.55655 | 2104337.16872 | 37.7576741235779 | -122.469180593809 | (37.7576741235779, -122.469180593809) | 1 | 8 | 4 | 56 | 12 | |||
39135 | 12169 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1425X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/16/1992 12:00:00 AM | 3 | 3X3 | 6016491.2755 | 2094964.9733 | 37.7333003856228 | -122.385349476433 | (37.7333003856228, -122.385349476433) | 10 | 3 | 8 | 58 | 1 | ||
39347 | 227502 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 46 Digby St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6002908.65564 | 2097548.38173 | 37.739633032631 | -122.432492759035 | (37.739633032631, -122.432492759035) | 2 | 7 | 5 | 63 | 7 | |||
39406 | 129582 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 2230 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6003450.16372 | 2117252.10795 | 37.7937653733223 | -122.432027112554 | (37.7937653733223, -122.432027112554) | 13 | 9 | 1 | 29490 | 27 | |||
39465 | 67244 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 5524 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/1992 12:00:00 AM | 7 | Permit Number 30708 | 5981494.88729 | 2111682.33433 | 37.7772032645806 | -122.507579541736 | (37.7772032645806, -122.507579541736) | 11 | 6 | 2 | 55 | 26 | |
39636 | 227448 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3988 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003796.30344 | 2104233.88994 | 37.7580401746408 | -122.429900410178 | (37.7580401746408, -122.429900410178) | 2 | 4 | 5 | 28862 | 3 | |||
40197 | 12213 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1503 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016014.681 | 2095761.1814 | 37.7354602343635 | -122.387052723732 | (37.7354602343635, -122.387052723732) | 10 | 3 | 8 | 58 | 1 | |||
40333 | 226731 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 114 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6005459.85628 | 2104033.16362 | 37.7575830951141 | -122.424132853742 | (37.7575830951141, -122.424132853742) | 2 | 4 | 5 | 28859 | 19 | |||
40584 | 6057 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1905 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4X4 | 6001269.0972 | 2112453.6996 | 37.7804662874281 | -122.439229695393 | (37.7804662874281, -122.439229695393) | 15 | 5 | 11 | 29490 | 41 | |||
40616 | 141229 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2 COLLINS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5998120.3361 | 2114458.595 | 37.7857915234083 | -122.450267251614 | (37.7857915234083, -122.450267251614) | 15 | 6 | 1 | 54 | 31 | |||
40866 | 137562 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1341 STEINER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6002737.4159 | 2112945.2111 | 37.7818992986555 | -122.434185243226 | (37.7818992986555, -122.434185243226) | 15 | 9 | 11 | 29490 | 41 | |||
40912 | 227306 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1470 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003270.17253 | 2099678.81961 | 37.7455032161105 | -122.431394832509 | (37.7455032161105, -122.431394832509) | 2 | 7 | 5 | 63 | 22 | |||
41151 | 227431 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 41 Eagle St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6000052.00191 | 2104388.30047 | 37.7582513938931 | -122.442860850467 | (37.7582513938931, -122.442860850467) | 2 | 4 | 5 | 28862 | 3 | |||
41197 | 129600 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2230 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6005520.4 | 2117740.68195 | 37.7952240242221 | -122.424898677743 | (37.7952240242221, -122.424898677743) | 13 | 9 | 1 | 28858 | 27 | |||
41356 | 207975 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 538 Teresita Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5998933.25341 | 2097323.81684 | 37.7387901961225 | -122.44622178873 | (37.7387901961225, -122.44622178873) | 9 | 7 | 4 | 59 | 40 | |||
41391 | 68819 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 201 Detroit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1993 12:00:00 AM | Permit Number 32767 | 5999394.1666158 | 2093791.36471631 | 37.729117226145 | -122.444374381277 | (37.729117226145, -122.444374381277) | 9 | 7 | 4 | 28861 | 40 | ||
41442 | 35152 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 265 Laussat St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/1998 12:00:00 AM | Permit Number 38683 | 6003463.92079467 | 2109118.95080504 | 37.7714345424169 | -122.431398649315 | (37.7714345424169, -122.431398649315) | 15 | 9 | 11 | 29492 | 10 | ||
41916 | 64559 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1562 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/1988 12:00:00 AM | 12 | Permit Number 25450 | 6000352.3546 | 2110302.164 | 37.7745065091562 | -122.442246634385 | (37.7745065091562, -122.442246634385) | 15 | 5 | 11 | 29492 | 16 | |
41981 | 57660 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 4417 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/1976 12:00:00 AM | 3x3 | Permit Number 772993 | 6001718.02788931 | 2104070.42319625 | 37.7574734209258 | -122.437076257467 | (37.7574734209258, -122.437076257467) | 2 | 4 | 5 | 28862 | 3 | ||
42108 | 12331 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1045 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 4X4 | 6004735.87767 | 2112555.20778 | 37.7809416686235 | -122.427243697772 | (37.7809416686235, -122.427243697772) | 7 | 9 | 11 | 29490 | 41 | |||
42241 | 227242 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 96 Red Rock Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6000317.34123 | 2100126.86957 | 37.7465656607776 | -122.441637379485 | (37.7465656607776, -122.441637379485) | 2 | 7 | 5 | 63 | 22 | |||
42683 | 226693 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 19 Ramona Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6005205.2228 | 2107708.26008 | 37.7676596586977 | -122.425274992744 | (37.7676596586977, -122.425274992744) | 8 | 4 | 5 | 28853 | 19 | |||
42717 | 227211 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 225 Montcalm St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 23 | Width 3ft | 6009836.16533 | 2099585.28248 | 37.7456163229324 | -122.408683960589 | (37.7456163229324, -122.408683960589) | 2 | 7 | 7 | 28859 | 2 | |||
42807 | 207398 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 160 Lomita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5991337.5246 | 2104227.06806 | 37.7573080176715 | -122.472987263976 | (37.7573080176715, -122.472987263976) | 1 | 8 | 4 | 56 | 12 | |||
42856 | 10143 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 920 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6005657.84848 | 2103570.53997 | 37.7563240154596 | -122.423415228047 | (37.7563240154596, -122.423415228047) | 2 | 4 | 5 | 28859 | 19 | |||
42955 | 51053 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 557 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2004 12:00:00 AM | Permit Number 47523 | 6002734.05323147 | 2103248.96658127 | 37.7552755973804 | -122.433503735784 | (37.7552755973804, -122.433503735784) | 2 | 4 | 5 | 28862 | 22 | |||
43123 | 227280 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 485 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 6002019.43775 | 2101461.49358 | 37.7503270527496 | -122.4358471979 | (37.7503270527496, -122.4358471979) | 2 | 4 | 5 | 28862 | 22 | |||
43434 | 49432 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 364@ KEARNY Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2003 12:00:00 AM | 7 | Permit Number 46371 | 6011662.83332 | 2116037.23111 | 37.7908917875712 | -122.403524862095 | (37.7908917875712, -122.403524862095) | 4 | 1 | 10 | 28854 | 6 | ||
43516 | 61858 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1150 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1985 12:00:00 AM | Permit Number 21898 | 6010250.43626462 | 2102515.61174925 | 37.7536855558022 | -122.40745802144 | (37.7536855558022, -122.40745802144) | 2 | 4 | 7 | 28859 | 19 | ||
43613 | 200620 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1417 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6016438.5299 | 2095044.7197 | 37.7335164350719 | -122.385537389897 | (37.7335164350719, -122.385537389897) | 10 | 3 | 8 | 58 | 1 | |||
43635 | 227350 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 30 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 3ft | 6007376.4096 | 2099328.82091 | 37.7447740628849 | -122.417171275545 | (37.7447740628849, -122.417171275545) | 2 | 7 | 7 | 28859 | 2 | |||
43651 | 65893 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 116 Palm Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/31/1990 12:00:00 AM | 9 | Permit Number 28900 | 5995931.63622 | 2113606.82428 | 37.7833272906212 | -122.457777832601 | (37.7833272906212, -122.457777832601) | 11 | 6 | 1 | 54 | 31 | |
43654 | 114877 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 226 BRODERICK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001315 | 2109584 | 37.7725894276985 | -122.438865189694 | (37.7725894276985, -122.438865189694) | 15 | 5 | 11 | 29492 | 9 | ||||
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 | |||
43850 | 35726 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 190 Dartmouth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/14/1998 12:00:00 AM | Permit Number 39007 | 6008565.46175199 | 2093223.89460892 | 37.7280780839519 | -122.412628258541 | (37.7280780839519, -122.412628258541) | 9 | 3 | 7 | 309 | 28 | ||
43925 | 112146 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 299X 05TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6011616 | 2112272 | 37.7805507327562 | -122.403421899857 | (37.7805507327562, -122.403421899857) | 6 | 2 | 9 | 28853 | 34 | |||
44037 | 226739 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1052 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010223.2273 | 2103077.92399 | 37.7552280170702 | -122.407591760047 | (37.7552280170702, -122.407591760047) | 2 | 4 | 7 | 28859 | 19 | |||
44258 | 67564 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1015 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/15/2014 12:00:00 AM | 15 | Permit Number 31116 | 6011653.24401 | 2103633.28884 | 37.756832869858 | -122.402685364734 | (37.756832869858, -122.402685364734) | 10 | 3 | 8 | 28856 | 29 | |
44461 | 51606 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2321 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Permit Number 47903 | 6001273.37015 | 2116460.68929 | 37.7914686945789 | -122.439502237855 | (37.7914686945789, -122.439502237855) | 13 | 6 | 1 | 29490 | 27 | |||
44660 | 177090 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 36 Santa Cruz Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 2ft | 5993074.95832 | 2086622.9468 | 37.7090719120225 | -122.46569961766 | (37.7090719120225, -122.46569961766) | 9 | 8 | 6 | 28861 | 25 | |||
44808 | 20275 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2291 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2X2 | 6009755.78997 | 2121736.88906 | 37.8064349417299 | -122.410525825802 | (37.8064349417299, -122.410525825802) | 3 | 1 | 10 | 308 | 23 | |||
44846 | 129615 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 211 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6006279.39268 | 2111260.53143 | 37.7774739709929 | -122.421811920298 | (37.7774739709929, -122.421811920298) | 7 | 9 | 11 | 28852 | 10 | |||
44969 | 17717 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1244 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/1992 12:00:00 AM | 6 | 3X3 | 6002311.9369 | 2112856.7932 | 37.7816323676405 | -122.435650874011 | (37.7816323676405, -122.435650874011) | 15 | 5 | 11 | 29490 | 41 | ||
45173 | 66827 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2351 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/22/1994 12:00:00 AM | 7 | 3x3 | Permit Number 33308 | 6009276.00847 | 2121806.91361 | 37.8066003024322 | -122.412191154694 | (37.8066003024322, -122.412191154694) | 3 | 1 | 10 | 308 | 23 | |
45354 | 227346 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 146 Bradford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009526.45825 | 2097773.0202 | 37.7406228957322 | -122.409626996885 | (37.7406228957322, -122.409626996885) | 10 | 7 | 7 | 28859 | 2 | |||
45391 | 65826 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2267 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/07/1990 12:00:00 AM | 10 | Permit Number 28816 | 6000491.01592 | 2119920.15776 | 37.8009229255132 | -122.442457641208 | (37.8009229255132, -122.442457641208) | 13 | 9 | 1 | 57 | 17 | |
45809 | 227403 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 557 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002706.87163 | 2103251.87768 | 37.7552820483346 | -122.433597945801 | (37.7552820483346, -122.433597945801) | 2 | 4 | 5 | 28862 | 22 | |||
46037 | 12311 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 959X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6004793.556 | 2112123.84108 | 37.7797605037857 | -122.427013427347 | (37.7797605037857, -122.427013427347) | 7 | 9 | 11 | 29490 | 41 | |||
46411 | 10221 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1370 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 65 | 3X3 | 6005802.11698 | 2100976.83229 | 37.7492104347131 | -122.422731980696 | (37.7492104347131, -122.422731980696) | 2 | 4 | 5 | 28859 | 19 | |||
46509 | 207887 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1324 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5995205.50671 | 2106558.40833 | 37.7639324562531 | -122.459779220539 | (37.7639324562531, -122.459779220539) | 15 | 5 | 11 | 56 | 12 | |||
46707 | 246134 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1302 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5999521.4239 | 2108333.7743 | 37.7690544177856 | -122.444979441835 | (37.7690544177856, -122.444979441835) | 15 | 5 | 11 | 29492 | 9 | |||
46742 | 227285 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 4416 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6000519.34087 | 2101713.08448 | 37.7509325330251 | -122.441052668149 | (37.7509325330251, -122.441052668149) | 2 | 4 | 5 | 28862 | 22 | |||
46976 | 227396 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 5 28th St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 3ft | 6005864.94303 | 2099629.40283 | 37.7455142453913 | -122.422418999536 | (37.7455142453913, -122.422418999536) | 2 | 7 | 5 | 28859 | 22 | |||
47088 | 246495 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 359 Duncan St | 1 | : | Tree | Private 2 | 15 | Width 3ft | 6004220.12982 | 2099827.66275 | 37.7459656978564 | -122.428120633885 | (37.7459656978564, -122.428120633885) | 2 | 7 | 5 | 63 | 22 | |||
47146 | 207941 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2194 12th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 5992629.8459 | 2100501.88116 | 37.7471543516012 | -122.468246957242 | (37.7471543516012, -122.468246957242) | 1 | 8 | 4 | 29491 | 40 | |||
47431 | 227332 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 241 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5998971.82186 | 2106730.89161 | 37.7646219232843 | -122.446765125805 | (37.7646219232843, -122.446765125805) | 15 | 5 | 11 | 29492 | 9 | |||
47478 | 68437 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 190 09th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/1993 12:00:00 AM | 22 | Permit Number 32291 | 6008616.38965 | 2110404.13314 | 37.7752540178903 | -122.413666857651 | (37.7752540178903, -122.413666857651) | 8 | 2 | 9 | 28853 | 34 | ||
48203 | 33325 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3129 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | 6 | Permit Number 37467 | 6004621.77515 | 2120339.17959 | 37.8023080334521 | -122.428193340463 | (37.8023080334521, -122.428193340463) | 13 | 9 | 1 | 57 | 17 | |
48220 | 129574 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2033 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001410.38478 | 2115467.41411 | 37.788749214855 | -122.438956956408 | (37.788749214855, -122.438956956408) | 13 | 6 | 1 | 29490 | 27 | |||
48262 | 226678 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 26 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006027.8785 | 2100265.88804 | 37.7472710791156 | -122.421900797581 | (37.7472710791156, -122.421900797581) | 2 | 7 | 7 | 28859 | 22 | |||
48548 | 207825 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 318 Edna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 5998773.91713 | 2093910.347 | 37.7294085152774 | -122.446527182289 | (37.7294085152774, -122.446527182289) | 9 | 7 | 4 | 28861 | 40 | |||
48552 | 227464 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 99 Uranus Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999375.15266 | 2105248.68232 | 37.7605751782337 | -122.445263541285 | (37.7605751782337, -122.445263541285) | 15 | 5 | 5 | 28862 | 3 | |||
48624 | 129633 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1828 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007334.41691 | 2118641.32283 | 37.7977992544837 | -122.418685778819 | (37.7977992544837, -122.418685778819) | 5 | 1 | 10 | 28858 | 32 | |||
48667 | 207846 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 160 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5995656.91883 | 2090949.83096 | 37.7211011142092 | -122.457088808724 | (37.7211011142092, -122.457088808724) | 9 | 8 | 6 | 28861 | 24 | |||
48888 | 227441 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 4200 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6002352.79055 | 2104154.11229 | 37.757739271379 | -122.434886981866 | (37.757739271379, -122.434886981866) | 2 | 4 | 5 | 28862 | 3 | |||
48890 | 227349 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 34 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007366.20889 | 2099309.50261 | 37.7447204452856 | -122.41720517909 | (37.7447204452856, -122.41720517909) | 2 | 7 | 7 | 28859 | 2 | |||
48919 | 226713 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1061 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6010264.70472 | 2103053.83895 | 37.7551642065834 | -122.407446620265 | (37.7551642065834, -122.407446620265) | 10 | 4 | 7 | 28859 | 19 | |||
49050 | 227322 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 107 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6000618.20547 | 2102486.60155 | 37.7530620547894 | -122.440766265559 | (37.7530620547894, -122.440766265559) | 2 | 4 | 5 | 28862 | 22 | |||
49140 | 56420 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 231 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/1973 12:00:00 AM | 7 | Permit Number 12580 | 5990219.56418 | 2113818.46401 | 37.7835785885278 | -122.477554600218 | (37.7835785885278, -122.477554600218) | 11 | 6 | 2 | 55 | 26 | ||
49213 | 207982 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 620 Detroit St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5999457.28605 | 2095077.61427 | 37.7326525677521 | -122.444248566437 | (37.7326525677521, -122.444248566437) | 9 | 7 | 4 | 63 | 40 | |||
49475 | 59083 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 771 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/1980 12:00:00 AM | 5 | Permit Number 18384 | 5993309.0611 | 2110688.13822 | 37.7751623558712 | -122.466638605274 | (37.7751623558712, -122.466638605274) | 11 | 6 | 2 | 54 | 11 | ||
49882 | 62789 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 196 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/1986 12:00:00 AM | Permit Number 23145 | 6000321.17614419 | 2091703.51030925 | 37.7234373055999 | -122.441019917909 | (37.7234373055999, -122.441019917909) | 9 | 7 | 6 | 28861 | 25 | ||
50151 | 67223 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 555 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1992 12:00:00 AM | 6 | Permit Number 30682 | 5981290.9854 | 2111950.9362 | 37.7779287520405 | -122.508304833393 | (37.7779287520405, -122.508304833393) | 11 | 6 | 2 | 55 | 26 | |
50331 | 177143 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 224 Naylor St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 3ft | 6002598.76646 | 2086748.83961 | 37.7099623361716 | -122.432792933869 | (37.7099623361716, -122.432792933869) | 9 | 7 | 6 | 28861 | 5 | |||
50578 | 177099 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 377 Delano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5999714.66231 | 2091641.03543 | 37.7232311998395 | -122.443112033811 | (37.7232311998395, -122.443112033811) | 9 | 7 | 6 | 28861 | 25 | |||
50603 | 25289 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 136 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6000745.99488 | 2091748.78566 | 37.7235858088167 | -122.439554644937 | (37.7235858088167, -122.439554644937) | 9 | 7 | 6 | 28861 | 25 | |||
50748 | 50368 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2784 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2003 12:00:00 AM | 4 | Permit Number 47035 | 6000204.6547 | 2114445.9464 | 37.7858758547183 | -122.443055209056 | (37.7858758547183, -122.443055209056) | 13 | 6 | 1 | 29490 | 27 | ||
51032 | 227372 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1152 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008039.11293 | 2101220.27352 | 37.750004828364 | -122.415013618485 | (37.750004828364, -122.415013618485) | 2 | 4 | 7 | 28859 | 19 | |||
51102 | 62019 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1617 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/21/1991 12:00:00 AM | 7 | Permit Number 29660 | 5999580.2026 | 2114540.2826 | 37.7860992534846 | -122.445222417327 | (37.7860992534846, -122.445222417327) | 15 | 6 | 1 | 29490 | 31 | |
51213 | 227504 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 16 Ohlone Way | 1 | Back Yard : Yard | Tree | Private 2 | 3 | Width 2ft | 6002174.41423 | 2096447.25188 | 37.7365679209746 | -122.434952717804 | (37.7365679209746, -122.434952717804) | 2 | 7 | 5 | 63 | 7 | |||
51222 | 207848 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 833 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5995895.43899 | 2089793.88094 | 37.7179408434817 | -122.456180784842 | (37.7179408434817, -122.456180784842) | 9 | 8 | 6 | 28861 | 24 |
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) );