trees

725 rows where qCaretaker_id = 6 sorted by qAddress

✎ 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)
16204 114507 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 10 LOMBARD ST 2 Back Yard : Cutout Tree Port 6       4x4   6011932 2120995 37.8045196580749 -122.402942401468 (37.8045196580749, -122.402942401468) 3 1 10 28860 6
21026 114508 Undocumented 4 Maytenus boaria :: Mayten 58 10 LOMBARD ST 3 Back Yard : Cutout Tree Port 6       4x4   6011932 2120995 37.8045196580749 -122.402942401468 (37.8045196580749, -122.402942401468) 3 1 10 28860 6
58595 114506 Undocumented 4 Maytenus boaria :: Mayten 58 10 LOMBARD ST 1 Back Yard : Cutout Tree Port 6       4x4   6011932 2120995 37.8045196580749 -122.402942401468 (37.8045196580749, -122.402942401468) 3 1 10 28860 6
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
11651 28006 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 100 The Embarcadero 3 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 6 3X3   6014086.70601 2117927.50101 37.7962171170916 -122.395270777766 (37.7962171170916, -122.395270777766) 3 2 10 28860 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
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
28206 28025 Permitted Site 7 Phoenix canariensis :: Canary Island Date Palm 160 100 The Embarcadero 5 Median : Cutout Tree Port 6   02/05/2001 12:00:00 AM 24 4X4   6014170.25601 2117873.24701 37.7960727946079 -122.394977873693 (37.7960727946079, -122.394977873693) 3 2 10 28860 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
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
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
45682 28024 Permitted Site 7 Phoenix canariensis :: Canary Island Date Palm 160 100 The Embarcadero 4 Median : Cutout Tree Port 6   02/05/2001 12:00:00 AM 24 4X4   6014145.30001 2117911.22501 37.7961756855245 -122.39506688845 (37.7961756855245, -122.39506688845) 3 2 10 28860 6
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
48553 28021 Permitted Site 7 Phoenix canariensis :: Canary Island Date Palm 160 100 The Embarcadero 1 Median : Cutout Tree Port 6   02/05/2001 12:00:00 AM 24 4x4   6014080.19501 2118017.56101 37.7964640385194 -122.395299619332 (37.7964640385194, -122.395299619332) 3 2 10 28860 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
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
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
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
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
77477 28023 Permitted Site 7 Phoenix canariensis :: Canary Island Date Palm 160 100 The Embarcadero 3 Median : Cutout Tree Port 6   02/05/2001 12:00:00 AM 24 4x4   6014119.25801 2117944.86201 37.7962665966149 -122.395159357042 (37.7962665966149, -122.395159357042) 3 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
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
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
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
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
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
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
119843 28004 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 100 The Embarcadero 1 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 6 3X3   6014041.13301 2117989.35001 37.7963844052449 -122.39543280592 (37.7963844052449, -122.39543280592) 3 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
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
136264 28008 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 100 The Embarcadero 5 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 6 3x3   6014135.53401 2117846.12001 37.7959963794451 -122.395096118536 (37.7959963794451, -122.395096118536) 3 2 10 28860 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
144197 28022 Permitted Site 7 Phoenix canariensis :: Canary Island Date Palm 160 100 The Embarcadero 2 Median : Cutout Tree Port 6   02/05/2001 12:00:00 AM 24 4X4   6014106.23701 2117977.41401 37.7963552526163 -122.39520669408 (37.7963552526163, -122.39520669408) 3 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
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
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
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
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
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
168910 28005 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 100 The Embarcadero 2 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 6 3X3   6014065.00401 2117953.54201 37.796287412573 -122.395347696851 (37.796287412573, -122.395347696851) 3 2 10 28860 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
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
177314 28007 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 100 The Embarcadero 4 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 6 3X3   6014117.08801 2117880.84301 37.7960906948417 -122.395162379187 (37.7960906948417, -122.395162379187) 3 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
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
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
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
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
3206 83039 DPW Maintained 1 Quercus suber :: Cork Oak 78 100X Cargo Way 13 Sidewalk: Curb side : Cutout Tree Port 6     12     6018611.72965 2097767.00037 37.7411112833697 -122.378212851336 (37.7411112833697, -122.378212851336) 10 3 8 58 1
6877 3643 DPW Maintained 1 Quercus ilex :: Holly Oak 305 100X Cargo Way 79 Sidewalk: Curb side : Cutout Tree Port 6     6 3X3   6017487.6627 2098619.8542 37.7433910314633 -122.382158823763 (37.7433910314633, -122.382158823763) 10 3 8 58 1
7035 3622 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 100X Cargo Way 58 Sidewalk: Curb side : Cutout Tree Port 6     6 3X3   6017832.21147 2098347.65106 37.7426626399605 -122.380948529647 (37.7426626399605, -122.380948529647) 10 3 8 58 1
7185 3603 DPW Maintained 1 Quercus ilex :: Holly Oak 305 100X Cargo Way 39 Sidewalk: Curb side : Cutout Tree Port 6     12 3X3   6018171.24251 2098094.76588 37.7419869748341 -122.379758679838 (37.7419869748341, -122.379758679838) 10 3 8 58 1
8437 83050 DPW Maintained 1 Rhamnus californica :: Coffeeberry Tree 320 100X Cargo Way 2 Sidewalk: Curb side : Cutout Tree Port 6     1     6018877.26977 2097567.07885 37.7405769700435 -122.377280830842 (37.7405769700435, -122.377280830842) 10 3 8 58 1
9540 83049 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 100X Cargo Way 5 Sidewalk: Curb side : Cutout Tree Port 6     11     6018864.16071 2097578.25634 37.7406069390666 -122.377326932804 (37.7406069390666, -122.377326932804) 10 3 8 58 1
10036 83037 DPW Maintained 1 Quercus ilex :: Holly Oak 305 100X Cargo Way 15 Sidewalk: Curb side : Cutout Tree Port 6     5     6018575.81097 2097793.86484 37.7411830681528 -122.378338911137 (37.7411830681528, -122.378338911137) 10 3 8 58 1
10393 3666 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 100X Cargo Way 102 Sidewalk: Curb side : Cutout Tree Port 6   05/02/2017 03:06:00 PM 3 3X3   6017134.48475 2098914.37607 37.7441802162386 -122.383400533034 (37.7441802162386, -122.383400533034) 10 3 8 58 1
10719 3608 DPW Maintained 1 Quercus ilex :: Holly Oak 305 100X Cargo Way 44 Sidewalk: Curb side : Cutout Tree Port 6   03/07/2006 12:00:00 AM 3 3X3   6018087.01832 2098157.15518 37.7421536371939 -122.380054237523 (37.7421536371939, -122.380054237523) 10 3 8 58 1
10762 3628 DPW Maintained 1 Quercus ilex :: Holly Oak 305 100X Cargo Way 64 Sidewalk: Curb side : Cutout Tree Port 6     6 3X3   6017730.69941 2098422.13413 37.7428615520079 -122.381304710649 (37.7428615520079, -122.381304710649) 10 3 8 58 1
11075 3596 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 100X Cargo Way 32 Sidewalk: Curb side : Cutout Tree Port 6   05/01/2017 03:07:00 PM 3 3X3   6018288.66955 2098007.43076 37.7417536466133 -122.379346585295 (37.7417536466133, -122.379346585295) 10 3 8 58 1
11481 3673 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 100X Cargo Way 109 Sidewalk: Curb side : Cutout Tree Port 6   04/10/2017 10:21:00 AM 3 3X3   6017015.17172 2099002.62034 37.7444159222737 -122.383819238476 (37.7444159222737, -122.383819238476) 10 3 8 58 1
12701 3581 Permitted Site 7 Ceratonia siliqua :: Carob 5 100X Cargo Way 16 Sidewalk: Curb side : Cutout Tree Port 6   03/01/2006 12:00:00 AM 3 3X3   6018980.3390981 2097500.2540781 37.7403991596993 -122.376919818221 (37.7403991596993, -122.376919818221) 10 3 8 58 1
14274 3580 Permitted Site 7 Quercus ilex :: Holly Oak 305 100X Cargo Way 15 Sidewalk: Curb side : Cutout Tree Port 6     6 3X3   6018980.3390981 2097500.2540781 37.7403991596993 -122.376919818221 (37.7403991596993, -122.376919818221) 10 3 8 58 1
15140 83033 DPW Maintained 1 Olea europaea :: Olive Tree 9 100X Cargo Way 3 Sidewalk: Curb side : Cutout Tree Port 6     1     6018894.74802 2097554.01331 37.7405420574702 -122.377219490814 (37.7405420574702, -122.377219490814) 10 3 8 58 1
17391 3602 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 100X Cargo Way 38 Sidewalk: Curb side : Cutout Tree Port 6   03/07/2006 12:00:00 AM 3 3X3   6018187.24152 2098084.44706 37.7419595239099 -122.379702643058 (37.7419595239099, -122.379702643058) 10 3 8 58 1
18663 83040 DPW Maintained 1 Quercus suber :: Cork Oak 78 100X Cargo Way 12 Sidewalk: Curb side : Cutout Tree Port 6     6     6018704.22704 2097697.64106 37.740925933998 -122.377888212277 (37.740925933998, -122.377888212277) 10 3 8 58 1
18840 83046 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 100X Cargo Way 6 Sidewalk: Curb side : Cutout Tree Port 6     1     6018811.25128 2097616.11187 37.740707968002 -122.377512501614 (37.740707968002, -122.377512501614) 10 3 8 58 1
26841 3665 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100X Cargo Way 101 Sidewalk: Curb side : Cutout Tree Port 6     18 3X3   6017153.34624 2098900.71457 37.7441437469313 -122.383334362693 (37.7441437469313, -122.383334362693) 10 3 8 58 1
26941 3606 DPW Maintained 1 Quercus ilex :: Holly Oak 305 100X Cargo Way 42 Sidewalk: Curb side : Cutout Tree Port 6     12 3X3   6018122.20462 2098131.02661 37.7420838344896 -122.379930757907 (37.7420838344896, -122.379930757907) 10 3 8 58 1
28445 3667 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 100X Cargo Way 103 Sidewalk: Curb side : Cutout Tree Port 6   05/02/2017 03:19:00 PM 3 3X3   6017116.62756 2098928.27448 37.7442173915214 -122.383463247242 (37.7442173915214, -122.383463247242) 10 3 8 58 1
30084 3591 DPW Maintained 1 Quercus suber :: Cork Oak 78 100X Cargo Way 27 Sidewalk: Curb side : Cutout Tree Port 6   03/07/2006 12:00:00 AM 3 3X3   6018372.01456 2097944.0595 37.7415842377244 -122.379054002545 (37.7415842377244, -122.379054002545) 10 3 8 58 1
31430 3675 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100X Cargo Way 111 Sidewalk: Curb side : Cutout Tree Port 6   03/07/2006 12:00:00 AM 3 3X3   6016978.81066 2099030.12804 37.7444894427423 -122.383946883753 (37.7444894427423, -122.383946883753) 10 3 8 58 1
31657 3663 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 100X Cargo Way 99 Sidewalk: Curb side : Cutout Tree Port 6   03/12/1990 12:00:00 AM 3 3X3   6017184.0839 2098879.25737 37.744086528482 -122.383226584333 (37.744086528482, -122.383226584333) 10 3 8 58 1
33186 3613 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 100X Cargo Way 49 Sidewalk: Curb side : Cutout Tree Port 6     6 3X3   6018003.94992 2098219.94993 37.7423214758653 -122.380345828295 (37.7423214758653, -122.380345828295) 10 3 8 58 1
33759 83042 DPW Maintained 1 Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 23 100X Cargo Way 10 Sidewalk: Curb side : Cutout Tree Port 6   03/18/2017 02:54:00 PM 3     6018742.83505 2097668.8048 37.740848882771 -122.37775271773 (37.740848882771, -122.37775271773) 10 3 8 58 1
33883 3629 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 100X Cargo Way 65 Sidewalk: Curb side : Cutout Tree Port 6     6 3X3   6017712.66324 2098437.04484 37.7429014981049 -122.381368111942 (37.7429014981049, -122.381368111942) 10 3 8 58 1
34219 3678 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100X Cargo Way 114 Sidewalk: Curb side : Cutout Tree Port 6     18 3X3   6016900.55326 2099090.71493 37.7446514753884 -122.384221703094 (37.7446514753884, -122.384221703094) 10 3 8 58 1
35545 3632 DPW Maintained 1 Quercus ilex :: Holly Oak 305 100X Cargo Way 68 Sidewalk: Curb side : Cutout Tree Port 6     6 3X3   6017663.5913 2098472.76802 37.7429968775117 -122.381540274588 (37.7429968775117, -122.381540274588) 10 3 8 58 1
35554 3584 DPW Maintained 1 Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 205 100X Cargo Way 19 Sidewalk: Curb side : Cutout Tree Port 6   12/11/1998 12:00:00 AM 3 3X3   6018506.82441 2097843.80813 37.7413163998229 -122.378580911506 (37.7413163998229, -122.378580911506) 10 3 8 58 1
40398 3671 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100X Cargo Way 107 Sidewalk: Curb side : Cutout Tree Port 6     18 3X3   6017047.36981 2098978.83891 37.7443524031345 -122.38370624765 (37.7443524031345, -122.38370624765) 10 3 8 58 1
41537 3684 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100X Cargo Way 120 Sidewalk: Curb side : Cutout Tree Port 6     18 3X3   6016817.82171 2099151.76391 37.7448145287778 -122.384512026728 (37.7448145287778, -122.384512026728) 10 3 8 58 1
42308 3639 DPW Maintained 1 Ceratonia siliqua :: Carob 5 100X Cargo Way 75 Sidewalk: Curb side : Cutout Tree Port 6   03/07/2006 12:00:00 AM 3 3X3   6017551.66161 2098562.89956 37.743238180002 -122.381933568796 (37.743238180002, -122.381933568796) 10 3 8 58 1
44203 3575 Permitted Site 7 Olea europaea :: Olive Tree 9 100X Cargo Way 10 Sidewalk: Curb side : Cutout Tree Port 6   03/01/2006 12:00:00 AM 3 3X3   6018980.3390981 2097500.2540781 37.7403991596993 -122.376919818221 (37.7403991596993, -122.376919818221) 10 3 8 58 1
44228 3670 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100X Cargo Way 106 Sidewalk: Curb side : Cutout Tree Port 6     18 3X3   6017067.53558 2098965.30929 37.7443163682077 -122.383635576218 (37.7443163682077, -122.383635576218) 10 3 8 58 1
45116 83043 DPW Maintained 1 Olea europaea :: Olive Tree 9 100X Cargo Way 9 Sidewalk: Curb side : Cutout Tree Port 6   03/18/2017 02:49:00 PM 3     6018760.27201 2097656.07243 37.7408148829885 -122.377691543139 (37.7408148829885, -122.377691543139) 10 3 8 58 1
46225 3611 DPW Maintained 1 Ceratonia siliqua :: Carob 5 100X Cargo Way 47 Sidewalk: Curb side : Cutout Tree Port 6   05/31/1996 12:00:00 AM 3 3X3   6018038.29611 2098194.83807 37.7422544187983 -122.380225323637 (37.7422544187983, -122.380225323637) 10 3 8 58 1
46442 3681 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 100X Cargo Way 117 Sidewalk: Curb side : Cutout Tree Port 6   05/02/2017 03:27:00 PM 3 3X3   6016866.95731 2099120.49255 37.7447313810499 -122.384339945926 (37.7447313810499, -122.384339945926) 10 3 8 58 1

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