trees
725 rows where qCaretaker_id = 6 sorted by Longitude
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
181820 | 27873 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 3 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6016004.86 | 2113595.663 | 37.784429370574 | -122.388331025715 | (37.784429370574, -122.388331025715) | 6 | 2 | 9 | 28856 | 6 | |||
182394 | 27874 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 4 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6016004.339 | 2113576.913 | 37.7843778584344 | -122.388331519124 | (37.7843778584344, -122.388331519124) | 6 | 2 | 9 | 28856 | 6 | |||
26774 | 27876 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 6 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6016002.256 | 2113521.705 | 37.784226154296 | -122.38833487113 | (37.784226154296, -122.38833487113) | 6 | 2 | 9 | 28856 | 6 | |||
35877 | 27875 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 5 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6016001.735 | 2113547.225 | 37.7842961975919 | -122.388338455378 | (37.7842961975919, -122.388338455378) | 6 | 2 | 9 | 28856 | 6 | |||
26048 | 27877 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 7 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6016000.173 | 2113494.1 | 37.7841502417687 | -122.388340150307 | (37.7841502417687, -122.388340150307) | 6 | 2 | 9 | 28856 | 6 | |||
89464 | 27878 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 8 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6015996.527 | 2113472.746 | 37.784091406469 | -122.388351273372 | (37.784091406469, -122.388351273372) | 6 | 2 | 9 | 28856 | 6 | |||
186984 | 27880 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 10 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6015993.402 | 2113417.017 | 37.7839382140346 | -122.388358193918 | (37.7839382140346, -122.388358193918) | 6 | 2 | 9 | 28856 | 6 | |||
102058 | 27879 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 9 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6015993.923 | 2113447.225 | 37.7840211872639 | -122.388358500511 | (37.7840211872639, -122.388358500511) | 6 | 2 | 9 | 28856 | 6 | |||
174840 | 27881 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 11 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6015990.277 | 2113394.1 | 37.7838751159548 | -122.388367405327 | (37.7838751159548, -122.388367405327) | 6 | 2 | 9 | 28856 | 6 | |||
144495 | 27882 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 12 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6015988.714 | 2113369.621 | 37.7838078155273 | -122.388371103678 | (37.7838078155273, -122.388371103678) | 6 | 2 | 9 | 28856 | 6 | |||
74837 | 27883 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 13 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6015986.631 | 2113340.455 | 37.7837276168383 | -122.388376273801 | (37.7837276168383, -122.388376273801) | 6 | 2 | 9 | 28856 | 6 | |||
66166 | 27885 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 15 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6015984.548 | 2113289.413 | 37.7835873515787 | -122.388379916552 | (37.7835873515787, -122.388379916552) | 6 | 2 | 9 | 28856 | 6 | |||
60041 | 27886 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 16 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6015979.339 | 2113269.621 | 37.7835327185594 | -122.388396555982 | (37.7835327185594, -122.388396555982) | 6 | 2 | 9 | 28856 | 6 | |||
170455 | 27887 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 17 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6015976.214 | 2113235.246 | 37.7834381593837 | -122.388404967313 | (37.7834381593837, -122.388404967313) | 6 | 2 | 9 | 28856 | 6 | |||
32855 | 25683 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 3X3 | 6015960.62101 | 2112553.15201 | 37.781564418481 | -122.388411289639 | (37.781564418481, -122.388411289639) | 6 | 2 | 9 | 28856 | 20 | ||
160580 | 27888 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 18 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6015971.527 | 2113185.767 | 37.7833020414658 | -122.388417728009 | (37.7833020414658, -122.388417728009) | 6 | 2 | 9 | 28856 | 6 | |||
37870 | 27889 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 19 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6015968.923 | 2113162.33 | 37.7832375444417 | -122.388425100514 | (37.7832375444417, -122.388425100514) | 6 | 2 | 9 | 28856 | 6 | |||
183096 | 27890 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 20 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6015967.881 | 2113137.85 | 37.7831702701294 | -122.388426996246 | (37.7831702701294, -122.388426996246) | 6 | 2 | 9 | 28856 | 6 | |||
87507 | 27892 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 22 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6015966.319 | 2113080.559 | 37.7830128753765 | -122.388428400104 | (37.7830128753765, -122.388428400104) | 6 | 2 | 9 | 28856 | 6 | |||
186680 | 27891 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 21 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6015966.319 | 2113109.725 | 37.7830929586512 | -122.388430436483 | (37.7830929586512, -122.388430436483) | 6 | 2 | 9 | 28856 | 6 | |||
39367 | 25684 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 2 | Median : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 3X3 | 6015953.02501 | 2112484.79201 | 37.781376296324 | -122.388432795571 | (37.781376296324, -122.388432795571) | 6 | 2 | 9 | 28856 | 20 | ||
55865 | 27893 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 23 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6015963.194 | 2113042.017 | 37.7829068745448 | -122.388436520394 | (37.7829068745448, -122.388436520394) | 6 | 2 | 9 | 28856 | 6 | |||
99729 | 27894 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 24 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6015959.027 | 2113012.85 | 37.7828265576108 | -122.388448900144 | (37.7828265576108, -122.388448900144) | 6 | 2 | 9 | 28856 | 6 | |||
19944 | 27895 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 25 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6015957.985 | 2112989.413 | 37.7827621471367 | -122.388450868666 | (37.7827621471367, -122.388450868666) | 6 | 2 | 9 | 28856 | 6 | |||
153314 | 27896 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 26 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6015954.339 | 2112951.913 | 37.7826589785254 | -122.388460864103 | (37.7826589785254, -122.388460864103) | 6 | 2 | 9 | 28856 | 6 | |||
79846 | 27897 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 27 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6015953.298 | 2112914.413 | 37.7825559542673 | -122.388461847258 | (37.7825559542673, -122.388461847258) | 6 | 2 | 9 | 28856 | 6 | |||
80326 | 27898 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 28 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6015948.61 | 2112884.725 | 37.7824741779053 | -122.388475992994 | (37.7824741779053, -122.388475992994) | 6 | 2 | 9 | 28856 | 6 | |||
43710 | 27848 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 07/15/1994 12:00:00 AM | 12 | 3X3 | 6015938.91901 | 2112416.43301 | 37.7811878161514 | -122.388476823036 | (37.7811878161514, -122.388476823036) | 6 | 2 | 9 | 28856 | 20 | ||
135460 | 27899 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 29 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6015946.527 | 2112865.975 | 37.7824225791883 | -122.388481890173 | (37.7824225791883, -122.388481890173) | 6 | 2 | 9 | 28856 | 6 | |||
58982 | 27900 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 30 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6015944.964 | 2112842.538 | 37.7823581398375 | -122.388485661103 | (37.7823581398375, -122.388485661103) | 6 | 2 | 9 | 28856 | 6 | |||
14831 | 195631 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 416 The Embarcadero | 6 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 9 | Width 4ft | 6015940.74399 | 2112714.61706 | 37.782006663809 | -122.388491328916 | (37.782006663809, -122.388491328916) | 6 | 2 | 9 | 28856 | 6 | ||
116987 | 27901 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 31 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6015942.36 | 2112820.142 | 37.7822965011504 | -122.38849310614 | (37.7822965011504, -122.38849310614) | 6 | 2 | 9 | 28856 | 6 | |||
14315 | 27902 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 32 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6015941.319 | 2112799.309 | 37.782239240724 | -122.388495252967 | (37.782239240724, -122.388495252967) | 6 | 2 | 9 | 28856 | 6 | |||
1501 | 27903 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 33 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6015937.152 | 2112771.705 | 37.7821632154212 | -122.388507741674 | (37.7821632154212, -122.388507741674) | 6 | 2 | 9 | 28856 | 6 | |||
20056 | 27904 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 34 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6015934.027 | 2112727.434 | 37.7820414840201 | -122.388515461744 | (37.7820414840201, -122.388515461744) | 6 | 2 | 9 | 28856 | 6 | |||
179517 | 27905 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 35 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6015930.902 | 2112710.767 | 37.7819955470034 | -122.388525109177 | (37.7819955470034, -122.388525109177) | 6 | 2 | 9 | 28856 | 6 | |||
164580 | 27849 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 4 | Median : Cutout | Tree | Port 6 | 07/15/1994 12:00:00 AM | 12 | 3X3 | 6015921.55801 | 2112354.58401 | 37.7810170305764 | -122.388532565578 | (37.7810170305764, -122.388532565578) | 6 | 2 | 9 | 28856 | 20 | ||
139606 | 27907 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015923.72801 | 2112571.59801 | 37.7816130226275 | -122.388540210862 | (37.7816130226275, -122.388540210862) | 6 | 2 | 9 | 28856 | 20 | ||
49211 | 27906 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 36 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6015925.694 | 2112692.017 | 37.7819437751015 | -122.38854181744 | (37.7819437751015, -122.38854181744) | 6 | 2 | 9 | 28856 | 6 | |||
134986 | 27908 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 The Embarcadero | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015917.21801 | 2112547.72601 | 37.7815471147029 | -122.388561065729 | (37.7815471147029, -122.388561065729) | 6 | 2 | 9 | 28856 | 20 | ||
16937 | 27910 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 The Embarcadero | 4 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015913.96301 | 2112493.47301 | 37.7813979677469 | -122.388568538406 | (37.7813979677469, -122.388568538406) | 6 | 2 | 9 | 28856 | 20 | ||
154540 | 27909 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 The Embarcadero | 3 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015913.96301 | 2112518.42901 | 37.7814664913266 | -122.388570280932 | (37.7814664913266, -122.388570280932) | 6 | 2 | 9 | 28856 | 20 | ||
118031 | 27911 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 The Embarcadero | 5 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015911.79301 | 2112468.51601 | 37.7813293211635 | -122.388574303017 | (37.7813293211635, -122.388574303017) | 6 | 2 | 9 | 28856 | 20 | ||
110967 | 27912 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 The Embarcadero | 6 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015910.70801 | 2112444.64501 | 37.7812637166204 | -122.388576389848 | (37.7812637166204, -122.388576389848) | 6 | 2 | 9 | 28856 | 20 | ||
189347 | 27913 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 The Embarcadero | 7 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015902.02701 | 2112416.43301 | 37.7811857717037 | -122.388604452195 | (37.7811857717037, -122.388604452195) | 6 | 2 | 9 | 28856 | 20 | ||
132853 | 27850 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 5 | Median : Cutout | Tree | Port 6 | 07/15/1994 12:00:00 AM | 12 | 3X3 | 6015895.51701 | 2112292.73501 | 37.7808457639334 | -122.388618336487 | (37.7808457639334, -122.388618336487) | 6 | 2 | 9 | 28856 | 20 | ||
152226 | 27914 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 The Embarcadero | 8 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015893.34601 | 2112392.56101 | 37.7811197434466 | -122.388632817528 | (37.7811197434466, -122.388632817528) | 6 | 2 | 9 | 28856 | 20 | ||
45885 | 27915 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 The Embarcadero | 9 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015885.75101 | 2112369.77501 | 37.7810567572813 | -122.388657501594 | (37.7810567572813, -122.388657501594) | 6 | 2 | 9 | 28856 | 20 | ||
51761 | 27916 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 The Embarcadero | 10 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015873.81501 | 2112343.73301 | 37.7809845902791 | -122.388696976059 | (37.7809845902791, -122.388696976059) | 6 | 2 | 9 | 28856 | 20 | ||
149101 | 27917 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 The Embarcadero | 11 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015864.05001 | 2112323.11701 | 37.7809274421657 | -122.38872931872 | (37.7809274421657, -122.38872931872) | 6 | 2 | 9 | 28856 | 20 | ||
171833 | 27851 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 6 | Median : Cutout | Tree | Port 6 | 07/15/1994 12:00:00 AM | 12 | 3X3 | 6015857.53901 | 2112236.31101 | 37.7806887314792 | -122.388745782008 | (37.7806887314792, -122.388745782008) | 6 | 2 | 9 | 28856 | 20 | ||
101706 | 27918 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 The Embarcadero | 12 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015851.02901 | 2112300.33101 | 37.7808641552493 | -122.388772773994 | (37.7808641552493, -122.388772773994) | 6 | 2 | 9 | 28856 | 20 | ||
30201 | 27919 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 The Embarcadero | 13 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015840.17801 | 2112278.62901 | 37.7808039650097 | -122.388808797741 | (37.7808039650097, -122.388808797741) | 6 | 2 | 9 | 28856 | 20 | ||
188675 | 27920 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 The Embarcadero | 14 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015829.32701 | 2112255.84301 | 37.7807407983373 | -122.388844745731 | (37.7807407983373, -122.388844745731) | 6 | 2 | 9 | 28856 | 20 | ||
167386 | 27852 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 7 | Median : Cutout | Tree | Port 6 | 07/15/1994 12:00:00 AM | 12 | 3X3 | 6015817.39201 | 2112182.05801 | 37.7805375397414 | -122.388880882265 | (37.7805375397414, -122.388880882265) | 6 | 2 | 9 | 28856 | 20 | ||
176402 | 27921 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 The Embarcadero | 15 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015810.88101 | 2112236.31101 | 37.7806861454365 | -122.388907195889 | (37.7806861454365, -122.388907195889) | 6 | 2 | 9 | 28856 | 20 | ||
52783 | 27922 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 The Embarcadero | 16 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015798.94501 | 2112218.95001 | 37.7806378144268 | -122.388947276171 | (37.7806378144268, -122.388947276171) | 6 | 2 | 9 | 28856 | 20 | ||
69243 | 27923 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 The Embarcadero | 17 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015780.49901 | 2112201.58901 | 37.7805891225502 | -122.389009877789 | (37.7805891225502, -122.389009877789) | 6 | 2 | 9 | 28856 | 20 | ||
172631 | 27853 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 8 | Median : Cutout | Tree | Port 6 | 07/15/1994 12:00:00 AM | 12 | 3X3 | 6015772.90401 | 2112134.31501 | 37.7804039822192 | -122.389031454309 | (37.7804039822192, -122.389031454309) | 6 | 2 | 9 | 28856 | 20 | ||
187172 | 27924 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 The Embarcadero | 18 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015682.84301 | 2112108.27301 | 37.7803274840965 | -122.389341201064 | (37.7803274840965, -122.389341201064) | 6 | 2 | 9 | 28856 | 20 | ||
77105 | 27925 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 The Embarcadero | 19 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015664.39701 | 2112091.99701 | 37.7802817711748 | -122.389403877954 | (37.7802817711748, -122.389403877954) | 6 | 2 | 9 | 28856 | 20 | ||
93183 | 27926 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 The Embarcadero | 20 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015645.95101 | 2112072.46601 | 37.7802271207192 | -122.389466327385 | (37.7802271207192, -122.389466327385) | 6 | 2 | 9 | 28856 | 20 | ||
151998 | 27927 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 The Embarcadero | 21 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015626.41901 | 2112054.02001 | 37.7801753891821 | -122.389532609523 | (37.7801753891821, -122.389532609523) | 6 | 2 | 9 | 28856 | 20 | ||
62387 | 27928 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 The Embarcadero | 22 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015611.22801 | 2112036.65901 | 37.7801268774736 | -122.389583949745 | (37.7801268774736, -122.389583949745) | 6 | 2 | 9 | 28856 | 20 | ||
166227 | 121471 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 102X King St | 1 | Median : Cutout | Tree | Port 6 | 9 | 3x3 | 6015546.21298 | 2111901.81315 | 37.7797530158304 | -122.389799446797 | (37.7797530158304, -122.389799446797) | 6 | 2 | 9 | 28856 | 20 | |||
78382 | 121470 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 120X The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 8 | 4x4 | 6015452 | 2116243 | 37.7916677028969 | -122.390428783846 | (37.7916677028969, -122.390428783846) | 6 | 2 | 9 | 28855 | 6 | |||
135201 | 25627 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800 The Embarcadero | 13 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6015154.19801 | 2116593.95801 | 37.7926148281307 | -122.391483731415 | (37.7926148281307, -122.391483731415) | 12 | 2 | 9 | 28855 | 6 | ||
88902 | 27870 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 800 The Embarcadero | 5 | Median : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 24 | 4X4 | 6015155.50001 | 2116672.08301 | 37.7928294135533 | -122.391484690649 | (37.7928294135533, -122.391484690649) | 12 | 2 | 9 | 28855 | 6 | ||
47010 | 25626 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800 The Embarcadero | 12 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6015143.78201 | 2116618.69801 | 37.7926821803134 | -122.391521501856 | (37.7926821803134, -122.391521501856) | 12 | 2 | 9 | 28855 | 6 | ||
133300 | 25625 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800 The Embarcadero | 11 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6015102.11501 | 2116685.10401 | 37.79286220301 | -122.391670317555 | (37.79286220301, -122.391670317555) | 12 | 2 | 9 | 28855 | 6 | ||
159054 | 27869 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 800 The Embarcadero | 4 | Median : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 24 | 4X4 | 6015100.81301 | 2116738.49001 | 37.7930087163181 | -122.391678556907 | (37.7930087163181, -122.391678556907) | 12 | 2 | 9 | 28855 | 6 | ||
31627 | 25624 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800 The Embarcadero | 10 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6015065.65701 | 2116724.16701 | 37.7929674371429 | -122.391799197633 | (37.7929674371429, -122.391799197633) | 12 | 2 | 9 | 28855 | 6 | ||
63790 | 25623 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800 The Embarcadero | 9 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6015040.91701 | 2116748.90601 | 37.7930339912858 | -122.391886530718 | (37.7930339912858, -122.391886530718) | 12 | 2 | 9 | 28855 | 6 | ||
139826 | 27868 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 800 The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 24 | 4X4 | 6015038.31301 | 2116806.19801 | 37.7931911572627 | -122.39189954881 | (37.7931911572627, -122.39189954881) | 12 | 2 | 9 | 28855 | 6 | ||
193365 | 25622 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800 The Embarcadero | 8 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6015012.27101 | 2116778.85401 | 37.7931146312154 | -122.391987743488 | (37.7931146312154, -122.391987743488) | 12 | 2 | 9 | 28855 | 6 | ||
86229 | 25621 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800 The Embarcadero | 7 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014992.74001 | 2116800.99001 | 37.7931743271891 | -122.392056871184 | (37.7931743271891, -122.392056871184) | 12 | 2 | 9 | 28855 | 6 | ||
28000 | 27867 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 800 The Embarcadero | 2 | Median : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 24 | 4X4 | 6014979.71901 | 2116870.00001 | 37.7933630896865 | -122.392106753362 | (37.7933630896865, -122.392106753362) | 12 | 2 | 9 | 28855 | 6 | ||
143845 | 25620 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800 The Embarcadero | 6 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014974.51101 | 2116817.91701 | 37.793219792707 | -122.392121129495 | (37.793219792707, -122.392121129495) | 12 | 2 | 9 | 28855 | 6 | ||
118865 | 25619 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800 The Embarcadero | 5 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014956.28201 | 2116834.84401 | 37.7932652581895 | -122.392185387885 | (37.7932652581895, -122.392185387885) | 12 | 2 | 9 | 28855 | 6 | ||
116516 | 27866 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 800 The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 24 | 4X4 | 6014921.77607 | 2116935.19701 | 37.7935388882384 | -122.39231180375 | (37.7935388882384, -122.39231180375) | 12 | 2 | 9 | 28855 | 6 | ||
71108 | 25618 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800 The Embarcadero | 4 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014901.59401 | 2116884.32301 | 37.7933980793798 | -122.392378075877 | (37.7933980793798, -122.392378075877) | 12 | 2 | 9 | 28855 | 6 | ||
172660 | 25617 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800 The Embarcadero | 3 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014889.87501 | 2116893.43801 | 37.7934224562927 | -122.392419262644 | (37.7934224562927, -122.392419262644) | 12 | 2 | 9 | 28855 | 6 | ||
36195 | 25616 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800 The Embarcadero | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014879.45901 | 2116905.15601 | 37.7934540527819 | -122.392456123078 | (37.7934540527819, -122.392456123078) | 12 | 2 | 9 | 28855 | 6 | ||
69869 | 25615 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800 The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014865.13601 | 2116922.08301 | 37.7934997349939 | -122.392506866704 | (37.7934997349939, -122.392506866704) | 12 | 2 | 9 | 28855 | 6 | ||
51968 | 15089 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 30 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 4X4 | 6014680.683616 | 2116874.398416 | 37.7933585592202 | -122.393141753221 | (37.7933585592202, -122.393141753221) | 12 | 2 | 10 | 28855 | 6 | |||
121228 | 15087 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 30 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 4X4 | 6014680.683616 | 2116874.398416 | 37.7933585592202 | -122.393141753221 | (37.7933585592202, -122.393141753221) | 12 | 2 | 10 | 28855 | 6 | |||
147907 | 15088 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 30 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 4X4 | 6014680.683616 | 2116874.398416 | 37.7933585592202 | -122.393141753221 | (37.7933585592202, -122.393141753221) | 12 | 2 | 10 | 28855 | 6 | |||
157848 | 15086 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 30 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 4X4 | 6014680.683616 | 2116874.398416 | 37.7933585592202 | -122.393141753221 | (37.7933585592202, -122.393141753221) | 12 | 2 | 10 | 28855 | 6 | |||
25228 | 27953 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 107X The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 6 | 6014670.2880903 | 2117144.019363 | 37.7940982979938 | -122.393196597915 | (37.7940982979938, -122.393196597915) | 12 | 2 | 10 | 28855 | 6 | |||
123833 | 27952 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 107X The Embarcadero | 2 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 6 | 6014670.2880903 | 2117144.019363 | 37.7940982979938 | -122.393196597915 | (37.7940982979938, -122.393196597915) | 12 | 2 | 10 | 28855 | 6 | |||
124639 | 27956 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 107X The Embarcadero | 6 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 6 | 6014670.2880903 | 2117144.019363 | 37.7940982979938 | -122.393196597915 | (37.7940982979938, -122.393196597915) | 12 | 2 | 10 | 28855 | 6 | |||
129323 | 27718 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 107X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 09/11/2000 12:00:00 AM | 6 | 6014670.2880903 | 2117144.019363 | 37.7940982979938 | -122.393196597915 | (37.7940982979938, -122.393196597915) | 12 | 2 | 10 | 28855 | 6 | |||
135109 | 27957 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 107X The Embarcadero | 7 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 6 | 6014670.2880903 | 2117144.019363 | 37.7940982979938 | -122.393196597915 | (37.7940982979938, -122.393196597915) | 12 | 2 | 10 | 28855 | 6 | |||
183882 | 27955 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 107X The Embarcadero | 5 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 6 | 6014670.2880903 | 2117144.019363 | 37.7940982979938 | -122.393196597915 | (37.7940982979938, -122.393196597915) | 12 | 2 | 10 | 28855 | 6 | |||
192167 | 27954 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 107X The Embarcadero | 4 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 6 | 6014670.2880903 | 2117144.019363 | 37.7940982979938 | -122.393196597915 | (37.7940982979938, -122.393196597915) | 12 | 2 | 10 | 28855 | 6 | |||
86437 | 28032 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 12 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014349.29301 | 2117643.21201 | 37.7954511263865 | -122.394342251353 | (37.7954511263865, -122.394342251353) | 4 | 2 | 10 | 28860 | 6 | ||
132193 | 28031 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 11 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014334.10201 | 2117669.25401 | 37.7955217871698 | -122.394396639485 | (37.7955217871698, -122.394396639485) | 4 | 2 | 10 | 28860 | 6 | ||
43793 | 28030 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 10 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014322.16601 | 2117689.87001 | 37.7955777303512 | -122.394439384649 | (37.7955777303512, -122.394439384649) | 4 | 2 | 10 | 28860 | 6 | ||
148304 | 28020 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100 The Embarcadero | 17 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014303.72001 | 2117502.15301 | 37.795061278092 | -122.394490060779 | (37.795061278092, -122.394490060779) | 4 | 2 | 10 | 28860 | 6 | ||
187664 | 28029 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 9 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014304.80501 | 2117713.74201 | 37.7956423121436 | -122.394501129585 | (37.7956423121436, -122.394501129585) | 4 | 2 | 10 | 28860 | 6 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );