Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID ▲ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4955 | 4955 | 253734 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Girard St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x12 | 6010529.0 | 2093052.0 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | ||||
| 4982 | 4982 | 253733 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Girard St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x12 | 6010529.0 | 2093052.0 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | ||||
| 4965 | 4965 | 253732 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Girard St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x12 | 6010529.0 | 2093052.0 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | ||||
| 5004 | 5004 | 253731 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x12 | 6010529.0 | 2093052.0 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | ||||
| 5028 | 5028 | 253730 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Girard St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x12 | 6010529.0 | 2093052.0 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | ||||
| 4956 | 4956 | 253729 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Girard St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x12 | 6010529.0 | 2093052.0 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | ||||
| 5037 | 5037 | 253728 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Girard St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x12 | 6010529.0 | 2093052.0 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | ||||
| 4993 | 4993 | 253727 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Girard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x12 | 6010529.0 | 2093052.0 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | ||||
| 4986 | 4986 | 253726 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Girard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x12 | 6010529.0 | 2093052.0 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | ||||
| 5021 | 5021 | 253725 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Girard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x12 | 6010529.0 | 2093052.0 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | ||||
| 4968 | 4968 | 253724 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Girard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x12 | 6010529.0 | 2093052.0 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | ||||
| 4620 | 4620 | 253639 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 4405 California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 3x3 | 5993893.0 | 2114132.0 | 37.784651953064206 | -122.46486880251801 | (37.7846519530642, -122.464868802518) | |||
| 4013 | 4013 | 253610 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1075 Mission St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 4ft | 6009725.02676 | 2112060.52163 | 37.7798642637711 | -122.40994876804 | (37.7798642637711, -122.40994876804) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 2299 | 2299 | 253020 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 760 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004216.0 | 2110862.0 | 37.7762631241711 | -122.42892145951299 | (37.7762631241711, -122.428921459513) | ||||
| 2767 | 2767 | 252950 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 261x Winding Way | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | Permit Number 780594 | 6001774.0 | 2086449.0 | 37.7090922302752 | -122.435622042553 | (37.7090922302752, -122.435622042553) | |||
| 2772 | 2772 | 252949 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 261x Winding Way | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | Permit Number 780594 | 6001774.0 | 2086449.0 | 37.7090922302752 | -122.435622042553 | (37.7090922302752, -122.435622042553) | |||
| 2087 | 2087 | 252878 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X King St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 3x3 | 6014268.0 | 2110701.0 | 37.776384889187796 | -122.394137287636 | (37.7763848891878, -122.394137287636) | |||
| 5029 | 5029 | 251680 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Girard St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x12 | 6010529.0 | 2093052.0 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | ||||
| 1665 | 1665 | 251650 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 101X Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | |||||||||
| 1685 | 1685 | 251478 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2x Virginia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 02/21/2004 12:00:00 AM | 3x3 | 6006146.0 | 2098692.0 | 37.7429562000135 | -122.42138058886101 | (37.7429562000135, -122.421380588861) | ||
| 975 | 975 | 251421 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X King St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 09/30/2014 01:37:00 PM | 3x3 | 6014268.0 | 2110701.0 | 37.776384889187796 | -122.394137287636 | (37.7763848891878, -122.394137287636) | ||
| 425 | 425 | 251299 | Planning Code 138.1 required 4 | Platanus x hispanica :: Sycamore: London Plane 15 | 2190X Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4X4 | 6003624.7851 | 2107240.8343 | 37.766286807234295 | -122.430708166736 | (37.7662868072343, -122.430708166736) | ||||
| 431 | 431 | 251298 | Planning Code 138.1 required 4 | Platanus x hispanica :: Sycamore: London Plane 15 | 2190X Market St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4X4 | 6003624.7851 | 2107240.8343 | 37.766286807234295 | -122.430708166736 | (37.7662868072343, -122.430708166736) | ||||
| 432 | 432 | 251297 | Planning Code 138.1 required 4 | Platanus x hispanica :: Sycamore: London Plane 15 | 2190X Market St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4X4 | 6003624.7851 | 2107240.8343 | 37.766286807234295 | -122.430708166736 | (37.7662868072343, -122.430708166736) | ||||
| 446 | 446 | 251296 | Planning Code 138.1 required 4 | Platanus x hispanica :: Sycamore: London Plane 15 | 2190X Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4X4 | 6003624.7851 | 2107240.8343 | 37.766286807234295 | -122.430708166736 | (37.7662868072343, -122.430708166736) | ||||
| 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) | ||||
| 156291 | 156291 | 250976 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 7010 California St | 5 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 5985685.129819999 | 2113916.728 | 37.783584222178995 | -122.49324901662399 | (37.783584222179, -122.493249016624) | |||
| 160175 | 160175 | 250975 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 7010 California St | 4 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 5985704.58491 | 2113917.1556700002 | 37.7835865343301 | -122.49318174196699 | (37.7835865343301, -122.493181741967) | |||
| 70752 | 70752 | 250974 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 7010 California St | 3 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 5985720.677490001 | 2113918.49675 | 37.78359115774511 | -122.493126167444 | (37.7835911577451, -122.493126167444) | |||
| 33448 | 33448 | 250973 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 7010 California St | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 5985735.07087 | 2113919.4528200002 | 37.7835946246316 | -122.493076443038 | (37.7835946246316, -122.493076443038) | |||
| 38838 | 38838 | 250972 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 7010 California St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 5985754.51701 | 2113919.45983 | 37.78359578115 | -122.493009168333 | (37.78359578115, -122.493009168333) | |||
| 56426 | 56426 | 250971 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 7002 California St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 5985825.16294 | 2113921.74383 | 37.783606183626105 | -122.492764932276 | (37.7836061836261, -122.492764932276) | |||
| 29631 | 29631 | 250970 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 6932 California St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 4ft | 5985996.4910699995 | 2113927.35673 | 37.7836316119485 | -122.49217262437 | (37.7836316119485, -122.49217262437) | |||
| 55403 | 55403 | 250969 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 6924 California St | 3 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 5986098.00978 | 2113930.24714 | 37.7836454821978 | -122.49182162619199 | (37.7836454821978, -122.491821626192) | |||
| 179695 | 179695 | 250968 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 6542 California St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 4ft | 5986266.0021 | 2113938.0378400004 | 37.783676690482004 | -122.49124101845699 | (37.783676690482, -122.491241018457) | |||
| 134246 | 134246 | 250967 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 6542 California St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 4ft | 5986305.7572 | 2113938.87572 | 37.78368131388 | -122.491103544499 | (37.78368131388, -122.491103544499) | |||
| 42642 | 42642 | 250966 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 6542 California St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5986349.34208 | 2113940.89483 | 37.7836894041789 | -122.490952908074 | (37.7836894041789, -122.490952908074) | |||
| 46424 | 46424 | 250965 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 6540 California St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 4ft | 5986394.617190001 | 2113942.87838 | 37.7836974953865 | -122.490796421524 | (37.7836974953865, -122.490796421524) | |||
| 176105 | 176105 | 250964 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 6540 California St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 5986452.15501 | 2113945.02201 | 37.7837067422095 | -122.490597522969 | (37.7837067422095, -122.490597522969) | |||
| 186717 | 186717 | 250963 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 6538 California St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 5986577.80338 | 2113949.50565 | 37.7837263914907 | -122.490163163006 | (37.7837263914907, -122.490163163006) | |||
| 28618 | 28618 | 250962 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 6538 California St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 5986619.26657 | 2113951.14977 | 37.78373332707871 | -122.490019838944 | (37.7837333270787, -122.490019838944) | |||
| 54635 | 54635 | 250961 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 6538 California St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 4ft | 5986661.98827 | 2113952.34597 | 37.783739106117295 | -122.489872127989 | (37.7837391061173, -122.489872127989) | |||
| 151747 | 151747 | 250960 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 6536 California St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 4ft | 5986717.82713 | 2113954.10541 | 37.7837471973129 | -122.489679078628 | (37.7837471973129, -122.489679078628) | |||
| 171365 | 171365 | 250959 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 6536 California St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 5986752.106919999 | 2113955.90215 | 37.783754131992104 | -122.489560617232 | (37.7837541319921, -122.489560617232) | |||
| 177485 | 177485 | 250958 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 6534 California St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 5986885.78325 | 2113960.21653 | 37.7837737812885 | -122.489098470914 | (37.7837737812885, -122.489098470914) | |||
| 34856 | 34856 | 250957 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 6534 California St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 5986936.54247 | 2113961.66352 | 37.7837807168614 | -122.488922971817 | (37.7837807168614, -122.488922971817) | |||
| 150117 | 150117 | 250956 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 6534 California St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 4ft | 5986981.781690001 | 2113961.9646099997 | 37.7837841837271 | -122.488766485305 | (37.7837841837271, -122.488766485305) | |||
| 173122 | 173122 | 250955 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 6532 California St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 5987034.671490001 | 2113964.2082700003 | 37.7837934305581 | -122.488583673816 | (37.7837934305581, -122.488583673816) | |||
| 60783 | 60783 | 250954 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 6532 California St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 4ft | 5987082.436980001 | 2113964.03529 | 37.7837957427146 | -122.48841841257601 | (37.7837957427146, -122.488418412576) | |||
| 55279 | 55279 | 250816 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 66 Sea View Ter | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 4ft | 5986143.35026 | 2114166.31593 | 37.7842963089792 | -122.491682151215 | (37.7842963089792, -122.491682151215) | |||
| 34041 | 34041 | 250815 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 66 Sea View Ter | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5986156.52823 | 2114164.57331 | 37.784292294401 | -122.491636432381 | (37.784292294401, -122.491636432381) | |||
| 73953 | 73953 | 250814 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 66 Sea View Ter | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 4ft | 5986166.78643 | 2114163.6239 | 37.7842902870978 | -122.491600873197 | (37.7842902870978, -122.491600873197) | |||
| 24473 | 24473 | 250486 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 220 El Camino Del Mar | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5987923.25995 | 2115358.25633 | 37.7876728999176 | -122.485611871313 | (37.7876728999176, -122.485611871313) | |||
| 27716 | 27716 | 250485 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 220 El Camino Del Mar | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5987961.74395 | 2115359.72592 | 37.7876791771886 | -122.485478833689 | (37.7876791771886, -122.485478833689) | |||
| 155951 | 155951 | 250484 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 220 El Camino Del Mar | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5987976.085519999 | 2115359.42161 | 37.7876791771865 | -122.485429192915 | (37.7876791771865, -122.485429192915) | |||
| 130977 | 130977 | 250307 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 4 United Nations Plz | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 0ft | 6008588.67814 | 2112072.19171 | 37.779832554580295 | -122.413880739803 | (37.7798325545803, -122.413880739803) | |||
| 38801 | 38801 | 250306 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 4 United Nations Plz | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 0ft | 6008573.7773400005 | 2112070.38194 | 37.7798267485347 | -122.41393216035601 | (37.7798267485347, -122.413932160356) | |||
| 153532 | 153532 | 250305 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 4 United Nations Plz | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 0ft | 6008554.56675 | 2112065.4885299997 | 37.779812233472704 | -122.413998272207 | (37.7798122334727, -122.413998272207) | |||
| 54984 | 54984 | 250304 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 4 United Nations Plz | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 0ft | 6008532.24811 | 2112064.35949 | 37.7798078798681 | -122.414075402566 | (37.7798078798681, -122.414075402566) | |||
| 64367 | 64367 | 250303 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 4 United Nations Plz | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 0ft | 6008514.64017 | 2112059.96196 | 37.7797948163118 | -122.41413600517599 | (37.7797948163118, -122.414136005176) | |||
| 54261 | 54261 | 250302 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 4 United Nations Plz | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 0ft | 6008493.92418 | 2112059.32847 | 37.7797919133004 | -122.41420762629 | (37.7797919133004, -122.41420762629) | |||
| 72230 | 72230 | 250301 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 United Nations Plz | 14 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 0ft | 6008422.13834 | 2112053.39653 | 37.779771593125 | -122.414455545984 | (37.779771593125, -122.414455545984) | |||
| 34450 | 34450 | 250300 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 United Nations Plz | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 0ft | 6008420.57979 | 2112029.11153 | 37.779704824759996 | -122.414459218831 | (37.77970482476, -122.414459218831) | |||
| 51080 | 51080 | 250299 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 United Nations Plz | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 0ft | 6008402.94933 | 2112049.56006 | 37.7797599810866 | -122.414521657841 | (37.7797599810866, -122.414521657841) | |||
| 188156 | 188156 | 250298 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 United Nations Plz | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 0ft | 6008400.93583 | 2112028.98514 | 37.7797033741539 | -122.414527167109 | (37.7797033741539, -122.414527167109) | |||
| 40359 | 40359 | 250297 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 United Nations Plz | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 0ft | 6008380.5766 | 2112045.78874 | 37.7797483690312 | -122.414598788204 | (37.7797483690312, -122.414598788204) | |||
| 183204 | 183204 | 250296 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 United Nations Plz | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 0ft | 6008382.28823 | 2112025.66624 | 37.7796932136159 | -122.414591442551 | (37.7796932136159, -122.414591442551) | |||
| 188521 | 188521 | 250295 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 United Nations Plz | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 0ft | 6008359.254290001 | 2112041.46764 | 37.7797353063774 | -122.41467224575199 | (37.7797353063774, -122.414672245752) | |||
| 41048 | 41048 | 250294 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 United Nations Plz | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 0ft | 6008364.20368 | 2112023.92173 | 37.7796874075756 | -122.414653881581 | (37.7796874075756, -122.414653881581) | |||
| 188050 | 188050 | 250293 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 United Nations Plz | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 0ft | 6008341.16975 | 2112039.72315 | 37.7797295003499 | -122.414734684778 | (37.7797295003499, -122.414734684778) | |||
| 176949 | 176949 | 250292 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 United Nations Plz | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 0ft | 6008339.69764 | 2112019.66547 | 37.779674344042796 | -122.414738357587 | (37.7796743440428, -122.414738357587) | |||
| 180468 | 180468 | 250291 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 United Nations Plz | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 0ft | 6008329.45289 | 2112037.8483700003 | 37.779723694325796 | -122.414775085919 | (37.7797236943258, -122.414775085919) | |||
| 151417 | 151417 | 250290 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 United Nations Plz | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 0ft | 6008327.51503 | 2112020.97203 | 37.7796772470476 | -122.41478059514601 | (37.7796772470476, -122.414780595146) | |||
| 130117 | 130117 | 250289 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 United Nations Plz | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 0ft | 6008315.06105 | 2112034.97107 | 37.7797149853055 | -122.41482467003401 | (37.7797149853055, -122.414824670034) | |||
| 177548 | 177548 | 250288 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 United Nations Plz | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 0ft | 6008315.19159 | 2112015.40955 | 37.7796612813825 | -122.414822833622 | (37.7796612813825, -122.414822833622) | |||
| 162027 | 162027 | 250287 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 43 United Nations Plz | 28 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 0ft | 6008296.47872 | 2112132.36375 | 37.779981358185296 | -122.414895849576 | (37.7799813581853, -122.414895849576) | |||
| 39563 | 39563 | 250286 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 43 United Nations Plz | 27 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 0ft | 6008300.87263 | 2112112.7782 | 37.7799278278445 | -122.414879262463 | (37.7799278278445, -122.414879262463) | |||
| 30359 | 30359 | 250285 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 43 United Nations Plz | 26 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 0ft | 6008311.26384 | 2112132.45914 | 37.7799824508737 | -122.41484470781401 | (37.7799824508737, -122.414844707814) | |||
| 130814 | 130814 | 250284 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 43 United Nations Plz | 25 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 0ft | 6008318.07852 | 2112114.01757 | 37.77993219764 | -122.414819827174 | (37.77993219764, -122.414819827174) | |||
| 163950 | 163950 | 250283 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 43 United Nations Plz | 24 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 0ft | 6008334.1263 | 2112136.76571 | 37.7799955602742 | -122.41476592093599 | (37.7799955602742, -122.414765920936) | |||
| 170408 | 170408 | 250282 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 43 United Nations Plz | 23 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 0ft | 6008336.06691 | 2112114.44505 | 37.779934382115606 | -122.414757627379 | (37.7799343821156, -122.414757627379) | |||
| 47872 | 47872 | 250281 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 43 United Nations Plz | 22 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 0ft | 6008344.09456 | 2112135.7661599996 | 37.7799933758261 | -122.414731365385 | (37.7799933758261, -122.414731365385) | |||
| 67241 | 67241 | 250280 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 43 United Nations Plz | 21 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 0ft | 6008350.1916 | 2112121.31781 | 37.7799540466755 | -122.41470925013901 | (37.7799540466755, -122.414709250139) | |||
| 67438 | 67438 | 250279 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 43 United Nations Plz | 20 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 0ft | 6008368.8075 | 2112132.87311 | 37.7799868206815 | -122.41464566717698 | (37.7799868206815, -122.414645667177) | |||
| 132329 | 132329 | 250278 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 43 United Nations Plz | 19 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 0ft | 6008372.2146 | 2112123.6525 | 37.7799616945114 | -122.414633227763 | (37.7799616945114, -122.414633227763) | |||
| 60151 | 60151 | 250277 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 43 United Nations Plz | 18 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 0ft | 6008392.9818 | 2112142.72321 | 37.780015224857294 | -122.41456273439199 | (37.7800152248573, -122.414562734392) | |||
| 23941 | 23941 | 250276 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 43 United Nations Plz | 17 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 0ft | 6008392.62375 | 2112125.224 | 37.7799671560941 | -122.414562734397 | (37.7799671560941, -122.414562734397) | |||
| 160081 | 160081 | 250275 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 43 United Nations Plz | 16 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 0ft | 6008410.57079 | 2112143.15923 | 37.7800174102082 | -122.414501916834 | (37.7800174102082, -122.414501916834) | |||
| 175613 | 175613 | 250274 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 43 United Nations Plz | 15 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 0ft | 6008410.261580001 | 2112128.0464 | 37.779975896618 | -122.414501916828 | (37.779975896618, -122.414501916828) | |||
| 73407 | 73407 | 250273 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 43 United Nations Plz | 14 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 0ft | 6008481.10598 | 2112153.6523700003 | 37.7800501841947 | -122.414258645714 | (37.7800501841947, -122.414258645714) | |||
| 51845 | 51845 | 250272 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 43 United Nations Plz | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 0ft | 6008485.20638 | 2112139.2449 | 37.780010855049 | -122.414243440893 | (37.780010855049, -122.414243440893) | |||
| 58454 | 58454 | 250271 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 43 United Nations Plz | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 0ft | 6008499.1431599995 | 2112156.4663299997 | 37.7800589238189 | -122.41419644590799 | (37.7800589238189, -122.414196445908) | |||
| 150038 | 150038 | 250270 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 43 United Nations Plz | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 0ft | 6008502.42852 | 2112141.27996 | 37.7800174102115 | -122.41418400559401 | (37.7800174102115, -122.414184005594) |
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");