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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 96480 | 96480 | 27535 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1300 Illinois St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/05/2001 12:00:00 AM | 15 | 3X3 | 6016127.146980001 | 2102787.87807 | 37.754760323366206 | -122.38715384385 | (37.7547603233662, -122.38715384385) | ||
| 107131 | 107131 | 27549 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1301X Illinois St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/05/2001 12:00:00 AM | 10 | 3X3 | 6016173.411126 | 2103023.95301 | 37.755411097271704 | -122.387010312465 | (37.7554110972717, -122.387010312465) | ||
| 102773 | 102773 | 27540 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1300 Illinois St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/24/2004 12:00:00 AM | 15 | 3X3 | 6016127.146980001 | 2102787.87807 | 37.754760323366206 | -122.38715384385 | (37.7547603233662, -122.38715384385) | ||
| 100382 | 100382 | 115402 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 218 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/29/2016 12:00:00 AM | 3 | Permit Number 776284 | 6005779.9 | 2096086.1 | 37.7357803359495 | -122.42246134044301 | (37.7357803359495, -122.422461340443) | ||
| 18001 | 18001 | 27903 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015937.152000001 | 2112771.705 | 37.78216321542121 | -122.388507741674 | (37.7821632154212, -122.388507741674) | |||
| 53184 | 53184 | 27902 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015941.319 | 2112799.309 | 37.782239240724 | -122.38849525296699 | (37.782239240724, -122.388495252967) | |||
| 75152 | 75152 | 27904 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015934.027000001 | 2112727.434 | 37.7820414840201 | -122.388515461744 | (37.7820414840201, -122.388515461744) | |||
| 77564 | 77564 | 27895 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015957.985 | 2112989.413 | 37.7827621471367 | -122.388450868666 | (37.7827621471367, -122.388450868666) | |||
| 80438 | 80438 | 27893 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015963.194 | 2113042.017 | 37.7829068745448 | -122.388436520394 | (37.7829068745448, -122.388436520394) | |||
| 83768 | 83768 | 27906 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 36 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015925.694 | 2112692.017 | 37.7819437751015 | -122.38854181744 | (37.7819437751015, -122.38854181744) | |||
| 85814 | 85814 | 27885 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015984.5479999995 | 2113289.413 | 37.7835873515787 | -122.388379916552 | (37.7835873515787, -122.388379916552) | |||
| 86833 | 86833 | 27886 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015979.339 | 2113269.621 | 37.7835327185594 | -122.388396555982 | (37.7835327185594, -122.388396555982) | |||
| 87036 | 87036 | 27900 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015944.964 | 2112842.538 | 37.7823581398375 | -122.388485661103 | (37.7823581398375, -122.388485661103) | |||
| 88547 | 88547 | 27883 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015986.631 | 2113340.455 | 37.7837276168383 | -122.388376273801 | (37.7837276168383, -122.388376273801) | |||
| 93631 | 93631 | 27878 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015996.527000001 | 2113472.746 | 37.784091406469 | -122.388351273372 | (37.784091406469, -122.388351273372) | |||
| 94674 | 94674 | 27870 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 800 The Embarcadero | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 24 | 4X4 | 6015155.50001 | 2116672.0830099997 | 37.79282941355329 | -122.391484690649 | (37.7928294135533, -122.391484690649) | ||
| 94742 | 94742 | 27897 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015953.2979999995 | 2112914.413 | 37.782555954267295 | -122.388461847258 | (37.7825559542673, -122.388461847258) | |||
| 95284 | 95284 | 27898 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015948.61 | 2112884.725 | 37.7824741779053 | -122.388475992994 | (37.7824741779053, -122.388475992994) | |||
| 97196 | 97196 | 27892 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015966.319 | 2113080.559 | 37.7830128753765 | -122.388428400104 | (37.7830128753765, -122.388428400104) | |||
| 100591 | 100591 | 27879 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015993.9229999995 | 2113447.225 | 37.784021187263896 | -122.388358500511 | (37.7840211872639, -122.388358500511) | |||
| 101348 | 101348 | 27884 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015985.589 | 2013289.4130000002 | 37.5090039879895 | -122.38142014589701 | (37.5090039879895, -122.381420145897) | |||
| 102906 | 102906 | 27894 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015959.027000001 | 2113012.85 | 37.7828265576108 | -122.388448900144 | (37.7828265576108, -122.388448900144) | |||
| 104427 | 104427 | 27901 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015942.36 | 2112820.142 | 37.7822965011504 | -122.38849310613999 | (37.7822965011504, -122.38849310614) | |||
| 109422 | 109422 | 27866 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 800 The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 24 | 4X4 | 6014921.77607 | 2116935.19701 | 37.793538888238395 | -122.39231180375 | (37.7935388882384, -122.39231180375) | ||
| 111012 | 111012 | 27882 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015988.714 | 2113369.621 | 37.7838078155273 | -122.388371103678 | (37.7838078155273, -122.388371103678) | |||
| 115406 | 115406 | 27868 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 800 The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 24 | 4X4 | 6015038.31301 | 2116806.19801 | 37.793191157262704 | -122.39189954881 | (37.7931911572627, -122.39189954881) | ||
| 116108 | 116108 | 27899 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015946.527000001 | 2112865.975 | 37.7824225791883 | -122.388481890173 | (37.7824225791883, -122.388481890173) | |||
| 116848 | 116848 | 27896 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015954.339 | 2112951.913 | 37.7826589785254 | -122.388460864103 | (37.7826589785254, -122.388460864103) | |||
| 117403 | 117403 | 27872 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6016007.985 | 2113618.059 | 37.784491038096206 | -122.38832177783199 | (37.7844910380962, -122.388321777832) | |||
| 118790 | 118790 | 27869 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 800 The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 24 | 4X4 | 6015100.81301 | 2116738.49001 | 37.7930087163181 | -122.39167855690701 | (37.7930087163181, -122.391678556907) | ||
| 119897 | 119897 | 27888 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015971.527000001 | 2113185.767 | 37.783302041465795 | -122.38841772800899 | (37.7833020414658, -122.388417728009) | |||
| 123233 | 123233 | 27887 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015976.214 | 2113235.246 | 37.7834381593837 | -122.38840496731301 | (37.7834381593837, -122.388404967313) | |||
| 124273 | 124273 | 27877 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6016000.1729999995 | 2113494.1 | 37.78415024176871 | -122.388340150307 | (37.7841502417687, -122.388340150307) | |||
| 125139 | 125139 | 27871 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6016012.152000001 | 2113641.496 | 37.78455562170571 | -122.388308997614 | (37.7845556217057, -122.388308997614) | |||
| 125282 | 125282 | 27867 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 800 The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 24 | 4X4 | 6014979.71901 | 2116870.00001 | 37.7933630896865 | -122.392106753362 | (37.7933630896865, -122.392106753362) | ||
| 125459 | 125459 | 27875 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6016001.735 | 2113547.225 | 37.78429619759189 | -122.388338455378 | (37.7842961975919, -122.388338455378) | |||
| 126905 | 126905 | 27876 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6016002.256 | 2113521.705 | 37.784226154296 | -122.38833487113001 | (37.784226154296, -122.38833487113) | |||
| 128919 | 128919 | 27889 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015968.9229999995 | 2113162.33 | 37.783237544441704 | -122.388425100514 | (37.7832375444417, -122.388425100514) | |||
| 139514 | 139514 | 27905 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015930.902000001 | 2112710.767 | 37.7819955470034 | -122.388525109177 | (37.7819955470034, -122.388525109177) | |||
| 139961 | 139961 | 27873 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6016004.86 | 2113595.663 | 37.784429370574 | -122.388331025715 | (37.784429370574, -122.388331025715) | |||
| 140224 | 140224 | 27874 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6016004.339 | 2113576.913 | 37.784377858434404 | -122.388331519124 | (37.7843778584344, -122.388331519124) | |||
| 141092 | 141092 | 27891 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015966.319 | 2113109.725 | 37.7830929586512 | -122.388430436483 | (37.7830929586512, -122.388430436483) | |||
| 141250 | 141250 | 27881 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015990.277000001 | 2113394.1 | 37.78387511595479 | -122.388367405327 | (37.7838751159548, -122.388367405327) | |||
| 141748 | 141748 | 27890 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015967.881 | 2113137.85 | 37.783170270129396 | -122.388426996246 | (37.7831702701294, -122.388426996246) | |||
| 141887 | 141887 | 27880 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015993.402000001 | 2113417.017 | 37.7839382140346 | -122.388358193918 | (37.7839382140346, -122.388358193918) | |||
| 44570 | 44570 | 27941 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 699 The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 6012787.5534626 | 2119857.700218 | 37.801444644335106 | -122.399901749617 | (37.8014446443351, -122.399901749617) | |||
| 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) | ||
| 78230 | 78230 | 27930 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 799 The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 10 | 6012635.1983488 | 2120084.4698961005 | 37.8020588041016 | -122.400444907677 | (37.8020588041016, -122.400444907677) | ||
| 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) | ||
| 83420 | 83420 | 27948 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 999 The Embarcadero | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | ||
| 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) | ||
| 91110 | 91110 | 27949 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 999 The Embarcadero | 6 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | ||
| 92133 | 92133 | 27942 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 699 The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 6012787.5534626 | 2119857.700218 | 37.801444644335106 | -122.399901749617 | (37.8014446443351, -122.399901749617) | |||
| 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) | ||
| 95434 | 95434 | 27933 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 799 The Embarcadero | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 10 | 6012635.1983488 | 2120084.4698961005 | 37.8020588041016 | -122.400444907677 | (37.8020588041016, -122.400444907677) | ||
| 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) | ||
| 98325 | 98325 | 27947 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 999 The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | ||
| 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) | ||
| 106831 | 106831 | 27951 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 999 The Embarcadero | 8 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | ||
| 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) | ||
| 114665 | 114665 | 27950 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 999 The Embarcadero | 7 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | ||
| 115229 | 115229 | 27932 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 799 The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 10 | 6012635.1983488 | 2120084.4698961005 | 37.8020588041016 | -122.400444907677 | (37.8020588041016, -122.400444907677) | ||
| 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) | ||
| 116513 | 116513 | 27946 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 999 The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | ||
| 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) | ||
| 119199 | 119199 | 27935 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 799 The Embarcadero | 7 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 10 | 6012635.1983488 | 2120084.4698961005 | 37.8020588041016 | -122.400444907677 | (37.8020588041016, -122.400444907677) | ||
| 120022 | 120022 | 27940 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 699 The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 6012787.5534626 | 2119857.700218 | 37.801444644335106 | -122.399901749617 | (37.8014446443351, -122.399901749617) | |||
| 123638 | 123638 | 27929 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 799 The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 10 | 6012635.1983488 | 2120084.4698961005 | 37.8020588041016 | -122.400444907677 | (37.8020588041016, -122.400444907677) | ||
| 127099 | 127099 | 27943 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 699 The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 6012787.5534626 | 2119857.700218 | 37.801444644335106 | -122.399901749617 | (37.8014446443351, -122.399901749617) | |||
| 128206 | 128206 | 27931 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 799 The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 10 | 6012635.1983488 | 2120084.4698961005 | 37.8020588041016 | -122.400444907677 | (37.8020588041016, -122.400444907677) | ||
| 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) | ||
| 143792 | 143792 | 27934 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 799 The Embarcadero | 6 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 10 | 6012635.1983488 | 2120084.4698961005 | 37.8020588041016 | -122.400444907677 | (37.8020588041016, -122.400444907677) | ||
| 144240 | 144240 | 27945 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 999 The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | ||
| 4983 | 4983 | 83050 | Private 5 | Rhamnus californica :: Coffeeberry Tree 232 | 100X Cargo Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/04/2006 12:00:00 AM | 1 | 6018877.26977 | 2097567.07885 | 37.7405769700435 | -122.377280830842 | (37.7405769700435, -122.377280830842) | |||
| 5054 | 5054 | 83037 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/04/2006 12:00:00 AM | 5 | 6018575.81097 | 2097793.86484 | 37.74118306815279 | -122.378338911137 | (37.7411830681528, -122.378338911137) | |||
| 5059 | 5059 | 83040 | Private 5 | Quercus suber :: Cork Oak 76 | 100X Cargo Way | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/04/2006 12:00:00 AM | 6 | 6018704.22704 | 2097697.64106 | 37.740925933998 | -122.37788821227699 | (37.740925933998, -122.377888212277) | |||
| 23209 | 23209 | 83033 | Private 5 | Olea europaea :: Olive Tree 41 | 100X Cargo Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/04/2006 12:00:00 AM | 1 | 6018894.74802 | 2097554.01331 | 37.7405420574702 | -122.377219490814 | (37.7405420574702, -122.377219490814) | |||
| 43784 | 43784 | 83046 | Private 5 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 100X Cargo Way | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/04/2006 12:00:00 AM | 1 | 6018811.25128 | 2097616.11187 | 37.740707968002 | -122.37751250161399 | (37.740707968002, -122.377512501614) | |||
| 134600 | 134600 | 83049 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100X Cargo Way | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/04/2006 12:00:00 AM | 11 | 6018864.1607099995 | 2097578.2563400003 | 37.7406069390666 | -122.377326932804 | (37.7406069390666, -122.377326932804) | |||
| 153213 | 153213 | 83039 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 100X Cargo Way | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/04/2006 12:00:00 AM | 12 | 6018611.72965 | 2097767.00037 | 37.741111283369705 | -122.378212851336 | (37.7411112833697, -122.378212851336) | |||
| 1123 | 1123 | 28040 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1500 The Embarcadero | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6011973.34792 | 2120976.9306 | 37.8044723526732 | -122.40279804081499 | (37.8044723526732, -122.402798040815) | ||
| 2826 | 2826 | 28035 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1500 The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6011869.41049 | 2121075.03017 | 37.804735906188796 | -122.403164632367 | (37.8047359061888, -122.403164632367) | ||
| 3878 | 3878 | 28034 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1500 The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6011851.06099 | 2121093.24306 | 37.8047848895665 | -122.403229415001 | (37.8047848895665, -122.403229415001) | ||
| 4234 | 4234 | 28039 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1500 The Embarcadero | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6011949.43377 | 2121001.73319 | 37.8045391192453 | -122.402882543817 | (37.8045391192453, -122.402882543817) | ||
| 5630 | 5630 | 28043 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1500 The Embarcadero | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6012024.04433 | 2120930.34171 | 37.8043472614676 | -122.402619322118 | (37.8043472614676, -122.402619322118) | ||
| 6942 | 6942 | 28041 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1500 The Embarcadero | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6011990.996730001 | 2120961.47906 | 37.804430911926495 | -122.40273587786501 | (37.8044309119265, -122.402735877865) | ||
| 7341 | 7341 | 28044 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1500 The Embarcadero | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6012052.65409 | 2120901.81041 | 37.8042705187194 | -122.402518307585 | (37.8042705187194, -122.402518307585) | ||
| 7651 | 7651 | 28038 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1500 The Embarcadero | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6011930.42206 | 2121019.16916 | 37.80458593256979 | -122.402949563068 | (37.8045859325698, -122.402949563068) |
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");