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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3168 | 3168 | 33093 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 4009 | 4009 | 34002 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 37940 | ||||||||||
| 4171 | 4171 | 39901 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/2002 12:00:00 AM | Permit Number 41185 | |||||||||
| 5912 | 5912 | 35691 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 6766 | 6766 | 33092 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 7580 | 7580 | 33091 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 7627 | 7627 | 33085 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 7750 | 7750 | 33087 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 8822 | 8822 | 36564 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1998 12:00:00 AM | Permit Number 39428 | |||||||||
| 10191 | 10191 | 35689 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 10366 | 10366 | 46719 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44843 | |||||||||
| 10578 | 10578 | 39903 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/2002 12:00:00 AM | Permit Number 41185 | |||||||||
| 10962 | 10962 | 33089 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 11036 | 11036 | 36559 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1998 12:00:00 AM | Permit Number 39428 | |||||||||
| 11116 | 11116 | 34003 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 37940 | ||||||||||
| 12200 | 12200 | 46197 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 12311 | 12311 | 39902 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/2002 12:00:00 AM | Permit Number 41185 | |||||||||
| 12475 | 12475 | 36562 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1998 12:00:00 AM | Permit Number 39428 | |||||||||
| 13380 | 13380 | 36560 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1998 12:00:00 AM | Permit Number 39428 | |||||||||
| 13386 | 13386 | 46196 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 13673 | 13673 | 33088 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 14741 | 14741 | 33082 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 14773 | 14773 | 46721 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44843 | |||||||||
| 15188 | 15188 | 34004 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 37940 | ||||||||||
| 15368 | 15368 | 33086 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 15698 | 15698 | 46198 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 15858 | 15858 | 33090 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 16147 | 16147 | 36565 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1998 12:00:00 AM | Permit Number 39428 | |||||||||
| 16437 | 16437 | 36563 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1998 12:00:00 AM | Permit Number 39428 | |||||||||
| 16615 | 16615 | 46720 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44843 | |||||||||
| 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) | |||||
| 86858 | 86858 | 34858 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 38478 | 6007910.36416897 | 2111288.85125958 | 37.777643571368706 | -122.41617183970699 | (37.7776435713687, -122.416171839707) | |||||
| 89396 | 89396 | 34859 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 38478 | 6007910.36416897 | 2111288.85125958 | 37.777643571368706 | -122.41617183970699 | (37.7776435713687, -122.416171839707) | |||||
| 90532 | 90532 | 34860 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 38478 | 6007910.36416897 | 2111288.85125958 | 37.777643571368706 | -122.41617183970699 | (37.7776435713687, -122.416171839707) | |||||
| 103571 | 103571 | 34855 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 38478 | 6007910.36416897 | 2111288.85125958 | 37.777643571368706 | -122.41617183970699 | (37.7776435713687, -122.416171839707) | |||||
| 113996 | 113996 | 34861 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 38478 | 6007910.36416897 | 2111288.85125958 | 37.777643571368706 | -122.41617183970699 | (37.7776435713687, -122.416171839707) | |||||
| 127906 | 127906 | 34856 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 38478 | 6007910.36416897 | 2111288.85125958 | 37.777643571368706 | -122.41617183970699 | (37.7776435713687, -122.416171839707) | |||||
| 164325 | 164325 | 52073 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 10 Normandie Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2005 12:00:00 AM | 5 | Permit Number 48268 | 6000955.032430001 | 2117341.04068 | 37.793867787207496 | -122.4406668518 | (37.7938677872075, -122.4406668518) | ||
| 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) | |||
| 90540 | 90540 | 33876 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Bush St | 5 | 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) | |||
| 92338 | 92338 | 33877 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Bush St | 6 | 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) | |||
| 140035 | 140035 | 33879 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Bush St | 8 | 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) | |||
| 142075 | 142075 | 33884 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Bush St | 3 | 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) | |||
| 143203 | 143203 | 33875 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Bush St | 4 | 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) | |||
| 47992 | 47992 | 27910 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015913.96301 | 2112493.47301 | 37.7813979677469 | -122.38856853840599 | (37.7813979677469, -122.388568538406) | ||
| 75154 | 75154 | 27919 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015840.17801 | 2112278.62901 | 37.7808039650097 | -122.38880879774099 | (37.7808039650097, -122.388808797741) | ||
| 80016 | 80016 | 27916 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015873.81501 | 2112343.7330099996 | 37.780984590279104 | -122.388696976059 | (37.7809845902791, -122.388696976059) | ||
| 81408 | 81408 | 27915 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015885.75101 | 2112369.77501 | 37.7810567572813 | -122.38865750159401 | (37.7810567572813, -122.388657501594) | ||
| 84010 | 84010 | 27922 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015798.94501 | 2112218.95001 | 37.7806378144268 | -122.388947276171 | (37.7806378144268, -122.388947276171) | ||
| 85492 | 85492 | 27923 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015780.499009999 | 2112201.5890099998 | 37.780589122550204 | -122.38900987778901 | (37.7805891225502, -122.389009877789) | ||
| 86606 | 86606 | 27928 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015611.22801 | 2112036.65901 | 37.7801268774736 | -122.389583949745 | (37.7801268774736, -122.389583949745) | ||
| 93427 | 93427 | 27925 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015664.3970099995 | 2112091.99701 | 37.7802817711748 | -122.38940387795401 | (37.7802817711748, -122.389403877954) | ||
| 96010 | 96010 | 27926 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015645.95101 | 2112072.4660099996 | 37.7802271207192 | -122.38946632738501 | (37.7802271207192, -122.389466327385) | ||
| 99026 | 99026 | 27918 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015851.02901 | 2112300.33101 | 37.7808641552493 | -122.388772773994 | (37.7808641552493, -122.388772773994) | ||
| 103527 | 103527 | 27912 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015910.70801 | 2112444.6450099996 | 37.781263716620394 | -122.388576389848 | (37.7812637166204, -122.388576389848) | ||
| 108615 | 108615 | 27911 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015911.79301 | 2112468.51601 | 37.781329321163504 | -122.38857430301701 | (37.7813293211635, -122.388574303017) | ||
| 113469 | 113469 | 27917 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015864.050009999 | 2112323.1170099997 | 37.780927442165705 | -122.38872931872 | (37.7809274421657, -122.38872931872) | ||
| 114113 | 114113 | 27908 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015917.21801 | 2112547.72601 | 37.781547114702896 | -122.38856106572901 | (37.7815471147029, -122.388561065729) | ||
| 115907 | 115907 | 27907 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015923.72801 | 2112571.59801 | 37.7816130226275 | -122.388540210862 | (37.7816130226275, -122.388540210862) | ||
| 117247 | 117247 | 27909 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015913.96301 | 2112518.42901 | 37.781466491326604 | -122.388570280932 | (37.7814664913266, -122.388570280932) | ||
| 119168 | 119168 | 27914 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015893.3460099995 | 2112392.56101 | 37.7811197434466 | -122.388632817528 | (37.7811197434466, -122.388632817528) | ||
| 119191 | 119191 | 27927 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015626.41901 | 2112054.0200099996 | 37.7801753891821 | -122.38953260952299 | (37.7801753891821, -122.389532609523) | ||
| 138763 | 138763 | 27921 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015810.88101 | 2112236.31101 | 37.780686145436505 | -122.38890719588899 | (37.7806861454365, -122.388907195889) | ||
| 139701 | 139701 | 27920 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015829.32701 | 2112255.84301 | 37.7807407983373 | -122.38884474573099 | (37.7807407983373, -122.388844745731) | ||
| 141754 | 141754 | 27913 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015902.02701 | 2112416.43301 | 37.781185771703704 | -122.388604452195 | (37.7811857717037, -122.388604452195) | ||
| 142572 | 142572 | 27924 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015682.84301 | 2112108.2730099997 | 37.780327484096496 | -122.389341201064 | (37.7803274840965, -122.389341201064) | ||
| 167061 | 167061 | 41356 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Walnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/03/2000 12:00:00 AM | 15 | Permit Number 42006 | 5998501.11002 | 2116122.08079 | 37.7903807999818 | -122.44906976535201 | (37.7903807999818, -122.449069765352) | |
| 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) | ||
| 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) | ||
| 90043 | 90043 | 33272 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000 California St | 3 | 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) | ||
| 93520 | 93520 | 33271 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000 California St | 2 | 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) | ||
| 125379 | 125379 | 33269 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000 California St | 5 | 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) | ||
| 143952 | 143952 | 33270 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000 California St | 4 | 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) | ||
| 163627 | 163627 | 33266 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000 California St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | 16 | Permit Number 37441 | 6009282.50963 | 2116419.10375 | 37.791807072592604 | -122.411787704436 | (37.7918070725926, -122.411787704436) | |
| 54363 | 54363 | 58697 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/15/2009 12:00:00 AM | 10 | 3x3 | Permit Number 52998 | 6007529.4322 | 2120255.65018 | 37.802242769642504 | -122.418125477804 | (37.8022427696425, -122.418125477804) | |
| 1721 | 1721 | 23308 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/1998 12:00:00 AM | 5 | 3X3 | 6006538.20918 | 2114040.94612 | 37.785122904641796 | -122.42111406077 | (37.7851229046418, -122.42111406077) | ||
| 125145 | 125145 | 23309 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000 Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/1998 12:00:00 AM | 5 | 3X3 | 6006855.2495099995 | 2114052.14393 | 37.7851715184224 | -122.42001799302 | (37.7851715184224, -122.42001799302) | ||
| 3891 | 3891 | 2801 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000X California St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 6009324.7749 | 2116423.80567 | 37.791822353872796 | -122.411641798449 | (37.7918223538728, -122.411641798449) | |||
| 5662 | 5662 | 2799 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000X California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6009392.24103 | 2116434.8412200003 | 37.7918564390776 | -122.411409144728 | (37.7918564390776, -122.411409144728) | |||
| 6638 | 6638 | 2796 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6009497.37807 | 2116449.99792 | 37.7919039520553 | -122.411046440041 | (37.7919039520553, -122.411046440041) | |||
| 6728 | 6728 | 2800 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000X California St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6009359.64856 | 2116429.6762900003 | 37.7918404293366 | -122.411521550081 | (37.7918404293366, -122.411521550081) | |||
| 7030 | 7030 | 2797 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6009460.44317 | 2116444.9215599997 | 37.7918879423249 | -122.411173876682 | (37.7918879423249, -122.411173876682) | |||
| 7783 | 7783 | 2798 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000X California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6009428.97581 | 2116439.3572400003 | 37.7918708992813 | -122.411282361009 | (37.7918708992813, -122.411282361009) | |||
| 22505 | 22505 | 23316 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1001 Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4X4 | 6006454.3314 | 2113960.7762 | 37.7848980489542 | -122.421398556818 | (37.7848980489542, -122.421398556818) | |||
| 22793 | 22793 | 23313 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1001 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4X4 | 6006442.7446 | 2114038.37158 | 37.785110453523295 | -122.421444156045 | (37.7851104535233, -122.421444156045) | |||
| 90509 | 90509 | 27352 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1001 Van Ness Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4X4 | 6006432.1210900005 | 2113993.39897 | 37.7849863708004 | -122.421477715093 | (37.7849863708004, -122.421477715093) | |||
| 2491 | 2491 | 235511 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1002 Clayton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/1982 12:00:00 AM | 25 | Width 4ft | Permit Number 20185 | 5998857.80295 | 2106434.63527 | 37.7638019637156 | -122.4471381628 | (37.7638019637156, -122.4471381628) | |
| 13260 | 13260 | 60572 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1002 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/1982 12:00:00 AM | Permit Number 20185 | 5998848.38048099 | 2106535.44717902 | 37.7640782295423 | -122.44717800789302 | (37.7640782295423, -122.447178007893) | |||
| 5779 | 5779 | 24620 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1008 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6001476.3994 | 2111883.9213 | 37.7789136147751 | -122.43847170626499 | (37.7789136147751, -122.438471706265) | |||
| 6909 | 6909 | 24621 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1008 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/21/1997 12:00:00 AM | 3 | 3X3 | 6001472.5955 | 2111901.4195 | 37.778961444031296 | -122.43848611948299 | (37.7789614440313, -122.438486119483) | ||
| 7641 | 7641 | 24622 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1008 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6001471.5811 | 2111916.8889 | 37.7790038613884 | -122.43849073733699 | (37.7790038613884, -122.438490737337) | |||
| 97494 | 97494 | 95164 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1008 Divisadero St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2014 12:00:00 AM | 5 | 3x3 | 6001495.55157 | 2111906.6866099997 | 37.778977211955294 | -122.43840708286501 | (37.7789772119553, -122.438407082865) | ||
| 180 | 180 | 18700 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100X Richardson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5999457.6873699995 | 2119517.78462 | 37.799759164102895 | -122.44600442526199 | (37.7997591641029, -122.446004425262) | |||
| 87476 | 87476 | 18699 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100X Richardson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2006 12:00:00 AM | 3 | 2X3 | 5999492.39608 | 2119457.52134 | 37.7995956791821 | -122.445879984184 | (37.7995956791821, -122.445879984184) | ||
| 184503 | 184503 | 40226 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 101 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1999 12:00:00 AM | 24 | Permit Number 41410 | 6014364.45427 | 2112502.79122 | 37.7813375610326 | -122.39392977934799 | (37.7813375610326, -122.393929779348) | |
| 175590 | 175590 | 64396 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 101 Spear St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/1988 12:00:00 AM | 9 | Permit Number 25238 | 6014825.71904 | 2116189.42708 | 37.7914858428567 | -122.392591979359 | (37.7914858428567, -122.392591979359) | ||
| 98804 | 98804 | 51672 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1010 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/11/2005 12:00:00 AM | Permit Number 47951 | 6005673.1639935 | 2113141.53894822 | 37.782604551431206 | -122.42404286741501 | (37.7826045514312, -122.424042867415) | ||
| 5488 | 5488 | 5869 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1010X Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005558.007 | 2113111.8938 | 37.7825166508653 | -122.424439152252 | (37.7825166508653, -122.424439152252) | |||
| 160953 | 160953 | 31488 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1014 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 16 | Permit Number 35052 | 6003120.510980001 | 2102286.73127 | 37.7526554461029 | -122.43209853943 | (37.7526554461029, -122.43209853943) | |
| 8888 | 8888 | 5224 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1019 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/1999 12:00:00 AM | 3 | 3X3 | 6001400.3204 | 2111938.9518 | 37.7790603867713 | -122.438738837647 | (37.7790603867713, -122.438738837647) |
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");