trees
163,064 rows where qCaretaker_id = 2 sorted by rowid 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 194395 | 183689 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1351 42nd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5983050 | 2105938 | 37.7615224629013 | -122.501774892125 | (37.7615224629013, -122.501774892125) | 1 | 8 | 3 | 56 | 35 | |||
| 194394 | 160700 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 932 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2017 12:00:00 AM | 3 | Width 0ft | 6003612.41439 | 2089600.12112 | 37.7178487735724 | -122.429492779881 | (37.7178487735724, -122.429492779881) | 9 | 7 | 6 | 28861 | 5 | ||
| 194393 | 254878 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3156 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2020 11:28:00 AM | 3 | 3x6 | 5995145 | 2086533 | 37.708944125162 | -122.458538785751 | (37.708944125162, -122.458538785751) | 9 | 8 | 6 | 28861 | 25 | ||
| 194392 | 162798 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 107 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 4x6 | 5996432.70685 | 2090525.92628 | 37.7199816938867 | -122.454376546047 | (37.7199816938867, -122.454376546047) | 9 | 8 | 6 | 28861 | 24 | ||
| 194391 | 109904 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 224 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/09/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779440 | 6007796.5595 | 2109021.55143 | 37.7714117049152 | -122.41640489308 | (37.7714117049152, -122.41640489308) | 8 | 2 | 9 | 28853 | 19 | |
| 194389 | 265057 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 1190 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2020 12:00:00 AM | 3 | 4x4 | Permit Number 781590 | |||||||||||
| 194388 | 162793 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 201 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 4x6 | 5996142.86432 | 2090531.62526 | 37.7199807154151 | -122.455378837768 | (37.7199807154151, -122.455378837768) | 9 | 8 | 6 | 28861 | 24 | ||
| 194387 | 183688 | DPW Maintained 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 1351 42nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5983050 | 2105938 | 37.7615224629013 | -122.501774892125 | (37.7615224629013, -122.501774892125) | 1 | 8 | 3 | 56 | 35 | |||
| 194386 | 73728 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1714 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2020 11:22:00 AM | 3 | Permit Number 782600 | 6010056.6035 | 2120001.6041 | 37.8016871392069 | -122.409362262219 | (37.8016871392069, -122.409362262219) | 3 | 1 | 10 | 308 | 23 | |
| 194385 | 115926 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 355 Bryant St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2020 11:25:00 AM | 3 | 3x3 | 6014797.50176 | 2113407.35792 | 37.7838453529251 | -122.392494926324 | (37.7838453529251, -122.392494926324) | 6 | 2 | 9 | 28856 | 6 | ||
| 194384 | 254279 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 80X Junipero Serra Blvd | 3 | Median : Yard | Tree | Private 2 | 12/24/2020 01:32:00 PM | 3 | 3x3 | 5991405 | 2095520 | 37.733404559811 | -122.472119261767 | (37.733404559811, -122.472119261767) | 1 | 8 | 4 | 64 | 40 | ||
| 194383 | 170708 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 77 Delano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2017 12:00:00 AM | 3 | Width 3ft | 6000579.72538 | 2092917.63724 | 37.7267857432424 | -122.440213187895 | (37.7267857432424, -122.440213187895) | 9 | 7 | 6 | 28861 | 25 | ||
| 194382 | 259013 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 131 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 4x6 | 5996343 | 2090506 | 37.7199218359789 | -122.45468519116 | (37.7199218359789, -122.45468519116) | 9 | 8 | 6 | 28861 | 24 | ||
| 194381 | 259007 | DPW Maintained 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 44 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 4x4 | 5996586 | 2090578 | 37.720133466152 | -122.453850425827 | (37.720133466152, -122.453850425827) | 9 | 8 | 6 | 28861 | 24 | ||
| 194379 | 68392 | DPW Maintained 1 | Olea Majestic Beauty :: 183 | 240 Cotter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779249 | 6001623.41455 | 2093933.04413 | 37.7296331848184 | -122.436677841421 | (37.7296331848184, -122.436677841421) | 9 | 7 | 6 | 28861 | 25 |
| 194378 | 162678 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 208 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 4x6 | 5996153.38061 | 2090571.45956 | 37.7200906944144 | -122.455345364123 | (37.7200906944144, -122.455345364123) | 9 | 8 | 6 | 28861 | 24 | ||
| 194377 | 171274 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 134 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2017 12:00:00 AM | 3 | Width 3ft | 6004391.75762 | 2092740.75057 | 37.726516347746 | -122.427022498699 | (37.726516347746, -122.427022498699) | 9 | 7 | 6 | 28861 | 5 | ||
| 194376 | 171271 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 330 Peru Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2017 12:00:00 AM | 3 | Width 3ft | 6004457.49043 | 2092972.68503 | 37.7271569051579 | -122.426811773162 | (37.7271569051579, -122.426811773162) | 9 | 7 | 6 | 28861 | 5 | ||
| 194374 | 265048 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 959 Kirkham St | 1 | Front Yard : Yard | Tree | Private 2 | 20x20 | 5991956 | 2105209 | 37.7600399316741 | -122.470919881603 | (37.7600399316741, -122.470919881603) | 1 | 8 | 4 | 56 | 12 | ||||
| 194373 | 53965 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 753 Davis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 17 | Permit Number 9680 | 6013049.65631 | 2119205.04164 | 37.799667209323 | -122.39894891638 | (37.799667209323, -122.39894891638) | 3 | 1 | 10 | 28860 | 6 | ||
| 194369 | 239983 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 4093 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6002641.47002 | 2101787.20604 | 37.7512566972432 | -122.433719446911 | (37.7512566972432, -122.433719446911) | 2 | 4 | 5 | 28862 | 22 | |||
| 194367 | 56573 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 250 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/2019 12:00:00 AM | 3 | 5x5 | 6010068.531 | 2121298.26 | 37.8052481034096 | -122.409412549107 | (37.8052481034096, -122.409412549107) | 3 | 1 | 10 | 308 | 23 | ||
| 194365 | 265036 | Undocumented 4 | Potential Site :: Potential Site 48 | 1250X Alabama St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009246 | 2101881 | 37.7518867820544 | -122.410886782822 | (37.7518867820544, -122.410886782822) | 2 | 4 | 7 | 28859 | 19 | |||||
| 194364 | 265034 | Undocumented 4 | Potential Site :: Potential Site 48 | 3012 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009402 | 2101646 | 37.7512502705876 | -122.410330719668 | (37.7512502705876, -122.410330719668) | 2 | 4 | 7 | 28859 | 19 | ||||
| 194363 | 265042 | Significant Tree 6 | Tree(s) :: 17 | 1000X Mandalay Ln | 2 | Unaccepted Street : Yard | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 10x010 | Permit Number 787936 | |||||||||||
| 194362 | 265015 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 303 Goettingen St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 2ft | 6010297.36317 | 2092850.16177 | 37.7271489416555 | -122.406614663752 | (37.7271489416555, -122.406614663752) | 10 | 3 | 7 | 309 | 28 | ||||
| 194360 | 265028 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2621 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997640 | 2089142 | 37.7162509166522 | -122.450103671662 | (37.7162509166522, -122.450103671662) | 9 | 8 | 6 | 28861 | 24 | ||||
| 194359 | 262298 | Significant Tree 6 | Tree(s) :: 17 | 1000X Mandalay Ln | 1 | Side Yard : Yard | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 10x10 | Permit Number 787936 | 5991616 | 2101838 | 37.7507643799851 | -122.471850083311 | (37.7507643799851, -122.471850083311) | 1 | 8 | 4 | 29491 | 12 | |
| 194358 | 265019 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 303 Goettingen St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 2ft | 6010297.36317 | 2092850.16177 | 37.7271489416555 | -122.406614663752 | (37.7271489416555, -122.406614663752) | 10 | 3 | 7 | 309 | 28 | ||||
| 194357 | 265018 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 303 Goettingen St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 2ft | 6010297.36317 | 2092850.16177 | 37.7271489416555 | -122.406614663752 | (37.7271489416555, -122.406614663752) | 10 | 3 | 7 | 309 | 28 | ||||
| 194356 | 224589 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2765 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008256.05874 | 2106775.28704 | 37.7652698164603 | -122.414656469826 | (37.7652698164603, -122.414656469826) | 8 | 4 | 7 | 28859 | 19 | |||
| 194355 | 265020 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 303 Goettingen St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 2ft | 6010297.36317 | 2092850.16177 | 37.7271489416555 | -122.406614663752 | (37.7271489416555, -122.406614663752) | 10 | 3 | 7 | 309 | 28 | ||||
| 194354 | 265021 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 303 Goettingen St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 2ft | 6010297.36317 | 2092850.16177 | 37.7271489416555 | -122.406614663752 | (37.7271489416555, -122.406614663752) | 10 | 3 | 7 | 309 | 28 | ||||
| 194353 | 265038 | Undocumented 4 | Potential Site :: Potential Site 48 | 1250X Alabama St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009246 | 2101881 | 37.7518867820544 | -122.410886782822 | (37.7518867820544, -122.410886782822) | 2 | 4 | 7 | 28859 | 19 | |||||
| 194352 | 265022 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 99 Harlan Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6011098 | 2115736 | 37.7900331129851 | -122.405457946913 | (37.7900331129851, -122.405457946913) | 5 | 1 | 10 | 28857 | 6 | ||||
| 194351 | 265046 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1250 Eucalyptus Dr | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 5x10 | Permit Number 781946 | 5987698.06233 | 2094734.87015 | 37.7310335805158 | -122.484877445397 | (37.7310335805158, -122.484877445397) | 1 | 8 | 4 | 64 | 35 | |
| 194350 | 265014 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 303 Goettingen St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 2ft | 6010297.36317 | 2092850.16177 | 37.7271489416555 | -122.406614663752 | (37.7271489416555, -122.406614663752) | 10 | 3 | 7 | 309 | 28 | ||||
| 194349 | 265045 | Section 806 (d) 5 | Tree(s) :: 17 | 1250 Eucalyptus Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 5x10 | Permit Number 781946 | 5987698.06233 | 2094734.87015 | 37.7310335805158 | -122.484877445397 | (37.7310335805158, -122.484877445397) | 1 | 8 | 4 | 64 | 35 | |
| 194347 | 159854 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 71 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2020 12:00:00 AM | 3 | 4x6 | 6001434.62769 | 2091757.97581 | 37.7236502119613 | -122.437174824773 | (37.7236502119613, -122.437174824773) | 9 | 7 | 6 | 28861 | 25 | ||
| 194346 | 265043 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 1250 Eucalyptus Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 5x10 | Permit Number 781946 | 5987698.06233 | 2094734.87015 | 37.7310335805158 | -122.484877445397 | (37.7310335805158, -122.484877445397) | 1 | 8 | 4 | 64 | 35 | |
| 194345 | 265012 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 303 Goettingen St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 2ft | 6010297.36317 | 2092850.16177 | 37.7271489416555 | -122.406614663752 | (37.7271489416555, -122.406614663752) | 10 | 3 | 7 | 309 | 28 | ||||
| 194344 | 124321 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 115 Jordan Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12/16/2020 12:00:00 AM | 3 | Width 3ft | 5996193.40211 | 2113658.22839 | 37.7834834671867 | -122.456875951009 | (37.7834834671867, -122.456875951009) | 11 | 6 | 1 | 54 | 31 | ||
| 194343 | 265044 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 1250 Eucalyptus Dr | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 5x10 | Permit Number 781946 | 5987698.06233 | 2094734.87015 | 37.7310335805158 | -122.484877445397 | (37.7310335805158, -122.484877445397) | 1 | 8 | 4 | 64 | 35 | |
| 194342 | 265013 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 303 Goettingen St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 2ft | 6010297.36317 | 2092850.16177 | 37.7271489416555 | -122.406614663752 | (37.7271489416555, -122.406614663752) | 10 | 3 | 7 | 309 | 28 | ||||
| 194341 | 265017 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 303 Goettingen St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 2ft | 6010297.36317 | 2092850.16177 | 37.7271489416555 | -122.406614663752 | (37.7271489416555, -122.406614663752) | 10 | 3 | 7 | 309 | 28 | ||||
| 194339 | 265037 | Undocumented 4 | Potential Site :: Potential Site 48 | 1250X Alabama St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009246 | 2101881 | 37.7518867820544 | -122.410886782822 | (37.7518867820544, -122.410886782822) | 2 | 4 | 7 | 28859 | 19 | |||||
| 194338 | 265025 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 99 Harlan Pl | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6011098 | 2115736 | 37.7900331129851 | -122.405457946913 | (37.7900331129851, -122.405457946913) | 5 | 1 | 10 | 28857 | 6 | ||||
| 194337 | 265035 | Undocumented 4 | Potential Site :: Potential Site 48 | 1250X Alabama St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009246 | 2101881 | 37.7518867820544 | -122.410886782822 | (37.7518867820544, -122.410886782822) | 2 | 4 | 7 | 28859 | 19 | |||||
| 194336 | 265016 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 303 Goettingen St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 2ft | 6010297.36317 | 2092850.16177 | 37.7271489416555 | -122.406614663752 | (37.7271489416555, -122.406614663752) | 10 | 3 | 7 | 309 | 28 | ||||
| 194335 | 265024 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 99 Harlan Pl | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6011098 | 2115736 | 37.7900331129851 | -122.405457946913 | (37.7900331129851, -122.405457946913) | 5 | 1 | 10 | 28857 | 6 | ||||
| 194334 | 265023 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 99 Harlan Pl | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6011098 | 2115736 | 37.7900331129851 | -122.405457946913 | (37.7900331129851, -122.405457946913) | 5 | 1 | 10 | 28857 | 6 | ||||
| 194333 | 238518 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 210 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6002025.02718 | 2096169.57182 | 37.7357969924364 | -122.435449354007 | (37.7357969924364, -122.435449354007) | 2 | 7 | 5 | 63 | 7 | |||
| 194332 | 237618 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 395 Eureka St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/2020 12:00:00 AM | 3 | 3x3 | Permit Number 787900 | 6001516.02196 | 2103550.89224 | 37.756035430207 | -122.437737665468 | (37.756035430207, -122.437737665468) | 2 | 4 | 5 | 28862 | 3 | |
| 194331 | 143216 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 217 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6010256 | 2121247 | 37.8051178581324 | -122.408760167658 | (37.8051178581324, -122.408760167658) | 3 | 1 | 10 | 308 | 23 | |||
| 194330 | 265002 | Significant Tree 6 | :: Tree 573 | 1445 San Bruno Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5x5 | 6011217 | 2101257 | 37.7502837374969 | -122.404026841996 | (37.7502837374969, -122.404026841996) | 10 | 4 | 8 | 28859 | 19 | ||||
| 194329 | 54859 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1830 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/1972 12:00:00 AM | 25 | Permit Number 10718 | 5999038.10946992 | 2110464.35352985 | 37.7748768498196 | -122.446804517086 | (37.7748768498196, -122.446804517086) | 15 | 5 | 11 | 29492 | 16 | ||
| 194328 | 258403 | Section 806 (d) 5 | Eriobotrya deflexa :: Bronze Loquat 8 | 1052 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/2019 12:00:00 AM | 3 | 3x5 | 6011869 | 2103486 | 37.7564404909426 | -122.401928842587 | (37.7564404909426, -122.401928842587) | 10 | 3 | 8 | 28856 | 29 | ||
| 194327 | 163429 | DPW Maintained 1 | Cassia leptophylla :: Gold Medallion Tree 152 | 426 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2020 12:00:00 AM | 3 | 4x6 | 5995056.70261 | 2088533.80912 | 37.714432803101 | -122.458988723671 | (37.714432803101, -122.458988723671) | 9 | 8 | 6 | 28861 | 24 | ||
| 194326 | 139658 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1654 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6001647 | 2111894 | 37.7789509909807 | -122.437882254054 | (37.7789509909807, -122.437882254054) | 15 | 5 | 11 | 29490 | 41 | |||
| 194325 | 163425 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 402X Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2020 12:00:00 AM | 3 | 4x6 | 5995055.45495 | 2088438.70724 | 37.7141716040183 | -122.458986154313 | (37.7141716040183, -122.458986154313) | 9 | 8 | 6 | 28861 | 24 | ||
| 194324 | 163428 | DPW Maintained 1 | Olea Majestic Beauty :: 183 | 416 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2020 12:00:00 AM | 0 | 4x6 | 5995056.18363 | 2088509.02002 | 37.7143647082391 | -122.458988723675 | (37.7143647082391, -122.458988723675) | 9 | 8 | 6 | 28861 | 24 | ||
| 194322 | 236900 | DPW Maintained 1 | :: Tree 573 | 240 Alma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5997562.78425 | 2106158.57847 | 37.7629699037624 | -122.451597300975 | (37.7629699037624, -122.451597300975) | 15 | 5 | 11 | 29492 | 9 | |||
| 194321 | 212968 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 403 Irving St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6 | 6x8 | 5994507.69841 | 2106650.30443 | 37.7641446251863 | -122.462199378021 | (37.7641446251863, -122.462199378021) | 1 | 5 | 11 | 56 | 12 | |||
| 194320 | 206251 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 450 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2020 05:08:00 PM | 3 | 4x6 | Permit Number 780527 | 5994371.92355 | 2106700.48715 | 37.7642745952224 | -122.462672621052 | (37.7642745952224, -122.462672621052) | 11 | 5 | 11 | 56 | 12 | |
| 194319 | 252846 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1500 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2020 12:00:00 AM | 3 | 3x3 | 6008908 | 2108725 | 37.7706598827985 | -122.412539385599 | (37.7706598827985, -122.412539385599) | 8 | 2 | 9 | 28853 | 19 | ||
| 194318 | 264973 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 3135 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 781901 | 6001403 | 2119193 | 37.7989782820217 | -122.43924964791 | (37.7989782820217, -122.43924964791) | 13 | 9 | 1 | 57 | 17 | |
| 194316 | 221734 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 203 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2020 12:00:00 AM | 3 | Width 4ft | Permit Number 780527 | 5997194 | 2107012 | 37.7652920558138 | -122.452934396642 | (37.7652920558138, -122.452934396642) | 15 | 5 | 11 | 29492 | 12 | |
| 194315 | 264988 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 450 Irving St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12/07/2020 12:00:00 AM | 3 | 4x6 | Permit Number 780527 | 5994371.92355 | 2106700.48715 | 37.7642745952224 | -122.462672621052 | (37.7642745952224, -122.462672621052) | 11 | 5 | 11 | 56 | 12 | |
| 194313 | 111849 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2720 Broderick St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | Permit Number 785307 | 6000127.71624 | 2117950.98913 | 37.7954953973371 | -122.443573271798 | (37.7954953973371, -122.443573271798) | 13 | 9 | 1 | 57 | 17 | ||
| 194312 | 264991 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 721 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 780527 | 5993542.41381 | 2106613.40944 | 37.7639876944061 | -122.465535310621 | (37.7639876944061, -122.465535310621) | 1 | 8 | 11 | 56 | 12 | |
| 194311 | 264987 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 450 Irving St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12/07/2020 12:00:00 AM | 3 | 4x6 | Permit Number 780527 | 5994371.92355 | 2106700.48715 | 37.7642745952224 | -122.462672621052 | (37.7642745952224, -122.462672621052) | 11 | 5 | 11 | 56 | 12 | |
| 194309 | 214611 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1325 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2020 12:00:00 AM | 3 | Width 2ft | Permit Number 780527 | 5993298.90225 | 2106431.45371 | 37.7634740439193 | -122.466364312861 | (37.7634740439193, -122.466364312861) | 1 | 8 | 11 | 56 | 12 | |
| 194308 | 204823 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1325 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2020 12:00:00 AM | 3 | Width 4ft | Permit Number 780527 | 5993302.77838 | 2106404.87542 | 37.7634012905668 | -122.466348974927 | (37.7634012905668, -122.466348974927) | 1 | 8 | 11 | 56 | 12 | |
| 194307 | 212966 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 403 Irving St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5994457.81868 | 2106649.28176 | 37.7641389450798 | -122.462371822121 | (37.7641389450798, -122.462371822121) | 1 | 5 | 11 | 56 | 12 | |||
| 194306 | 264992 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 721 Irving St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12/07/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 780527 | 5993542.41381 | 2106613.40944 | 37.7639876944061 | -122.465535310621 | (37.7639876944061, -122.465535310621) | 1 | 8 | 11 | 56 | 12 | |
| 194305 | 212967 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 403 Irving St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5994483.48694 | 2106651.50195 | 37.7641465191771 | -122.462283204732 | (37.7641465191771, -122.462283204732) | 1 | 5 | 11 | 56 | 12 | |||
| 194304 | 264984 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 94X Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2020 12:00:00 AM | 3 | 3x3 | Permit Number 780527 | 5998136 | 2107256 | 37.7660159557417 | -122.449693840282 | (37.7660159557417, -122.449693840282) | 15 | 5 | 11 | 29492 | 9 | |
| 194303 | 111847 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2720 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | Permit Number 785307 | 6000127.3505 | 2117932.29224 | 37.7954440397598 | -122.443573193555 | (37.7954440397598, -122.443573193555) | 13 | 9 | 1 | 57 | 17 | ||
| 194302 | 155102 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 101 Carl St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2020 12:00:00 AM | 3 | 4x6 | Permit Number 780527 | 5997966.99634 | 2107143.35929 | 37.7656970025444 | -122.450270266774 | (37.7656970025444, -122.450270266774) | 15 | 5 | 11 | 29492 | 9 | |
| 194300 | 155101 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 101 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2020 12:00:00 AM | 3 | 4x6 | Permit Number 780527 | 5997940.66985 | 2107138.81946 | 37.7656830306656 | -122.45036099667 | (37.7656830306656, -122.45036099667) | 15 | 5 | 11 | 29492 | 9 | |
| 194299 | 264985 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 94X Carl St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2020 12:00:00 AM | 3 | 3x3 | Permit Number 780527 | 5998136 | 2107256 | 37.7660159557417 | -122.449693840282 | (37.7660159557417, -122.449693840282) | 15 | 5 | 11 | 29492 | 9 | |
| 194298 | 262528 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3400 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2020 12:00:00 AM | 3 | 3x3 | 6003691 | 2120547 | 37.8028259466608 | -122.431429119577 | (37.8028259466608, -122.431429119577) | 13 | 9 | 1 | 57 | 17 | ||
| 194297 | 252847 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1500 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2020 12:00:00 AM | 3 | 3x3 | 6008908 | 2108725 | 37.7706598827985 | -122.412539385599 | (37.7706598827985, -122.412539385599) | 8 | 2 | 9 | 28853 | 19 | ||
| 194296 | 187453 | Permitted Site 7 | Ficus retusa nitida :: Banyan Fig 54 | 4621 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6002078.4831 | 2091980.9842 | 37.724299121454 | -122.434965072602 | (37.724299121454, -122.434965072602) | 9 | 7 | 6 | 28861 | 5 | |||
| 194295 | 111848 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2720 Broderick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | Permit Number 785307 | 6000127.46619 | 2117938.95057 | 37.7954623283723 | -122.443573271789 | (37.7954623283723, -122.443573271789) | 13 | 9 | 1 | 57 | 17 | ||
| 194294 | 111846 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2720 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2020 12:00:00 AM | 3 | 3x3 | Permit Number 785307 | 6000128.0406 | 2117924.83666 | 37.7954236080649 | -122.443570269862 | (37.7954236080649, -122.443570269862) | 13 | 9 | 1 | 57 | 17 | |
| 194293 | 15750 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 4621 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4X4 | 6002067.6674 | 2091962.7327 | 37.7242483928285 | -122.435001156163 | (37.7242483928285, -122.435001156163) | 9 | 7 | 6 | 28861 | 5 | |||
| 194292 | 214534 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 721 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 780527 | 5993542.41381 | 2106613.40944 | 37.7639876944061 | -122.465535310621 | (37.7639876944061, -122.465535310621) | 1 | 8 | 11 | 56 | 12 | |
| 194291 | 264997 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 909 Shields St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x9 | 5991621 | 2089826 | 37.7177827456648 | -122.470957844969 | (37.7177827456648, -122.470957844969) | 9 | 8 | 6 | 64 | 24 | ||||
| 194290 | 264989 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 403 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2020 12:00:00 AM | 3 | 6x8 | Permit Number 780527 | 5994507.69841 | 2106650.30443 | 37.7641446251863 | -122.462199378021 | (37.7641446251863, -122.462199378021) | 1 | 5 | 11 | 56 | 12 | |
| 194289 | 264993 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 725 Irving St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 780527 | 5993487.77014 | 2106611.56006 | 37.7639794646992 | -122.465724170953 | (37.7639794646992, -122.465724170953) | 1 | 8 | 11 | 56 | 12 | |
| 194288 | 264990 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 403 Irving St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2020 12:00:00 AM | 3 | 6x8 | Permit Number 780527 | 5994507.69841 | 2106650.30443 | 37.7641446251863 | -122.462199378021 | (37.7641446251863, -122.462199378021) | 1 | 5 | 11 | 56 | 12 | |
| 194287 | 264983 | Significant Tree 6 | Yucca spp :: Yucca 289 | 2957 22nd St | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6008491 | 2103259 | 37.7556280948319 | -122.41359514096 | (37.7556280948319, -122.41359514096) | 2 | 4 | 7 | 28859 | 19 | |||||
| 194283 | 180504 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 1985 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 34 | Width 2ft | Permit Number 785142 | 6000839.04929 | 2090641.3338 | 37.720550292949 | -122.439153637233 | (37.720550292949, -122.439153637233) | 9 | 7 | 6 | 28861 | 25 | ||
| 194282 | 177746 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 65 Ocean Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Permit Number 785586 | 6001053.43812 | 2091726.98644 | 37.7235434462625 | -122.438490308995 | (37.7235434462625, -122.438490308995) | 9 | 7 | 6 | 28861 | 25 | |||
| 194281 | 178533 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1985 Alemany Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 2ft | Permit Number 785142 | 6000911.61584 | 2090780.99233 | 37.7209378926573 | -122.438912801483 | (37.7209378926573, -122.438912801483) | 9 | 7 | 6 | 28861 | 25 | ||
| 194278 | 177749 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 65 Ocean Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Permit Number 785586 | 6001147.04243 | 2091731.7631 | 37.7235618859526 | -122.438167078262 | (37.7235618859526, -122.438167078262) | 9 | 7 | 6 | 28861 | 25 | |||
| 194277 | 180017 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1985 Alemany Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | Permit Number 785142 | 6000882.12551 | 2090726.03967 | 37.7207853271706 | -122.439010804221 | (37.7207853271706, -122.439010804221) | 9 | 7 | 6 | 28861 | 25 | ||
| 194276 | 262536 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 65 Ocean Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 785586 | 6001004.64572 | 2091720.9184 | 37.7235240092161 | -122.438658540667 | (37.7235240092161, -122.438658540667) | 9 | 7 | 6 | 28861 | 25 | ||||
| 194275 | 177745 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 65 Ocean Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Permit Number 785586 | 6001030.42901 | 2091724.92182 | 37.723536468427 | -122.438569699355 | (37.723536468427, -122.438569699355) | 9 | 7 | 6 | 28861 | 25 |
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) );