27,746 rows where qCaretaker_id = 1 sorted by TreeID

View and edit SQL

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)
138186 1 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 10 10th Ave 1 Median : Cutout Tree DPW 1     3 16   5992719.40718 2114869.71245 37.7866097734767 -122.468982710496 (37.7866097734767, -122.468982710496) 11 6 1 54 11
34993 10 DPW Maintained 1 Palm (unknown Genus) :: Palm Spp 273 97 12th St 4 Median : Cutout Tree DPW 1     20 3X3   6007166.5822125 2109668.7679164 37.7731533608049 -122.418629924651 (37.7731533608049, -122.418629924651) 8 2 9 28853 19
60856 1000 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1726 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     20 3X5PL   6001385.76767 2092068.06757 37.724498876108 -122.437365919005 (37.724498876108, -122.437365919005) 9 7 6 28861 25
181241 10001 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 145 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X2   6005474.27283 2108090.23028 37.7687236538132 -122.424371552702 (37.7687236538132, -122.424371552702) 8 4 5 28853 19
81417 10002 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 145 Guerrero St 2 Sidewalk: Curb side : Cutout Tree DPW 1   09/19/2014 12:50:00 PM 3 3X2   6005473.70519 2108134.2356 37.7688444498294 -122.424376646466 (37.7688444498294, -122.424376646466) 8 4 5 28853 19
119271 10004 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 150 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     28 3X3   6005403.33839 2108127.1988 37.7688211546939 -122.424619539876 (37.7688211546939, -122.424619539876) 8 4 5 28853 19
153196 10005 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 156 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6005408.68432 2108096.72474 37.7687377821415 -122.424598880629 (37.7687377821415, -122.424598880629) 8 4 5 28853 19
72431 10007 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 170 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     20 3X3   6005407.88099 2108072.95104 37.7686724598889 -122.424599967939 (37.7686724598889, -122.424599967939) 8 4 5 28853 19
68163 10008 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 170 Guerrero St 2 Sidewalk: Curb side : Cutout Tree DPW 1     22 3X3   6005410.95643 2108039.08035 37.7685796327732 -122.424586920555 (37.7685796327732, -122.424586920555) 8 4 5 28853 19
84704 10009 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 170 Guerrero St 3 Sidewalk: Curb side : Cutout Tree DPW 1     22 3X3   6005412.73113 2108018.38384 37.7685229053392 -122.4245793096 (37.7685229053392, -122.4245793096) 8 4 5 28853 19
149997 1001 DPW Maintained 1 Ulmus pumila :: Siberian Elm 99 1731 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     27 3X3   6001471.07065 2092002.59485 37.724323951976 -122.437066353202 (37.724323951976, -122.437066353202) 9 7 6 28861 25
108815 10011 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 198 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     25 2X3   6005417.15338 2107897.14895 37.7681902730979 -122.424555388522 (37.7681902730979, -122.424555388522) 8 4 5 28853 19
100677 10013 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 215 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x2   6005495.275 2107715.11687 37.7676948680391 -122.424272225299 (37.7676948680391, -122.424272225299) 8 4 5 28853 19
5282 10014 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 224 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/11/2016 06:44:00 AM 3 2x3   6005430.43675 2107671.80391 37.7675722796594 -122.424493411759 (37.7675722796594, -122.424493411759) 8 4 5 28853 19
10710 10015 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 232 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1   08/02/2019 12:00:00 AM 3 3x3   6005430.70254 2107623.59079 37.7674399129618 -122.424489062615 (37.7674399129618, -122.424489062615) 8 4 5 28853 19
11894 10016 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 236 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/11/2016 06:59:00 AM 3 3x3   6005434.04749 2107587.52272 37.7673410675527 -122.42447492707 (37.7673410675527, -122.42447492707) 8 4 5 28853 19
164886 100169 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 180X Manchester St   Back Yard : Yard Tree DPW 1         Adjacent to rear of property - DPW parcel 6008242 2099158 37.7443536844995 -122.414166136282 (37.7443536844995, -122.414166136282) 2 7 7 28859 2
166798 10017 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 240 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1   10/24/2012 12:00:00 AM 1 3x3   6005435.61743 2107572.1515 37.7672989505107 -122.424468403392 (37.7672989505107, -122.424468403392) 8 4 5 28853 19
137124 100186 DPW Maintained 1 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 2445 HARRISON ST 3 Sidewalk: Curb side : Cutout Tree DPW 1     8 3x3   6008897 2104213 37.7582703522428 -122.41225848425 (37.7582703522428, -122.41225848425) 2 4 7 28859 19
29237 1002 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1731 Alemany Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1     27 3X3   6001471.07065 2092002.59485 37.724323951976 -122.437066353202 (37.724323951976, -122.437066353202) 9 7 6 28861 25
8493 10021 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 274 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/01/2018 12:00:00 AM 3 3x4   6005443.44254 2107417.66285 37.7668752034469 -122.424430347706 (37.7668752034469, -122.424430347706) 8 4 5 28853 19
57105 10022 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 282 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/01/2003 12:00:00 AM 3 2x2   6005445.78054 2107378.48496 37.7667677623348 -122.424419474005 (37.7667677623348, -122.424419474005) 8 4 5 28853 19
50953 1003 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1750 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     30 3X3   6001350.47669 2091970.9547 37.7242302198351 -122.437480963901 (37.7242302198351, -122.437480963901) 9 7 6 28861 25
189963 10030 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 307 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3PL   6005523.84407 2107170.82921 37.76620199705 -122.424134695569 (37.76620199705, -122.424134695569) 8 4 5 28853 19
110386 10031 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 310 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     100 2x3   6005459.49344 2107143.42218 37.7661231103266 -122.424355322653 (37.7661231103266, -122.424355322653) 8 4 5 28853 19
8685 10038 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 360 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     30 3X3   6005474.31982 2106984.12162 37.7656865461171 -122.424292710045 (37.7656865461171, -122.424292710045) 8 4 5 28853 19
140093 10039 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 360 Guerrero St 2 Sidewalk: Curb side : Cutout Tree DPW 1   01/25/1991 12:00:00 AM 20 3X3   6005477.19258 2106955.99773 37.76560948682 -122.424280773358 (37.76560948682, -122.424280773358) 8 4 5 28853 19
174779 10040 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 360 Guerrero St 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6005476.56858 2106925.65434 37.7655261358546 -122.424280773346 (37.7655261358546, -122.424280773346) 8 4 5 28853 19
75410 10041 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 360 Guerrero St 4 Sidewalk: Curb side : Cutout Tree DPW 1   02/02/1991 12:00:00 AM 20 3X3   6005475.31081 2106892.46038 37.7654349221143 -122.424282762643 (37.7654349221143, -122.424282762643) 8 4 5 28853 19
110173 10042 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 360 Guerrero St 5 Sidewalk: Curb side : Cutout Tree DPW 1     20 3X3   6005475.5325 2106875.27322 37.7653877427782 -122.424280773365 (37.7653877427782, -122.424280773365) 8 4 5 28853 19
186885 10043 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 360 Guerrero St 6 Sidewalk: Curb side : Cutout Tree DPW 1     20 3X3   6005477.51423 2106859.76809 37.765345281278 -122.424272816157 (37.765345281278, -122.424272816157) 8 4 5 28853 19
189420 10044 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 360 Guerrero St 7 Sidewalk: Curb side : Cutout Tree DPW 1     30 3X3   6005474.87318 2106843.21233 37.7652996739685 -122.424280773353 (37.7652996739685, -122.424280773353) 8 4 5 28853 19
130223 10046 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 380 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     20 3X3   6005478.63749 2106816.50174 37.7652265455926 -122.424265853604 (37.7652265455926, -122.424265853604) 8 4 5 28853 19
119544 10047 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 380 Guerrero St 2 Sidewalk: Curb side : Cutout Tree DPW 1   12/13/2009 12:00:00 AM 8 3X3   6005478.32549 2106801.33005 37.765184870121 -122.424265853606 (37.765184870121, -122.424265853606) 8 4 5 28853 19
123095 10048 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 388 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/12/2014 12:00:00 AM 3 3X3   6005479.4973627 2106724.9559124 37.7649752310589 -122.424256368065 (37.7649752310589, -122.424256368065) 8 4 5 28853 19
70006 10050 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 390 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     45 3X3   6005481.13253 2106756.02425 37.7650606296618 -122.424252922232 (37.7650606296618, -122.424252922232) 8 4 5 28853 19
147500 10051 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 398 Guerrero St 2 Sidewalk: Curb side : Cutout Tree DPW 1   12/11/2009 12:00:00 AM 16 3X3   6005480.85974 2106714.7911 37.7649473978257 -122.424250932944 (37.7649473978257, -122.424250932944) 8 4 5 28853 19
26263 10052 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 394 Guerrero St 3 Sidewalk: Curb side : Cutout Tree DPW 1   09/02/2005 12:00:00 AM 16 3X3   6005485.0846607 2106684.1712003 37.7648635614138 -122.424234142103 (37.7648635614138, -122.424234142103) 8 4 5 28853 19
128483 100535 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 2050X Market St 5 Median : Cutout Tree DPW 1     36 8   6004529.3 2108103.5 37.7687066827543 -122.427641088373 (37.7687066827543, -122.427641088373) 7 4 5 28862 3
96272 100536 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 2050X Market St 6 Median : Cutout Tree DPW 1     36 8   6004529.3 2108103.5 37.7687066827543 -122.427641088373 (37.7687066827543, -122.427641088373) 7 4 5 28862 3
23067 100537 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 2010X Market St 1 Median : Cutout Tree DPW 1     36 8   6004815.4 2108376.1 37.7694713555808 -122.426670904591 (37.7694713555808, -122.426670904591) 7 4 5 28862 3
173092 100538 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 2010X Market St 2 Median : Cutout Tree DPW 1     36 8   6004815.4 2108376.1 37.7694713555808 -122.426670904591 (37.7694713555808, -122.426670904591) 7 4 5 28862 3
124663 100539 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 2010X Market St 3 Median : Cutout Tree DPW 1     36 8   6004815.4 2108376.1 37.7694713555808 -122.426670904591 (37.7694713555808, -122.426670904591) 7 4 5 28862 3
153413 10054 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 426 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     80 3X2   6005501.95571 2106458.62904 37.764245228771 -122.424159747992 (37.764245228771, -122.424159747992) 8 4 5 28859 19
133621 100540 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 2010X Market St 4 Median : Cutout Tree DPW 1     36 8   6004815.4 2108376.1 37.7694713555808 -122.426670904591 (37.7694713555808, -122.426670904591) 7 4 5 28862 3
87906 10055 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 432 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     90 3X2   6005503.26278 2106415.24362 37.7641261764966 -122.424152141508 (37.7641261764966, -122.424152141508) 8 4 5 28859 19
35158 100568 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 868 Folsom St 2 Sidewalk: Curb side : Cutout Tree DPW 1     3 3x3   6011788.1802 2112369.4793 37.780828003664 -122.40283310111 (37.780828003664, -122.40283310111) 6 2 9 28853 34
118184 10057 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 439 Guerrero St 2 Sidewalk: Curb side : Cutout Tree DPW 1   06/09/2016 06:50:00 AM 3 3X3   6005566.67326 2106440.43668 37.7641989307536 -122.423934614407 (37.7641989307536, -122.423934614407) 8 4 5 28859 19
187519 10058 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 451 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x5   6005573.31758 2106314.3851 37.763853198087 -122.4239026696 (37.763853198087, -122.4239026696) 8 4 5 28859 19
10559 10061 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 490 Guerrero St 2 Sidewalk: Curb side : Cutout Tree DPW 1     60 2X2   6005517.65207 2106131.14555 37.7633469229371 -122.424082167969 (37.7633469229371, -122.424082167969) 8 4 5 28859 19
84387 100665 Permitted Site 7 Tree(s) :: 17 63 Walter St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 09/04/2012 12:00:00 AM   3x3 Permit Number 769258 6003201.8 2107946.7 37.7682009695292 -122.432221606092 (37.7682009695292, -122.432221606092) 15 5 5 28862 3
36953 10067 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 545 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/19/1992 12:00:00 AM 6 3x3   6005600.27416 2105821.78074 37.7625021447809 -122.423774406467 (37.7625021447809, -122.423774406467) 8 4 5 28859 19
142003 10068 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 549 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4x4   6005603.73706 2105778.33301 37.762383043055 -122.423759340124 (37.762383043055, -122.423759340124) 8 4 5 28859 19
98229 1007 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1827 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/06/2006 12:00:00 AM 10 3X3   6001335.27273 2091591.54514 37.7231875827374 -122.437506364337 (37.7231875827374, -122.437506364337) 9 7 6 28861 25
96105 10071 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 563 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 2x3   6005607.25335 2105721.20389 37.7622263784702 -122.423743116346 (37.7622263784702, -122.423743116346) 8 4 5 28859 19
122217 10072 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 573 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6005609.84736 2105668.09746 37.7620807071743 -122.423730368485 (37.7620807071743, -122.423730368485) 8 4 5 28859 19
157767 10076 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 600 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     70 2x2   6005555.84644 2105437.30746 37.7614439637781 -122.423900725242 (37.7614439637781, -122.423900725242) 2 4 5 28859 19
194159 10077 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 611 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6005621.78486 2105416.82041 37.7613914334809 -122.423671214664 (37.7613914334809, -122.423671214664) 2 4 5 28859 19
38084 10079 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 614 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     50 3X3   6005561.0033 2105378.47551 37.7612827162343 -122.423878706238 (37.7612827162343, -122.423878706238) 2 4 5 28859 19
153679 100816 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 261 06th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     7 3x3   6010798.79921 2111766.85068 37.7791180333094 -122.406213398837 (37.7791180333094, -122.406213398837) 14 2 9 28853 34
9499 10082 DPW Maintained 1 Ulmus spp :: Elm Spp 98 635 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 2X2   6005631.67807 2105272.56381 37.7609958972634 -122.42362674139 (37.7609958972634, -122.42362674139) 2 4 5 28859 19
129923 10088 DPW Maintained 1 Ligustrum japonicum :: Japanese Privet 232 680 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X2   6005576.87933 2105026.12376 37.760316137501 -122.423798743025 (37.760316137501, -122.423798743025) 2 4 5 28859 19
126060 10089 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 700 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     80 3X3   6005586.51976 2104851.24563 37.7598365074586 -122.423752966647 (37.7598365074586, -122.423752966647) 2 4 5 28859 19
83562 10092 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 708 Guerrero St 2 Sidewalk: Curb side : Cutout Tree DPW 1   01/27/2009 12:00:00 AM 6 3X3   6005588.90911 2104804.48181 37.7597082398685 -122.423741377976 (37.7597082398685, -122.423741377976) 2 4 5 28859 19
6865 10095 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 727 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/01/2015 12:00:00 AM 3 2X2   6005664.236 2104708.85405 37.759449920391 -122.423474060781 (37.759449920391, -122.423474060781) 2 4 5 28859 19
136011 100962 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 55 Hawthorne St 2 Sidewalk: Curb side : Cutout Tree DPW 1 Private 04/03/2013 12:00:00 AM 18 3x3 Permit Number 768706 6013015.61085 2114021.62606 37.7854328757839 -122.39870276924 (37.7854328757839, -122.39870276924) 6 2 9 28855 6
108778 10097 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 744 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     30 2X2   6005593.39843 2104652.72108 37.7592917939369 -122.423715061076 (37.7592917939369, -122.423715061076) 2 4 5 28859 19
28708 1010 DPW Maintained 1 Ulmus pumila :: Siberian Elm 99 1840X Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     35 3X3   6001180.26428 2091487.57144 37.7228932804007 -122.438034753125 (37.7228932804007, -122.438034753125) 9 7 6 28861 25
125007 10100 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 750 Guerrero St 2 Sidewalk: Curb side : Cutout Tree DPW 1   05/22/1995 12:00:00 AM 40 2x2   6005607.26399 2104540.55602 37.7589845976709 -122.423659132264 (37.7589845976709, -122.423659132264) 2 4 5 28859 19
162124 101027 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1010X Portola Dr 1 Front Yard : Yard Tree DPW 1           5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621) 1 7 4 59 40
178118 101028 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1010X Portola Dr 2 Front Yard : Yard Tree DPW 1           5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621) 1 7 4 59 40
108055 101029 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1010X Portola Dr 3 Front Yard : Yard Tree DPW 1           5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621) 1 7 4 59 40
22712 101030 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1010X Portola Dr 4 Median : Yard Tree DPW 1     40     5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621) 1 7 4 59 40
161324 101031 DPW Maintained 1 Sequoiadendron giganteum :: Sierra Redwood 240 1010X Portola Dr 5 Front Yard : Yard Tree DPW 1           5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621) 1 7 4 59 40
28896 101032 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1010X Portola Dr 6 Front Yard : Yard Tree DPW 1           5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621) 1 7 4 59 40
30134 101033 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 1010X Portola Dr 7 Front Yard : Yard Tree DPW 1           5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621) 1 7 4 59 40
183595 101034 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1010X Portola Dr 8 Front Yard : Yard Tree DPW 1           5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621) 1 7 4 59 40
137630 101035 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1010X Portola Dr 9 Front Yard : Yard Tree DPW 1   09/03/2014 12:00:00 AM 3     5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621) 1 7 4 59 40
122378 101036 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1010X Portola Dr 10 Front Yard : Yard Tree DPW 1   04/11/2013 12:00:00 AM 3     5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621) 1 7 4 59 40
112172 101037 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1010X Portola Dr 11 Front Yard : Yard Tree DPW 1           5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621) 1 7 4 59 40
175191 101038 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1010X Portola Dr 12 Front Yard : Yard Tree DPW 1           5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621) 1 7 4 59 40
109137 101039 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1010X Portola Dr 13 Front Yard : Yard Tree DPW 1   08/23/2014 12:00:00 AM       5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621) 1 7 4 59 40
165137 101040 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1010X Portola Dr 14 Front Yard : Yard Tree DPW 1   04/11/2013 12:00:00 AM 3     5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621) 1 7 4 59 40
26201 10106 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 785 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 2X2   6005679.32961 2104414.6071 37.7586428391006 -122.423400941414 (37.7586428391006, -122.423400941414) 2 4 5 28859 19
119561 101064 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 380X Beacon St 2 Median : Cutout Tree DPW 1     3 3x3   6002433 2098186.8 37.7413589965156 -122.434182997537 (37.7413589965156, -122.434182997537) 2 7 5 63 7
40548 101065 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 380X Beacon St 1 Median : Cutout Tree DPW 1     3 3x3   6002433 2098186.8 37.7413589965156 -122.434182997537 (37.7413589965156, -122.434182997537) 2 7 5 63 7
172510 10107 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 799X Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/02/2014 06:59:00 AM 3 3x4   6005682.50344 2104371.22039 37.7585238884792 -122.423386880525 (37.7585238884792, -122.423386880525) 2 4 5 28859 19
129274 10108 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 799X Guerrero St 2 Sidewalk: Curb side : Cutout Tree DPW 1   12/02/2014 06:48:00 AM 3 3x3   6005680.61411 2104397.9808 37.7585972596694 -122.423395317067 (37.7585972596694, -122.423395317067) 2 4 5 28859 19
131459 10112 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 821 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 3x3   6005694.08607 2104163.28117 37.7579535897166 -122.423332040744 (37.7579535897166, -122.423332040744) 2 4 5 28859 19
123731 10113 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 827 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 3X3   6005696.52511 2104103.91625 37.757790725171 -122.423319385483 (37.757790725171, -122.423319385483) 2 4 5 28859 19
37532 10114 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 827 Guerrero St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6005696.25247 2104120.31934 37.7578357488369 -122.423321494416 (37.7578357488369, -122.423321494416) 2 4 5 28859 19
81026 10115 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 827 Guerrero St 3 Sidewalk: Curb side : Cutout Tree DPW 1     3 3x3   6005698.17392 2104144.57278 37.7579024515588 -122.423316573309 (37.7579024515588, -122.423316573309) 2 4 5 28859 19
106701 10117 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 845 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6005699.22258 2104067.01691 37.7576895604408 -122.423307433493 (37.7576895604408, -122.423307433493) 2 4 5 28859 19
53719 10118 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 845 Guerrero St 2 Sidewalk: Curb side : Cutout Tree DPW 1   02/01/1990 12:00:00 AM 3 3X3   6005704.2510557 2104056.9285895 37.7576621440613 -122.423289325813 (37.7576621440613, -122.423289325813) 2 4 5 28859 19
193072 10119 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 850 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1   07/06/1992 12:00:00 AM 18 3X3   6005631.880167 2104012.3184419 37.757535570368 -122.423536442741 (37.757535570368, -122.423536442741) 2 4 5 28859 19
98169 1012 DPW Maintained 1 Ulmus americana :: American Elm 74 1845 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     36 3X3   6001257.97709 2091441.77631 37.7227719565453 -122.437762838379 (37.7227719565453, -122.437762838379) 9 7 6 28861 25
74513 10124 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 877 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 3X3   6005714.7162163 2103867.2939475 37.7571420422058 -122.42323965319 (37.7571420422058, -122.42323965319) 2 4 5 28859 19
148725 10125 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 876 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/11/2015 02:57:00 PM 3 3x3   6005640.44198 2103866.83654 37.7571365942954 -122.423496489872 (37.7571365942954, -122.423496489872) 2 4 5 28859 19
58452 101254 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 3700X Cesar Chavez St 1 Front Yard : Yard Tree DPW 1           6005840.6 2100555.6 37.7480559984104 -122.422568977073 (37.7480559984104, -122.422568977073) 2 4 5 28859 19
137681 101255 DPW Maintained 1 x Chiranthofremontia lenzii :: Hybrid Monkey Hand Tree 552 3700X Cesar Chavez St 2 Front Yard : Yard Tree DPW 1           6005840.6 2100555.6 37.7480559984104 -122.422568977073 (37.7480559984104, -122.422568977073) 2 4 5 28859 19

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