trees
27,746 rows where qCaretaker_id = 1 sorted by qSpecies_id 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 82111 | 90716 | DPW Maintained 1 | Quercus frainetto 'Trump' :: Hungarian Oak 406 | 4530 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5981585.539599 | 2110312.077402 | 37.7734462814106 | -122.507164273797 | (37.7734462814106, -122.507164273797) | 11 | 6 | 2 | 55 | 26 | |
| 101648 | 90709 | DPW Maintained 1 | Quercus frainetto 'Trump' :: Hungarian Oak 406 | 4400 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5981985.083822 | 2110326.577967 | 37.7735096198008 | -122.505783291903 | (37.7735096198008, -122.505783291903) | 11 | 6 | 2 | 55 | 26 | |
| 126927 | 90747 | DPW Maintained 1 | Quercus frainetto 'Trump' :: Hungarian Oak 406 | 4331 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5982206.432655 | 2110294.58511 | 37.7734348021867 | -122.505015255541 | (37.7734348021867, -122.505015255541) | 11 | 6 | 2 | 55 | 26 | |
| 175607 | 90741 | DPW Maintained 1 | Quercus frainetto 'Trump' :: Hungarian Oak 406 | 4499X Cabrillo St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5981694.399659 | 2110276.001926 | 37.7733536396946 | -122.506785041478 | (37.7733536396946, -122.506785041478) | 11 | 6 | 2 | 55 | 26 | |
| 184498 | 90748 | DPW Maintained 1 | Quercus frainetto 'Trump' :: Hungarian Oak 406 | 4331 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5982206.432655 | 2110294.58511 | 37.7734348021867 | -122.505015255541 | (37.7734348021867, -122.505015255541) | 11 | 6 | 2 | 55 | 26 | |
| 23684 | 7478 | DPW Maintained 1 | Ulmus parvifolia 'Sempervirens' :: Weeping Chinese Elm 401 | 2650X Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/23/2007 12:00:00 AM | 3 | 3x3 | 6008254.1361302 | 2102990.9843832 | 37.7548788814664 | -122.414395330099 | (37.7548788814664, -122.414395330099) | 2 | 4 | 7 | 28859 | 19 | ||
| 49011 | 1086 | DPW Maintained 1 | Ulmus parvifolia 'Sempervirens' :: Weeping Chinese Elm 401 | 2162 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 5999946.20296 | 2089791.38405 | 37.7181656785377 | -122.442178933209 | (37.7181656785377, -122.442178933209) | 9 | 7 | 6 | 28861 | 25 | |||
| 21746 | 190035 | DPW Maintained 1 | Chiranthodendron pentadactylon :: Monkey Hand Tree 393 | 1300x De Haro St | 34 | Median : Yard | Tree | DPW 1 | 27 | 6012271.55994 | 2101940.28585 | 37.7522187560075 | -122.400428070906 | (37.7522187560075, -122.400428070906) | 10 | 3 | 8 | 28856 | 29 | ||||
| 21312 | 16358 | DPW Maintained 1 | Populus tremuloides :: Quaking aspen 391 | 1306X Montgomery St | 2 | Median : Cutout | Tree | DPW 1 | 42 | 8 | 6011461.03473 | 2119844.77729 | 37.8013351180737 | -122.404491213299 | (37.8013351180737, -122.404491213299) | 3 | 1 | 10 | 308 | 23 | |||
| 67045 | 16360 | DPW Maintained 1 | Populus tremuloides :: Quaking aspen 391 | 1306X Montgomery St | 5 | Median : Cutout | Tree | DPW 1 | 42 | 8 | 6011456.11099 | 2119859.6934 | 37.8013757989128 | -122.404509302284 | (37.8013757989128, -122.404509302284) | 3 | 1 | 10 | 308 | 23 | |||
| 172335 | 24265 | DPW Maintained 1 | Ilex aquifolium :: European Holly 390 | 300X Winding Way | 3 | Median : Cutout | Tree | DPW 1 | 18 | 8 | 6001546.70936 | 2086492.80474 | 37.7091995959417 | -122.436410724793 | (37.7091995959417, -122.436410724793) | 9 | 7 | 6 | 28861 | 5 | |||
| 83237 | 240364 | DPW Maintained 1 | Quercus wislizenii :: Interior Live Oak 389 | 1x Elsie St | 3 | Median : Cutout | Tree | DPW 1 | 6 | Width 3ft | 6006311.92268 | 2096890.82859 | 37.7380199402741 | -122.420679036208 | (37.7380199402741, -122.420679036208) | 2 | 7 | 7 | 28859 | 2 | |||
| 29735 | 197479 | DPW Maintained 1 | Schefflera species :: Umbrella tree 387 | 1700x Quesada Ave | 48 | Median : Yard | Tree | DPW 1 | 4 | 6014300.68484 | 2095327.0716 | 37.7341731981237 | -122.392948336615 | (37.7341731981237, -122.392948336615) | 10 | 3 | 8 | 58 | 1 | ||||
| 101001 | 197481 | DPW Maintained 1 | Schefflera species :: Umbrella tree 387 | 1700x Quesada Ave | 21 | Median : Yard | Tree | DPW 1 | 4 | 6014505.90634 | 2095186.14654 | 37.7337976439333 | -122.392228962601 | (37.7337976439333, -122.392228962601) | 10 | 3 | 8 | 58 | 1 | ||||
| 19800 | 13790 | DPW Maintained 1 | Platanus x hispanica 'Bloodgood' :: Bloodgood London Plane 386 | 925 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/21/1992 12:00:00 AM | 20 | 4X4 | 6010172.1312849 | 2113372.8551837 | 37.7834926696549 | -122.408494625591 | (37.7834926696549, -122.408494625591) | 14 | 2 | 9 | 28853 | 34 | ||
| 77751 | 13884 | DPW Maintained 1 | Platanus x hispanica 'Bloodgood' :: Bloodgood London Plane 386 | 1025 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/30/2017 12:00:00 AM | 3 | 4x4 | 6009472.3125 | 2112691.0532 | 37.7815813872553 | -122.410867567036 | (37.7815813872553, -122.410867567036) | 14 | 2 | 9 | 28853 | 34 | ||
| 95306 | 10595 | DPW Maintained 1 | Platanus x hispanica 'Bloodgood' :: Bloodgood London Plane 386 | 1098 Harrison St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 38 | 3X3 | Permit Number 780455 | 6010831.52232 | 2110575.81704 | 37.7758495624369 | -122.406016267448 | (37.7758495624369, -122.406016267448) | 14 | 2 | 9 | 28853 | 34 | ||
| 102931 | 28333 | DPW Maintained 1 | Platanus x hispanica 'Bloodgood' :: Bloodgood London Plane 386 | 3231 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/07/2011 12:00:00 AM | 3 | 3x3 | 6006577.67231 | 2099437.86673 | 37.7450285108087 | -122.419940898853 | (37.7450285108087, -122.419940898853) | 2 | 7 | 7 | 28859 | 2 | ||
| 154883 | 10596 | DPW Maintained 1 | Platanus x hispanica 'Bloodgood' :: Bloodgood London Plane 386 | 1098 Harrison St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 125 | 3X3 | Permit Number 780455 | 6010813.59233 | 2110557.81798 | 37.7757991383537 | -122.406077023861 | (37.7757991383537, -122.406077023861) | 14 | 2 | 9 | 28853 | 34 | ||
| 31684 | 15331 | DPW Maintained 1 | Corymbia citriodora :: Lemon Scented Gum 384 | 1700X Mission St | 3 | Median : Cutout | Tree | DPW 1 | 12 | 4X4 | 6006725.71304 | 2108437.22279 | 37.7697470004467 | -122.42006753591 | (37.7697470004467, -122.42006753591) | 8 | 4 | 7 | 28853 | 19 | |||
| 53340 | 24613 | DPW Maintained 1 | Corymbia citriodora :: Lemon Scented Gum 384 | 1735 Mission St | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 24 | 6x7 | 6006758.73918 | 2108085.91697 | 37.7687842586517 | -122.419928366315 | (37.7687842586517, -122.419928366315) | 8 | 4 | 7 | 28853 | 19 | |||
| 100547 | 15329 | DPW Maintained 1 | Corymbia citriodora :: Lemon Scented Gum 384 | 1700X Mission St | 1 | Median : Cutout | Tree | DPW 1 | 12 | 4X4 | 6006717.7369932 | 2108570.5208478 | 37.7701125558687 | -122.420104586186 | (37.7701125558687, -122.420104586186) | 8 | 4 | 7 | 28853 | 19 | |||
| 140022 | 15332 | DPW Maintained 1 | Corymbia citriodora :: Lemon Scented Gum 384 | 1700X Mission St | 4 | Median : Cutout | Tree | DPW 1 | 12 | 4X4 | 6006723.99669 | 2108411.90123 | 37.7696773767498 | -122.420071675471 | (37.7696773767498, -122.420071675471) | 8 | 4 | 7 | 28853 | 19 | |||
| 144738 | 15330 | DPW Maintained 1 | Corymbia citriodora :: Lemon Scented Gum 384 | 1700X Mission St | 2 | Median : Cutout | Tree | DPW 1 | 12 | 4X4 | 6006727.83912 | 2108452.72313 | 37.769789680489 | -122.420061282012 | (37.769789680489, -122.420061282012) | 8 | 4 | 7 | 28853 | 19 | |||
| 155589 | 9296 | DPW Maintained 1 | Corymbia citriodora :: Lemon Scented Gum 384 | 135X Mansell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6011497.3933158 | 2090592.5284866 | 37.7210170109869 | -122.40230748066 | (37.7210170109869, -122.40230748066) | 10 | 7 | 8 | 309 | 28 | |||
| 162016 | 13409 | DPW Maintained 1 | Corymbia citriodora :: Lemon Scented Gum 384 | 364 Marietta Dr | 2 | Median : Cutout | Tree | DPW 1 | 100 | 5 | 5999660.108164 | 2097381.7238333 | 37.7389906787724 | -122.443712833155 | (37.7389906787724, -122.443712833155) | 9 | 7 | 4 | 59 | 40 | |||
| 173295 | 15333 | DPW Maintained 1 | Corymbia citriodora :: Lemon Scented Gum 384 | 1700X Mission St | 5 | Median : Cutout | Tree | DPW 1 | 12 | 4X4 | 6006720.95157 | 2108390.0555 | 37.7696172219899 | -122.420080657908 | (37.7696172219899, -122.420080657908) | 8 | 4 | 7 | 28853 | 19 | |||
| 36068 | 91596 | DPW Maintained 1 | Ligustrum ovalifolium :: California privet 382 | 644 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6007464.720587 | 2105907.404981 | 37.7628423226144 | -122.41733201971 | (37.7628423226144, -122.41733201971) | 8 | 4 | 7 | 28859 | 19 | ||||
| 49164 | 17450 | DPW Maintained 1 | Ligustrum ovalifolium :: California privet 382 | 1967 Palou Ave | 4 | Sidewalk: Curb side : Cutout | Landscaping | DPW 1 | 42 | 3X3 | 6012966.10245 | 2096645.10936 | 37.7377180333685 | -122.397654855789 | (37.7377180333685, -122.397654855789) | 10 | 3 | 8 | 58 | 1 | |||
| 19026 | 112232 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 34 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 5999559.4748 | 2111943.9518 | 37.7789692179466 | -122.445107405519 | (37.7789692179466, -122.445107405519) | 15 | 5 | 1 | 29490 | 16 | |||
| 22393 | 112219 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 5999801.7848 | 2111978.4708 | 37.7790778255592 | -122.444271642134 | (37.7790778255592, -122.444271642134) | 15 | 5 | 1 | 29490 | 16 | |||
| 22748 | 4236 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 4015 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003796.1789191 | 2100385.9218973 | 37.7474745521244 | -122.429626406668 | (37.7474745521244, -122.429626406668) | 2 | 4 | 5 | 63 | 22 | |||
| 22920 | 112217 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 5999859.3165 | 2111987.2698 | 37.7791052675019 | -122.444073249698 | (37.7791052675019, -122.444073249698) | 15 | 5 | 1 | 29490 | 16 | |||
| 23809 | 22543 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 1416X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X6 | 6002329.27888 | 2093769.42378 | 37.7292240094582 | -122.434225904616 | (37.7292240094582, -122.434225904616) | 9 | 7 | 6 | 28861 | 25 | |||
| 27162 | 112228 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 30 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 5999656.6019 | 2111958.8423 | 37.7790156466584 | -122.444772475715 | (37.7790156466584, -122.444772475715) | 15 | 5 | 1 | 29490 | 16 | |||
| 28486 | 986 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 1634 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6001643.13591 | 2092619.68288 | 37.7260281147961 | -122.436515696352 | (37.7260281147961, -122.436515696352) | 9 | 7 | 6 | 28861 | 25 | |||
| 29587 | 112207 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 6000150.3593 | 2112028.2188 | 37.7792343016328 | -122.443069358849 | (37.7792343016328, -122.443069358849) | 15 | 5 | 1 | 29490 | 16 | |||
| 34607 | 112199 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6000361.5345 | 2112057.6615 | 37.7793271820734 | -122.442340932958 | (37.7793271820734, -122.442340932958) | 15 | 5 | 1 | 29490 | 16 | |||
| 38543 | 112222 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 24 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 5999751.0216 | 2111973.3945 | 37.7790609910565 | -122.444446887136 | (37.7790609910565, -122.444446887136) | 15 | 5 | 1 | 29490 | 16 | |||
| 39837 | 112205 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 6000191.9852 | 2112033.972 | 37.7792524717433 | -122.442925771356 | (37.7792524717433, -122.442925771356) | 15 | 5 | 1 | 29490 | 16 | |||
| 44652 | 22542 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 1416X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3X6 | 6002345.30363 | 2093794.47674 | 37.7292937087186 | -122.434172296015 | (37.7292937087186, -122.434172296015) | 9 | 7 | 6 | 28861 | 25 | |||
| 44690 | 112203 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 6000273.8832 | 2112045.1399 | 37.7792878048325 | -122.442643255191 | (37.7792878048325, -122.442643255191) | 15 | 5 | 1 | 29490 | 16 | |||
| 44725 | 17327 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 150 Otis St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6006652.60436 | 2108850.55128 | 37.7708777828196 | -122.420349758438 | (37.7708777828196, -122.420349758438) | 8 | 2 | 9 | 28853 | 19 | |||
| 47143 | 112221 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 5999767.2658 | 2111975.0866 | 37.7790665639672 | -122.444390813692 | (37.7790665639672, -122.444390813692) | 15 | 5 | 1 | 29490 | 16 | |||
| 50348 | 112227 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 29 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 5999670.4772 | 2111960.8729 | 37.7790220139758 | -122.44472462162 | (37.7790220139758, -122.44472462162) | 15 | 5 | 1 | 29490 | 16 | |||
| 54970 | 112220 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 22 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 5999785.2022 | 2111976.4403 | 37.7790713042385 | -122.444328861929 | (37.7790713042385, -122.444328861929) | 15 | 5 | 1 | 29490 | 16 | |||
| 55726 | 112230 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 32 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 5999608.2076 | 2111950.3818 | 37.7789896544652 | -122.444939282166 | (37.7789896544652, -122.444939282166) | 15 | 5 | 1 | 29490 | 16 | |||
| 58487 | 112216 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 5999876.9145 | 2111991.6693 | 37.7791183512882 | -122.444012687447 | (37.7791183512882, -122.444012687447) | 15 | 5 | 1 | 29490 | 16 | |||
| 60546 | 112229 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 31 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 5999625.4671 | 2111952.4123 | 37.778996214713 | -122.444879720826 | (37.778996214713, -122.444879720826) | 15 | 5 | 1 | 29490 | 16 | |||
| 65630 | 112208 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 6000131.4077 | 2112027.2035 | 37.7792304332977 | -122.443134847125 | (37.7792304332977, -122.443134847125) | 15 | 5 | 1 | 29490 | 16 | |||
| 70151 | 112231 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 33 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 5999586.5486 | 2111947.336 | 37.7789800553383 | -122.44501399007 | (37.7789800553383, -122.44501399007) | 15 | 5 | 1 | 29490 | 16 | |||
| 95398 | 112233 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 35 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 5999535.7853 | 2111942.5981 | 37.7789641488857 | -122.445189259355 | (37.7789641488857, -122.445189259355) | 15 | 5 | 1 | 29490 | 16 | |||
| 99297 | 989 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 1654 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3x3 | 6001587.11696 | 2092507.46593 | 37.7257168090816 | -122.436701320907 | (37.7257168090816, -122.436701320907) | 9 | 7 | 6 | 28861 | 25 | |||
| 100877 | 112226 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 28 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 5999690.1056 | 2111964.2571 | 37.7790324262058 | -122.444656962607 | (37.7790324262058, -122.444656962607) | 15 | 5 | 1 | 29490 | 16 | |||
| 104878 | 17328 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 150 Otis St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006653.98787 | 2108819.46705 | 37.7707925108849 | -122.420342766214 | (37.7707925108849, -122.420342766214) | 8 | 2 | 9 | 28853 | 19 | |||
| 106198 | 112212 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 6000031.5732 | 2112011.6361 | 37.7791819962456 | -122.443479096263 | (37.7791819962456, -122.443479096263) | 15 | 5 | 1 | 29490 | 16 | |||
| 106794 | 17325 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 150 Otis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/31/2016 12:00:00 AM | 3 | 3x3 | 6006651.4447 | 2108878.46794 | 37.7709543699737 | -122.420355751511 | (37.7709543699737, -122.420355751511) | 8 | 2 | 9 | 28853 | 19 | ||
| 107323 | 112210 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 6000061.0159 | 2112016.0356 | 37.7791957551898 | -122.443377558283 | (37.7791957551898, -122.443377558283) | 15 | 5 | 1 | 29490 | 16 | |||
| 114807 | 112204 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 6000217.3668 | 2112038.033 | 37.7792650692531 | -122.44283825785 | (37.7792650692531, -122.44283825785) | 15 | 5 | 1 | 29490 | 16 | |||
| 122910 | 112214 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 5999912.7872 | 2111996.4072 | 37.7791334066275 | -122.443888930048 | (37.7791334066275, -122.443888930048) | 15 | 5 | 1 | 29490 | 16 | |||
| 124876 | 112225 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 27 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 5999706.3499 | 2111966.626 | 37.7790398575412 | -122.444600937512 | (37.7790398575412, -122.444600937512) | 15 | 5 | 1 | 29490 | 16 | |||
| 125298 | 112201 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 6000313.4786 | 2112051.2315 | 37.7793067878446 | -122.442506716118 | (37.7793067878446, -122.442506716118) | 15 | 5 | 1 | 29490 | 16 | |||
| 135505 | 112209 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 6000086.736 | 2112020.0967 | 37.7792083726121 | -122.44328887392 | (37.7792083726121, -122.44328887392) | 15 | 5 | 1 | 29490 | 16 | |||
| 137508 | 112211 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 6000045.7869 | 2112014.0051 | 37.7791893114958 | -122.443430095603 | (37.7791893114958, -122.443430095603) | 15 | 5 | 1 | 29490 | 16 | |||
| 150468 | 17329 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 150 Otis St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006657.292 | 2108797.54474 | 37.7707325036273 | -122.420329780922 | (37.7707325036273, -122.420329780922) | 8 | 2 | 9 | 28853 | 19 | |||
| 154468 | 112206 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 6000170.3262 | 2112030.9262 | 37.7792428738926 | -122.443000479785 | (37.7792428738926, -122.443000479785) | 15 | 5 | 1 | 29490 | 16 | |||
| 161149 | 112224 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 26 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 5999721.5789 | 2111968.3181 | 37.7790453725975 | -122.444548376071 | (37.7790453725975, -122.444548376071) | 15 | 5 | 1 | 29490 | 16 | |||
| 162430 | 112200 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 1 | 3x3 | 6000341.5676 | 2112055.2926 | 37.7793195396336 | -122.442409836485 | (37.7793195396336, -122.442409836485) | 15 | 5 | 1 | 29490 | 16 | |||
| 166138 | 112234 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 36 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 5999518.8642 | 2111940.5676 | 37.7789576077977 | -122.445247649985 | (37.7789576077977, -122.445247649985) | 15 | 5 | 1 | 29490 | 16 | |||
| 175259 | 112215 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 5999896.5429 | 2111994.715 | 37.7791278336753 | -122.443945003918 | (37.7791278336753, -122.443945003918) | 15 | 5 | 1 | 29490 | 16 | |||
| 178801 | 17326 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 150 Otis St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/29/2015 12:00:00 AM | 24 | 3X3 | 6006652.92291 | 2108866.07298 | 37.7709204196628 | -122.420349758429 | (37.7709204196628, -122.420349758429) | 8 | 2 | 9 | 28853 | 19 | ||
| 18321 | 13049 | DPW Maintained 1 | Magnolia doltsopa 'Silvercloud' :: Silvercloud Magnolia 378 | 544 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/10/2017 09:00:00 AM | 3 | 3x3 | 6009728.29593 | 2120587.34051 | 37.8032770263832 | -122.410539747275 | (37.8032770263832, -122.410539747275) | 3 | 1 | 10 | 308 | 23 | ||
| 92247 | 29377 | DPW Maintained 1 | Juglans nigra :: Eastern black walnut 376 | 3201 Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3x3 | 6014173.2464 | 2089796.2958 | 37.7189797211541 | -122.393002094215 | (37.7189797211541, -122.393002094215) | 10 | 3 | 8 | 58 | 1 | |||
| 125210 | 29376 | DPW Maintained 1 | Juglans nigra :: Eastern black walnut 376 | 3201 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 4x4 | 6014152.5379 | 2089770.1057 | 37.7189066579696 | -122.393071844457 | (37.7189066579696, -122.393071844457) | 10 | 3 | 8 | 58 | 1 | |||
| 162659 | 1165 | DPW Maintained 1 | Escallonia bifida :: White escallonia 374 | 2849X Alemany Blvd | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 5997618.33471 | 2088040.74004 | 37.7132258706419 | -122.450099227424 | (37.7132258706419, -122.450099227424) | 9 | 7 | 6 | 28861 | 25 | |||
| 16850 | 15577 | DPW Maintained 1 | Solanum rantonnetti :: 372 | 3120 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 1 | 6006912.5724 | 2100283.6127 | 37.7473696007082 | -122.418842842112 | (37.7473696007082, -122.418842842112) | 2 | 7 | 7 | 28859 | 2 | ||||
| 43343 | 28279 | DPW Maintained 1 | Solanum rantonnetti :: 372 | 1435 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/12/2002 12:00:00 AM | 3 | 3X3 | 6004563.8852658 | 2100541.3153404 | 37.7479446664543 | -122.426982792733 | (37.7479446664543, -122.426982792733) | 2 | 4 | 5 | 63 | 22 | ||
| 91192 | 15575 | DPW Maintained 1 | Solanum rantonnetti :: 372 | 3120 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/10/2004 12:00:00 AM | 3 | 3X3 | 6006944.412 | 2100344.7947 | 37.7475393853778 | -122.418737080966 | (37.7475393853778, -122.418737080966) | 2 | 7 | 7 | 28859 | 2 | ||
| 102550 | 86490 | DPW Maintained 1 | Solanum rantonnetti :: 372 | 1618 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987805.7655 | 2104249.4147 | 37.7571642715643 | -122.485202959431 | (37.7571642715643, -122.485202959431) | 1 | 8 | 3 | 56 | 35 | ||
| 174648 | 142726 | DPW Maintained 1 | Solanum rantonnetti :: 372 | 650 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | Width 0ft | 6008226.8051 | 2121045.8618 | 37.8044517189216 | -122.415768208034 | (37.8044517189216, -122.415768208034) | 5 | 1 | 10 | 308 | 23 | |||
| 189255 | 15576 | DPW Maintained 1 | Solanum rantonnetti :: 372 | 3120 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006933.1745 | 2100324.1926 | 37.7474821839526 | -122.418774478773 | (37.7474821839526, -122.418774478773) | 2 | 7 | 7 | 28859 | 2 | |||
| 38721 | 24263 | DPW Maintained 1 | Prunus laurocerasus :: English laurel 371 | 300X Winding Way | 1 | Median : Cutout | Tree | DPW 1 | 30 | 8 | 6001575.13411 | 2086503.14158 | 37.7092295937538 | -122.436313223902 | (37.7092295937538, -122.436313223902) | 9 | 7 | 6 | 28861 | 5 | |||
| 56202 | 178859 | DPW Maintained 1 | Prunus laurocerasus :: English laurel 371 | 300x Winding Way | 2 | Median : Cutout | Tree | DPW 1 | 36 | Width 0ft | 6001566.6929 | 2086499.15435 | 37.7092181660671 | -122.436342112826 | (37.7092181660671, -122.436342112826) | 9 | 7 | 6 | 28861 | 5 | |||
| 83481 | 12696 | DPW Maintained 1 | Hakea laurina :: Sea Urchin Tree 370 | 1352 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 5991211.41269 | 2114825.51279 | 37.7864011704317 | -122.474196725991 | (37.7864011704317, -122.474196725991) | 11 | 6 | 1 | 54 | 33 | |||
| 15743 | 97256 | DPW Maintained 1 | Jubaea chilensis :: Chilean Wine Palm 363 | 198 Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 10/05/2011 12:00:00 AM | 6004815 | 2107196 | 37.7662310620632 | -122.426588243906 | (37.7662310620632, -122.426588243906) | 8 | 4 | 5 | 28862 | 3 | ||||
| 127841 | 226828 | DPW Maintained 1 | Jubaea chilensis :: Chilean Wine Palm 363 | 100x Dolores St | 2 | Median : Yard | Tree | DPW 1 | 18 | 6004803.7155 | 2107705.96952 | 37.7676306780299 | -122.426663593649 | (37.7676306780299, -122.426663593649) | 8 | 4 | 5 | 28862 | 3 | ||||
| 42885 | 92052 | DPW Maintained 1 | Betula nigra :: River Birch 361 | 2323 Cesar Chavez St | Sidewalk: Property side : Cutout | Tree | DPW 1 | 05/16/2009 12:00:00 AM | 6012395.863444 | 2100936.77011 | 37.7494702500338 | -122.399927744224 | (37.7494702500338, -122.399927744224) | 10 | 3 | 8 | 58 | 1 | |||||
| 57770 | 199339 | DPW Maintained 1 | Eucalyptus pulverulenta :: Silver Mountain Gum Tree 357 | 1300x De Haro St | 27 | Median : Yard | Tree | DPW 1 | 16 | 6012269.24818 | 2102070.28333 | 37.7525755719142 | -122.4004451958 | (37.7525755719142, -122.4004451958) | 10 | 3 | 8 | 28856 | 29 | ||||
| 66997 | 24266 | DPW Maintained 1 | Eucalyptus pulverulenta :: Silver Mountain Gum Tree 357 | 350X Winding Way | 4 | Median : Cutout | Tree | DPW 1 | 30 | 8 | 6001132.77174 | 2086585.13109 | 37.7094295741756 | -122.437847962815 | (37.7094295741756, -122.437847962815) | 9 | 7 | 6 | 28861 | 5 | |||
| 13844 | 260966 | Significant Tree 6 | Robinia pseudoacacia 'Umbraculifera' :: Globe Locust 356 | 1100x Vermont St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010509 | 2103658 | 37.7568367689384 | -122.406644345083 | (37.7568367689384, -122.406644345083) | 10 | 4 | 8 | 28859 | 19 | ||||
| 14462 | 261432 | Significant Tree 6 | Robinia pseudoacacia 'Umbraculifera' :: Globe Locust 356 | 1100x Vermont St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010509 | 2103658 | 37.7568367689384 | -122.406644345083 | (37.7568367689384, -122.406644345083) | 10 | 4 | 8 | 28859 | 19 | ||||
| 16010 | 260965 | Significant Tree 6 | Robinia pseudoacacia 'Umbraculifera' :: Globe Locust 356 | 1100x Vermont St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010509 | 2103658 | 37.7568367689384 | -122.406644345083 | (37.7568367689384, -122.406644345083) | 10 | 4 | 8 | 28859 | 19 | ||||
| 21492 | 26625 | DPW Maintained 1 | Ulmus 'Prospector' :: Prospector Elm 354 | 1285X Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/15/1998 12:00:00 AM | 6 | 3X3 | 6011577.7605432 | 2093254.4735551 | 37.7283306504833 | -122.402216731645 | (37.7283306504833, -122.402216731645) | 10 | 3 | 8 | 58 | 1 | ||
| 33237 | 26630 | DPW Maintained 1 | Ulmus 'Prospector' :: Prospector Elm 354 | 1099X Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/16/1998 12:00:00 AM | 6 | 3x3 | 6011264.5101367 | 2094143.9045995 | 37.7307553523476 | -122.403362203504 | (37.7307553523476, -122.403362203504) | 10 | 3 | 8 | 58 | 1 | ||
| 37474 | 26573 | DPW Maintained 1 | Ulmus 'Prospector' :: Prospector Elm 354 | 355 Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/22/1998 12:00:00 AM | 6 | 3X3 | 6010658.7520522 | 2098287.1955653 | 37.742098094898 | -122.4057481481 | (37.742098094898, -122.4057481481) | 10 | 3 | 8 | 58 | 1 | ||
| 41486 | 26633 | DPW Maintained 1 | Ulmus 'Prospector' :: Prospector Elm 354 | 1099X Bay Shore Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/16/1998 12:00:00 AM | 3 | 3x3 | 6011264.5101367 | 2094143.9045995 | 37.7307553523476 | -122.403362203504 | (37.7307553523476, -122.403362203504) | 10 | 3 | 8 | 58 | 1 | ||
| 43560 | 26588 | DPW Maintained 1 | Ulmus 'Prospector' :: Prospector Elm 354 | 1689 Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/08/1998 12:00:00 AM | 6 | 3X3 | 6012152.58041 | 2090999.78087 | 37.7221717951322 | -122.400071264268 | (37.7221717951322, -122.400071264268) | 10 | 3 | 8 | 58 | 1 | ||
| 47306 | 10858 | DPW Maintained 1 | Ulmus 'Prospector' :: Prospector Elm 354 | 1299X HUDSON AVE | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/09/1998 12:00:00 AM | 3 | 3X4 | 6017281 | 2095243 | 37.734107450868 | -122.382638493216 | (37.734107450868, -122.382638493216) | 10 | 3 | 8 | 58 | 1 | ||
| 78024 | 10828 | DPW Maintained 1 | Ulmus 'Prospector' :: Prospector Elm 354 | 1139X Hudson Ave | 35 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/2006 12:00:00 AM | 3 | 3X4 | 6017877.50401 | 2094618.75301 | 37.7324263269122 | -122.380532796123 | (37.7324263269122, -122.380532796123) | 10 | 3 | 8 | 58 | 1 | ||
| 78066 | 26587 | DPW Maintained 1 | Ulmus 'Prospector' :: Prospector Elm 354 | 1689 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/08/1998 12:00:00 AM | 6 | 3X3 | 6012155.56121 | 2090982.84738 | 37.722125465409 | -122.400059771692 | (37.722125465409, -122.400059771692) | 10 | 3 | 8 | 58 | 1 |
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) );