Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▲ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2733 | 2733 | 253189 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99x The Embarcadero | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014645.0 | 2117171.0 | 37.794170975650296 | -122.393285986986 | (37.7941709756503, -122.393285986986) | ||||
| 2735 | 2735 | 253188 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99x The Embarcadero | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014645.0 | 2117171.0 | 37.794170975650296 | -122.393285986986 | (37.7941709756503, -122.393285986986) | ||||
| 2737 | 2737 | 253186 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99x The Embarcadero | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014645.0 | 2117171.0 | 37.794170975650296 | -122.393285986986 | (37.7941709756503, -122.393285986986) | ||||
| 2738 | 2738 | 253184 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99x The Embarcadero | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014645.0 | 2117171.0 | 37.794170975650296 | -122.393285986986 | (37.7941709756503, -122.393285986986) | ||||
| 2739 | 2739 | 253185 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99x The Embarcadero | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014645.0 | 2117171.0 | 37.794170975650296 | -122.393285986986 | (37.7941709756503, -122.393285986986) | ||||
| 2741 | 2741 | 253190 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99x The Embarcadero | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014645.0 | 2117171.0 | 37.794170975650296 | -122.393285986986 | (37.7941709756503, -122.393285986986) | ||||
| 2744 | 2744 | 253187 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99x The Embarcadero | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014645.0 | 2117171.0 | 37.794170975650296 | -122.393285986986 | (37.7941709756503, -122.393285986986) | ||||
| 77908 | 77908 | 23617 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 99X Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3x3 | 5992931.1771373 | 2097763.0006234 | 37.7396514793132 | -122.467005897689 | (37.7396514793132, -122.467005897689) | |||
| 118929 | 118929 | 23618 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 99X Vicente St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3x3 | 5992931.1771373 | 2097763.0006234 | 37.7396514793132 | -122.467005897689 | (37.7396514793132, -122.467005897689) | |||
| 5846 | 5846 | 18671 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 99X Richardson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/29/1997 12:00:00 AM | 13 | 2X2 | 5999533.57531 | 2119335.56991 | 37.799263184406705 | -122.445728714712 | (37.7992631844067, -122.445728714712) | ||
| 5935 | 5935 | 18670 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 99X Richardson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 5999509.53732 | 2119357.2628900004 | 37.799321375051704 | -122.445813455145 | (37.7993213750517, -122.445813455145) | |||
| 23047 | 23047 | 23302 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 999 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 4X4 | 6006475.4929599995 | 2113790.126 | 37.7844306784727 | -122.421313221929 | (37.7844306784727, -122.421313221929) | |||
| 23192 | 23192 | 23303 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 999 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 4X4 | 6006477.84301 | 2113768.62409 | 37.7843717719938 | -122.42130356412301 | (37.7843717719938, -122.421303564123) | |||
| 100421 | 100421 | 23305 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 999 Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4X4 | 6006374.81018 | 2113794.55882 | 37.784437173038704 | -122.42166186516899 | (37.7844371730387, -122.421661865169) | |||
| 145301 | 145301 | 23304 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 999 VAN NESS AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6006374.0 | 2113794.0 | 37.784435592971 | -122.42166462841298 | (37.784435592971, -122.421664628413) | |||
| 88092 | 88092 | 47919 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 999 Revised) Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/04/2005 12:00:00 AM | 6 | Permit Number 47908 | 6006486.39229912 | 2113910.68802822 | 37.78476232670629 | -122.421284078173 | (37.7847623267063, -122.421284078173) | ||
| 109573 | 109573 | 47920 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 999 Revised) Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 45655 | 6006486.39229912 | 2113910.68802822 | 37.78476232670629 | -122.421284078173 | (37.7847623267063, -122.421284078173) | ||||
| 111554 | 111554 | 47918 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 999 Revised) Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 45655 | 6006486.39229912 | 2113910.68802822 | 37.78476232670629 | -122.421284078173 | (37.7847623267063, -122.421284078173) | ||||
| 6002 | 6002 | 95174 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 999 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6001433.5416 | 2111715.5330000003 | 37.7784488251579 | -122.43860789955099 | (37.7784488251579, -122.438607899551) | |||
| 7926 | 7926 | 95173 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 999 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6001430.752 | 2111736.5816 | 37.7785064606021 | -122.438619058388 | (37.7785064606021, -122.438619058388) | |||
| 118824 | 118824 | 13860 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 998 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6009623.0562505 | 2112946.0496627 | 37.78228999836271 | -122.41036407382201 | (37.7822899983627, -122.410364073822) | |||
| 140680 | 140680 | 5866 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 998 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/1995 12:00:00 AM | 3 | 3X3 | 6005664.3899300005 | 2113122.17635 | 37.782550891124004 | -122.424071844531 | (37.782550891124, -122.424071844531) | ||
| 14240 | 14240 | 13858 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 995 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/01/1990 12:00:00 AM | 35 | 4X4 | 6009732.8033 | 2112958.8474 | 37.7823312894321 | -122.40998529993901 | (37.7823312894321, -122.409985299939) | ||
| 15291 | 15291 | 13859 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 995 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4X4 | 6009742.5413 | 2112949.1095 | 37.7823050972444 | -122.409950922983 | (37.7823050972444, -122.409950922983) | |||
| 148692 | 148692 | 201229 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 995 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6009744.4889 | 2112973.4544 | 37.782372051713295 | -122.409945904238 | (37.7823720517133, -122.409945904238) | |||
| 167331 | 167331 | 201230 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 995 Market St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6009754.2268 | 2112960.795 | 37.78233783776329 | -122.409911321324 | (37.7823378377633, -122.409911321324) | |||
| 39629 | 39629 | 134819 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 995 Chestnut St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6007150.82501 | 2120500.5449900003 | 37.80289387162271 | -122.419453029152 | (37.8028938716227, -122.419453029152) | |||
| 49021 | 49021 | 134816 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 995 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6007098.09376 | 2120495.28962 | 37.8028764715415 | -122.41963513374901 | (37.8028764715415, -122.419635133749) | |||
| 132229 | 132229 | 134817 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 995 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007112.0266 | 2120497.32305 | 37.8028828396404 | -122.419587063205 | (37.8028828396404, -122.419587063205) | |||
| 162666 | 162666 | 134818 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 995 Chestnut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007124.95237 | 2120498.06243 | 37.802885597861795 | -122.419542385778 | (37.8028855978618, -122.419542385778) | |||
| 47430 | 47430 | 134821 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 993 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007216.24905 | 2120513.46576 | 37.8029330334999 | -122.41922754484 | (37.8029330334999, -122.41922754484) | |||
| 160178 | 160178 | 134820 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 993 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007198.65652 | 2120511.41596 | 37.8029264144903 | -122.419288278732 | (37.8029264144903, -122.419288278732) | |||
| 164396 | 164396 | 134822 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 993 Chestnut St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6007262.00214 | 2120521.36649 | 37.8029573034844 | -122.419069775858 | (37.8029573034844, -122.419069775858) | |||
| 81145 | 81145 | 13856 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 991 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 4X4 | 6009733.829934901 | 2112955.195175 | 37.782321318828394 | -122.409981490315 | (37.7823213188284, -122.409981490315) | |||
| 26812 | 26812 | 134823 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 991 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6007286.858080001 | 2120523.46815 | 37.8029644737818 | -122.418983910378 | (37.8029644737818, -122.418983910378) | |||
| 64018 | 64018 | 134827 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 991 Chestnut St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007349.29025 | 2120528.21446 | 37.8029810213102 | -122.418768198988 | (37.8029810213102, -122.418768198988) | |||
| 133949 | 133949 | 134825 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 991 Chestnut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6007312.129790001 | 2120526.16397 | 37.8029732988405 | -122.41889664826401 | (37.8029732988405, -122.418896648264) | |||
| 135883 | 135883 | 134826 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 991 Chestnut St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007323.8540199995 | 2120527.32997 | 37.802977160536706 | -122.418856158993 | (37.8029771605367, -122.418856158993) | |||
| 148008 | 148008 | 134824 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 991 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007300.19163 | 2120524.40003 | 37.8029677832925 | -122.41893783540701 | (37.8029677832925, -122.418937835407) | |||
| 88794 | 88794 | 115245 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 990 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/20/2016 12:00:00 AM | 3x3 | 6009439.8 | 2118094.4 | 37.7964158497349 | -122.411361881702 | (37.7964158497349, -122.411361881702) | |||
| 104730 | 104730 | 115247 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 990 Pacific Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/20/2016 12:00:00 AM | 3x3 | 6009439.8 | 2118094.4 | 37.7964158497349 | -122.411361881702 | (37.7964158497349, -122.411361881702) | |||
| 138991 | 138991 | 115246 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 990 Pacific Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/20/2016 12:00:00 AM | 3x3 | 6009439.8 | 2118094.4 | 37.7964158497349 | -122.411361881702 | (37.7964158497349, -122.411361881702) | |||
| 105759 | 105759 | 13854 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 990 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/15/1995 12:00:00 AM | 12 | 4x4 | 6009687.4901870005 | 2113021.5868707 | 37.7825010173778 | -122.410146494728 | (37.7825010173778, -122.410146494728) | ||
| 38257 | 38257 | 134373 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 990 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6005734.18909 | 2113131.9772200002 | 37.7825817424861 | -122.423831066448 | (37.7825817424861, -122.423831066448) | |||
| 17493 | 17493 | 23974 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 West Portal Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5993014.5056 | 2097814.877 | 37.7397987281257 | -122.466721556006 | (37.7397987281257, -122.466721556006) | |||
| 18046 | 18046 | 23972 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 West Portal Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 5993001.2031 | 2097804.4048 | 37.7397692063869 | -122.466766788992 | (37.7397692063869, -122.466766788992) | |||
| 21527 | 21527 | 23973 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 West Portal Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 5993007.7128 | 2097807.2351 | 37.7397773533681 | -122.46674448708201 | (37.7397773533681, -122.466744487082) | |||
| 156693 | 156693 | 195341 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 Steuart St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6014363.86847 | 2117187.08029 | 37.7941995057537 | -122.394259866515 | (37.7941995057537, -122.394259866515) | |||
| 59427 | 59427 | 211882 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 San Anselmo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 8ft | 5993133.46797 | 2096720.62207 | 37.7368010432217 | -122.466230735658 | (37.7368010432217, -122.466230735658) | |||
| 166996 | 166996 | 211883 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 San Anselmo Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 8ft | 5993091.26879 | 2096743.1724900003 | 37.73686052618039 | -122.466378273942 | (37.7368605261804, -122.466378273942) | |||
| 24960 | 24960 | 195408 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 Mission St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6014582.39886 | 2116707.05795 | 37.7928936208834 | -122.393470111553 | (37.7928936208834, -122.393470111553) | |||
| 27080 | 27080 | 195407 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6014563.82999 | 2116686.50255 | 37.7928361488079 | -122.39353292201 | (37.7928361488079, -122.39353292201) | |||
| 159925 | 159925 | 195409 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 Mission St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6014620.44692 | 2116745.93037 | 37.793002469437205 | -122.393341183855 | (37.7930024694372, -122.393341183855) | |||
| 170499 | 170499 | 195406 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6014550.2413800005 | 2116675.9945799997 | 37.7928065413299 | -122.39357920383499 | (37.7928065413299, -122.393579203835) | |||
| 175352 | 175352 | 195403 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6014473.31186 | 2116604.29244 | 37.7926053890835 | -122.393840364258 | (37.7926053890835, -122.393840364258) | |||
| 177869 | 177869 | 195410 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 Mission St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6014642.42784 | 2116761.97677 | 37.7930477503037 | -122.39326625145901 | (37.7930477503037, -122.393266251459) | |||
| 178047 | 178047 | 195404 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6014488.25084 | 2116618.57829 | 37.7926454448852 | -122.39378967485099 | (37.7926454448852, -122.393789674851) | |||
| 183723 | 183723 | 195405 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6014531.3542 | 2116655.44565 | 37.7927490692731 | -122.393643115961 | (37.7927490692731, -122.393643115961) | |||
| 186611 | 186611 | 234718 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 Henry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6002908.07014 | 2107379.66945 | 37.766627383577706 | -122.433197066698 | (37.7666273835777, -122.433197066698) | |||
| 200 | 200 | 134567 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 Grove St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 07/06/2011 12:00:00 AM | 4 | Width 4ft | 6007561.6986 | 2111595.58464 | 37.778466176805296 | -122.417399738421 | (37.7784661768053, -122.417399738421) | ||
| 203 | 203 | 134565 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 15 | Width 4ft | 6007431.26589 | 2111583.6583 | 37.7784260904314 | -122.41785010990299 | (37.7784260904314, -122.417850109903) | |||
| 205 | 205 | 134566 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 Grove St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 14 | Width 4ft | 6007493.55732 | 2111589.9734900002 | 37.7784469358085 | -122.417635067622 | (37.7784469358085, -122.417635067622) | |||
| 209 | 209 | 134568 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 Grove St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 12/17/2009 12:00:00 AM | 5 | Width 4ft | 6007669.37768 | 2111613.23365 | 37.778520694605795 | -122.41702848568501 | (37.7785206946058, -122.417028485685) | ||
| 214 | 214 | 251244 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 Grove St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 05/29/2013 12:00:00 AM | 6007340.02606 | 2111591.01475 | 37.778441154342296 | -122.41816626519301 | (37.7784411543423, -122.418166265193) | ||||
| 89910 | 89910 | 10726 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 Ardath Ct | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X4 | 6017489.511071401 | 2095183.8764266002 | 37.73395662609639 | -122.38191348672399 | (37.7339566260964, -122.381913486724) | |||
| 103223 | 103223 | 10725 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 Ardath Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X4 | 6017489.511071401 | 2095183.8764266002 | 37.73395662609639 | -122.38191348672399 | (37.7339566260964, -122.381913486724) | |||
| 141664 | 141664 | 10724 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 Ardath Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X4 | 6017489.511071401 | 2095183.8764266002 | 37.73395662609639 | -122.38191348672399 | (37.7339566260964, -122.381913486724) | |||
| 145219 | 145219 | 10727 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 Ardath Ct | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/2004 12:00:00 AM | 12 | 3X4 | 6017489.511071401 | 2095183.8764266002 | 37.73395662609639 | -122.38191348672399 | (37.7339566260964, -122.381913486724) | ||
| 15424 | 15424 | 13847 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 989 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 4X4 | 6009762.991 | 2112988.0614 | 37.782413196002395 | -122.409882926294 | (37.7824131960024, -122.409882926294) | |||
| 16784 | 16784 | 13848 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 989 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4X4 | 6009772.728999999 | 2112975.402 | 37.782378982039795 | -122.40984834304399 | (37.7823789820398, -122.409848343044) | |||
| 90107 | 90107 | 13850 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 989 Market St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4X4 | 6009747.4153425 | 2112968.1407914 | 37.7823576258181 | -122.40993540477501 | (37.7823576258181, -122.409935404775) | |||
| 125169 | 125169 | 13853 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 989 Market St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 4X4 | 6009747.4153425 | 2112968.1407914 | 37.7823576258181 | -122.40993540477501 | (37.7823576258181, -122.409935404775) | |||
| 138338 | 138338 | 13849 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 989 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4X4 | 6009747.4153425 | 2112968.1407914 | 37.7823576258181 | -122.40993540477501 | (37.7823576258181, -122.409935404775) | |||
| 6054 | 6054 | 13845 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 988 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4x4 | 6009746.4364 | 2113096.1529 | 37.7827090617985 | -122.40994783109 | (37.7827090617985, -122.40994783109) | |||
| 8306 | 8306 | 13846 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 988 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6009730.4123 | 2113083.3933 | 37.78267312888261 | -122.410002366849 | (37.7826731288826, -122.410002366849) | |||
| 26317 | 26317 | 143319 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 988 MARKET ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6009654.6749 | 2112984.0565 | 37.7823961285152 | -122.410257371184 | (37.7823961285152, -122.410257371184) | |||
| 45670 | 45670 | 143316 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 988 MARKET ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6009701.8736 | 2113022.474 | 37.782504259418204 | -122.410096796812 | (37.7825042594182, -122.410096796812) | |||
| 47103 | 47103 | 143317 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 988 MARKET ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6009678.8231 | 2113038.9387 | 37.782548175574604 | -122.410177704659 | (37.7825481755746, -122.410177704659) | |||
| 59131 | 59131 | 143318 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 988 MARKET ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6009678.8231 | 2113000.5212 | 37.7824426902491 | -122.41017499147301 | (37.7824426902491, -122.410174991473) | |||
| 76805 | 76805 | 143315 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 988 MARKET ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6009708.4594 | 2113060.8916 | 37.7826101141483 | -122.41007672576201 | (37.7826101141483, -122.410076725762) | |||
| 141067 | 141067 | 35814 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 985 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 776809 | 6006347.1524299 | 2103860.86986085 | 37.7571600746524 | -122.42105198546999 | (37.7571600746524, -122.42105198547) | ||
| 77871 | 77871 | 13844 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 984 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4x4 | 6009734.617085501 | 2113066.6079832 | 37.782627276054605 | -122.40998663469699 | (37.7826272760546, -122.409986634697) | |||
| 115990 | 115990 | 13843 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 982X Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4x4 | 6009750.0747082 | 2113081.3749081003 | 37.782668688852795 | -122.409934200489 | (37.7826686888528, -122.409934200489) | |||
| 19626 | 19626 | 23040 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 981 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/04/1994 12:00:00 AM | 6 | 3X3 | 6006351.67952 | 2103895.42013 | 37.7572551968739 | -122.421038782125 | (37.7572551968739, -122.421038782125) | ||
| 146295 | 146295 | 13842 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 980X Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4x4 | 6009765.9093461 | 2113096.5020018998 | 37.7827111116947 | -122.40988048733699 | (37.7827111116947, -122.409880487337) | |||
| 61725 | 61725 | 195806 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 980 Howard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6010619.06927 | 2112131.9393 | 37.780110426198604 | -122.406860899035 | (37.7801104261986, -122.406860899035) | |||
| 64000 | 64000 | 195804 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 980 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6010663.914890001 | 2112173.38956 | 37.780226748113705 | -122.406708678873 | (37.7802267481137, -122.406708678873) | |||
| 174025 | 174025 | 195805 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 980 Howard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6010641.85901 | 2112152.77813 | 37.78016891990521 | -122.40678352764401 | (37.7801689199052, -122.406783527644) | |||
| 178589 | 178589 | 195803 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 980 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6010685.45031 | 2112192.31729 | 37.7802799241099 | -122.40663551182101 | (37.7802799241099, -122.406635511821) | |||
| 9595 | 9595 | 35817 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 980 Houston St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1998 12:00:00 AM | Permit Number 39055 | ||||||||
| 12686 | 12686 | 35818 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 980 Houston St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1998 12:00:00 AM | Permit Number 39055 | ||||||||
| 13881 | 13881 | 35819 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 980 Houston St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1998 12:00:00 AM | Permit Number 39055 | ||||||||
| 15498 | 15498 | 35820 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 980 Houston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1998 12:00:00 AM | Permit Number 39055 | ||||||||
| 18814 | 18814 | 23970 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 98 West Portal Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 3x3 | 5992940.9175 | 2097860.1162 | 37.739918696433 | -122.466979278496 | (37.739918696433, -122.466979278496) | |||
| 19482 | 19482 | 23968 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 98 West Portal Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3x3 | 5992958.8303 | 2097876.1292 | 37.739963697987896 | -122.46691850783998 | (37.7399636979879, -122.46691850784) | |||
| 20990 | 20990 | 23971 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 98 West Portal Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 5992931.6897 | 2097846.8173 | 37.7398816483815 | -122.46701021751001 | (37.7398816483815, -122.46701021751) | |||
| 21887 | 21887 | 23967 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 98 West Portal Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 5992967.5153 | 2097884.5427 | 37.7399873006087 | -122.46688909044501 | (37.7399873006087, -122.466889090445) | |||
| 22245 | 22245 | 23969 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 98 West Portal Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3x3 | 5992949.0597 | 2097865.5443 | 37.7399340705835 | -122.466951520918 | (37.7399340705835, -122.466951520918) | |||
| 72848 | 72848 | 133617 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 98 Richardson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5999592.71733 | 2119396.20128 | 37.7994330384574 | -122.44552842581498 | (37.7994330384574, -122.445528425815) | |||
| 161695 | 161695 | 133616 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 98 Richardson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5999604.475930001 | 2119385.98665 | 37.799405663094 | -122.44548700214399 | (37.799405663094, -122.445487002144) |
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");