trees

725 rows where qCaretaker_id = 6 sorted by Fire Prevention Districts descending

✎ View and edit SQL

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)
165984 108830 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 46 Ney St   Sidewalk: Curb side : Cutout Tree Port 6 FUF     3x3   6003763.1265 2093992.42876 37.7299176091889 -122.429284866217 (37.7299176091889, -122.429284866217) 9 7 6 28861 5
615 262077 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 565 Page St 1 Sidewalk: Curb side : Cutout Tree Port 6 Private 04/16/2020 12:00:00 AM 3 3x3   6003870.34162 2109702.301 37.7730593047529 -122.430034440005 (37.7730593047529, -122.430034440005) 7 9 11 29492 10
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
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
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
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
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
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
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
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
27365 27871 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 280 The Embarcadero 1 Sidewalk: Curb side : Cutout Tree Port 6   01/31/2001 12:00:00 AM 12     6016012.152 2113641.496 37.7845556217057 -122.388308997614 (37.7845556217057, -122.388308997614) 6 2 9 28856 6
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
164907 27872 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 280 The Embarcadero 2 Sidewalk: Curb side : Cutout Tree Port 6   01/31/2001 12:00:00 AM 12     6016007.985 2113618.059 37.7844910380962 -122.388321777832 (37.7844910380962, -122.388321777832) 6 2 9 28856 6
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
9581 28011 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 100 The Embarcadero 8 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 6 3X3   6014191.95801 2117739.78401 37.795707543335 -122.394893427962 (37.795707543335, -122.394893427962) 4 2 10 28860 6
17161 28026 Permitted Site 7 Phoenix canariensis :: Canary Island Date Palm 160 100 The Embarcadero 6 Median : Cutout Tree Port 6   02/05/2001 12:00:00 AM 24 4X4   6014253.80701 2117776.67601 37.795812278914 -122.394682002417 (37.795812278914, -122.394682002417) 4 2 10 28860 6
20337 28014 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 100 The Embarcadero 11 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 6 3X3   6014226.68001 2117656.23301 37.7954800625202 -122.394767428538 (37.7954800625202, -122.394767428538) 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
65056 28016 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 100 The Embarcadero 13 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 6 3X3   6014245.12601 2117603.06501 37.7953351012525 -122.394699876607 (37.7953351012525, -122.394699876607) 4 2 10 28860 6
65902 28017 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 100 The Embarcadero 14 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 6 3X3   6014258.14701 2117577.02301 37.7952643199629 -122.394652996927 (37.7952643199629, -122.394652996927) 4 2 10 28860 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
89848 28013 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 100 The Embarcadero 10 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 6 3X3   6014214.74401 2117682.27501 37.7955509040886 -122.394810554146 (37.7955509040886, -122.394810554146) 4 2 10 28860 6
108085 28010 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 100 The Embarcadero 7 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 6 3X3   6014178.93701 2117764.74001 37.7957753426227 -122.394940232051 (37.7957753426227, -122.394940232051) 4 1 10 28860 6
111729 28027 Permitted Site 7 Phoenix canariensis :: Canary Island Date Palm 160 100 The Embarcadero 7 Median : Cutout Tree Port 6   02/05/2001 12:00:00 AM 24 4X4   6014263.57201 2117754.97501 37.795753235969 -122.394646693031 (37.795753235969, -122.394646693031) 4 2 10 28860 6
113760 28019 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 100 The Embarcadero 16 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 6 3X3   6014278.76301 2117533.62001 37.7951462916621 -122.394578620953 (37.7951462916621, -122.394578620953) 4 2 10 28860 6
117657 28012 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 100 The Embarcadero 9 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 6 3X3   6014204.97801 2117711.57201 37.7956308037617 -122.394846399273 (37.7956308037617, -122.394846399273) 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
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
153960 28018 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 100 The Embarcadero 15 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 6 3X3   6014268.99801 2117554.23701 37.7952023582244 -122.394613854051 (37.7952023582244, -122.394613854051) 4 2 10 28860 6
181478 28009 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 100 The Embarcadero 6 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 6 3X3   6014164.83101 2117791.86701 37.7958490426136 -122.394990942689 (37.7958490426136, -122.394990942689) 4 1 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
188165 28015 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 100 The Embarcadero 12 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 6 3X3   6014236.44501 2117630.19201 37.7954091029766 -122.39473181516 (37.7954091029766, -122.39473181516) 4 2 10 28860 6
191559 28028 Permitted Site 7 Phoenix canariensis :: Canary Island Date Palm 160 100 The Embarcadero 8 Median : Cutout Tree Port 6   02/05/2001 12:00:00 AM 24 4X4   6014289.61401 2117737.61301 37.7957070117951 -122.394555365911 (37.7957070117951, -122.394555365911) 4 2 10 28860 6
1742 28048 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1800 The Embarcadero 4 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.55539 37.808912348093 -122.41573688061 (37.808912348093, -122.41573688061) 3 1 10 308 23
2509 27941 Permitted Site 7 Phoenix canariensis :: Canary Island Date Palm 160 699 The Embarcadero 2 Median : Cutout Tree Port 6   02/01/2001 12:00:00 AM 24     6012787.5534626 2119857.700218 37.8014446443351 -122.399901749617 (37.8014446443351, -122.399901749617) 3 1 10 28860 6
3522 25785 Permitted Site 7 Phoenix canariensis :: Canary Island Date Palm 160 500X The Embarcadero 4 Median : Cutout Tree Port 6   08/30/1996 12:00:00 AM 36 10   6013445.7547399 2119056.6213274 37.7992817461076 -122.397567846492 (37.7992817461076, -122.397567846492) 3 1 10 28860 6
6693 25675 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 350X The Embarcadero 2 Sidewalk: Curb side : Cutout Tree Port 6   12/18/2000 12:00:00 AM 12 4x4   6013785.7946449 2118604.8635638 37.7980602547356 -122.396359500707 (37.7980602547356, -122.396359500707) 3 1 10 28860 6
7822 26018 Permitted Site 7 Phoenix canariensis :: Canary Island Date Palm 160 899X The Embarcadero 2 Median : Cutout Tree Port 6   12/01/2000 12:00:00 AM 36 10   6012483.6012207 2120310.1113669 37.8026699057947 -122.400985372375 (37.8026699057947, -122.400985372375) 3 1 10 28860 6
8261 25749 Permitted Site 7 Phoenix canariensis :: Canary Island Date Palm 160 1301X The Embarcadero 2 Median : Cutout Tree Port 6   08/30/1996 12:00:00 AM 36 10   6011423.5148387 2121491.4283584 37.805854321699 -122.404737040358 (37.805854321699, -122.404737040358) 3 1 10 28860 23
9221 28049 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1800 The Embarcadero 5 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.55539 37.808912348093 -122.41573688061 (37.808912348093, -122.41573688061) 3 1 10 308 23
9326 27814 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 350X The Embarcadero 13 Sidewalk: Curb side : Cutout Tree Port 6   07/15/1994 12:00:00 AM 12 4x4   6013785.7946449 2118604.8635638 37.7980602547356 -122.396359500707 (37.7980602547356, -122.396359500707) 3 1 10 28860 6
9569 25843 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 800X The Embarcadero 7 Sidewalk: Curb side : Cutout Tree Port 6   10/30/1995 12:00:00 AM 6 4X4   6013291.71436 2119122.7738 37.7994548065492 -122.398105526769 (37.7994548065492, -122.398105526769) 3 1 10 28860 6
9595 25849 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 800X The Embarcadero 13 Sidewalk: Curb side : Cutout Tree Port 6   10/30/1995 12:00:00 AM 6 4X4   6012736.380854 2120162.4372415 37.8022785256437 -122.400100244504 (37.8022785256437, -122.400100244504) 3 1 10 28860 6
11134 28042 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1400 The Embarcadero 10 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 12 3X3   6012004.18493 2120947.51548 37.804393307678 -122.4026892561 (37.804393307678, -122.4026892561) 3 1 10 28860 6

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);