Data source: data.sfgov.org
This data as json, CSV (advanced)
qSiteInfo ✖
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 110324 | 110324 | 999 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1725 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | 6001467.99656 | 2092045.3572200001 | 37.724441193017796 | -122.43708004004499 | (37.7244411930178, -122.437080040045) | |||
| 78239 | 78239 | 1002 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1731 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 27 | 3X3 | 6001471.07065 | 2092002.59485 | 37.724323951976 | -122.437066353202 | (37.724323951976, -122.437066353202) | |||
| 10868 | 10868 | 1003 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1750 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6001350.47669 | 2091970.9547 | 37.7242302198351 | -122.43748096390101 | (37.7242302198351, -122.437480963901) | |||
| 80722 | 80722 | 1026 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1955X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6000855.2579 | 2090665.6856099998 | 37.7206180798117 | -122.439099353738 | (37.7206180798117, -122.439099353738) | |||
| 142119 | 142119 | 1043 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2000 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X5 | 6000617.15273 | 2090448.0855 | 37.7200070478885 | -122.43990681257799 | (37.7200070478885, -122.439906812578) | |||
| 12553 | 12553 | 1045 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2003X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6000641.86431 | 2090326.5948 | 37.719674868584704 | -122.43981268741999 | (37.7196748685847, -122.43981268742) | |||
| 116026 | 116026 | 1065 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2071X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6000361.32249 | 2090050.85473 | 37.7189017758401 | -122.440762648624 | (37.7189017758401, -122.440762648624) | |||
| 10562 | 10562 | 1073 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2118 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | 6000085.1139 | 2089908.73955 | 37.7184958258874 | -122.44170719653201 | (37.7184958258874, -122.441707196532) | |||
| 10491 | 10491 | 1075 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2119 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 6000135.00359 | 2089836.3366200002 | 37.7182998663217 | -122.44152955615299 | (37.7182998663217, -122.441529556153) | ||||
| 13175 | 13175 | 1076 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2124 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | 6000057.48494 | 2089881.91046 | 37.7184205850222 | -122.441800773687 | (37.7184205850222, -122.441800773687) | |||
| 10459 | 10459 | 1079 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2133 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 6000101.3096199995 | 2089802.83807 | 37.718205967213 | -122.441643618974 | (37.718205967213, -122.441643618974) | |||
| 12800 | 12800 | 1083 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2150 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3x3 | 5999998.5130900005 | 2089822.2609599999 | 37.718253440618504 | -122.44200033506901 | (37.7182534406185, -122.442000335069) | |||
| 10510 | 10510 | 1087 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2174 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 5999920.01803 | 2089753.43888 | 37.718059997362396 | -122.442266720544 | (37.7180599973624, -122.442266720544) | |||
| 10684 | 10684 | 1109 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2362 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x3 | 5999292.86989 | 2089155.09159 | 37.716381308429206 | -122.44439151548201 | (37.7163813084292, -122.444391515482) | |||
| 12258 | 12258 | 1155 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2700 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3x3 | 5997899.99425 | 2088293.2375900003 | 37.7139352846675 | -122.44914389918199 | (37.7139352846675, -122.449143899182) | |||
| 10881 | 10881 | 1170 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2900 Alemany Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 5996939.82993 | 2087557.20875 | 37.711859355284204 | -122.45240948860099 | (37.7118593552842, -122.452409488601) | |||
| 12008 | 12008 | 1186 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3021 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 5996654.59932 | 2087233.67855 | 37.7109546705803 | -122.453371976343 | (37.7109546705803, -122.453371976343) | |||
| 11599 | 11599 | 1188 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3023 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 5996633.13731 | 2087220.7977599998 | 37.7109180726785 | -122.453445224323 | (37.7109180726785, -122.453445224323) | |||
| 12890 | 12890 | 1261 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3833 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X6 | 5992776.62471 | 2087495.32693 | 37.7114500468546 | -122.466794068292 | (37.7114500468546, -122.466794068292) | |||
| 13182 | 13182 | 1306 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 4001 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X6 | 5991941.83628 | 2087094.05513 | 37.7103000369794 | -122.469650093897 | (37.7103000369794, -122.469650093897) | |||
| 98653 | 98653 | 1387 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 Ardath Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6017196.4858197 | 2095452.9646741 | 37.7346793028525 | -122.382945295721 | (37.7346793028525, -122.382945295721) | |||
| 96369 | 96369 | 1388 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 Ardath Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6017196.4858197 | 2095452.9646741 | 37.7346793028525 | -122.382945295721 | (37.7346793028525, -122.382945295721) | |||
| 123048 | 123048 | 1390 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 14 Ardath Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X4 | 6017255.7672836 | 2095462.3809536998 | 37.7347084334081 | -122.38274099254801 | (37.7347084334081, -122.382740992548) | |||
| 145209 | 145209 | 1391 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 14 Ardath Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X4 | 6017255.7672836 | 2095462.3809536998 | 37.7347084334081 | -122.38274099254801 | (37.7347084334081, -122.382740992548) | |||
| 106329 | 106329 | 1400 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 55 Ardath Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X4 | 6017370.6963946 | 2095342.6587031998 | 37.734386048723 | -122.38233531274099 | (37.734386048723, -122.382335312741) | |||
| 140229 | 140229 | 1401 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 62 Ardath Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X4 | 6017428.9119183 | 2095344.9938608997 | 37.734395675993795 | -122.382134203041 | (37.7343956759938, -122.382134203041) | |||
| 44830 | 44830 | 1402 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 62 Ardath Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/1996 12:00:00 AM | 12 | 3X4 | 6017428.9119183 | 2095344.9938608997 | 37.734395675993795 | -122.382134203041 | (37.7343956759938, -122.382134203041) | ||
| 101912 | 101912 | 1407 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 78 Ardath Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X4 | 6017465.853593799 | 2095288.5052945998 | 37.7342426097847 | -122.382002554251 | (37.7342426097847, -122.382002554251) | |||
| 92830 | 92830 | 1408 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 78 Ardath Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X4 | 6017465.853593799 | 2095288.5052945998 | 37.7342426097847 | -122.382002554251 | (37.7342426097847, -122.382002554251) | |||
| 142983 | 142983 | 1445 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 151X Arguello Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X5 | 5995492.27499 | 2115135.20138 | 37.7874985527143 | -122.459408560713 | (37.7874985527143, -122.459408560713) | |||
| 145661 | 145661 | 1446 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 151X Arguello Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X5 | 5995492.27499 | 2115135.20138 | 37.7874985527143 | -122.459408560713 | (37.7874985527143, -122.459408560713) | |||
| 88843 | 88843 | 1447 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 151X Arguello Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X5 | 5995492.27499 | 2115135.20138 | 37.7874985527143 | -122.459408560713 | (37.7874985527143, -122.459408560713) | |||
| 87207 | 87207 | 1448 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 151X Arguello Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X5 | 5995492.27499 | 2115135.20138 | 37.7874985527143 | -122.459408560713 | (37.7874985527143, -122.459408560713) | |||
| 95872 | 95872 | 1449 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 151X Arguello Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X5 | 5995492.27499 | 2115135.20138 | 37.7874985527143 | -122.459408560713 | (37.7874985527143, -122.459408560713) | |||
| 122772 | 122772 | 1451 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 151X ARGUELLO BLVD | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X5 | 5995497.0 | 2115135.0 | 37.7874982714485 | -122.459392198652 | (37.7874982714485, -122.459392198652) | |||
| 97100 | 97100 | 1478 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 255 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3PL | 5995470.91664 | 2114596.3439599997 | 37.7860177674927 | -122.45944341566099 | (37.7860177674927, -122.459443415661) | |||
| 105571 | 105571 | 1479 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 275 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 5995504.99684 | 2114582.08886 | 37.7859805862865 | -122.45932447548999 | (37.7859805862865, -122.45932447549) | |||
| 120842 | 120842 | 1483 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 22X Cornwall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5995478.05277 | 2114267.60184 | 37.785115540376395 | -122.459394910497 | (37.7851155403764, -122.459394910497) | |||
| 118466 | 118466 | 1486 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3881X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 5995672.10843 | 2114464.90293 | 37.7856684316831 | -122.45873783185199 | (37.7856684316831, -122.458737831852) | |||
| 18882 | 18882 | 1487 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3881X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 5995672.10843 | 2114464.90293 | 37.7856684316831 | -122.45873783185199 | (37.7856684316831, -122.458737831852) | |||
| 138877 | 138877 | 1489 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1X Cornwall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5995492.59641 | 2114212.1077799997 | 37.7849640047891 | -122.459340574193 | (37.7849640047891, -122.459340574193) | |||
| 94703 | 94703 | 1504 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 345 Arguello Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 5995528.04701 | 2113952.87428 | 37.7842542573275 | -122.459199148829 | (37.7842542573275, -122.459199148829) | |||
| 79921 | 79921 | 1719 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 08/19/2006 12:00:00 AM | 3 | 3X9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | ||
| 142437 | 142437 | 1720 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Bay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 08/19/2006 12:00:00 AM | 3 | 3X9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | ||
| 125164 | 125164 | 1721 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Bay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 08/19/2006 12:00:00 AM | 3 | 3X9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | ||
| 107737 | 107737 | 1722 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Bay St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 3x9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | |||
| 115308 | 115308 | 1723 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Bay St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3X9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | |||
| 112223 | 112223 | 1724 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Bay St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 3X9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | |||
| 102952 | 102952 | 1725 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Bay St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12/15/1992 12:00:00 AM | 6 | 3X9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | ||
| 97827 | 97827 | 1726 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Bay St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3X9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | |||
| 114188 | 114188 | 1727 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Bay St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 3X9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | |||
| 126259 | 126259 | 1728 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Bay St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3x9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | |||
| 143982 | 143982 | 1729 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Bay St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 3X9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | |||
| 121717 | 121717 | 1730 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Bay St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 3x9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | |||
| 112155 | 112155 | 1731 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Bay St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 3X9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | |||
| 96617 | 96617 | 1732 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Bay St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 08/19/2006 12:00:00 AM | 3 | 3X9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | ||
| 118758 | 118758 | 1733 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Bay St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 08/19/2006 12:00:00 AM | 3 | 3X9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | ||
| 84379 | 84379 | 1734 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Bay St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 3x9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | |||
| 124401 | 124401 | 1735 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Bay St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 08/19/2006 12:00:00 AM | 3 | 3X9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | ||
| 86191 | 86191 | 1736 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Bay St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 3X9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | |||
| 49118 | 49118 | 1737 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Bay St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 3X9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | |||
| 2320 | 2320 | 1739 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 Bay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 08/19/2006 12:00:00 AM | 3 | 6010211.1306 | 2121614.8438 | 37.8061253525476 | -122.408941413862 | (37.8061253525476, -122.408941413862) | |||
| 8258 | 8258 | 1740 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 Bay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 5 | 6010239.3355 | 2121619.2312 | 37.8061389791251 | -122.408844115422 | (37.8061389791251, -122.408844115422) | |||
| 5751 | 5751 | 1741 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 Bay St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 5 | 6010277.5688 | 2121623.6186 | 37.8061531673047 | -122.408712111835 | (37.8061531673047, -122.408712111835) | |||
| 8654 | 8654 | 1742 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 Bay St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 5 | 6010362.8102 | 2121638.0345 | 37.8061975236724 | -122.408418135849 | (37.8061975236724, -122.408418135849) | |||
| 6111 | 6111 | 1744 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 Bay St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 5 | 6010455.5729 | 2121649.3164 | 37.806233695246796 | -122.40809790947901 | (37.8062336952468, -122.408097909479) | |||
| 6981 | 6981 | 1746 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 Bay St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 24 | 5 | 6010500.0739 | 2121656.211 | 37.8062551176462 | -122.40794439194401 | (37.8062551176462, -122.407944391944) | |||
| 8663 | 8663 | 1747 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 Bay St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 5 | 6010526.3985 | 2121656.8377 | 37.80625831218661 | -122.40785333492902 | (37.8062583121866, -122.407853334929) | |||
| 6698 | 6698 | 1748 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 Bay St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 5 | 6010555.2301 | 2121661.2252 | 37.806271973223794 | -122.407753867308 | (37.8062719732238, -122.407753867308) | |||
| 8833 | 8833 | 1749 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 Bay St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 5 | 6010575.9137 | 2121665.6126 | 37.8062851777933 | -122.40768259734502 | (37.8062851777933, -122.407682597345) | |||
| 7132 | 7132 | 1750 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 Bay St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 5 | 6010626.0557 | 2121671.8803 | 37.8063051940875 | -122.4075095136 | (37.8063051940875, -122.4075095136) | |||
| 8607 | 8607 | 1751 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 Bay St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 24 | 5 | 6010656.7677 | 2121676.8945 | 37.8063206808441 | -122.40740358257901 | (37.8063206808441, -122.407403582579) | |||
| 7500 | 7500 | 1752 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 Bay St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 24 | 5 | 6010681.2119 | 2121680.6552 | 37.806332374912294 | -122.40731925401899 | (37.8063323749123, -122.407319254019) | |||
| 97364 | 97364 | 1754 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 Bay St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 5 | 6010168.4492363 | 2121611.1016263003 | 37.8061126865638 | -122.409088856241 | (37.8061126865638, -122.409088856241) | |||
| 119036 | 119036 | 1755 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 Bay St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 5 | 6010168.4492363 | 2121611.1016263003 | 37.8061126865638 | -122.409088856241 | (37.8061126865638, -122.409088856241) | |||
| 99468 | 99468 | 1756 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 Bay St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 24 | 5 | 6010168.4492363 | 2121611.1016263003 | 37.8061126865638 | -122.409088856241 | (37.8061126865638, -122.409088856241) | |||
| 12680 | 12680 | 1833 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2174 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6011634.522580001 | 2087511.81203 | 37.712565639665705 | -122.40161704481301 | (37.7125656396657, -122.401617044813) | |||
| 125256 | 125256 | 1953 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 22 Bertha Ln | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X4 | 6017592.1686028 | 2095111.1070948 | 37.733762484425604 | -122.38155350563 | (37.7337624844256, -122.38155350563) | |||
| 125959 | 125959 | 1954 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 21 Bertha Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X4 | 6017641.3611143 | 2095102.1574124 | 37.7337406262862 | -122.38138280862499 | (37.7337406262862, -122.381382808625) | |||
| 91828 | 91828 | 1955 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 25 Bertha Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X4 | 6017638.8079822 | 2095100.1024124 | 37.733734842709495 | -122.381391492798 | (37.7337348427095, -122.381391492798) | |||
| 118979 | 118979 | 1960 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 36 Bertha Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/05/1995 12:00:00 AM | 12 | 3X4 | 6017618.4307655 | 2095033.1830576 | 37.733549970373105 | -122.38145729159599 | (37.7335499703731, -122.381457291596) | ||
| 114394 | 114394 | 1961 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 36 Bertha Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X4 | 6017618.4307655 | 2095033.1830576 | 37.733549970373105 | -122.38145729159599 | (37.7335499703731, -122.381457291596) | |||
| 139311 | 139311 | 1963 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 45 Bertha Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X4 | 6017685.4326556 | 2095014.8991764 | 37.7335034653707 | -122.38122437355301 | (37.7335034653707, -122.381224373553) | |||
| 118082 | 118082 | 1966 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 52 Bertha Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X4 | 6017664.782928 | 2094963.8795893998 | 37.733362235703105 | -122.381292219909 | (37.7333622357031, -122.381292219909) | |||
| 122448 | 122448 | 1968 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 56 Bertha Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X4 | 6017678.029080301 | 2094949.6712286999 | 37.73332395359 | -122.3812454362 | (37.73332395359, -122.3812454362) | |||
| 108197 | 108197 | 1969 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 60 Bertha Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X4 | 6017691.275232499 | 2094935.4628679 | 37.73328567145779 | -122.38119865254 | (37.7332856714578, -122.38119865254) | |||
| 110298 | 110298 | 1970 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 64 Bertha Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6017795.70326 | 2094889.17065 | 37.7331643262404 | -122.380834395392 | (37.7331643262404, -122.380834395392) | |||
| 96128 | 96128 | 1971 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 65 Bertha Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X4 | 6017747.471158401 | 2094948.5087384998 | 37.7333245948231 | -122.381005272435 | (37.7333245948231, -122.381005272435) | |||
| 144051 | 144051 | 1972 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 71 Bertha Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X4 | 6017766.748096599 | 2094928.7177616002 | 37.7332713166995 | -122.38093725062201 | (37.7332713166995, -122.380937250622) | |||
| 85379 | 85379 | 1977 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 85 Bertha Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6017816.9295357 | 2094882.3145501 | 37.73314667222579 | -122.380760533243 | (37.7331466722258, -122.380760533243) | |||
| 110519 | 110519 | 1981 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 102 Bertha Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X4 | 6017840.507549 | 2094792.7784106003 | 37.732902124826104 | -122.38067279528299 | (37.7329021248261, -122.380672795283) | |||
| 111552 | 111552 | 1982 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 102 Bertha Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X4 | 6017840.507549 | 2094792.7784106003 | 37.732902124826104 | -122.38067279528299 | (37.7329021248261, -122.380672795283) | |||
| 79818 | 79818 | 1985 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 107 Bertha Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X4 | 6017895.3004083 | 2094810.8316481998 | 37.7329547191536 | -122.38048461462601 | (37.7329547191536, -122.380484614626) | |||
| 124947 | 124947 | 1986 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 110 Bertha Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/01/1996 12:00:00 AM | 6 | 3X4 | 6017869.4511125 | 2094766.8627322 | 37.732832562725704 | -122.380570928198 | (37.7328325627257, -122.380570928198) | ||
| 111425 | 111425 | 1987 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 110 Bertha Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6017869.4511125 | 2094766.8627322 | 37.732832562725704 | -122.380570928198 | (37.7328325627257, -122.380570928198) | |||
| 86146 | 86146 | 1989 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 115 Bertha Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6017924.2439717995 | 2094784.9159698002 | 37.7328851568912 | -122.38038274764601 | (37.7328851568912, -122.380382747646) | |||
| 104263 | 104263 | 1991 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 123 Bertha Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6017953.1875354005 | 2094759.0002915 | 37.732815594540206 | -122.38028088085501 | (37.7328155945402, -122.380280880855) | |||
| 138706 | 138706 | 1992 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 123 Bertha Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X4 | 6017953.1875354005 | 2094759.0002915 | 37.732815594540206 | -122.38028088085501 | (37.7328155945402, -122.380280880855) | |||
| 110752 | 110752 | 2168 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2115X Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1990 12:00:00 AM | 10 | 3x3 | 6005923.83461 | 2117712.48837 | 37.795169390971 | -122.42350072309799 | (37.795169390971, -122.423500723098) | ||
| 94042 | 94042 | 2176 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1378X Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6001166.4305 | 2111105.5534099997 | 37.7767587769626 | -122.43948819775801 | (37.7767587769626, -122.439488197758) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");