trees
2,180 rows where qSpecies_id = 57 sorted by DBH 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 87906 | 10055 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 432 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X2 | 6005503.26278 | 2106415.24362 | 37.7641261764966 | -122.424152141508 | (37.7641261764966, -122.424152141508) | 8 | 4 | 5 | 28859 | 19 | |||
| 1280 | 191487 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 288 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010205.79697 | 2110974.44372 | 37.7769090816273 | -122.408208942312 | (37.7769090816273, -122.408208942312) | 8 | 2 | 9 | 28853 | 34 | |||
| 4286 | 227210 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 35 Powhattan Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 3ft | 6007555 | 2098218 | 37.7417340415028 | -122.416475073326 | (37.7417340415028, -122.416475073326) | 2 | 7 | 7 | 28859 | 2 | |||
| 6285 | 72175 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2243 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6000606.57902 | 2119937.60106 | 37.8009774064533 | -122.442058997842 | (37.8009774064533, -122.442058997842) | 13 | 9 | 1 | 57 | 17 | |||
| 6534 | 140294 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 180 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5998301.012 | 2110133.2386 | 37.7739255579875 | -122.449330419507 | (37.7739255579875, -122.449330419507) | 15 | 5 | 11 | 29492 | 16 | |||
| 7160 | 62593 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 731 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1986 12:00:00 AM | 9 | Permit Number 22899 | 5984434.98291 | 2110845.23688 | 37.7750775975018 | -122.497347157504 | (37.7750775975018, -122.497347157504) | 11 | 6 | 2 | 55 | 26 | |
| 7648 | 62594 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 735 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1986 12:00:00 AM | 9 | Permit Number 22900 | 5984433.86075 | 2110817.89863 | 37.7750024687546 | -122.497349020618 | (37.7750024687546, -122.497349020618) | 11 | 6 | 2 | 55 | 26 | |
| 9420 | 62591 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 759 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1986 12:00:00 AM | 9 | Permit Number 22897 | 5984439.68457 | 2110661.64848 | 37.7745737920548 | -122.497317337939 | (37.7745737920548, -122.497317337939) | 11 | 6 | 2 | 55 | 26 | |
| 9829 | 207861 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 70 Ralston St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 5992207.07547 | 2088343.8619 | 37.7137470322778 | -122.468824268047 | (37.7137470322778, -122.468824268047) | 9 | 8 | 6 | 64 | 24 | |||
| 11229 | 244526 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 535 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5998923.9253 | 2108820.3562 | 37.7703563290142 | -122.447081166685 | (37.7703563290142, -122.447081166685) | 15 | 5 | 11 | 29492 | 9 | |||
| 12145 | 207895 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2405 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5991680.9977 | 2099010.21605 | 37.7430037753042 | -122.471419295088 | (37.7430037753042, -122.471419295088) | 1 | 8 | 4 | 29491 | 40 | |||
| 20106 | 226744 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1198 Hampshire St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010266.86598 | 2102287.21405 | 37.7530593460119 | -122.407385103056 | (37.7530593460119, -122.407385103056) | 2 | 4 | 7 | 28859 | 19 | |||
| 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 | |||
| 22633 | 141822 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1001 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004770.3402 | 2112320.581 | 37.7802993903032 | -122.427107758126 | (37.7802993903032, -122.427107758126) | 7 | 9 | 11 | 29490 | 41 | |||
| 23984 | 12171 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1421X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/1993 12:00:00 AM | 9 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.385876260938 | (37.7340798748876, -122.385876260938) | 10 | 3 | 8 | 58 | 1 | ||
| 24736 | 191441 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2250 25th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6012095.50182 | 2101892.00289 | 37.7520763618475 | -122.401033518791 | (37.7520763618475, -122.401033518791) | 10 | 3 | 8 | 28856 | 29 | |||
| 26783 | 41176 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1529 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/23/1999 12:00:00 AM | 9 | Permit Number 41895 | 6002871.19311 | 2121292.04704 | 37.8048251531279 | -122.434319365747 | (37.8048251531279, -122.434319365747) | 13 | 9 | 1 | 57 | 17 | |
| 30959 | 129658 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2211 Stockton St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009773.35506 | 2121727.83726 | 37.8064110724651 | -122.410464398813 | (37.8064110724651, -122.410464398813) | 3 | 1 | 10 | 308 | 23 | |||
| 31714 | 67465 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 937 Olmstead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/01/1992 12:00:00 AM | 9 | Permit Number 30978 | 6008961.1272 | 2090382.77007 | 37.7202991536555 | -122.41105982826 | (37.7202991536555, -122.41105982826) | 9 | 3 | 7 | 309 | 28 | ||
| 33284 | 226691 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 35 Ramona Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6005210.09814 | 2107610.98194 | 37.7673928316461 | -122.425251206571 | (37.7673928316461, -122.425251206571) | 8 | 4 | 5 | 28853 | 19 | |||
| 36405 | 98645 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2110 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 9 | 5x5 | 6002788.88101 | 2119245.38589 | 37.7992008856766 | -122.434457791187 | (37.7992008856766, -122.434457791187) | 13 | 9 | 1 | 57 | 17 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 41145 | 207832 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 147 Judson Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 5999123.91286 | 2093462.37431 | 37.7281984720769 | -122.44528502248 | (37.7281984720769, -122.44528502248) | 9 | 7 | 4 | 28861 | 40 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |
| 45757 | 201240 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 832 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6011987.3715 | 2112559.9702 | 37.7813621675722 | -122.402157393633 | (37.7813621675722, -122.402157393633) | 6 | 2 | 9 | 28853 | 34 | |||
| 45856 | 37501 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 830 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/1998 12:00:00 AM | 9 | Permit Number 39965 | 6009497.37561 | 2115737.1064 | 37.7899465245609 | -122.410996073526 | (37.7899465245609, -122.410996073526) | 5 | 1 | 10 | 28857 | 21 | ||
| 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 | |||
| 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 | |||
| 47447 | 129639 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1136 Union St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007510.50379 | 2119218.83195 | 37.7993948622524 | -122.418117431574 | (37.7993948622524, -122.418117431574) | 5 | 1 | 1 | 28858 | 32 | |||
| 48384 | 227291 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 65 Zircon Pl | 4 | Front Yard : Yard | Tree | Private 2 | 9 | Width 4ft | 6002354.98671 | 2098718.92039 | 37.7428156470274 | -122.434490777424 | (37.7428156470274, -122.434490777424) | 2 | 7 | 5 | 63 | 7 | |||
| 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 | |||
| 49525 | 138669 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1716 Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5999601.6075 | 2114746.9787 | 37.7866680088585 | -122.44516322805 | (37.7866680088585, -122.44516322805) | 15 | 6 | 1 | 29490 | 31 | |||
| 51878 | 129613 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 711 Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6009198.53973 | 2115384.83404 | 37.7889625079688 | -122.412005118241 | (37.7889625079688, -122.412005118241) | 5 | 1 | 10 | 28858 | 21 | |||
| 52043 | 56174 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 701 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/03/1973 12:00:00 AM | 9 | Permit Number 12282 | 5990956.32694 | 2110582.1012 | 37.7747351534663 | -122.474769414984 | (37.7747351534663, -122.474769414984) | 11 | 6 | 2 | 54 | 26 | ||
| 52385 | 226722 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1111 Hampshire St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010289.0097 | 2102653.41278 | 37.7540660857915 | -122.407334339005 | (37.7540660857915, -122.407334339005) | 10 | 4 | 7 | 28859 | 19 | |||
| 56368 | 34692 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3101X Webster St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 07/28/1997 12:00:00 AM | 9 | 3x3 | Permit Number 38352 | 6002825.2019 | 2119271.55666 | 37.7992748054477 | -122.434333980647 | (37.7992748054477, -122.434333980647) | 13 | 9 | 1 | 57 | 17 |
| 61846 | 142321 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1542 HAYES ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6000429.2107 | 2110311.8766 | 37.7745375574505 | -122.441981472333 | (37.7745375574505, -122.441981472333) | 15 | 5 | 11 | 29492 | 16 | |||
| 63232 | 207993 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 395 Joost Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 10ft | 5999470.98074 | 2094940.54969 | 37.7322770018656 | -122.444191374942 | (37.7322770018656, -122.444191374942) | 9 | 7 | 4 | 63 | 40 | |||
| 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 | |||
| 64010 | 217677 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 254 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5992403.7215 | 2097300.6069 | 37.7383514042899 | -122.468795958226 | (37.7383514042899, -122.468795958226) | 1 | 8 | 4 | 59 | 40 | |||
| 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 | |||
| 64817 | 57386 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1125 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/02/1976 12:00:00 AM | 9 | Permit Number 16225 | 6008086.74583 | 2116379.20728 | 37.791630372888 | -122.415922231451 | (37.791630372888, -122.415922231451) | 5 | 1 | 10 | 28858 | 21 | ||
| 66431 | 129575 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2031 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001413.81367 | 2115442.77183 | 37.7886817486042 | -122.438943326283 | (37.7886817486042, -122.438943326283) | 13 | 6 | 1 | 29490 | 27 | |||
| 68332 | 227317 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 4340 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6000963.82611 | 2102321.4348 | 37.752628223639 | -122.439559205415 | (37.752628223639, -122.439559205415) | 2 | 4 | 5 | 28862 | 22 | |||
| 70224 | 120400 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 163 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5988653.91402 | 2114240.51561 | 37.7846464457785 | -122.483002026322 | (37.7846464457785, -122.483002026322) | 11 | 6 | 2 | 55 | 26 | |||
| 71501 | 200524 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1475 La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6016218.7564 | 2095580.3392 | 37.7349749763778 | -122.386334547429 | (37.7349749763778, -122.386334547429) | 10 | 3 | 8 | 58 | 1 | |||
| 77647 | 226680 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 142 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6005582.61781 | 2100240.03524 | 37.7471749721658 | -122.423438640089 | (37.7471749721658, -122.423438640089) | 2 | 7 | 5 | 28859 | 22 | |||
| 80334 | 129603 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1617 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6005654.34929 | 2118205.1509 | 37.7965069035375 | -122.424468245119 | (37.7965069035375, -122.424468245119) | 13 | 9 | 1 | 28858 | 27 | |||
| 81093 | 12173 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1411X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/1992 12:00:00 AM | 9 | 3X3 | 6016408.3895 | 2095102.4888 | 37.7336733897742 | -122.385645619675 | (37.7336733897742, -122.385645619675) | 10 | 3 | 8 | 58 | 1 | ||
| 82524 | 217648 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 377 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5992011.4385 | 2096784.9217 | 37.7369127922508 | -122.470114728443 | (37.7369127922508, -122.470114728443) | 1 | 8 | 4 | 59 | 40 | |||
| 83091 | 34203 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1911 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/17/1997 12:00:00 AM | 9 | Permit Number 38022 | 6004270.98382 | 2118013.74533 | 37.7959031355868 | -122.429241335742 | (37.7959031355868, -122.429241335742) | 13 | 9 | 1 | 28858 | 27 | ||
| 85350 | 227450 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 90 Collingwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001995.97093 | 2105325.26691 | 37.7609347127742 | -122.436204819598 | (37.7609347127742, -122.436204819598) | 15 | 4 | 5 | 28862 | 3 | |||
| 85895 | 207998 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 395 Joost Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 10ft | 5999486.80728 | 2094946.96177 | 37.7322955108311 | -122.444137119754 | (37.7322955108311, -122.444137119754) | 9 | 7 | 4 | 63 | 40 | |||
| 86117 | 246235 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 96 Delmar St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5999349.417 | 2107770.815 | 37.7674988549926 | -122.44553391432 | (37.7674988549926, -122.44553391432) | 15 | 5 | 11 | 29492 | 9 | |||
| 86929 | 226723 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1109 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010287.53935 | 2102671.43851 | 37.7541154981458 | -122.407340694523 | (37.7541154981458, -122.407340694523) | 10 | 4 | 7 | 28859 | 19 | |||
| 87339 | 129656 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2211 Stockton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009761.43643 | 2121807.95495 | 37.8066303874512 | -122.410511306563 | (37.8066303874512, -122.410511306563) | 3 | 1 | 10 | 308 | 23 | |||
| 87784 | 248439 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 68 Downey St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5998835.0618 | 2107965.3827 | 37.768003711032 | -122.447326998761 | (37.768003711032, -122.447326998761) | 15 | 5 | 11 | 29492 | 9 | |||
| 91189 | 129670 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2300 Powell St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6009329.84162 | 2121764.6853 | 37.8064873745564 | -122.412001868104 | (37.8064873745564, -122.412001868104) | 3 | 1 | 10 | 308 | 23 | |||
| 92318 | 65829 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2290 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/07/1990 12:00:00 AM | 9 | Permit Number 28819 | 6000416.29807 | 2119955.15085 | 37.8010147480994 | -122.442718709912 | (37.8010147480994, -122.442718709912) | 13 | 9 | 1 | 57 | 17 | |
| 92358 | 129597 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2100 Franklin St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6005573.05547 | 2117336.02058 | 37.7941159002879 | -122.424687680612 | (37.7941159002879, -122.424687680612) | 13 | 9 | 1 | 28858 | 27 | |||
| 92830 | 227272 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 4331 Cesar Chavez St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 4ft | 6001752.41046 | 2100271.74966 | 37.7470451262446 | -122.4366854416 | (37.7470451262446, -122.4366854416) | 2 | 4 | 5 | 63 | 22 | |||
| 93651 | 98648 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2110 Greenwich St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 9 | 5x5 | 6002730.0885 | 2119237.75472 | 37.7991765949935 | -122.434660687245 | (37.7991765949935, -122.434660687245) | 13 | 9 | 1 | 57 | 17 | ||
| 94033 | 12170 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1421X La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/1993 12:00:00 AM | 9 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.385876260938 | (37.7340798748876, -122.385876260938) | 10 | 3 | 8 | 58 | 1 | ||
| 96212 | 177050 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2134 San Jose Ave | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 5998727.35732 | 2090872.12433 | 37.7210636034854 | -122.446469652679 | (37.7210636034854, -122.446469652679) | 9 | 7 | 6 | 28861 | 25 | |||
| 96385 | 227417 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 234 Eureka St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001420.42317 | 2104418.67731 | 37.7584127214746 | -122.438130438088 | (37.7584127214746, -122.438130438088) | 2 | 4 | 5 | 28862 | 3 | |||
| 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 | |||
| 97760 | 61663 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 121 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/1984 12:00:00 AM | 9 | 6x9 | Permit Number 21657 | 5992393.21685 | 2114622.98494 | 37.7859134760601 | -122.470093267127 | (37.7859134760601, -122.470093267127) | 11 | 6 | 2 | 54 | 11 |
| 98057 | 124328 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 116 Palm Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5995929.77747 | 2113622.35703 | 37.783369832624 | -122.457785387429 | (37.783369832624, -122.457785387429) | 11 | 6 | 1 | 54 | 31 | |||
| 102276 | 227401 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 569 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002632.3517 | 2103249.18042 | 37.7552704138102 | -122.433855464885 | (37.7552704138102, -122.433855464885) | 2 | 4 | 5 | 28862 | 22 | |||
| 110206 | 92942 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 377 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 5992043 | 2096735 | 37.73677754441 | -122.470001973507 | (37.73677754441, -122.470001973507) | 1 | 8 | 4 | 59 | 40 | ||||
| 110642 | 114466 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2351 Powell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6009278.4623 | 2121786.53745 | 37.8065444922964 | -122.412181221704 | (37.8065444922964, -122.412181221704) | 3 | 1 | 10 | 308 | 23 | |||
| 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 | |||
| 113239 | 93119 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1555 Hayes St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6000421 | 2110261 | 37.774397395284 | -122.442006222093 | (37.774397395284, -122.442006222093) | 15 | 5 | 11 | 29492 | 16 | |||
| 113351 | 245069 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 4 Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6000408.7062 | 2108954.5393 | 37.7708094828751 | -122.441954956883 | (37.7708094828751, -122.441954956883) | 15 | 5 | 11 | 29492 | 9 | |||
| 116469 | 227247 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 203 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6003955.64595 | 2095256.72933 | 37.7333999916083 | -122.428709395715 | (37.7333999916083, -122.428709395715) | 9 | 7 | 5 | 28861 | 25 | |||
| 118597 | 227353 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 625 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006157.33458 | 2096566.85783 | 37.7371216749251 | -122.421190526549 | (37.7371216749251, -122.421190526549) | 2 | 7 | 7 | 28859 | 2 | |||
| 119266 | 12172 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1419X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.385876260938 | (37.7340798748876, -122.385876260938) | 10 | 3 | 8 | 58 | 1 | |||
| 119738 | 129636 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1181 Union St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007340.70028 | 2119141.24699 | 37.7991722746363 | -122.418699507883 | (37.7991722746363, -122.418699507883) | 5 | 1 | 10 | 28858 | 32 | |||
| 120292 | 191495 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1198 La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6016624.88641 | 2094815.22838 | 37.7328966068827 | -122.384877113693 | (37.7328966068827, -122.384877113693) | 10 | 3 | 8 | 58 | 1 | |||
| 120827 | 226718 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1179 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010302.59976 | 2102373.43579 | 37.7532980917512 | -122.407267605716 | (37.7532980917512, -122.407267605716) | 10 | 4 | 7 | 28859 | 19 | |||
| 121578 | 33112 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2628 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | 9 | Permit Number 37349 | 6000339.44764 | 2118557.89779 | 37.7971738812189 | -122.442884250816 | (37.7971738812189, -122.442884250816) | 13 | 9 | 1 | 57 | 17 | |
| 121768 | 207926 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1630 Portola Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5991910.04045 | 2096405.2401 | 37.7358644199941 | -122.470437659868 | (37.7358644199941, -122.470437659868) | 1 | 8 | 4 | 59 | 40 | |||
| 121946 | 217633 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 362 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5992003.7966 | 2096898.1347 | 37.7372232047665 | -122.470149391099 | (37.7372232047665, -122.470149391099) | 1 | 8 | 4 | 59 | 40 | |||
| 123404 | 57058 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2030 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/1980 12:00:00 AM | 9 | Permit Number 18365 | 6001452.76061 | 2115511.13593 | 37.7888716746238 | -122.438813476778 | (37.7888716746238, -122.438813476778) | 13 | 6 | 1 | 29490 | 27 | ||
| 125111 | 226742 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1166 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010257.73398 | 2102428.33955 | 37.7534463341917 | -122.407426631958 | (37.7534463341917, -122.407426631958) | 2 | 4 | 7 | 28859 | 19 | |||
| 125609 | 177138 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 567 Bowdoin St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008881.29174 | 2093378.99217 | 37.7285216695165 | -122.411547373223 | (37.7285216695165, -122.411547373223) | 9 | 3 | 7 | 309 | 28 | |||
| 127466 | 227323 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 840 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6002425.74996 | 2103315.19428 | 37.7554399459049 | -122.434574674276 | (37.7554399459049, -122.434574674276) | 2 | 4 | 5 | 28862 | 22 | |||
| 127679 | 177084 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 199 Blanken Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6012033.75638 | 2087275.42031 | 37.7119388247963 | -122.400220567635 | (37.7119388247963, -122.400220567635) | 10 | 3 | 8 | 309 | 1 | |||
| 128787 | 227303 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2211 Castro St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | 6002724.72616 | 2099043.5598 | 37.7437280128274 | -122.433235515417 | (37.7437280128274, -122.433235515417) | 2 | 7 | 5 | 63 | 22 | ||||
| 129294 | 207812 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 635 Hearst Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 5997216.39115 | 2094387.61086 | 37.7306298809467 | -122.451946087746 | (37.7306298809467, -122.451946087746) | 9 | 7 | 4 | 28861 | 40 | |||
| 130375 | 36982 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 251 09th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/1998 12:00:00 AM | 9 | Permit Number 39606 | 5993044.7391 | 2113780.4585 | 37.7836377719626 | -122.467777899893 | (37.7836377719626, -122.467777899893) | 11 | 6 | 2 | 54 | 11 | ||
| 130554 | 129630 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2615 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006581.14365 | 2120192.71417 | 37.8020165433842 | -122.421402549791 | (37.8020165433842, -122.421402549791) | 5 | 9 | 1 | 28858 | 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) );