trees
27,746 rows where qCaretaker_id = 1 sorted by TreeID
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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) );