Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20654 | 20654 | 49903 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1686 15th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/02/2003 12:00:00 AM | Permit Number 46673 | 6006217.29915575 | 2107312.14837083 | 37.7666291551697 | -122.42174620348499 | (37.7666291551697, -122.421746203485) | ||
| 20868 | 20868 | 114568 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 621 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/2015 12:00:00 AM | 6010507.2 | 2116333.9 | 37.79164175144621 | -122.407544247145 | (37.7916417514462, -122.407544247145) | ||||
| 21202 | 21202 | 117236 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 635 GROVE ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004711.0 | 2111132.0 | 37.777032483526895 | -122.427228354699 | (37.7770324835269, -122.427228354699) | ||||
| 30541 | 30541 | 103924 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X The Embarcadero | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/30/1995 12:00:00 AM | 4x4 | 6013544.1 | 2119061.0 | 37.7992992444467 | -122.397227842585 | (37.7992992444467, -122.397227842585) | |||
| 38342 | 38342 | 113370 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 88 HOWARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014757.0 | 2116474.0 | 37.7922633974731 | -122.39284966575 | (37.7922633974731, -122.39284966575) | ||||
| 42744 | 42744 | 113684 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X THE EMBARCADERO | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6013440.0 | 2119057.0 | 37.7992824654164 | -122.3975877866 | (37.7992824654164, -122.3975877866) | ||||
| 43168 | 43168 | 49023 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 199 01st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/2003 12:00:00 AM | Permit Number 46205 | 6013823.58160426 | 2115158.37921296 | 37.788599120029396 | -122.39598709957701 | (37.7885991200294, -122.395987099577) | |||
| 44082 | 44082 | 41480 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2390 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 42055 | 6007082.30805796 | 2120481.73008774 | 37.8028383512958 | -122.41968879786002 | (37.8028383512958, -122.41968879786) | ||||
| 49230 | 49230 | 46118 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 Folsom St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2001 12:00:00 AM | Permit Number 44476 | 6015543.8 | 2115940.8 | 37.7908430231508 | -122.390090033136 | (37.7908430231508, -122.390090033136) | |||
| 50157 | 50157 | 104797 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 342 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014205.7 | 2115535.6 | 37.7896561328511 | -122.39469144446801 | (37.7896561328511, -122.394691444468) | ||||
| 51321 | 51321 | 115599 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 699 02nd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6015347.857021701 | 2112248.60687265 | 37.7806942317989 | -122.390509891446 | (37.7806942317989, -122.390509891446) | |||
| 51510 | 51510 | 113673 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X THE EMBARCADERO | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6013440.0 | 2119057.0 | 37.7992824654164 | -122.3975877866 | (37.7992824654164, -122.3975877866) | ||||
| 53188 | 53188 | 49505 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 702@ INNES Phelps St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/2003 12:00:00 AM | Permit Number 46416 | 6015133.81699265 | 2097838.73838627 | 37.7411159643244 | -122.39024332946 | (37.7411159643244, -122.39024332946) | |||
| 61496 | 61496 | 52410 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1337 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2006 12:00:00 AM | 3x3 | Permit Number 48529 | 6007932.42258608 | 2116165.68067346 | 37.79103540399161 | -122.416441058577 | (37.7910354039916, -122.416441058577) | ||
| 64069 | 64069 | 33687 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 610 Ivy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | 2x3 | Permit Number 37763 | 6004420.66783798 | 2111040.26799248 | 37.776764186768105 | -122.428226164884 | (37.7767641867681, -122.428226164884) | ||
| 64869 | 64869 | 33267 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | Permit Number 37441 | 6009551.65503934 | 2116448.08509162 | 37.7919017434497 | -122.41085850563101 | (37.7919017434497, -122.410858505631) | ||
| 66028 | 66028 | 30535 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1020 Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1995 12:00:00 AM | Permit Number 34535 | 6011195.92412392 | 2110919.1949505 | 37.776812772940005 | -122.404779881684 | (37.77681277294, -122.404779881684) | |||
| 66648 | 66648 | 31947 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2002 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1995 12:00:00 AM | Permit Number 35358 | 6003915.74450462 | 2115298.16977388 | 37.7884267396179 | -122.43027669406 | (37.7884267396179, -122.43027669406) | |||
| 69883 | 69883 | 114317 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1X 09TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2015 12:00:00 AM | 3x3 | Permit Number 776579 | 6008059.0 | 2111315.0 | 37.77772372592089 | -122.41565950833 | (37.7777237259209, -122.41565950833) | ||
| 72579 | 72579 | 116801 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2120 BROADWAY | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003325.0 | 2117599.0 | 37.7947107530845 | -122.432484978634 | (37.7947107530845, -122.432484978634) | ||||
| 74400 | 74400 | 105470 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 833 Jamestown Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2014 12:00:00 AM | 3x3 | Permit Number 772170 | 6014874.7 | 2088927.9 | 37.7166342161119 | -122.390516776389 | (37.7166342161119, -122.390516776389) | ||
| 76349 | 76349 | 113681 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X THE EMBARCADERO | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6013440.0 | 2119057.0 | 37.7992824654164 | -122.3975877866 | (37.7992824654164, -122.3975877866) | ||||
| 76352 | 76352 | 108427 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 270X HAYES ST | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006095.6 | 2111028.7 | 37.776827051685295 | -122.422431244298 | (37.7768270516853, -122.422431244298) | ||||
| 77350 | 77350 | 67790 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 4032 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1992 12:00:00 AM | Permit Number 31432 | 6003633.68639817 | 2101305.49997493 | 37.749990296647894 | -122.43025389067199 | (37.7499902966479, -122.430253890672) | ||
| 77378 | 77378 | 113565 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X King St | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6014268.596778099 | 2110706.0699128 | 37.776398843196894 | -122.394135578218 | (37.7763988431969, -122.394135578218) | |||||
| 77398 | 77398 | 106965 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 63 BELLE AVE | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5991753.8 | 2086471.1 | 37.7085786821221 | -122.47025464516001 | (37.7085786821221, -122.47025464516) | ||||||
| 77473 | 77473 | 60330 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 4166 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1982 12:00:00 AM | Permit Number 19902 | 6002608.00205956 | 2104170.96535693 | 37.7578000327261 | -122.434005560815 | (37.7578000327261, -122.434005560815) | ||
| 77843 | 77843 | 98421 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1501X Steiner St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | Permit Number 768629 | 6002677.2 | 2113386.1 | 37.7831064505465 | -122.43442509431299 | (37.7831064505465, -122.434425094313) | |||
| 77899 | 77899 | 105477 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 833 Jamestown Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2014 12:00:00 AM | 3x3 | Permit Number 772170 | 6014874.7 | 2088927.9 | 37.7166342161119 | -122.390516776389 | (37.7166342161119, -122.390516776389) | ||
| 77936 | 77936 | 73302 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 900x Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/24/1999 12:00:00 AM | 5x5 | 6001563.0 | 2111524.0 | 37.7779302874148 | -122.438146331007 | (37.7779302874148, -122.438146331007) | |||
| 77947 | 77947 | 117234 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 635 GROVE ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004711.0 | 2111132.0 | 37.777032483526895 | -122.427228354699 | (37.7770324835269, -122.427228354699) | ||||
| 77989 | 77989 | 116974 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 121 SPEAR ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014757.0 | 2116474.0 | 37.7922633974731 | -122.39284966575 | (37.7922633974731, -122.39284966575) | ||||
| 78003 | 78003 | 107872 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 830X Harrison St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x3 | 6012494.965419999 | 2112152.38808 | 37.7802713603069 | -122.400372718325 | (37.7802713603069, -122.400372718325) | ||||
| 78032 | 78032 | 108123 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1901 FOLSOM ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008051.0 | 2107091.0 | 37.7661251677687 | -122.415388074018 | (37.7661251677687, -122.415388074018) | ||||
| 78045 | 78045 | 51743 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/27/2005 12:00:00 AM | Permit Number 48019 | 6014845.30588734 | 2117033.03281922 | 37.79380327609871 | -122.392583245697 | (37.7938032760987, -122.392583245697) | |||
| 78139 | 78139 | 117240 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 635 GROVE ST | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004711.0 | 2111132.0 | 37.777032483526895 | -122.427228354699 | (37.7770324835269, -122.427228354699) | ||||
| 78228 | 78228 | 40596 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1745 Alameda St | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1999 12:00:00 AM | Permit Number 41614 | 6011825.33105533 | 2107918.51147284 | 37.7686087407967 | -122.402391521525 | (37.7686087407967, -122.402391521525) | ||
| 78336 | 78336 | 92742 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1680 Eddy St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/22/2009 12:00:00 AM | 3x3 | Permit Number 52927 | 6002403.9 | 2112682.2 | 37.7811582017665 | -122.435320233246 | (37.7811582017665, -122.435320233246) | ||
| 78369 | 78369 | 117237 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 635 GROVE ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004711.0 | 2111132.0 | 37.777032483526895 | -122.427228354699 | (37.7770324835269, -122.427228354699) | ||||
| 78387 | 78387 | 46124 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2001 12:00:00 AM | Permit Number 44476 | 6015543.8 | 2115940.8 | 37.7908430231508 | -122.390090033136 | (37.7908430231508, -122.390090033136) | |||
| 78393 | 78393 | 55169 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 955 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/07/1981 12:00:00 AM | Permit Number 11075 | 6003156.510606 | 2102681.79205166 | 37.7537422304515 | -122.432002254548 | (37.7537422304515, -122.432002254548) | ||
| 78399 | 78399 | 112719 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 455 BAY ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008645.0 | 2121254.0 | 37.805046714355505 | -122.414335738873 | (37.8050467143555, -122.414335738873) | ||||
| 78618 | 78618 | 49506 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 702@ INNES Phelps St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/2003 12:00:00 AM | Permit Number 46416 | 6015133.81699265 | 2097838.73838627 | 37.7411159643244 | -122.39024332946 | (37.7411159643244, -122.39024332946) | |||
| 78719 | 78719 | 109939 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 798x SHOTWELL ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007932.0 | 2103563.0 | 37.7564314044236 | -122.415549866582 | (37.7564314044236, -122.415549866582) | ||||
| 78731 | 78731 | 34925 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2025 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 38518 | 6005978.74277339 | 2117331.2147487 | 37.7941256085394 | -122.423283615739 | (37.7941256085394, -122.423283615739) | ||||
| 78734 | 78734 | 51729 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1269 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2005 12:00:00 AM | Permit Number 48011 | 6007711.04793017 | 2102275.87642509 | 37.7528848342508 | -122.41622284153999 | (37.7528848342508, -122.41622284154) | |||
| 79084 | 79084 | 54607 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 824 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/20/1972 12:00:00 AM | Permit Number 10430 | 6001738.60489423 | 2108759.15636023 | 37.770348703510706 | -122.437340825094 | (37.7703487035107, -122.437340825094) | |||
| 79130 | 79130 | 122733 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3203 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6008384.0 | 2100540.0 | 37.7481563241105 | -122.41377286403 | (37.7481563241105, -122.41377286403) | ||||
| 79207 | 79207 | 33520 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 156 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2002 12:00:00 AM | Permit Number 45090 | 6007339.22789751 | 2098166.57654537 | 37.741580707379796 | -122.417217500399 | (37.7415807073798, -122.417217500399) | ||
| 79453 | 79453 | 107874 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 830X Harrison St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x3 | 6012494.965419999 | 2112152.38808 | 37.7802713603069 | -122.400372718325 | (37.7802713603069, -122.400372718325) | ||||
| 79692 | 79692 | 110794 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 900 CALIFORNIA ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009776.0 | 2116634.0 | 37.7924247975925 | -122.410095399183 | (37.7924247975925, -122.410095399183) | ||||
| 79694 | 79694 | 107976 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2750 JACKSON ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001096.4 | 2116670.4 | 37.7920344322485 | -122.440129594684 | (37.7920344322485, -122.440129594684) | ||||
| 79700 | 79700 | 112674 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 500x FILBERT ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010481.0 | 2120003.0 | 37.8017147408613 | -122.407893747059 | (37.8017147408613, -122.407893747059) | ||||
| 79804 | 79804 | 33888 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/1997 12:00:00 AM | Permit Number 37864 | 6012794.22809133 | 2116196.61186458 | 37.79139254050121 | -122.399621455512 | (37.7913925405012, -122.399621455512) | |||
| 79953 | 79953 | 32787 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1661 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37153 | 5999823.76126907 | 2110867.52212558 | 37.7760286983996 | -122.444115767373 | (37.7760286983996, -122.444115767373) | ||
| 80083 | 80083 | 108131 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1901 FOLSOM ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008051.0 | 2107091.0 | 37.7661251677687 | -122.415388074018 | (37.7661251677687, -122.415388074018) | ||||
| 80184 | 80184 | 85053 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 59x Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/27/2007 12:00:00 AM | Permit Number 49392 | 6008980.9 | 2122342.3 | 37.808053775378795 | -122.413250320783 | (37.8080537753788, -122.413250320783) | |||
| 80185 | 80185 | 30706 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 21 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | Permit Number 34616 | 6005672.1323567005 | 2109287.22209736 | 37.772021477067 | -122.423772292692 | (37.772021477067, -122.423772292692) | ||
| 80237 | 80237 | 113567 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X King St | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6014268.596778099 | 2110706.0699128 | 37.776398843196894 | -122.394135578218 | (37.7763988431969, -122.394135578218) | |||||
| 80295 | 80295 | 94433 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 726 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5998579.0 | 2108104.0 | 37.7683696837618 | -122.448222667379 | (37.7683696837618, -122.448222667379) | |||||
| 80417 | 80417 | 116617 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 345 CHURCH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004348.0 | 2106967.0 | 37.7655758708781 | -122.428187185753 | (37.7655758708781, -122.428187185753) | ||||
| 80421 | 80421 | 31535 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1394 San Bruno Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | Permit Number 35086 | 6011138.71993424 | 2101856.99163788 | 37.751926809144294 | -122.404339766926 | (37.7519268091443, -122.404339766926) | ||
| 80473 | 80473 | 96517 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1975 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6002736.0 | 2114050.0 | 37.7849326895546 | -122.434269149206 | (37.7849326895546, -122.434269149206) | ||||
| 80483 | 80483 | 31534 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1394 San Bruno Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | Permit Number 35086 | 6011138.71993424 | 2101856.99163788 | 37.751926809144294 | -122.404339766926 | (37.7519268091443, -122.404339766926) | ||
| 80509 | 80509 | 110645 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200x DRUMM ST | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 6013666.0 | 2117675.0 | 37.7955004026749 | -122.396708806749 | (37.7955004026749, -122.396708806749) | |||||
| 80517 | 80517 | 35932 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 150 Appleton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/1998 12:00:00 AM | Permit Number 39098 | 6006020.23705366 | 2096832.81834876 | 37.7378442132608 | -122.421683420307 | (37.7378442132608, -122.421683420307) | |||
| 80519 | 80519 | 103071 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 255 Broadway | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6012256.1 | 2118721.6 | 37.7982955442476 | -122.401660929382 | (37.7982955442476, -122.401660929382) | ||||
| 80670 | 80670 | 117233 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 635 GROVE ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004711.0 | 2111132.0 | 37.777032483526895 | -122.427228354699 | (37.7770324835269, -122.427228354699) | ||||
| 80791 | 80791 | 45205 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 600-698X Bowdoin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46769 | 6008896.51323802 | 2093167.07646195 | 37.7279406478975 | -122.411479785884 | (37.7279406478975, -122.411479785884) | ||
| 80986 | 80986 | 121409 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1661 15th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006340.0 | 2107214.0 | 37.7663665814797 | -122.42131483132 | (37.7663665814797, -122.42131483132) | ||||
| 81010 | 81010 | 34857 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 38478 | 6007910.36416897 | 2111288.85125958 | 37.777643571368706 | -122.41617183970699 | (37.7776435713687, -122.416171839707) | |||||
| 81037 | 81037 | 101512 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 240X DRUMM ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6013870.0 | 2117910.0 | 37.796157009088 | -122.396019403228 | (37.796157009088, -122.396019403228) | ||||
| 81050 | 81050 | 40589 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1745 Alameda St | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1999 12:00:00 AM | Permit Number 41614 | 6011825.33105533 | 2107918.51147284 | 37.7686087407967 | -122.402391521525 | (37.7686087407967, -122.402391521525) | ||
| 81187 | 81187 | 121020 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1653 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005036.0 | 2119492.0 | 37.8000053242339 | -122.42669955493601 | (37.8000053242339, -122.426699554936) | ||||
| 81219 | 81219 | 117257 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1570 31ST AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 5986686.8 | 2104596.0 | 37.7580506528461 | -122.489098201432 | (37.7580506528461, -122.489098201432) | |||||
| 81250 | 81250 | 50711 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1355 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/2004 12:00:00 AM | Permit Number 47267 | 6007708.33589503 | 2111017.51574242 | 37.7768871872259 | -122.4168514975 | (37.7768871872259, -122.4168514975) | |||
| 81304 | 81304 | 121687 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1653 Grant Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010440.0 | 2120221.0 | 37.802311019742206 | -122.408051009419 | (37.8023110197422, -122.408051009419) | ||||
| 81474 | 81474 | 111053 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2059X MARKET ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6004434.0 | 2107851.0 | 37.76800798766929 | -122.427952728751 | (37.7680079876693, -122.427952728751) | ||||
| 81594 | 81594 | 108137 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 727 VALENCIA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x6 | 6006292.3 | 2105317.6 | 37.761156823902 | -122.42134513249701 | (37.761156823902, -122.421345132497) | ||||
| 81625 | 81625 | 41455 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2238 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/31/2000 12:00:00 AM | Permit Number 42045 | 6001025.06662099 | 2113514.63784374 | 37.7833654634469 | -122.44015001084298 | (37.7833654634469, -122.440150010843) | |||
| 81691 | 81691 | 49221 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 500 Howard St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.39615519799999 | (37.7885414925604, -122.396155198) | |||
| 81727 | 81727 | 113376 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 88 HOWARD ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014757.0 | 2116474.0 | 37.7922633974731 | -122.39284966575 | (37.7922633974731, -122.39284966575) | ||||
| 81777 | 81777 | 122693 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2500X Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001760.0 | 2117029.0 | 37.7930568116395 | -122.43785923271999 | (37.7930568116395, -122.43785923272) | ||||
| 81884 | 81884 | 46550 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1849 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/2002 12:00:00 AM | Permit Number 44693 | 6003062.93164857 | 2113741.50977388 | 37.7841042040776 | -122.43311602268801 | (37.7841042040776, -122.433116022688) | |||
| 81945 | 81945 | 98430 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401X Steiner St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6002724.9 | 2113044.1 | 37.782170112299795 | -122.434235614198 | (37.7821701122998, -122.434235614198) | ||||
| 82091 | 82091 | 107974 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2750 JACKSON ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001096.4 | 2116670.4 | 37.7920344322485 | -122.440129594684 | (37.7920344322485, -122.440129594684) | ||||
| 82152 | 82152 | 122825 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 201x Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9x6 | 6012272.0 | 2118721.0 | 37.7982947840288 | -122.401605868068 | (37.7982947840288, -122.401605868068) | ||||
| 82230 | 82230 | 117232 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 635 GROVE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004711.0 | 2111132.0 | 37.777032483526895 | -122.427228354699 | (37.7770324835269, -122.427228354699) | ||||
| 82282 | 82282 | 121367 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3359 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006712.0 | 2101966.0 | 37.7519777578384 | -122.41965575839501 | (37.7519777578384, -122.419655758395) | ||||
| 82376 | 82376 | 33268 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000 California St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | Permit Number 37441 | 6009551.65503934 | 2116448.08509162 | 37.7919017434497 | -122.41085850563101 | (37.7919017434497, -122.410858505631) | ||
| 82467 | 82467 | 46420 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 530 Chestnut St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2002 12:00:00 AM | Permit Number 44643 | 6009285.11323863 | 2120849.80325768 | 37.803972827810995 | -122.412091961384 | (37.803972827811, -122.412091961384) | |||
| 82558 | 82558 | 35012 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1101 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/1997 12:00:00 AM | 3x3 | Permit Number 38583 | 6006451.02882669 | 2114219.82281186 | 37.7856091410849 | -122.421428385854 | (37.7856091410849, -122.421428385854) | ||
| 82577 | 82577 | 57712 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 655 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1987 12:00:00 AM | Permit Number 24567 | 6003077.52499171 | 2110495.81975272 | 37.775193178371296 | -122.43283358882 | (37.7751931783713, -122.43283358882) | ||
| 82645 | 82645 | 41436 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3490 California St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/31/2000 12:00:00 AM | Permit Number 42041 | 5997743.085699201 | 2114801.91682509 | 37.7867125977658 | -122.451597198841 | (37.7867125977658, -122.451597198841) | |||
| 82658 | 82658 | 50709 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1355 Market St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/2004 12:00:00 AM | Permit Number 47267 | 6007708.33589503 | 2111017.51574242 | 37.7768871872259 | -122.4168514975 | (37.7768871872259, -122.4168514975) | |||
| 82803 | 82803 | 102580 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2X Drumm St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/12/2013 12:00:00 AM | Permit Number 769964 | 6013786.1 | 2116863.1 | 37.7932777999137 | -122.396236306259 | (37.7932777999137, -122.396236306259) | |||
| 82834 | 82834 | 107870 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 830X Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x3 | 6012494.965419999 | 2112152.38808 | 37.7802713603069 | -122.400372718325 | (37.7802713603069, -122.400372718325) | ||||
| 82862 | 82862 | 113568 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X King St | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6014268.596778099 | 2110706.0699128 | 37.776398843196894 | -122.394135578218 | (37.7763988431969, -122.394135578218) | |||||
| 82880 | 82880 | 112265 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 201X WALNUT ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 5998535.0 | 2115724.0 | 37.7892897137264 | -122.448923821633 | (37.7892897137264, -122.448923821633) | |||
| 82953 | 82953 | 60331 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 4175 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1982 12:00:00 AM | 3x3 | Permit Number 19903 | 6002568.73005013 | 2104116.70638175 | 37.7576488217943 | -122.434137500842 | (37.7576488217943, -122.434137500842) |
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");