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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17162 | 17162 | 25069 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1000X Dolores St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005114.64614 | 2102050.12648 | 37.752118640770995 | -122.42518562892599 | (37.752118640771, -122.425185628926) | |||
| 17966 | 17966 | 25063 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1000X Dolores St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005101.20924 | 2102268.05958 | 37.7527162753581 | -122.42524760211501 | (37.7527162753581, -122.425247602115) | |||
| 18812 | 18812 | 25066 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1000X Dolores St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005105.419480001 | 2102158.55982 | 37.7524158523077 | -122.425225251269 | (37.7524158523077, -122.425225251269) | |||
| 21785 | 21785 | 25131 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1600X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005285.7039 | 2098966.45887 | 37.74366125975121 | -122.42437477586901 | (37.7436612597512, -122.424374775869) | |||
| 21999 | 21999 | 25056 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 900X Dolores St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005074.95095 | 2102753.03228 | 37.7540464140318 | -122.42537291722999 | (37.7540464140318, -122.42537291723) | |||
| 11231 | 11231 | 16408 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1186X Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 42 | TR | 6001104.60764 | 2087178.31507 | 37.7110567247495 | -122.43798776335 | (37.7110567247495, -122.43798776335) | |||
| 17262 | 17262 | 25065 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1000X Dolores St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 20 | 6005108.04672 | 2102186.2977 | 37.7524921625065 | -122.42521813940901 | (37.7524921625065, -122.425218139409) | |||
| 18277 | 18277 | 25059 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1000X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 20 | 6005094.91106 | 2102418.8508099997 | 37.7531299572042 | -122.425280111693 | (37.7531299572042, -122.425280111693) | |||
| 20590 | 20590 | 25105 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1400X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 20 | 6005226.29827 | 2100039.91633 | 37.7466053739367 | -122.424656532567 | (37.7466053739367, -122.424656532567) | |||
| 20631 | 20631 | 25060 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1000X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 20 | 6005096.113419999 | 2102391.61943 | 37.7530552540956 | -122.425274016077 | (37.7530552540956, -122.425274016077) | |||
| 11503 | 11503 | 27099 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 681 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 2X2 | 6005896.77811 | 2093584.4181099997 | 37.7289178631699 | -122.421879597869 | (37.7289178631699, -122.421879597869) | |||
| 18428 | 18428 | 25049 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 900X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/20/1999 12:00:00 AM | 30 | 20 | 6005065.417330001 | 2102966.79857 | 37.7546328277698 | -122.425421098419 | (37.7546328277698, -122.425421098419) | ||
| 19141 | 19141 | 25104 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1400X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 20 | 6005230.71957 | 2100053.05302 | 37.7466416939779 | -122.424642178499 | (37.7466416939779, -122.424642178499) | |||
| 19386 | 19386 | 25103 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1400X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 20 | 6005223.79386 | 2100066.14764 | 37.746677257659705 | -122.424667058263 | (37.7466772576597, -122.424667058263) | |||
| 26642 | 26642 | 27703 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1600 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2003 12:00:00 AM | 30 | 5X5 | 5995069.03366 | 2092243.1445 | 37.7246184644438 | -122.45921454824101 | (37.7246184644438, -122.459214548241) | ||
| 117906 | 117906 | 28390 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1556 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 30 | 5X5 | 5995079.29349 | 2092240.59215 | 37.7246120461485 | -122.459178896827 | (37.7246120461485, -122.459178896827) | ||
| 148382 | 148382 | 217471 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1440 Plymouth Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | Width 3ft | 5995913.41271 | 2093587.41578 | 37.728358019885505 | -122.456392814383 | (37.7283580198855, -122.456392814383) | |||
| 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) | |||
| 184709 | 184709 | 243934 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 4220 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 3ft | 6002371.598130001 | 2100644.4982 | 37.748103774890204 | -122.434570994281 | (37.7481037748902, -122.434570994281) | |||
| 27544 | 27544 | 217486 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 134 Flood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 27 | Width 10ft | 5999850.54516 | 2094099.6824900003 | 37.729989823555705 | -122.442818779256 | (37.7299898235557, -122.442818779256) | |||
| 11318 | 11318 | 27101 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 675 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | 3X3 | 6005857.71837 | 2093582.84449 | 37.7289113394736 | -122.42201451865101 | (37.7289113394736, -122.422014518651) | |||
| 73403 | 73403 | 243919 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1203 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 4ft | 6009251.77945 | 2102094.62591 | 37.752473675130794 | -122.410881883003 | (37.7524736751308, -122.410881883003) | |||
| 164681 | 164681 | 217438 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 601x Monterey Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 26 | Width 4ft | 5997647.71271 | 2094708.73187 | 37.731536298642396 | -122.45047809200399 | (37.7315362986424, -122.450478092004) | |||
| 184860 | 184860 | 181218 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 765 Delano Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | Width 10ft | 5998962.78764 | 2090178.0255900002 | 37.719171212271796 | -122.445605954547 | (37.7191712122718, -122.445605954547) | |||
| 65852 | 65852 | 243939 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 52 Levant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 2ft | 6000277.85355 | 2106550.76339 | 37.7642018571482 | -122.44223499246401 | (37.7642018571482, -122.442234992464) | |||
| 80612 | 80612 | 28634 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1001 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/03/2003 12:00:00 AM | 25 | 5X5 | 5996752.18528 | 2091690.06821 | 37.7231964704228 | -122.453356228535 | (37.7231964704228, -122.453356228535) | ||
| 149948 | 149948 | 181283 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 221 Vienna St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | 6004356.32803 | 2092093.79207 | 37.72473793927671 | -122.427098916803 | (37.7247379392767, -122.427098916803) | ||||
| 153692 | 153692 | 181286 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 675 Silver Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 2ft | 6005845.63379 | 2093583.6017 | 37.7289127370316 | -122.42205634973999 | (37.7289127370316, -122.42205634974) | |||
| 153758 | 153758 | 217429 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1113 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 3ft | 5991520.38705 | 2105187.01956 | 37.7599543762085 | -122.472424840551 | (37.7599543762085, -122.472424840551) | |||
| 164223 | 164223 | 244905 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 31 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 0ft | 6000349.4407 | 2109066.7154 | 37.7711141128681 | -122.44216801058799 | (37.7711141128681, -122.442168010588) | |||
| 166880 | 166880 | 243917 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1205 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 4ft | 6009254.00297 | 2102050.79541 | 37.7523534510568 | -122.410871098321 | (37.7523534510568, -122.410871098321) | |||
| 30281 | 30281 | 181242 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 80 Blanken Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 4ft | 6011652.37664 | 2087363.09382 | 37.7121582854612 | -122.40154488951099 | (37.7121582854612, -122.401544889511) | |||
| 33283 | 33283 | 181264 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 271 Leland Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 3ft | 6009517.64457 | 2087677.5938400002 | 37.712902490626895 | -122.40894535574499 | (37.7129024906269, -122.408945355745) | |||
| 44059 | 44059 | 199443 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 625 King St | 23 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 4ft | 6012254.773469999 | 2108757.11148 | 37.7709353106325 | -122.400965034535 | (37.7709353106325, -122.400965034535) | |||
| 51670 | 51670 | 181284 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 75 Stoneyford Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 6006132.8407 | 2093885.45886 | 37.7297577652023 | -122.421084877777 | (37.7297577652023, -122.421084877777) | ||||
| 52264 | 52264 | 243920 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1203 Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 4ft | 6009249.697790001 | 2102114.85274 | 37.7525290967575 | -122.41089051021099 | (37.7525290967575, -122.410890510211) | |||
| 75130 | 75130 | 181288 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 701 Prague St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 5ft | 6002649.9412 | 2087357.15211 | 37.7116355320158 | -122.432659488848 | (37.7116355320158, -122.432659488848) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 115989 | 115989 | 87714 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1298X Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/29/2007 12:00:00 AM | 24 | 3x3 | 5995838.896292 | 2092008.0569689998 | 37.7240172004189 | -122.456536255807 | (37.7240172004189, -122.456536255807) | ||
| 120258 | 120258 | 28637 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 955 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2003 12:00:00 AM | 24 | 5XX5 | 5996975.36021 | 2091606.08521 | 37.7229786625948 | -122.452578702244 | (37.7229786625948, -122.452578702244) | ||
| 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) | |||
| 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) | ||
| 170710 | 170710 | 247119 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2301 Castro St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 6002742.76916 | 2098847.9819 | 37.7431920249995 | -122.43315915579201 | (37.7431920249995, -122.433159155792) | ||||
| 178946 | 178946 | 243918 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1205 Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 4ft | 6009252.506630001 | 2102069.1473 | 37.752403757340005 | -122.410877568955 | (37.75240375734, -122.410877568955) | |||
| 49819 | 49819 | 49090 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 101 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Permit Number 46240 | 6005000.86531 | 2092599.96167 | 37.7261641966181 | -122.424906823795 | (37.7261641966181, -122.424906823795) | |||
| 53739 | 53739 | 107420 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 62 Naples St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 23 | 6004646.42863 | 2093164.0318599998 | 37.727692982045205 | -122.426172231973 | (37.7276929820452, -122.426172231973) | ||||
| 60293 | 60293 | 244814 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 45 Hoff St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 6ft | 6006569.6779 | 2106452.55606 | 37.7642887820295 | -122.420466362743 | (37.7642887820295, -122.420466362743) | |||
| 66563 | 66563 | 184459 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2170 45th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 23 | Width 0ft | 5982352.1644 | 2100338.7067 | 37.746107363854705 | -122.503773678611 | (37.7461073638547, -122.503773678611) | |||
| 72671 | 72671 | 217483 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 487 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 10ft | 5998873.28001 | 2094951.91453 | 37.7322740898789 | -122.44625857187599 | (37.7322740898789, -122.446258571876) | |||
| 155468 | 155468 | 217472 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 59 Hazelwood Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 23 | Width 3ft | 5996579.72389 | 2094039.2232700002 | 37.729636804572394 | -122.45412197764401 | (37.7296368045724, -122.454121977644) | |||
| 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) | |||
| 165462 | 165462 | 243940 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 52 Levant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 2ft | 6000286.216519999 | 2106527.07627 | 37.764137294817296 | -122.442204366933 | (37.7641372948173, -122.442204366933) | |||
| 165577 | 165577 | 243936 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 300 Virginia Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 23 | Width 3ft | 6006941.75615 | 2098326.05055 | 37.741996218065296 | -122.41860313204599 | (37.7419962180653, -122.418603132046) | |||
| 173091 | 173091 | 217428 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1113 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 5991492.83801 | 2105186.64815 | 37.7599517618807 | -122.47252009133601 | (37.7599517618807, -122.472520091336) | |||
| 176643 | 176643 | 181263 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 271 Leland Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 3ft | 6009475.51838 | 2087694.07697 | 37.7129453900797 | -122.40909212061199 | (37.7129453900797, -122.409092120612) | |||
| 180281 | 180281 | 202175 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 100 Kalmanovitz St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 23 | Width 2ft | 6013138.4392099995 | 2093044.77183 | 37.7278418441173 | -122.396806662905 | (37.7278418441173, -122.396806662905) | |||
| 186788 | 186788 | 203185 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 10 Arkansas St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 4ft | 6012813.13968 | 2106962.381 | 37.76603851379279 | -122.398907634804 | (37.7660385137928, -122.398907634804) | |||
| 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) | ||||
| 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) | ||
| 34652 | 34652 | 243942 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 701 Church St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | Width 3ft | 6004361.46086 | 2104388.80864 | 37.7584975338534 | -122.427956893407 | (37.7584975338534, -122.427956893407) | |||
| 38080 | 38080 | 217478 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 51 Keystone Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 5994094.09681 | 2093023.21308 | 37.7267042448879 | -122.462641314769 | (37.7267042448879, -122.462641314769) | |||
| 39492 | 39492 | 181267 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 271 Leland Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 3ft | 6009562.93662 | 2087661.4051599998 | 37.7128605768164 | -122.40878766951799 | (37.7128605768164, -122.408787669518) | |||
| 44242 | 44242 | 181222 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 578 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6002385.20268 | 2090560.3971799999 | 37.720415918045795 | -122.43380329969101 | (37.7204159180458, -122.433803299691) | |||
| 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) | |||
| 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) | ||
| 168665 | 168665 | 217474 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2007 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 5993457.007669999 | 2101818.8487299997 | 37.750818147353705 | -122.46548237740299 | (37.7508181473537, -122.465482377403) | |||
| 170196 | 170196 | 217458 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1x Minerva St | 27 | Median : Cutout 11 | Tree 1 | DPW 2 | 22 | Width 0ft | 5996270.87292 | 2089001.5829099999 | 37.7157869222056 | -122.454825868913 | (37.7157869222056, -122.454825868913) | |||
| 173828 | 173828 | 199451 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1455 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 5ft | 6015633.06498 | 2108386.39567 | 37.77010527416 | -122.389253441416 | (37.77010527416, -122.389253441416) | |||
| 181473 | 181473 | 218224 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 399 Claremont Blvd | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 22 | 5993477.431469999 | 2097858.26435 | 37.7399445640996 | -122.465124117182 | (37.7399445640996, -122.465124117182) | ||||
| 183191 | 183191 | 181262 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 271 Leland Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 3ft | 6009462.97914 | 2087698.55594 | 37.7129569859491 | -122.409135776392 | (37.7129569859491, -122.409135776392) | |||
| 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) | |||
| 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) | |||
| 23492 | 23492 | 202174 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 100 Kalmanovitz St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 2ft | 6013138.83373 | 2093054.0318599998 | 37.7278672922301 | -122.39680594795401 | (37.7278672922301, -122.396805947954) | |||
| 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) | |||
| 41272 | 41272 | 243941 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 701 Church St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | Width 3ft | 6004362.39063 | 2104350.06977 | 37.758391218686796 | -122.4279509174 | (37.7583912186868, -122.4279509174) | |||
| 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) | |||
| 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) | |||
| 59290 | 59290 | 199446 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1515 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 5ft | 6015650.90558 | 2108071.91419 | 37.7692427658814 | -122.38916976848199 | (37.7692427658814, -122.389169768482) | |||
| 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) | |||
| 77010 | 77010 | 217431 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2070 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 5993239.44153 | 2093011.60748 | 37.7266231206395 | -122.46559496444401 | (37.7266231206395, -122.465594964444) | |||
| 105609 | 105609 | 28635 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1001 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/03/2003 12:00:00 AM | 21 | 5X5 | 5996764.463409999 | 2091686.23626 | 37.723186652559 | -122.45331350914 | (37.723186652559, -122.45331350914) | ||
| 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) | |||
| 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) | |||
| 154136 | 154136 | 119374 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 866 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 5986063.1424 | 2109995.79652 | 37.7728405660437 | -122.49165253211099 | (37.7728405660437, -122.491652532111) | |||
| 156998 | 156998 | 181281 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 333 Peru Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 4ft | 6004496.25142 | 2093004.99255 | 37.727247805938795 | -122.426680076425 | (37.7272478059388, -122.426680076425) | |||
| 160884 | 160884 | 217455 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1x Minerva St | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 21 | Width 0ft | 5996102.296490001 | 2089002.27895 | 37.7157791619582 | -122.455408593627 | (37.7157791619582, -122.455408593627) | |||
| 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) | ||
| 174910 | 174910 | 181219 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 519 Lisbon St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 6ft | 6002044.02941 | 2090439.9964599998 | 37.720065958565 | -122.434974017336 | (37.720065958565, -122.434974017336) | |||
| 186914 | 186914 | 202176 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 100 Kalmanovitz St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 2ft | 6013132.98284 | 2093010.28184 | 37.7277468379346 | -122.396823108819 | (37.7277468379346, -122.396823108819) | |||
| 188996 | 188996 | 181266 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 271 Leland Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 3ft | 6009541.56007 | 2087669.1100400002 | 37.712880535479 | -122.40886209741001 | (37.712880535479, -122.40886209741) | |||
| 6773 | 6773 | 45307 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 561 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/25/2005 12:00:00 AM | 20 | 5x5 | Permit Number 44145 | 6000554.5197 | 2110946.4965 | 37.7762872030081 | -122.44159355669599 | (37.7762872030081, -122.441593556696) |
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");