trees
27,746 rows where qCaretaker_id = 1 sorted by Fire Prevention Districts descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4628 | 6858 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2865X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/17/1992 12:00:00 AM | 15 | 3X3 | 5997253 | 2087738 | 37.7123737035526 | -122.451340121886 | (37.7123737035526, -122.451340121886) | 9 | 7 | 6 | 28861 | 25 | ||
| 4837 | 115185 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2300X Alemany Blvd | 2 | Median : Cutout | Tree | DPW 1 | 3 | 5999482.43288 | 2089277.31598 | 37.716727722789 | -122.443745071105 | (37.716727722789, -122.443745071105) | 9 | 7 | 6 | 28861 | 25 | ||||
| 4843 | 260426 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 740 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/17/2019 12:00:00 AM | 3 | 6009322.86982 | 2092462.23119 | 37.726029197201 | -122.409956117368 | (37.726029197201, -122.409956117368) | 9 | 3 | 7 | 309 | 28 | ||
| 4856 | 17502 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 125 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002131.24887 | 2091360.19572 | 37.7225975717171 | -122.434738297838 | (37.7225975717171, -122.434738297838) | 9 | 7 | 6 | 28861 | 5 | |||
| 4902 | 262165 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 725 Delta St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/07/2019 12:00:00 AM | 3 | 6009246.1256 | 2087178.55003 | 37.7115170052904 | -122.409848612702 | (37.7115170052904, -122.409848612702) | 9 | 7 | 8 | 309 | 39 | |||
| 4977 | 11672 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 710X Junipero Serra Blvd | 9 | Median : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991310.6193982 | 2092985.752428 | 37.7264406890913 | -122.472260886614 | (37.7264406890913, -122.472260886614) | 9 | 8 | 4 | 64 | 40 | ||
| 5016 | 29966 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 500x Junipero Serra Blvd | 10 | Median : Cutout | Tree | DPW 1 | 04/01/2007 12:00:00 AM | 3 | 3x3 | 5991400.88182 | 2093544.5626 | 37.7279802659702 | -122.471989567778 | (37.7279802659702, -122.471989567778) | 9 | 8 | 4 | 59 | 40 | ||
| 5066 | 262068 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 800X Alemany Blvd | 8 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004191 | 2094544 | 37.7314563142861 | -122.427844943089 | (37.7314563142861, -122.427844943089) | 9 | 7 | 6 | 28861 | 5 | ||||
| 5134 | 13416 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 442 Marietta Dr | 1 | Median : Cutout | Tree | DPW 1 | 6 | 5 | 5999568.3476194 | 2097073.0677048 | 37.7381379481581 | -122.444007926391 | (37.7381379481581, -122.444007926391) | 9 | 7 | 4 | 59 | 40 | |||
| 5187 | 16150 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 395 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5999449.98722 | 2094649.82142 | 37.7314775324521 | -122.444243069762 | (37.7314775324521, -122.444243069762) | 9 | 7 | 4 | 63 | 40 | |||
| 5384 | 259412 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 900x Geneva Ave | 1 | Median : Cutout | Tree | DPW 1 | 3x3 | 6000287 | 2089053 | 37.7161576592819 | -122.440948005451 | (37.7161576592819, -122.440948005451) | 9 | 7 | 6 | 28861 | 5 | ||||
| 5440 | 258159 | DPW Maintained 1 | Ulmus carpinifolia 'Frontier' :: Frontier Elm 'Frontier' 244 | 760 Felton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 3x5 | 6008719 | 2093255 | 37.7281721087609 | -122.412099667236 | (37.7281721087609, -122.412099667236) | 9 | 3 | 7 | 309 | 28 | ||
| 5481 | 112239 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2400X Alemany Blvd | 4 | Median : Cutout | Tree | DPW 1 | 10/27/2015 07:41:00 AM | 3 | 5999153.8915 | 2088963.97845 | 37.7158486246797 | -122.444858161098 | (37.7158486246797, -122.444858161098) | 9 | 7 | 6 | 28861 | 25 | |||
| 5562 | 261838 | DPW Maintained 1 | Potential Site :: Potential Site 48 | 20x Ruth St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6001536 | 2091749 | 37.7236313283612 | -122.436823756643 | (37.7236313283612, -122.436823756643) | 9 | 7 | 6 | 28861 | 25 | ||||
| 5663 | 261655 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1160 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6000777 | 2086850 | 37.710136608373 | -122.439096536592 | (37.710136608373, -122.439096536592) | 9 | 7 | 6 | 28861 | 5 | ||||
| 5688 | 15705 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 4275 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6003304.89544 | 2093685.57074 | 37.729049093647 | -122.430847134016 | (37.729049093647, -122.430847134016) | 9 | 7 | 6 | 28861 | 5 | |||
| 5746 | 258377 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1036 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3x3 | 6007782.72545 | 2093434.59134 | 37.7286126501976 | -122.415349121053 | (37.7286126501976, -122.415349121053) | 9 | 3 | 7 | 309 | 5 | |||
| 5765 | 112237 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2400X Alemany Blvd | 2 | Median : Cutout | Tree | DPW 1 | 10/27/2015 08:35:00 AM | 3 | 5999175.75859 | 2088985.62206 | 37.71590930104 | -122.444784133402 | (37.71590930104, -122.444784133402) | 9 | 7 | 6 | 28861 | 25 | |||
| 5773 | 180020 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1800x Alemany Blvd | 8 | Median : Cutout | Tree | DPW 1 | 4 | Width 2ft | 6001294.85354 | 2091604.85507 | 37.7232218307036 | -122.437647038084 | (37.7232218307036, -122.437647038084) | 9 | 7 | 6 | 28861 | 25 | |||
| 5837 | 87442 | DPW Maintained 1 | Tree(s) :: 17 | 2801X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/2008 12:00:00 AM | 3x3 | 5997499.095645 | 2087961.159651 | 37.7130005371424 | -122.450505622879 | (37.7130005371424, -122.450505622879) | 9 | 7 | 6 | 28861 | 25 | |||
| 5926 | 258370 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 998 Silliman St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6007899.48346 | 2093470.38454 | 37.7287174922185 | -122.414948012993 | (37.7287174922185, -122.414948012993) | 9 | 3 | 7 | 309 | 28 | |||
| 5967 | 252969 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 101 Whipple Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 5998071 | 2087307 | 37.7112370808248 | -122.448481858962 | (37.7112370808248, -122.448481858962) | 9 | 7 | 6 | 28861 | 25 | ||||
| 5969 | 258129 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 1000 Bowdoin St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 3x5 | 6009416.09812 | 2091494.49671 | 37.7233772263446 | -122.409565560368 | (37.7233772263446, -122.409565560368) | 9 | 3 | 7 | 309 | 28 | ||
| 5977 | 177494 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 1002x Naples St | 8 | Median : Yard | Tree | DPW 1 | 1 | 6001533.96245 | 2088133.73568 | 37.7137045060241 | -122.436572153999 | (37.7137045060241, -122.436572153999) | 9 | 7 | 6 | 28861 | 5 | ||||
| 5982 | 259609 | DPW Maintained 1 | :: 45 | 1035 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6009443.72066 | 2087255.36906 | 37.711739006489 | -122.40917108656 | (37.711739006489, -122.40917108656) | 9 | 7 | 8 | 309 | 39 | ||
| 5995 | 258380 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 80 Somerset St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6009574.25344 | 2094049.89218 | 37.7304026643572 | -122.409199080219 | (37.7304026643572, -122.409199080219) | 9 | 3 | 7 | 309 | 28 | |||
| 6001 | 262052 | DPW Maintained 1 | Tree(s) :: 17 | 851X Alemany Blvd | 3 | Side Yard : Yard | Tree | DPW 1 | 3x3 | 6004188 | 2094500 | 37.7313353304363 | -122.42785218062 | (37.7313353304363, -122.42785218062) | 9 | 7 | 6 | 28861 | 5 | ||||
| 6012 | 16704 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1677X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 29 | 5x6 | 6001608.07304 | 2092347.28192 | 37.7252781710498 | -122.43661741688 | (37.7252781710498, -122.43661741688) | 9 | 7 | 6 | 28861 | 25 | |||
| 6015 | 16176 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 438 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5999154.53701 | 2094721.74383 | 37.731658154085 | -122.445269662966 | (37.731658154085, -122.445269662966) | 9 | 7 | 4 | 59 | 40 | |||
| 6030 | 19323 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 200 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X5 | 5993467.32802 | 2089853.93143 | 37.7179660496774 | -122.4645779904 | (37.7179660496774, -122.4645779904) | 9 | 8 | 6 | 64 | 24 | |||
| 6088 | 258369 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 998 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6007899.48346 | 2093470.38454 | 37.7287174922185 | -122.414948012993 | (37.7287174922185, -122.414948012993) | 9 | 3 | 7 | 309 | 28 | |||
| 6233 | 258390 | DPW Maintained 1 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 642 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 5x5 | 6002875.15558 | 2090065.87943 | 37.7190858723969 | -122.432074396816 | (37.7190858723969, -122.432074396816) | 9 | 7 | 6 | 28861 | 5 | |||
| 6300 | 259616 | DPW Maintained 1 | :: 45 | 941 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6009687.32277 | 2087163.71083 | 37.7115009759818 | -122.408322666595 | (37.7115009759818, -122.408322666595) | 9 | 7 | 8 | 309 | 39 | ||
| 6438 | 29970 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 500X Junipero Serra Blvd | 14 | Median : Cutout | Tree | DPW 1 | 04/01/2007 12:00:00 AM | 3 | 3x3 | 5991349.07674 | 2093718.94394 | 37.7284560756763 | -122.472181363504 | (37.7284560756763, -122.472181363504) | 9 | 8 | 4 | 64 | 40 | ||
| 6515 | 16335 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 862X Monterey Blvd | 5 | Median : Cutout | Tree | DPW 1 | 04/22/2008 12:00:00 AM | 3 | 5 | 5996588.55754 | 2094717.49275 | 37.7314996764704 | -122.454140408353 | (37.7314996764704, -122.454140408353) | 9 | 7 | 4 | 59 | 40 | ||
| 6573 | 262162 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 18 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/07/2019 12:00:00 AM | 3 | 6011290.10954 | 2087489.4095 | 37.7124849020689 | -122.402805875722 | (37.7124849020689, -122.402805875722) | 9 | 7 | 8 | 309 | 39 | ||
| 6610 | 162707 | DPW Maintained 1 | Potential Site :: Potential Site 48 | 730 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | Width 0ft | 5994580.47048 | 2090599.74641 | 37.7200779878775 | -122.460784391892 | (37.7200779878775, -122.460784391892) | 9 | 8 | 6 | 28861 | 24 | |||
| 6620 | 258386 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 100 Hamilton St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 6009028.92475 | 2093781.29726 | 37.7296345936181 | -122.411065400912 | (37.7296345936181, -122.411065400912) | 9 | 3 | 7 | 309 | 28 | ||||
| 6624 | 261657 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1170 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6000734 | 2086848 | 37.7101286699763 | -122.439245009525 | (37.7101286699763, -122.439245009525) | 9 | 7 | 6 | 28861 | 5 | ||||
| 6707 | 15866 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5425 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/1995 12:00:00 AM | 6 | 3X3 | 5999452.41338 | 2088067.62767 | 37.7134044805159 | -122.443761975638 | (37.7134044805159, -122.443761975638) | 9 | 7 | 6 | 28861 | 5 | ||
| 6804 | 1081 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2144 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 5999999.92726 | 2089842.39347 | 37.718308800511 | -122.441996891163 | (37.718308800511, -122.441996891163) | 9 | 7 | 6 | 28861 | 25 | |||
| 6815 | 26065 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 252 Broad St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 5994463.9745 | 2088114.2994 | 37.7132468380661 | -122.461007025599 | (37.7132468380661, -122.461007025599) | 9 | 8 | 6 | 28861 | 24 | |||
| 6823 | 11708 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 700X Junipero Serra Blvd | 25 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991296.5308 | 2092759.13423 | 37.7258176365683 | -122.472293077282 | (37.7258176365683, -122.472293077282) | 9 | 8 | 4 | 64 | 40 | ||
| 6874 | 258105 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 49 Naglee Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5998652.17813 | 2087511.67596 | 37.7118322871785 | -122.446487885746 | (37.7118322871785, -122.446487885746) | 9 | 7 | 6 | 28861 | 25 | |||||
| 6898 | 43451 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 1 | Permit Number 43162 | 5999743.13158 | 2091140.97159 | 37.7218597624867 | -122.442977727254 | (37.7218597624867, -122.442977727254) | 9 | 7 | 6 | 28861 | 25 | |
| 6925 | 43437 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 19 | Permit Number 43162 | 5999381.26407 | 2091328.91122 | 37.7223551630339 | -122.444242104791 | (37.7223551630339, -122.444242104791) | 9 | 7 | 6 | 28861 | 25 | |
| 7054 | 259630 | DPW Maintained 1 | :: 45 | 25 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6011219.86081 | 2087480.59399 | 37.7124567737707 | -122.403048058633 | (37.7124567737707, -122.403048058633) | 9 | 7 | 8 | 309 | 39 | ||
| 7147 | 260402 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 10X Arch St | 1 | Median : Yard | Tree | DPW 1 | 3X5 | 5992587 | 2087523 | 37.7115150847083 | -122.467451465905 | (37.7115150847083, -122.467451465905) | 9 | 8 | 4 | 64 | 24 | ||||
| 7186 | 262074 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 800X Alemany Blvd | 14 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004191 | 2094544 | 37.7314563142861 | -122.427844943089 | (37.7314563142861, -122.427844943089) | 9 | 7 | 6 | 28861 | 5 | ||||
| 7204 | 262178 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 235 Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/07/2019 12:00:00 AM | 3 | 6009840.919 | 2087844.03033 | 37.713377594646 | -122.407839737463 | (37.713377594646, -122.407839737463) | 9 | 7 | 8 | 309 | 39 | ||
| 7232 | 262073 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 800X Alemany Blvd | 13 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004191 | 2094544 | 37.7314563142861 | -122.427844943089 | (37.7314563142861, -122.427844943089) | 9 | 7 | 6 | 28861 | 5 | ||||
| 7244 | 171732 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 1000 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 0 | 3x5 | 6007830.37334 | 2093450.39965 | 37.7286587343082 | -122.415185517621 | (37.7286587343082, -122.415185517621) | 9 | 3 | 7 | 309 | 5 | ||
| 7281 | 258376 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1030 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3x3 | 6007799.31029 | 2093439.67558 | 37.7286275425489 | -122.415292145905 | (37.7286275425489, -122.415292145905) | 9 | 3 | 7 | 309 | 5 | |||
| 7294 | 259631 | DPW Maintained 1 | :: 45 | 86 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6010819.87099 | 2087731.57587 | 37.7131235744523 | -122.404448208813 | (37.7131235744523, -122.404448208813) | 9 | 7 | 8 | 309 | 39 | ||
| 7312 | 254991 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1508 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/21/2020 12:00:00 PM | 3 | 4x4 | 6002019 | 2093366 | 37.7280986838153 | -122.435269719024 | (37.7280986838153, -122.435269719024) | 9 | 7 | 6 | 28861 | 25 | ||
| 7337 | 15078 | DPW Maintained 1 | Washingtonia filifera :: California Fan Palm 176 | 60 Minerva St | 1 | Median : Cutout | Tree | DPW 1 | 3 | 11 | 5996206.9344238 | 2089043.0380608 | 37.7158970804766 | -122.455049862348 | (37.7158970804766, -122.455049862348) | 9 | 8 | 6 | 28861 | 24 | |||
| 7347 | 262056 | DPW Maintained 1 | Tree(s) :: 17 | 851X Alemany Blvd | 7 | Side Yard : Yard | Tree | DPW 1 | 3x3 | 6004188 | 2094500 | 37.7313353304363 | -122.42785218062 | (37.7313353304363, -122.42785218062) | 9 | 7 | 6 | 28861 | 5 | ||||
| 7353 | 16291 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 710 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/31/2001 12:00:00 AM | 3 | 3x3 | 5997353.28432 | 2094748.65298 | 37.7316290565338 | -122.451498861191 | (37.7316290565338, -122.451498861191) | 9 | 7 | 4 | 59 | 40 | ||
| 7360 | 91134 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 400X Trumbull St | 2 | Median : Cutout | Tree | DPW 1 | 3 | 3x3 | 6005738.144013 | 2094265.96683 | 37.730780298312 | -122.422476416564 | (37.730780298312, -122.422476416564) | 9 | 7 | 6 | 28861 | 5 | |||
| 7457 | 2165 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 119X Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/1997 12:00:00 AM | 12 | 3X27 | 5993658.6263 | 2088481.9826 | 37.7142100327703 | -122.463817234952 | (37.7142100327703, -122.463817234952) | 9 | 8 | 6 | 64 | 24 | ||
| 7465 | 17540 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 512 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6002977.3728 | 2090782.38877 | 37.721059043035 | -122.431772202434 | (37.721059043035, -122.431772202434) | 9 | 7 | 6 | 28861 | 5 | |||
| 7473 | 122856 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3000X Alemany Blvd | 3 | Median : Cutout | Tree | DPW 1 | 12/08/2016 01:13:00 PM | 3 | 3x3 | 5996611.63138 | 2087256.15424 | 37.7110139206266 | -122.45352210466 | (37.7110139206266, -122.45352210466) | 9 | 7 | 6 | 28861 | 25 | ||
| 7480 | 180280 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1204x Alemany Blvd | 18 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 6002728.35558 | 2094064.39346 | 37.7300565721367 | -122.432867327564 | (37.7300565721367, -122.432867327564) | 9 | 7 | 6 | 28861 | 25 | |||
| 7535 | 264754 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 176 Hahn St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007577 | 2087516 | 37.7123498887131 | -122.4156414431 | (37.7123498887131, -122.4156414431) | 9 | 7 | 8 | 309 | 39 | ||||
| 7566 | 264756 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 176 Hahn St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007577 | 2087516 | 37.7123498887131 | -122.4156414431 | (37.7123498887131, -122.4156414431) | 9 | 7 | 8 | 309 | 39 | ||||
| 7600 | 12920 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2981X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3x3 | 5996820.13855 | 2087345.5314 | 37.7112712800431 | -122.452807904632 | (37.7112712800431, -122.452807904632) | 9 | 7 | 6 | 28861 | 25 | |||
| 7628 | 262385 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 900x Geneva Ave | 12 | Median : Cutout | Tree | DPW 1 | 3x3 | 6000362 | 2089058 | 37.7161756595217 | -122.440689128694 | (37.7161756595217, -122.440689128694) | 9 | 7 | 6 | 28861 | 5 | ||||
| 7686 | 116544 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1041x Naples St | 7 | Median : Yard | Tree | DPW 1 | 5 | 3x3 | 6001586.02621 | 2088182.95127 | 37.7138425996209 | -122.436395723209 | (37.7138425996209, -122.436395723209) | 9 | 7 | 6 | 28861 | 5 | |||
| 7695 | 262179 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 255 Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/07/2019 12:00:00 AM | 3 | 6009723.14992 | 2087886.44693 | 37.713487468075 | -122.408249780165 | (37.713487468075, -122.408249780165) | 9 | 7 | 8 | 309 | 39 | ||
| 7724 | 259614 | DPW Maintained 1 | :: 45 | 928 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6009731.2164 | 2087189.88087 | 37.7115752914499 | -122.408172802554 | (37.7115752914499, -122.408172802554) | 9 | 7 | 8 | 309 | 39 | ||
| 7745 | 28428 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2499 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/2003 12:00:00 AM | 12 | 3X3 | 5991618.4954 | 2094538.91045 | 37.7307230868187 | -122.471309697155 | (37.7307230868187, -122.471309697155) | 9 | 8 | 4 | 59 | 40 | ||
| 7766 | 30822 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 151 Lippard Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/06/1995 12:00:00 AM | Permit Number 34679 | 6001848.24049432 | 2095191.22581593 | 37.7331006378237 | -122.435990589821 | (37.7331006378237, -122.435990589821) | 9 | 7 | 5 | 63 | 40 | |||
| 7789 | 259629 | DPW Maintained 1 | :: 45 | 18 Arleta Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6011290.10954 | 2087489.4095 | 37.7124849020689 | -122.402805875722 | (37.7124849020689, -122.402805875722) | 9 | 7 | 8 | 309 | 39 | |||
| 7809 | 258391 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 701 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 5x5 | 6002214.93495 | 2089702.35217 | 37.7180502540861 | -122.434330546175 | (37.7180502540861, -122.434330546175) | 9 | 7 | 6 | 28861 | 5 | |||
| 7813 | 206807 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 11x Saint Francis Blvd | 1 | Median : Yard | Tree | DPW 1 | 12 | 5991689.22153 | 2095992.93147 | 37.7347195542573 | -122.471171081279 | (37.7347195542573, -122.471171081279) | 9 | 8 | 4 | 59 | 40 | ||||
| 7856 | 259620 | DPW Maintained 1 | :: 45 | 1230 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6008944.20258 | 2087484.57598 | 37.7123403644372 | -122.410913742428 | (37.7123403644372, -122.410913742428) | 9 | 7 | 8 | 309 | 39 | ||
| 7938 | 369 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3690X 19th Ave | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 25 | 2 | 5990489.74295 | 2091103.38095 | 37.7212246253626 | -122.474961247113 | (37.7212246253626, -122.474961247113) | 9 | 8 | 4 | 64 | 40 | ||
| 8002 | 212121 | DPW Maintained 1 | Tree(s) :: 17 | 2101x Monterey Blvd | 3 | Median : Yard | Tree | DPW 1 | 11/27/2019 12:00:00 AM | 3 | Width 10ft | Permit Number 784468 | 5991651 | 2095488 | 37.7333309287491 | -122.471266448142 | (37.7333309287491, -122.471266448142) | 9 | 8 | 4 | 59 | 40 | |
| 8097 | 26292 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1900X San Jose Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/20/1997 12:00:00 AM | 3 | 3X3 | 5999828.34203 | 2092450.55637 | 37.725460439341 | -122.442777166756 | (37.725460439341, -122.442777166756) | 9 | 7 | 6 | 28861 | 25 | ||
| 8134 | 1169 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2900 Alemany Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 5996958.76452 | 2087574.18326 | 37.7119070481533 | -122.452345269826 | (37.7119070481533, -122.452345269826) | 9 | 7 | 6 | 28861 | 25 | |||
| 8151 | 112241 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2400X Alemany Blvd | 6 | Median : Cutout | Tree | DPW 1 | 10/27/2015 07:34:00 AM | 3 | 5999126.802 | 2088939.36005 | 37.71577948212 | -122.444950025942 | (37.71577948212, -122.444950025942) | 9 | 7 | 6 | 28861 | 25 | |||
| 8161 | 262050 | DPW Maintained 1 | Tree(s) :: 17 | 851X Alemany Blvd | 1 | Side Yard : Yard | Tree | DPW 1 | 3x3 | 6004188 | 2094500 | 37.7313353304363 | -122.42785218062 | (37.7313353304363, -122.42785218062) | 9 | 7 | 6 | 28861 | 5 | ||||
| 8192 | 258125 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 731 Woolsey St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 3x5 | 6009632.88512 | 2091554.43402 | 37.7235539468335 | -122.408820391364 | (37.7235539468335, -122.408820391364) | 9 | 3 | 7 | 309 | 28 | |||
| 8233 | 111536 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 900x BOSWORTH ST | 14 | Front Yard : Yard | Tree | DPW 1 | 24 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | ||||
| 8417 | 259628 | DPW Maintained 1 | :: 45 | 100 Britton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6008465.19154 | 2087632.83273 | 37.7127205750598 | -122.412579828323 | (37.7127205750598, -122.412579828323) | 9 | 7 | 8 | 309 | 39 | ||
| 8458 | 259610 | DPW Maintained 1 | :: 45 | 1107 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 6009254.2033 | 2087326.13058 | 37.7119226839796 | -122.409831104788 | (37.7119226839796, -122.409831104788) | 9 | 7 | 8 | 309 | 39 | ||||
| 8506 | 258378 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1100 Silliman St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3x5 | 6007594.19766 | 2093376.79647 | 37.7284433601031 | -122.415996783146 | (37.7284433601031, -122.415996783146) | 9 | 3 | 7 | 309 | 5 | |||
| 8719 | 258160 | DPW Maintained 1 | Ulmus carpinifolia 'Frontier' :: Frontier Elm 'Frontier' 244 | 760 Felton St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6008719 | 2093255 | 37.7281721087609 | -122.412099667236 | (37.7281721087609, -122.412099667236) | 9 | 3 | 7 | 309 | 28 | |||
| 8749 | 934 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1295 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X6 | 6002685.65968 | 2093990.26069 | 37.7298505986268 | -122.43300963811 | (37.7298505986268, -122.43300963811) | 9 | 7 | 6 | 28861 | 25 | |||
| 8773 | 262076 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 800X Alemany Blvd | 16 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004191 | 2094544 | 37.7314563142861 | -122.427844943089 | (37.7314563142861, -122.427844943089) | 9 | 7 | 6 | 28861 | 5 | ||||
| 8921 | 259414 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 900x Geneva Ave | 3 | Median : Cutout | Tree | DPW 1 | 3x3 | 6000362 | 2089058 | 37.7161756595217 | -122.440689128694 | (37.7161756595217, -122.440689128694) | 9 | 7 | 6 | 28861 | 5 | ||||
| 8942 | 259632 | DPW Maintained 1 | :: 45 | 31 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6011179.21594 | 2087501.52553 | 37.7125119777417 | -122.40319001201 | (37.7125119777417, -122.40319001201) | 9 | 7 | 8 | 309 | 39 | ||
| 8985 | 26035 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 32 Broad St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/19/1997 12:00:00 AM | 12 | 3X3 | 5996388.1269 | 2088087.32843 | 37.713283317556 | -122.454354585517 | (37.713283317556, -122.454354585517) | 9 | 8 | 6 | 28861 | 24 | ||
| 8998 | 208278 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 20 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 5995821.66146 | 2098283.49942 | 37.7412470549149 | -122.457049545217 | (37.7412470549149, -122.457049545217) | 9 | 7 | 4 | 59 | 40 | |||
| 9028 | 259394 | DPW Maintained 1 | Potential Site :: Potential Site 48 | 700 Grafton Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Width 0ft | 5994645.44681 | 2090598.07212 | 37.7200771290263 | -122.460559671092 | (37.7200771290263, -122.460559671092) | 9 | 8 | 6 | 28861 | 24 | ||||
| 9033 | 254440 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 501X Brotherhood Way | 20 | Median : Yard | Tree | DPW 1 | 10x10 | 5992686 | 2087818 | 37.7123307991194 | -122.467130733446 | (37.7123307991194, -122.467130733446) | 9 | 8 | 4 | 64 | 24 | ||||
| 9132 | 25380 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1315 Geneva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/04/2003 12:00:00 AM | 12 | 3X3 | 6002230.18921 | 2088039.80094 | 37.7134861217893 | -122.434159032437 | (37.7134861217893, -122.434159032437) | 9 | 7 | 6 | 28861 | 5 | ||
| 9212 | 259382 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 225 Whipple Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 5997701 | 2087724 | 37.7123609051901 | -122.449790697309 | (37.7123609051901, -122.449790697309) | 9 | 7 | 6 | 28861 | 25 | ||||
| 9230 | 27347 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 300X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 3 | 2X2 | 5991444.7104442 | 2094652.0546396 | 37.7310236980815 | -122.471918736195 | (37.7310236980815, -122.471918736195) | 9 | 8 | 4 | 64 | 40 | ||
| 9309 | 258372 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 1000 Silliman St | 2 | Sidewalk: Property side : Cutout | Tree | DPW 1 | FUF | 3x5 | 6007882.23453 | 2093465.09674 | 37.7287020037839 | -122.415007269683 | (37.7287020037839, -122.415007269683) | 9 | 3 | 7 | 309 | 5 |
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) );