Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▲ | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 156982 | 156982 | 137506 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 150 Francisco St | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 3ft | 6010570.56702 | 2121351.03968 | 37.8054211392381 | -122.407678906174 | (37.8054211392381, -122.407678906174) | |||
| 54749 | 54749 | 137504 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2521 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6007440.32409 | 2121045.18765 | 37.8044056238841 | -122.41848985342399 | (37.8044056238841, -122.418489853424) | |||
| 33585 | 33585 | 137505 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2521 Leavenworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6007440.6556 | 2121042.48362 | 37.8043982179661 | -122.41848851434601 | (37.8043982179661, -122.418488514346) | |||
| 160511 | 160511 | 33315 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1229 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | 19 | Permit Number 37460 | 6005351.66292 | 2120593.2650099997 | 37.8030469569032 | -122.42568566546001 | (37.8030469569032, -122.42568566546) | |
| 53512 | 53512 | 33314 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1229 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1997 12:00:00 AM | 18 | Permit Number 37460 | 6005325.69823 | 2120590.66128 | 37.803038340517396 | -122.425775331487 | (37.8030383405174, -122.425775331487) | |
| 54015 | 54015 | 250212 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 300 Filbert St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | Width 0ft | 6011360.92473 | 2120092.038 | 37.8020084404915 | -122.404855058325 | (37.8020084404915, -122.404855058325) | |||
| 43953 | 43953 | 249965 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 265 Filbert St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | Width 0ft | 6011638.85917 | 2120086.18138 | 37.802007891017205 | -122.40389285566799 | (37.8020078910172, -122.403892855668) | |||
| 148787 | 148787 | 137501 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2317 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 4ft | 6000760.82972 | 2119605.96149 | 37.8000756013698 | -122.44150141455401 | (37.8000756013698, -122.441501414554) | |||
| 51490 | 51490 | 67305 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2317 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/1992 12:00:00 AM | 18 | Permit Number 30786 | 6000748.48964 | 2119604.08725 | 37.800069752172604 | -122.44154398128299 | (37.8000697521726, -122.441543981283) | ||
| 135412 | 135412 | 137503 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1142 Filbert St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | Width 3ft | 6007446.543330001 | 2119552.3525099996 | 37.8003070257165 | -122.418362418606 | (37.8003070257165, -122.418362418606) | |||
| 91124 | 91124 | 113402 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2032 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12 | 3x3 | 6006483.0 | 2117763.0 | 37.7953396281575 | -122.42156950983299 | (37.7953396281575, -122.421569509833) | ||
| 139224 | 139224 | 96035 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2032 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767674 | 6006483.0 | 2117763.0 | 37.7953396281575 | -122.42156950983299 | (37.7953396281575, -122.421569509833) | |
| 96091 | 96091 | 97445 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900@Gough Pacific Ave | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6004943.9 | 2117474.7 | 37.794461125583794 | -122.42687450783701 | (37.7944611255838, -122.426874507837) | |||||
| 134126 | 134126 | 137502 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1360 Jones St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6008496.5924 | 2117239.72456 | 37.7940161753676 | -122.41456508161801 | (37.7940161753676, -122.414565081618) | |||
| 186449 | 186449 | 52601 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1360WASHINGTON Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/2006 12:00:00 AM | 12 | Permit Number 48694 | 6008501.73087 | 2117208.37484 | 37.7939303854283 | -122.414545082491 | (37.7939303854283, -122.414545082491) | ||
| 24682 | 24682 | 203198 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 91 Market St | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 10ft | 6013828.57328 | 2116873.69458 | 37.7933092533841 | -122.39609008760401 | (37.7933092533841, -122.396090087604) | |||
| 161827 | 161827 | 203197 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 91 Market St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 17 | Width 10ft | 6013808.49559 | 2116854.49545 | 37.7932554199655 | -122.39615821213499 | (37.7932554199655, -122.396158212135) | |||
| 165364 | 165364 | 203196 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 91 Market St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 10ft | 6013792.252169999 | 2116838.17263 | 37.7932096975269 | -122.39621327133301 | (37.7932096975269, -122.396213271333) | |||
| 9740 | 9740 | 173671 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 299x Beale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014575.0 | 2115523.0 | 37.789642061391 | -122.39341281176901 | (37.789642061391, -122.393412811769) | ||||
| 9752 | 9752 | 173678 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 299x Beale St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014575.0 | 2115523.0 | 37.789642061391 | -122.39341281176901 | (37.789642061391, -122.393412811769) | ||||
| 79235 | 79235 | 6115 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 600X El Camino Del Mar | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 15-HOA | 5986691.2678849995 | 2115146.1691739 | 37.787018710699 | -122.48985866316099 | (37.787018710699, -122.489858663161) | |||
| 80227 | 80227 | 6116 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 600X El Camino Del Mar | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 15-HOA | 5986691.2678849995 | 2115146.1691739 | 37.787018710699 | -122.48985866316099 | (37.787018710699, -122.489858663161) | |||
| 87834 | 87834 | 27695 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 600X El Camino Del Mar | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 15-HOA | 5986691.2678849995 | 2115146.1691739 | 37.787018710699 | -122.48985866316099 | (37.787018710699, -122.489858663161) | |||
| 93045 | 93045 | 6109 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 600X El Camino Del Mar | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 15-HOA | 5986691.2678849995 | 2115146.1691739 | 37.787018710699 | -122.48985866316099 | (37.787018710699, -122.489858663161) | |||
| 101360 | 101360 | 6110 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 600X El Camino Del Mar | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 15-HOA | 5986691.2678849995 | 2115146.1691739 | 37.787018710699 | -122.48985866316099 | (37.787018710699, -122.489858663161) | |||
| 104622 | 104622 | 27693 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 600X El Camino Del Mar | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 15-HOA | 5986691.2678849995 | 2115146.1691739 | 37.787018710699 | -122.48985866316099 | (37.787018710699, -122.489858663161) | |||
| 106348 | 106348 | 6113 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 600X El Camino Del Mar | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 15-HOA | 5986691.2678849995 | 2115146.1691739 | 37.787018710699 | -122.48985866316099 | (37.787018710699, -122.489858663161) | |||
| 110321 | 110321 | 6112 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 600X El Camino Del Mar | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 15-HOA | 5986691.2678849995 | 2115146.1691739 | 37.787018710699 | -122.48985866316099 | (37.787018710699, -122.489858663161) | |||
| 111730 | 111730 | 27692 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 600X El Camino Del Mar | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 15-HOA | 5986691.2678849995 | 2115146.1691739 | 37.787018710699 | -122.48985866316099 | (37.787018710699, -122.489858663161) | |||
| 112905 | 112905 | 6111 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 600X El Camino Del Mar | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 15-HOA | 5986691.2678849995 | 2115146.1691739 | 37.787018710699 | -122.48985866316099 | (37.787018710699, -122.489858663161) | |||
| 123108 | 123108 | 6114 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 600X El Camino Del Mar | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 15-HOA | 5986691.2678849995 | 2115146.1691739 | 37.787018710699 | -122.48985866316099 | (37.787018710699, -122.489858663161) | |||
| 127634 | 127634 | 27696 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 600X El Camino Del Mar | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 15-HOA | 5986691.2678849995 | 2115146.1691739 | 37.787018710699 | -122.48985866316099 | (37.787018710699, -122.489858663161) | |||
| 128687 | 128687 | 6108 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 600X El Camino Del Mar | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 15-HOA | 5986691.2678849995 | 2115146.1691739 | 37.787018710699 | -122.48985866316099 | (37.787018710699, -122.489858663161) | |||
| 145369 | 145369 | 6107 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 600X El Camino Del Mar | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 15-HOA | 5986691.2678849995 | 2115146.1691739 | 37.787018710699 | -122.48985866316099 | (37.787018710699, -122.489858663161) | |||
| 44370 | 44370 | 137500 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 52 Iris Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 5997635.71873 | 2114163.76026 | 37.78495423950061 | -122.451922604659 | (37.7849542395006, -122.451922604659) | |||
| 160869 | 160869 | 124558 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 90 Palm Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 5995920.27647 | 2113881.21497 | 37.7840800415509 | -122.457836994738 | (37.7840800415509, -122.457836994738) | |||
| 183818 | 183818 | 124559 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 90 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 5995921.75191 | 2113853.09729 | 37.7840029226817 | -122.45782985493 | (37.7840029226817, -122.45782985493) | |||
| 28377 | 28377 | 48685 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 100 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2002 12:00:00 AM | 22 | Permit Number 45967 | 5995923.78548 | 2113769.63655 | 37.7837738786202 | -122.45781677815 | (37.7837738786202, -122.45781677815) | ||
| 45244 | 45244 | 124344 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 105 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 4ft | 5995869.2461 | 2113758.79509 | 37.7837409774514 | -122.458004677882 | (37.7837409774514, -122.458004677882) | |||
| 29445 | 29445 | 124343 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 105 Palm Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 5995870.59128 | 2113726.09219 | 37.7836512613147 | -122.457997656644 | (37.7836512613147, -122.457997656644) | |||
| 28011 | 28011 | 124342 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 105 Palm Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 5995870.42219 | 2113701.84259 | 37.7835846686773 | -122.457996486135 | (37.7835846686773, -122.457996486135) | |||
| 147475 | 147475 | 124341 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 105 Palm Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 5995870.37991 | 2113683.65327 | 37.783534723234894 | -122.45799531563699 | (37.7835347232349, -122.457995315637) | |||
| 189103 | 189103 | 96941 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 108 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | 5995926.85193 | 2113670.95774 | 37.7835031091294 | -122.457799026544 | (37.7835031091294, -122.457799026544) | ||||
| 39861 | 39861 | 65881 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 122 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 19 | 3x3 | Permit Number 53867 | 5995930.99366 | 2113550.02665 | 37.783171302573 | -122.457775944343 | (37.783171302573, -122.457775944343) |
| 105688 | 105688 | 47457 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1307 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/26/2006 12:00:00 AM | Permit Number 49033 | 6000227.71556431 | 2113384.63358291 | 37.782963078767 | -122.442899183951 | (37.782963078767, -122.442899183951) | ||
| 107982 | 107982 | 47458 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1307 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/26/2006 12:00:00 AM | Permit Number 49033 | 6000227.71556431 | 2113384.63358291 | 37.782963078767 | -122.442899183951 | (37.782963078767, -122.442899183951) | ||
| 50846 | 50846 | 124333 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 172 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 5995945.982919999 | 2113131.373 | 37.782022652324294 | -122.45769378533001 | (37.7820226523243, -122.45769378533) | |||
| 148908 | 148908 | 118014 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 472 37th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 6ft | 5984415.81444 | 2112632.82053 | 37.779984662684704 | -122.49754547051 | (37.7799846626847, -122.49754547051) | |||
| 110388 | 110388 | 112172 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 998X MISSION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6010071.0 | 2112545.0 | 37.7812139111906 | -122.40878607767901 | (37.7812139111906, -122.408786077679) | ||||
| 164885 | 164885 | 199495 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 87 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6010059.4721800005 | 2112539.81003 | 37.78119901506621 | -122.408825592144 | (37.7811990150662, -122.408825592144) | |||
| 50542 | 50542 | 56949 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 87 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/27/1974 12:00:00 AM | 16 | Permit Number 14201 | 6010069.06775 | 2112529.00786 | 37.7811698923233 | -122.408791633752 | (37.7811698923233, -122.408791633752) | ||
| 117029 | 117029 | 199490 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 483 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 5ft | 6010121.32315 | 2112524.17075 | 37.7811595375133 | -122.408610513875 | (37.7811595375133, -122.408610513875) | |||
| 158682 | 158682 | 65148 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 7330 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1989 12:00:00 AM | 17 | Permit Number 27125 | 5984217.18812 | 2112512.23092 | 37.7796419140825 | -122.498223688652 | (37.7796419140825, -122.498223688652) | ||
| 988 | 988 | 199496 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 87 06th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | Width 4ft | 6010015.0817 | 2112492.094 | 37.781065511609604 | -122.40897579419399 | (37.7810655116096, -122.408975794194) | |||
| 34386 | 34386 | 199497 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 72 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 4ft | 6010024.2102 | 2112481.0403 | 37.7810356721041 | -122.408943433887 | (37.7810356721041, -122.408943433887) | |||
| 54820 | 54820 | 199491 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 991 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 5ft | 6010160.462780001 | 2112475.94927 | 37.7810293246804 | -122.408471707117 | (37.7810293246804, -122.408471707117) | |||
| 2853 | 2853 | 253248 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 570 Jessie St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/2017 12:00:00 AM | 3 | 3x3 | Permit Number 775513 | 6009730.1467 | 2112442.1376799997 | 37.7809123781536 | -122.40995800293301 | (37.7809123781536, -122.409958002933) | |
| 2868 | 2868 | 253247 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 570 Jessie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/2017 12:00:00 AM | 3 | 3x3 | Permit Number 775513 | 6009730.1467 | 2112442.1376799997 | 37.7809123781536 | -122.40995800293301 | (37.7809123781536, -122.409958002933) | |
| 2897 | 2897 | 253249 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 570 Jessie St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/2017 12:00:00 AM | 3 | 3x3 | Permit Number 775513 | 6009730.1467 | 2112442.1376799997 | 37.7809123781536 | -122.40995800293301 | (37.7809123781536, -122.409958002933) | |
| 38867 | 38867 | 199498 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1008 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 4ft | 6010028.2471900005 | 2112434.38373 | 37.780907790314394 | -122.40892617503 | (37.7809077903144, -122.40892617503) | |||
| 13867 | 13867 | 102421 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 101 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 4x4 | 6010161.06831 | 2112431.87946 | 37.780908353287394 | -122.40846650275199 | (37.7809083532874, -122.408466502752) | |||
| 156009 | 156009 | 102420 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 101 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4x4 | 6010175.35097 | 2112415.36622 | 37.780863811667295 | -122.408415926663 | (37.7808638116673, -122.408415926663) | |||
| 46987 | 46987 | 102441 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1007X Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 4x4 | 6010078.92624 | 2112396.7113200002 | 37.7808071894337 | -122.408748191999 | (37.7808071894337, -122.408748191999) | |||
| 15166 | 15166 | 102426 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 100 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 4x4 | 6010110.9527900005 | 2112392.33205 | 37.780796958746 | -122.408637087058 | (37.780796958746, -122.408637087058) | |||
| 62727 | 62727 | 199499 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1008 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 6009970.38295 | 2112379.67473 | 37.7807543308744 | -122.40912249520001 | (37.7807543308744, -122.4091224952) | |||
| 43226 | 43226 | 118483 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 8349 Geary Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | 5981073.18846 | 2112308.0171 | 37.7788963529663 | -122.50908477858499 | (37.7788963529663, -122.509084778585) | ||||
| 130131 | 130131 | 118484 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 8349 Geary Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | 5981049.15965 | 2112307.0389 | 37.7788922504996 | -122.50916782963499 | (37.7788922504996, -122.509167829635) | ||||
| 170194 | 170194 | 67454 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 18 Rossi Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/1992 12:00:00 AM | 24 | Permit Number 30963 | 5996314.7251699995 | 2112137.62024 | 37.7793152462196 | -122.456346235157 | (37.7793152462196, -122.456346235157) | ||
| 146701 | 146701 | 102431 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 982 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 4x4 | 6010575.8749400005 | 2112088.03468 | 37.7799874573922 | -122.40700723309601 | (37.7799874573922, -122.407007233096) | |||
| 13833 | 13833 | 95855 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 185 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 6010497.41028 | 2112077.91159 | 37.7799552706525 | -122.407277965014 | (37.7799552706525, -122.407277965014) | |||
| 70541 | 70541 | 102432 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 982 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | 4x4 | 6010557.78599 | 2112071.21552 | 37.779940263668706 | -122.40706862532801 | (37.7799402636687, -122.407068625328) | |||
| 14065 | 14065 | 95854 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 185 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 6010514.67057 | 2112059.04775 | 37.779904440962504 | -122.407216923546 | (37.7799044409625, -122.407216923546) | |||
| 16718 | 16718 | 102428 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 184 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 4x4 | 6010438.87034 | 2112046.078 | 37.779864586616505 | -122.407478236832 | (37.7798645866165, -122.407478236832) | |||
| 59377 | 59377 | 199500 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 184 06th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6010448.06676 | 2112033.83872 | 37.7798314951708 | -122.40744555907601 | (37.7798314951708, -122.407445559076) | |||
| 51291 | 51291 | 100875 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 995 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 6010609.42845 | 2112029.4559299997 | 37.7798284914364 | -122.406887026109 | (37.7798284914364, -122.406887026109) | ||||
| 188646 | 188646 | 100874 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 995 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 6010596.8170300005 | 2112015.71985 | 37.7797900696951 | -122.40692968637501 | (37.7797900696951, -122.406929686375) | ||||
| 184866 | 184866 | 199501 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1012 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6010462.04247 | 2111980.9380099997 | 37.7796870244685 | -122.40739348023199 | (37.7796870244685, -122.407393480232) | |||
| 44869 | 44869 | 199502 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1012 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6010449.4105 | 2111969.43782 | 37.7796547406221 | -122.40743636892 | (37.7796547406221, -122.40743636892) | |||
| 16698 | 16698 | 102419 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 201 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 4x4 | 6010609.192559999 | 2111959.7498 | 37.7796370815369 | -122.40688292791799 | (37.7796370815369, -122.406882927918) | |||
| 14256 | 14256 | 102418 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 201 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 4x4 | 6010625.41098 | 2111944.3761400003 | 37.7795957765601 | -122.406825737323 | (37.7795957765601, -122.406825737323) | |||
| 1634 | 1634 | 199504 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 1009 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 770993 | 6010510.13491 | 2111932.18806 | 37.7795558601644 | -122.407223669342 | (37.7795558601644, -122.407223669342) | |
| 1642 | 1642 | 199503 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 1009 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 770993 | 6010500.983080001 | 2111924.50305 | 37.7795342467397 | -122.40725478770099 | (37.7795342467397, -122.407254787701) | |
| 1602 | 1602 | 102429 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 200 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2017 12:00:00 AM | 3 | 4x4 | Permit Number 770993 | 6010552.49087 | 2111923.99595 | 37.7795357369219 | -122.40707656363399 | (37.7795357369219, -122.407076563634) | |
| 1601 | 1601 | 102430 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 200 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2017 12:00:00 AM | 3 | 4x4 | Permit Number 770993 | 6010566.09371 | 2111909.33227 | 37.779496235110706 | -122.407028471514 | (37.7794962351107, -122.407028471514) | |
| 40464 | 40464 | 199494 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 281 06th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6010924.085580001 | 2111634.58421 | 37.7787618676114 | -122.405770660782 | (37.7787618676114, -122.405770660782) | |||
| 146398 | 146398 | 199506 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 121 07th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6009672.01904 | 2111627.24224 | 37.778671609854 | -122.410101548456 | (37.778671609854, -122.410101548456) | |||
| 67150 | 67150 | 199493 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 281 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 5ft | 6010934.97193 | 2111623.29262 | 37.7787314723253 | -122.405732204886 | (37.7787314723253, -122.405732204886) | |||
| 183952 | 183952 | 199492 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 281 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 5ft | 6010946.44549 | 2111612.84065 | 37.778703415264296 | -122.40569177677901 | (37.7787034152643, -122.405691776779) | |||
| 164288 | 164288 | 199505 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 121 07th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6009689.53245 | 2111610.6533 | 37.7786270421403 | -122.41003979110901 | (37.7786270421403, -122.410039791109) | |||
| 156933 | 156933 | 62745 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 121 07th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/1986 12:00:00 AM | 13 | Permit Number 23093 | 6009715.48574 | 2111589.25493 | 37.7785697418509 | -122.409948497336 | (37.7785697418509, -122.409948497336) | ||
| 63685 | 63685 | 84744 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 170 King St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 20 | Permit No. 49304 | 6015122.21866 | 2111558.9441 | 37.7787880531604 | -122.391242266936 | (37.7787880531604, -122.391242266936) | ||
| 46634 | 46634 | 84745 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 170 King St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 18 | Permit No. 49304 | 6015113.5864699995 | 2111549.96085 | 37.7787629081139 | -122.39127150119499 | (37.7787629081139, -122.391271501195) | ||
| 75228 | 75228 | 84746 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 170 King St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 22 | Permit No. 49304 | 6015095.84023 | 2111532.74661 | 37.778714656793 | -122.391331689209 | (37.778714656793, -122.391331689209) | ||
| 47057 | 47057 | 84747 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 170 King St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 19 | Permit No. 49304 | 6015084.20168 | 2111522.58673 | 37.7786861141091 | -122.391371241385 | (37.7786861141091, -122.391371241385) | ||
| 154180 | 154180 | 84748 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 170 King St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 20 | Permit No. 49304 | 6015067.98121 | 2111507.0743 | 37.7786426202078 | -122.391426270004 | (37.7786426202078, -122.391426270004) | ||
| 165043 | 165043 | 84749 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 170 King St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 21 | Permit No. 49304 | 6015056.82948 | 2111496.40969 | 37.7786127186366 | -122.391464102698 | (37.7786127186366, -122.391464102698) | ||
| 97601 | 97601 | 98960 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 401 Grove St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6005778.2 | 2111279.0 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | |||||
| 113128 | 113128 | 98959 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 401 Grove St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6005778.2 | 2111279.0 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | |||||
| 87968 | 87968 | 116597 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 800x SCOTT ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002075.0 | 2111247.0 | 37.777198820389295 | -122.436355315705 | (37.7771988203893, -122.436355315705) | ||||
| 124601 | 124601 | 116596 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 800x SCOTT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002075.0 | 2111247.0 | 37.777198820389295 | -122.436355315705 | (37.7771988203893, -122.436355315705) |
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");