trees
142,615 rows where qLegalStatus_id = 1 sorted by Neighborhoods (old) 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) ▲ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7475 | 260914 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1165 Oak St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | 6001427.67727 | 2109710.45692 | 37.7729430567741 | -122.438484490103 | (37.7729430567741, -122.438484490103) | 15 | 5 | 11 | 29492 | 9 | |||
| 7542 | 247487 | DPW Maintained 1 | Tristania conferta :: 61 | 312 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6002757.5424 | 2109611.6714 | 37.772747372498 | -122.433877269198 | (37.772747372498, -122.433877269198) | 15 | 5 | 11 | 29492 | 9 | |||
| 7621 | 239705 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 4922 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 5997802.28625 | 2105653.55065 | 37.7615969375718 | -122.450732535394 | (37.7615969375718, -122.450732535394) | 15 | 5 | 11 | 29492 | 9 | |||
| 7624 | 246397 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1320 Waller St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5999315.6516 | 2108414.4782 | 37.769264264093 | -122.445696997639 | (37.769264264093, -122.445696997639) | 15 | 5 | 11 | 29492 | 9 | |||
| 7672 | 248550 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 136 Frederick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 5999176.8044 | 2107705.1011 | 37.767308565322 | -122.446126228732 | (37.767308565322, -122.446126228732) | 15 | 5 | 11 | 29492 | 9 | |||
| 7750 | 248443 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 721 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5997578.9268 | 2108015.8037 | 37.768070296065 | -122.451675447809 | (37.768070296065, -122.451675447809) | 15 | 5 | 11 | 29492 | 9 | |||
| 7909 | 244126 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1777 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 29 | Width 0ft | 5998100.8363 | 2108896.3044 | 37.7705178019644 | -122.449933692773 | (37.7705178019644, -122.449933692773) | 15 | 5 | 11 | 29492 | 9 | |||
| 7940 | 245907 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 205 Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6001841.0498 | 2108801.5549 | 37.7704709427473 | -122.436989504702 | (37.7704709427473, -122.436989504702) | 15 | 5 | 11 | 29492 | 9 | |||
| 7960 | 228004 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 1039 Cole St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5998111.03938 | 2106633.51885 | 37.7643053520281 | -122.449735311348 | (37.7643053520281, -122.449735311348) | 15 | 5 | 11 | 29492 | 9 | |||
| 8064 | 240144 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1207 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5998176.37667 | 2106172.12741 | 37.7630422254456 | -122.449476081756 | (37.7630422254456, -122.449476081756) | 15 | 5 | 11 | 29492 | 9 | |||
| 8185 | 247646 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 900 Duboce Ave | 2 | : | Tree | Private 2 | 13 | Width 5ft | 6001616.30949 | 2108303.20625 | 37.7690898244695 | -122.437731184045 | (37.7690898244695, -122.437731184045) | 15 | 5 | 5 | 29492 | 9 | |||
| 8396 | 225575 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 99 Carmelita St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6002578.23632 | 2108754.51591 | 37.7703836584071 | -122.434436211974 | (37.7703836584071, -122.434436211974) | 15 | 5 | 5 | 29492 | 9 | |||
| 8428 | 228137 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 266 Rivoli St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5997698.72333 | 2105921.93859 | 37.762327934407 | -122.451110070772 | (37.762327934407, -122.451110070772) | 15 | 5 | 11 | 29492 | 9 | |||
| 8470 | 14592 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1222 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3x3 | 5999472.8199 | 2108630.0925 | 37.7698652586639 | -122.445168866065 | (37.7698652586639, -122.445168866065) | 15 | 5 | 11 | 29492 | 9 | |||
| 8630 | 5179 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1071X Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3X3 | 6001831.363 | 2109760.4908 | 37.7731033917316 | -122.437091677951 | (37.7731033917316, -122.437091677951) | 15 | 5 | 11 | 29492 | 9 | |||
| 8692 | 247232 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 760 Duboce Ave | 4 | : | Tree | Private 2 | 3 | Width 3ft | 6002013.60886 | 2108293.7767 | 37.7690865158689 | -122.436356276247 | (37.7690865158689, -122.436356276247) | 15 | 5 | 5 | 29492 | 9 | |||
| 8734 | 227141 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 266 Rivoli St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5997670.57496 | 2105917.36363 | 37.7623137611024 | -122.451207095032 | (37.7623137611024, -122.451207095032) | 15 | 5 | 11 | 29492 | 9 | |||
| 8769 | 32194 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 40 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/18/1995 12:00:00 AM | 2 | Permit Number 35521 | 6000876.834 | 2109176.6725 | 37.7714460698883 | -122.440351630177 | (37.7714460698883, -122.440351630177) | 15 | 5 | 11 | 29492 | 9 | |
| 8852 | 248572 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 196 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5998334.1825 | 2107625.9113 | 37.7670429747654 | -122.449035020083 | (37.7670429747654, -122.449035020083) | 15 | 5 | 11 | 29492 | 9 | |||
| 8865 | 248498 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 156 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5998302.5369 | 2107853.4873 | 37.7676660307619 | -122.449160873661 | (37.7676660307619, -122.449160873661) | 15 | 5 | 11 | 29492 | 9 | |||
| 9272 | 245113 | DPW Maintained 1 | Cinnamomum camphora :: Camphor Tree 90 | 265 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5999808.2851 | 2109439.1163 | 37.7721057759535 | -122.444066643429 | (37.7721057759535, -122.444066643429) | 15 | 5 | 11 | 29492 | 9 | |||
| 9337 | 244882 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1397 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5999938.3807 | 2109154.2405 | 37.7713309995727 | -122.443596165541 | (37.7713309995727, -122.443596165541) | 15 | 5 | 11 | 29492 | 9 | |||
| 9365 | 247654 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 900 Duboce Ave | 10 | : | Tree | Private 2 | 15 | Width 5ft | 6001517.12711 | 2108295.57391 | 37.7690632279012 | -122.438073702561 | (37.7690632279012, -122.438073702561) | 15 | 5 | 5 | 29492 | 9 | |||
| 9481 | 10434 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1457 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 3X3 | 5999128.9575 | 2108690.2041 | 37.7700106766776 | -122.44636259864 | (37.7700106766776, -122.44636259864) | 15 | 5 | 11 | 29492 | 9 | |||
| 9553 | 248603 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 404 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5997968.8193 | 2107535.8196 | 37.7667747031965 | -122.45029225419 | (37.7667747031965, -122.45029225419) | 15 | 5 | 11 | 29492 | 9 | |||
| 9653 | 247307 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 311 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6003219.2087 | 2109482.81 | 37.7724197383315 | -122.432271110524 | (37.7724197383315, -122.432271110524) | 15 | 9 | 11 | 29492 | 9 | |||
| 9849 | 245126 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 1256 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 0ft | 6000553.8142 | 2109283.0637 | 37.771719796222 | -122.44147660467 | (37.771719796222, -122.44147660467) | 15 | 5 | 11 | 29492 | 9 | |||
| 10007 | 264696 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1285 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/2020 12:00:00 AM | 3 | Width 0ft | Permit Number 782245 | 5999562.003 | 2108407.0589 | 37.7692579547157 | -122.444844350278 | (37.7692579547157, -122.444844350278) | 15 | 5 | 11 | 29492 | 9 | |
| 10111 | 233339 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 4750 17th St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 4ft | 5998413.40576 | 2105689.21442 | 37.7617298240875 | -122.448621500105 | (37.7617298240875, -122.448621500105) | 15 | 5 | 11 | 29492 | 9 | |||
| 10231 | 228002 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 1033 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5998104.33903 | 2106671.65488 | 37.764409680579 | -122.449761234305 | (37.764409680579, -122.449761234305) | 15 | 5 | 11 | 29492 | 9 | |||
| 10362 | 237919 | DPW Maintained 1 | Grevillea robusta :: Silk Oak Tree 76 | 1182 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 5998950.43455 | 2105771.37241 | 37.7619861021088 | -122.446770052318 | (37.7619861021088, -122.446770052318) | 15 | 5 | 5 | 29492 | 9 | |||
| 10372 | 260929 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 925 Cole St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | 5998050.49977 | 2107087.50026 | 37.7655484062222 | -122.449977421621 | (37.7655484062222, -122.449977421621) | 15 | 5 | 11 | 29492 | 9 | ||
| 10391 | 261268 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1544 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 5999025.8241 | 2109069.656 | 37.771046664384 | -122.446746640696 | (37.771046664384, -122.446746640696) | 15 | 5 | 11 | 29492 | 9 | ||||
| 10440 | 246120 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1285 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/1979 12:00:00 AM | 17 | Width 0ft | Permit Number 17675 | 5999565 | 2108371 | 37.7691591171027 | -122.444831391499 | (37.7691591171027, -122.444831391499) | 15 | 5 | 11 | 29492 | 9 | |
| 10488 | 260919 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 630 Cole St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | 5997903.7812 | 2108434.36371 | 37.7692381539002 | -122.450581995995 | (37.7692381539002, -122.450581995995) | 15 | 5 | 11 | 29492 | 9 | |||
| 10641 | 232039 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 50 Scott St | 12 | : | Tree | Private 2 | 9 | Width 3ft | 6002403.60195 | 2108716.39098 | 37.7702690623006 | -122.435037544552 | (37.7702690623006, -122.435037544552) | 15 | 5 | 5 | 29492 | 9 | |||
| 10675 | 247554 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 815 Buena Vista Ave West | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 30 | Width 2ft | 6000050.05446 | 2108365.18828 | 37.769170829105 | -122.443153202975 | (37.769170829105, -122.443153202975) | 15 | 5 | 11 | 29492 | 9 | |||
| 10684 | 236904 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 251 Alma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5997463.02622 | 2106112.38029 | 37.7628373418849 | -122.451938994804 | (37.7628373418849, -122.451938994804) | 15 | 5 | 11 | 29492 | 9 | |||
| 10744 | 260918 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 469 Frederick St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | 5997465.89984 | 2107424.38822 | 37.7664399466471 | -122.452023719463 | (37.7664399466471, -122.452023719463) | 15 | 5 | 11 | 29492 | 9 | |||
| 10798 | 246087 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1245 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5999728.2562 | 2108429.1654 | 37.7693281401256 | -122.444270879733 | (37.7693281401256, -122.444270879733) | 15 | 5 | 11 | 29492 | 9 | |||
| 10822 | 227716 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 810 Clayton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5998663.42523 | 2107521.35267 | 37.7667747077998 | -122.447888696528 | (37.7667747077998, -122.447888696528) | 15 | 5 | 11 | 29492 | 9 | |||
| 10854 | 31785 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 15 Alpine Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 9 | Permit Number 35256 | 6001632.60531 | 2108617.48502 | 37.7699536826355 | -122.437697329081 | (37.7699536826355, -122.437697329081) | 15 | 5 | 5 | 29492 | 9 | |
| 11000 | 241648 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 50 Scott St | 2 | : | Tree | Private 2 | 4 | Width 3ft | 6002449.19089 | 2108391.942 | 37.7693807938253 | -122.434856646815 | (37.7693807938253, -122.434856646815) | 15 | 5 | 5 | 29492 | 9 | |||
| 11022 | 25490 | DPW Maintained 1 | :: 45 | 645 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/01/2008 12:00:00 AM | 6 | 3x3 | 6003008.9663 | 2109230.97801 | 37.771716346673 | -122.432980363376 | (37.771716346673, -122.432980363376) | 15 | 5 | 11 | 29492 | 9 | ||
| 11138 | 264697 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1285 Waller St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/2020 12:00:00 AM | 3 | Width 0ft | Permit Number 782245 | 5999562.003 | 2108407.0589 | 37.7692579547157 | -122.444844350278 | (37.7692579547157, -122.444844350278) | 15 | 5 | 11 | 29492 | 9 | |
| 11220 | 239703 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1048 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 5998155.79673 | 2106630.88901 | 37.7643006917393 | -122.449580319477 | (37.7643006917393, -122.449580319477) | 15 | 5 | 11 | 29492 | 9 | |||
| 11229 | 244526 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 535 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5998923.9253 | 2108820.3562 | 37.7703563290142 | -122.447081166685 | (37.7703563290142, -122.447081166685) | 15 | 5 | 11 | 29492 | 9 | |||
| 11252 | 221394 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 704 Waller St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 08:48:00 AM | 3 | Width 3ft | 6002285.30812 | 2108832.29494 | 37.7705805883473 | -122.435455014354 | (37.7705805883473, -122.435455014354) | 15 | 5 | 11 | 29492 | 9 | ||
| 11273 | 248466 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 144 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5998292.5435 | 2107918.5956 | 37.7678442300261 | -122.449200130602 | (37.7678442300261, -122.449200130602) | 15 | 5 | 11 | 29492 | 9 | |||
| 11415 | 260944 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 351X Upper Ter | 1 | Unaccepted Street : Yard | Tree | DPW 1 | 3x3 | 5999155 | 2106055 | 37.7627765565078 | -122.446082944502 | (37.7627765565078, -122.446082944502) | 15 | 5 | 5 | 29492 | 9 | ||||
| 11429 | 246150 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1504 Waller St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 5998421.7001 | 2108292.1353 | 37.7688772616464 | -122.448780303512 | (37.7688772616464, -122.448780303512) | 15 | 5 | 11 | 29492 | 9 | |||
| 11493 | 221060 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 63 Potomac St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003088.10057 | 2108697.27411 | 37.7702554150908 | -122.432668502776 | (37.7702554150908, -122.432668502776) | 15 | 5 | 5 | 29492 | 9 | |||
| 11552 | 245177 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 119 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | Permit Number 780020 | 6000299.8756 | 2109409.2021 | 37.7720516702596 | -122.442364048942 | (37.7720516702596, -122.442364048942) | 15 | 5 | 11 | 29492 | 9 | ||
| 11580 | 247184 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1 Buena Vista Ave East | 1 | : | Tree | Private 2 | 11/09/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 780753 | 6001013.06071 | 2108893.70983 | 37.7706768805726 | -122.439860124855 | (37.7706768805726, -122.439860124855) | 15 | 5 | 11 | 29492 | 9 | |
| 11591 | 246388 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1640 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5997718.8338 | 2108194.9271 | 37.7685701345672 | -122.451204446298 | (37.7685701345672, -122.451204446298) | 15 | 5 | 11 | 29492 | 9 | |||
| 11684 | 233270 | DPW Maintained 1 | Melaleuca styphelliodes :: Paperbark Tree 220 | 141 Delmar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5999376.63712 | 2107387.11473 | 37.7664468644518 | -122.445412171329 | (37.7664468644518, -122.445412171329) | 15 | 5 | 5 | 29492 | 9 | |||
| 11728 | 248542 | DPW Maintained 1 | Tree(s) :: 17 | 258 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5998812.5011 | 2107653.6201 | 37.7671464005807 | -122.44738259118 | (37.7671464005807, -122.44738259118) | 15 | 5 | 11 | 29492 | 9 | |||
| 11778 | 107473 | DPW Maintained 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 1500 Page St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/15/2014 12:00:00 AM | 3 | 3x3 | 5999274.15837 | 2109122.8221 | 37.7712068279612 | -122.445891472086 | (37.7712068279612, -122.445891472086) | 15 | 5 | 11 | 29492 | 9 | ||
| 11870 | 245936 | DPW Maintained 1 | Tristania conferta :: 61 | 188 Beulah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5997210.9895 | 2107777.1744 | 37.76739400269 | -122.452930870305 | (37.76739400269, -122.452930870305) | 15 | 5 | 11 | 29492 | 9 | |||
| 11889 | 246929 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 349 Frederick St | 1 | : | Tree | Private 2 | 9 | Width 4ft | 5998314.74139 | 2107540.20293 | 37.7668065294199 | -122.449096088512 | (37.7668065294199, -122.449096088512) | 15 | 5 | 11 | 29492 | 9 | |||
| 12072 | 10326 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 819 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2007 12:00:00 AM | 3 | 3X3 | 6002207.57646 | 2109118.35989 | 37.7713616369503 | -122.43574435864 | (37.7713616369503, -122.43574435864) | 15 | 5 | 11 | 29492 | 9 | ||
| 12127 | 225284 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 101 Rivoli St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5998165.49077 | 2105960.31713 | 37.7624600250279 | -122.449498469484 | (37.7624600250279, -122.449498469484) | 15 | 5 | 11 | 29492 | 9 | |||
| 12266 | 246192 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 755 Buena Vista Ave West | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5999893.4495 | 2108060.1682 | 37.7683243897923 | -122.443672973707 | (37.7683243897923, -122.443672973707) | 15 | 5 | 11 | 29492 | 9 | |||
| 12290 | 248374 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1607 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5997855.864 | 2108169.7923 | 37.7685089656416 | -122.450728660067 | (37.7685089656416, -122.450728660067) | 15 | 5 | 11 | 29492 | 9 | |||
| 12362 | 246146 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1504 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/1980 12:00:00 AM | 16 | Width 0ft | Permit Number 18128 | 5998494.9848 | 2108301.523 | 37.7689072283708 | -122.44852749406 | (37.7689072283708, -122.44852749406) | 15 | 5 | 11 | 29492 | 9 | |
| 12478 | 246193 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 755 Buena Vista Ave West | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2019 12:00:00 AM | 3 | Width 0ft | 5999885.5759 | 2108037.456 | 37.7682615787189 | -122.443698575802 | (37.7682615787189, -122.443698575802) | 15 | 5 | 11 | 29492 | 9 | ||
| 12487 | 236445 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 994 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5998851.72609 | 2106478.89575 | 37.7639231446737 | -122.447162366272 | (37.7639231446737, -122.447162366272) | 15 | 5 | 11 | 29492 | 9 | |||
| 12541 | 247401 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 940 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6002054.8941 | 2109494.2208 | 37.7723849838567 | -122.436299396839 | (37.7723849838567, -122.436299396839) | 15 | 5 | 11 | 29492 | 9 | |||
| 12833 | 228133 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 127 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5998876.15346 | 2107427.17954 | 37.7665282890742 | -122.447146129895 | (37.7665282890742, -122.447146129895) | 15 | 5 | 11 | 29492 | 9 | |||
| 12872 | 225999 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 700 Duboce Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002335.19401 | 2108315.06979 | 37.7691632487104 | -122.435245457027 | (37.7691632487104, -122.435245457027) | 15 | 5 | 5 | 29492 | 9 | |||
| 12977 | 235705 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 50 Scott St | 9 | : | Tree | Private 2 | 6 | Width 3ft | 6002413.688 | 2108646.89138 | 37.7700788062318 | -122.434997685721 | (37.7700788062318, -122.434997685721) | 15 | 5 | 5 | 29492 | 9 | |||
| 13010 | 247253 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1118 Waller St | 3 | : | Tree | Private 2 | 7 | Width 3ft | 6000028.37595 | 2108519.10482 | 37.7695922091358 | -122.443239243804 | (37.7695922091358, -122.443239243804) | 15 | 5 | 11 | 29492 | 9 | |||
| 13085 | 248398 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 726 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 5998582.351 | 2108084.2431 | 37.768315627898 | -122.448209653817 | (37.768315627898, -122.448209653817) | 15 | 5 | 11 | 29492 | 9 | |||
| 13181 | 239606 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 179 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5997457.76068 | 2107065.24918 | 37.7654533761877 | -122.452025957451 | (37.7654533761877, -122.452025957451) | 15 | 5 | 11 | 29492 | 9 | |||
| 13231 | 248334 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1569 Waller St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5998104.0324 | 2108202.8007 | 37.7686138007777 | -122.449872650062 | (37.7686138007777, -122.449872650062) | 15 | 5 | 11 | 29492 | 9 | |||
| 13237 | 236458 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1210 Shrader St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5997758.4442 | 2106385.26645 | 37.7636035345904 | -122.450936930613 | (37.7636035345904, -122.450936930613) | 15 | 5 | 11 | 29492 | 9 | |||
| 13423 | 244887 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 163 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5999854.6506 | 2109116.5264 | 37.7712226704839 | -122.443883080705 | (37.7712226704839, -122.443883080705) | 15 | 5 | 11 | 29492 | 9 | |||
| 13569 | 230923 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 219 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 8ft | 5998956.22216 | 2106879.20748 | 37.7650282702508 | -122.446829753801 | (37.7650282702508, -122.446829753801) | 15 | 5 | 11 | 29492 | 9 | |||
| 13680 | 247278 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 404 Ashbury St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2015 12:00:00 AM | 18 | Width 0ft | 5998896.1541 | 2109320.6647 | 37.7717284621218 | -122.447213239628 | (37.7717284621218, -122.447213239628) | 15 | 5 | 11 | 29492 | 9 | ||
| 14071 | 4509 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1807X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 5998320.8634 | 2109271.3175 | 37.7715600792218 | -122.449199642237 | (37.7715600792218, -122.449199642237) | 15 | 5 | 11 | 29492 | 9 | |||
| 14122 | 247317 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 225 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6002750.0987 | 2109384.7475 | 37.7721238731083 | -122.433886794778 | (37.7721238731083, -122.433886794778) | 15 | 5 | 11 | 29492 | 9 | |||
| 14332 | 247276 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1685 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5998939.5199 | 2109355.4855 | 37.7718265489366 | -122.447065741453 | (37.7718265489366, -122.447065741453) | 15 | 5 | 11 | 29492 | 9 | |||
| 14349 | 234225 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 191 Frederick St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5999237.89355 | 2107666.27076 | 37.7672054354024 | -122.445912137756 | (37.7672054354024, -122.445912137756) | 15 | 5 | 5 | 29492 | 9 | |||
| 14353 | 229577 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 726 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 5997981.76535 | 2107892.21384 | 37.7677540119653 | -122.450273168888 | (37.7677540119653, -122.450273168888) | 15 | 5 | 11 | 29492 | 9 | |||
| 14473 | 246016 | DPW Maintained 1 | :: 45 | 1605 Haight St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 0 | Width 0ft | 5998345.69 | 2108581.6399 | 37.7696678206354 | -122.449064074288 | (37.7696678206354, -122.449064074288) | 15 | 5 | 11 | 29492 | 9 | |||
| 14474 | 260945 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 351X Upper Ter | 2 | Unaccepted Street : Yard | Tree | DPW 1 | 3x3 | 5999155 | 2106055 | 37.7627765565078 | -122.446082944502 | (37.7627765565078, -122.446082944502) | 15 | 5 | 5 | 29492 | 9 | ||||
| 14508 | 246217 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 725 Buena Vista Ave West | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5999828.0384 | 2107849.3991 | 37.7677419398126 | -122.443884078726 | (37.7677419398126, -122.443884078726) | 15 | 5 | 11 | 29492 | 9 | |||
| 14512 | 247242 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 901 Buena Vista Ave West | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 6ft | 6000095.1365 | 2108566.27188 | 37.7697255246317 | -122.443011709931 | (37.7697255246317, -122.443011709931) | 15 | 5 | 11 | 29492 | 9 | |||
| 14859 | 245105 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 250 Central Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 5999853.8212 | 2109427.1506 | 37.7720755187291 | -122.443908271008 | (37.7720755187291, -122.443908271008) | 15 | 5 | 11 | 29492 | 9 | |||
| 14945 | 228138 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 266 Rivoli St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5997642.73778 | 2105913.08582 | 37.7623004214351 | -122.451303064403 | (37.7623004214351, -122.451303064403) | 15 | 5 | 11 | 29492 | 9 | |||
| 14953 | 239697 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 155 Alma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5997911.0613 | 2106175.96002 | 37.763037567858 | -122.450393989214 | (37.763037567858, -122.450393989214) | 15 | 5 | 11 | 29492 | 9 | |||
| 15072 | 246185 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1326 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 5999538.3824 | 2108204.1634 | 37.7686995067752 | -122.444911465275 | (37.7686995067752, -122.444911465275) | 15 | 5 | 11 | 29492 | 9 | |||
| 15118 | 247553 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 815 Buena Vista Ave West | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6000067.12392 | 2108379.27144 | 37.7692104712049 | -122.443095172401 | (37.7692104712049, -122.443095172401) | 15 | 5 | 11 | 29492 | 9 | |||
| 15166 | 10340 | DPW Maintained 1 | Tristania conferta :: 61 | 914 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X4 | 6001716.4806 | 2109101.7503 | 37.7712881236094 | -122.437441889428 | (37.7712881236094, -122.437441889428) | 15 | 5 | 11 | 29492 | 9 | |||
| 15200 | 14594 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1232 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/01/2015 12:00:00 AM | 3 | 3x3 | 5999475.5453 | 2108600.1124 | 37.7697830964441 | -122.445157283294 | (37.7697830964441, -122.445157283294) | 15 | 5 | 11 | 29492 | 9 | ||
| 15279 | 248611 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 862 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5997689.6108 | 2107534.9111 | 37.7667562259025 | -122.45125791953 | (37.7667562259025, -122.45125791953) | 15 | 5 | 11 | 29492 | 9 | |||
| 15303 | 246138 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 636 Shrader St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 5997581.198 | 2108306.5196 | 37.7688686575946 | -122.451688565499 | (37.7688686575946, -122.451688565499) | 15 | 5 | 11 | 29492 | 9 | |||
| 15318 | 244196 | DPW Maintained 1 | Tree(s) :: 17 | 508 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5998471.7891 | 2108892.6681 | 37.7705290359785 | -122.448650307908 | (37.7705290359785, -122.448650307908) | 15 | 5 | 11 | 29492 | 9 | |||
| 15508 | 244193 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 531 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5998442.5226 | 2108797.178 | 37.7702651709945 | -122.448744661621 | (37.7702651709945, -122.448744661621) | 15 | 5 | 11 | 29492 | 9 | |||
| 15544 | 248600 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 840 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/1979 12:00:00 AM | 12 | Width 0ft | Permit Number 17869 | 5997201.7532 | 2107543.996 | 37.7667532252023 | -122.452945984051 | (37.7667532252023, -122.452945984051) | 15 | 5 | 11 | 29492 | 9 |
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) );