trees
8,298 rows where qLegalStatus_id = 4 sorted by Neighborhoods (old)
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) ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
767 | 100549 | Undocumented 4 | Acer spp :: Maple 88 | 290X Tehama St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x4 | |||||||||||||
3669 | 103667 | Undocumented 4 | Tree(s) :: 17 | 350X Hickory St | 6 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
4476 | 112909 | Undocumented 4 | Tree(s) :: 17 | 1899X Beach St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
4983 | 112267 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1X Geary St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
5100 | 101532 | Undocumented 4 | Tree(s) :: 17 | 11323 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | ||||||||||||||
5748 | 115724 | Undocumented 4 | Syzygium paniculatum :: Brush Cherry 243 | 250x Octavia St | 1 | Side Yard : Yard | Tree | Dept of Real Estate 7 | |||||||||||||||
6238 | 103666 | Undocumented 4 | Tree(s) :: 17 | 350X Hickory St | 5 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
7827 | 115725 | Undocumented 4 | Syzygium paniculatum :: Brush Cherry 243 | 250X Octavia St | 2 | Side Yard : Yard | Tree | Dept of Real Estate 7 | |||||||||||||||
9335 | 112908 | Undocumented 4 | Tree(s) :: 17 | 1899X Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
9557 | 112910 | Undocumented 4 | Tree(s) :: 17 | 1899X Beach St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
10205 | 173902 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 601x Hearst Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
10489 | 102839 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 1101X Portola Dr | 2 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
10516 | 102842 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1101X Portola Dr | 8 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
10813 | 100543 | Undocumented 4 | Acer spp :: Maple 88 | 290X Tehama St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x4 | |||||||||||||
10916 | 108180 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 835 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | ||||||||||||||
10998 | 100001 | Undocumented 4 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 501X 01st St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | Address is 100 1st Street | ||||||||||||||
11335 | 112269 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1X Geary St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
12733 | 102843 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101X Portola Dr | 10 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
14524 | 99746 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 4250 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | ||||||||||||||
15154 | 102838 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1101X Portola Dr | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
15233 | 109923 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 214 state st | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | ||||||||||||||
15258 | 103665 | Undocumented 4 | Tree(s) :: 17 | 350X Hickory St | 4 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
16355 | 103663 | Undocumented 4 | Tree(s) :: 17 | 350X Hickory St | 2 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
18064 | 103664 | Undocumented 4 | Tree(s) :: 17 | 350X Hickory St | 3 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
18422 | 112268 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1X Geary St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
18674 | 103662 | Undocumented 4 | Tree(s) :: 17 | 350X Hickory St | 1 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
52 | 264970 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1026 Ingerson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014048 | 2089990 | 37.7195046364539 | -122.393448574201 | (37.7195046364539, -122.393448574201) | 10 | 3 | 8 | 58 | 1 | ||||
53 | 264969 | Undocumented 4 | Acacia stenophylla :: Shoestring Acacia 30 | 1099X Hollister Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15x15 | 6014337 | 2089983 | 37.719501468928 | -122.392449109694 | (37.719501468928, -122.392449109694) | 10 | 3 | 8 | 58 | 1 | |||
164 | 116129 | Undocumented 4 | Tree(s) :: 17 | 1601X Armstrong Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014258.08027 | 2092570.23406 | 37.7266011147526 | -122.392902822978 | (37.7266011147526, -122.392902822978) | 10 | 3 | 8 | 58 | 1 | |||||
277 | 110381 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 2235 PALOU AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27x18 | 6011689 | 2097713 | 37.740579036374 | -122.402145495204 | (37.740579036374, -122.402145495204) | 10 | 3 | 8 | 58 | 1 | ||||
829 | 262514 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2230 Jerrold Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012281 | 2099339 | 37.74507671213 | -122.400212745638 | (37.74507671213, -122.400212745638) | 10 | 3 | 8 | 58 | 1 | ||||
1093 | 262511 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2230 Jerrold Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012281 | 2099339 | 37.74507671213 | -122.400212745638 | (37.74507671213, -122.400212745638) | 10 | 3 | 8 | 58 | 1 | ||||
2945 | 98684 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 40 Bay View St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6014207 | 2094775 | 37.7326521179743 | -122.393233618799 | (37.7326521179743, -122.393233618799) | 10 | 3 | 8 | 58 | 1 | |||||
3569 | 261071 | Undocumented 4 | Acer buergeranum :: Trident Maple 110 | 58 Latona St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6014335 | 2094330 | 37.7314373487466 | -122.392759967745 | (37.7314373487466, -122.392759967745) | 10 | 3 | 8 | 58 | 1 | |
3645 | 254418 | Undocumented 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1245x Ingalls St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6017856 | 2093901 | 37.7304543311207 | -122.380557270451 | (37.7304543311207, -122.380557270451) | 10 | 3 | 8 | 58 | 1 | ||||
4298 | 262513 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2230 Jerrold Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012281 | 2099339 | 37.74507671213 | -122.400212745638 | (37.74507671213, -122.400212745638) | 10 | 3 | 8 | 58 | 1 | ||||
5495 | 260381 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 1924 Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6015697 | 2093053 | 37.7280065148754 | -122.387962157958 | (37.7280065148754, -122.387962157958) | 10 | 3 | 8 | 58 | 1 | ||||
5555 | 256038 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1563 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | 6015087 | 2093984 | 37.7305290408635 | -122.390135976897 | (37.7305290408635, -122.390135976897) | 10 | 3 | 8 | 58 | 1 | ||
5584 | 110379 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 2194 PALOU AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27x18 | 6011949 | 2097537 | 37.7401102866319 | -122.401234145483 | (37.7401102866319, -122.401234145483) | 10 | 3 | 8 | 58 | 1 | ||||
6361 | 116132 | Undocumented 4 | Tree(s) :: 17 | 1601X Armstrong Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014258.08027 | 2092570.23406 | 37.7266011147526 | -122.392902822978 | (37.7266011147526, -122.392902822978) | 10 | 3 | 8 | 58 | 1 | |||||
6455 | 117452 | Undocumented 4 | Tree(s) :: 17 | 1530 HUDSON AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6016055 | 2097226 | 37.7394845622146 | -122.387015456594 | (37.7394845622146, -122.387015456594) | 10 | 3 | 8 | 58 | 1 | ||||
6505 | 261618 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 1900x Bay Shore Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012644 | 2089018 | 37.7167576107691 | -122.398233561415 | (37.7167576107691, -122.398233561415) | 10 | 3 | 8 | 58 | 1 | ||||
7225 | 260193 | Undocumented 4 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 845 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6015971 | 2096622 | 37.7378214492677 | -122.387263773804 | (37.7378214492677, -122.387263773804) | 10 | 3 | 8 | 58 | 1 | ||||
7364 | 261070 | Undocumented 4 | Acer buergeranum :: Trident Maple 110 | 58 Latona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6014335 | 2094330 | 37.7314373487466 | -122.392759967745 | (37.7314373487466, -122.392759967745) | 10 | 3 | 8 | 58 | 1 | |
7433 | 110378 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 2176 PALOU AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27x18 | 6011973 | 2097506 | 37.7400265061348 | -122.401148985018 | (37.7400265061348, -122.401148985018) | 10 | 3 | 8 | 58 | 1 | ||||
8037 | 257932 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 1039 Hudson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6018789 | 2095103 | 37.7338062313868 | -122.377415095373 | (37.7338062313868, -122.377415095373) | 10 | 3 | 8 | 58 | 1 | ||||
8158 | 254632 | Undocumented 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1100x Hudson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6017356 | 2095183 | 37.733946845802 | -122.382375019073 | (37.733946845802, -122.382375019073) | 10 | 3 | 8 | 58 | 1 | ||||
8589 | 111310 | Undocumented 4 | Acacia spp :: Acacia Spp 105 | 99x GILROY ST | 1 | Unaccepted Street : Yard | Tree | Private 2 | 30x30 | 6015277 | 2088666 | 37.7159373992527 | -122.389107938034 | (37.7159373992527, -122.389107938034) | 10 | 3 | 8 | 58 | 1 | ||||
8808 | 198709 | Undocumented 4 | Ulmus spp :: Elm Spp 98 | 1575 Bay Shore Blvd | 5 | : | Tree | Private 2 | 9 | Width 3ft | 6011880.53852 | 2091897.11167 | 37.7246205103096 | -122.401074672678 | (37.7246205103096, -122.401074672678) | 10 | 3 | 8 | 58 | 1 | |||
8836 | 262545 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 1919 Donner Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/18/2020 12:00:00 AM | 3 | 3x3 | 6011672 | 2093386 | 37.7286970547273 | -122.401900181645 | (37.7286970547273, -122.401900181645) | 10 | 3 | 8 | 58 | 1 | ||
9919 | 106007 | Undocumented 4 | Tree(s) :: 17 | 1800X LANE ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014836 | 2094060 | 37.7307237967737 | -122.391009037699 | (37.7307237967737, -122.391009037699) | 10 | 3 | 8 | 58 | 1 | ||||
10420 | 105551 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1398X HAWES ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6017214 | 2092838 | 37.7275000929711 | -122.382702837059 | (37.7275000929711, -122.382702837059) | 10 | 3 | 8 | 58 | 1 | |||
10895 | 112844 | Undocumented 4 | Podocarpus gracilor :: Fern Pine 51 | 2200 KEITH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014766 | 2092880 | 37.7274798696224 | -122.391168591224 | (37.7274798696224, -122.391168591224) | 10 | 3 | 8 | 58 | 1 | ||||
11756 | 108765 | Undocumented 4 | :: 45 | 500X Lathrop Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | 10 | 3 | 8 | 309 | 1 | ||||
13344 | 110423 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 64 DORMAN AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27x18 | 6011306 | 2097433 | 37.7397888309311 | -122.403450074877 | (37.7397888309311, -122.403450074877) | 10 | 3 | 8 | 58 | 1 | ||||
13473 | 105162 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1600X OAKDALE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 5x5 | 6015006 | 2095503 | 37.7346954145828 | -122.390522107646 | (37.7346954145828, -122.390522107646) | 10 | 3 | 8 | 58 | 1 | |||
14104 | 262548 | Undocumented 4 | Quercus tomentella :: Island oak 178 | 1299 Gilman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/2020 12:00:00 AM | 3x3 | 6013984 | 2090616 | 37.7212199518701 | -122.3937135928 | (37.7212199518701, -122.3937135928) | 10 | 3 | 8 | 58 | 1 | |||
14460 | 261617 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 1900x Bay Shore Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012644 | 2089018 | 37.7167576107691 | -122.398233561415 | (37.7167576107691, -122.398233561415) | 10 | 3 | 8 | 58 | 1 | ||||
14857 | 194268 | Undocumented 4 | Persea americana :: Avocado 34 | 900 Quint St | 3 | Side Yard : Yard | Tree | Private 2 | 7 | Width 3ft | 6014100.15686 | 2097559.70841 | 37.7402924173605 | -122.393797854205 | (37.7402924173605, -122.393797854205) | 10 | 3 | 8 | 58 | 1 | |||
18044 | 262512 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2230 Jerrold Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012281 | 2099339 | 37.74507671213 | -122.400212745638 | (37.74507671213, -122.400212745638) | 10 | 3 | 8 | 58 | 1 | ||||
18077 | 262510 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2230 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012281 | 2099339 | 37.74507671213 | -122.400212745638 | (37.74507671213, -122.400212745638) | 10 | 3 | 8 | 58 | 1 | ||||
19076 | 99594 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1855X Evans Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6014349.8 | 2099426.2 | 37.7454312840379 | -122.393065244865 | (37.7454312840379, -122.393065244865) | 10 | 3 | 8 | 58 | 1 | |||
19491 | 260088 | Undocumented 4 | Corymbia citriodora :: Lemon Scented Gum 384 | 1100 Oakdale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15x5 | 6017813 | 2093492 | 37.7293289240284 | -122.380677509991 | (37.7293289240284, -122.380677509991) | 10 | 3 | 8 | 58 | 1 | ||||
21358 | 110380 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 2200 PALOU AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27x18 | 6011920 | 2097566 | 37.7401882965272 | -122.401336453712 | (37.7401882965272, -122.401336453712) | 10 | 3 | 8 | 58 | 1 | ||||
22201 | 121023 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 200 Executive Park Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6014230 | 2086988 | 37.7112718434151 | -122.392609576957 | (37.7112718434151, -122.392609576957) | 10 | 3 | 8 | 58 | 1 | |||||
22311 | 254407 | Undocumented 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1176x Ingalls St | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6017715 | 2093956 | 37.7305975684905 | -122.381048555108 | (37.7305975684905, -122.381048555108) | 10 | 3 | 8 | 58 | 1 | ||||
23240 | 255713 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 618x Mendell St | 3 | Front Yard : Yard | Tree | Private 2 | 3x3 | Permit Number 781846 | 6016234 | 2097322 | 37.7397580688138 | -122.386403238688 | (37.7397580688138, -122.386403238688) | 10 | 3 | 8 | 58 | 1 | |||
24385 | 111658 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 1740 CESAR CHAVEZ ST | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 07/07/2015 12:00:00 AM | 3 | 6014066 | 2101066 | 37.7499180589901 | -122.394161367931 | (37.7499180589901, -122.394161367931) | 10 | 3 | 8 | 58 | 1 | |||
25368 | 108741 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 100x HESTER AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012550 | 2088124 | 37.7142976286929 | -122.398495779076 | (37.7142976286929, -122.398495779076) | 10 | 3 | 8 | 309 | 1 | ||||
25651 | 191577 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 750 Phelps St | 20 | : | Tree | Private 2 | 11 | Width 4ft | 6015326.98728 | 2098089.14563 | 37.7418142438421 | -122.38959289501 | (37.7418142438421, -122.38959289501) | 10 | 3 | 8 | 58 | 1 | |||
25728 | 96200 | Undocumented 4 | Tree(s) :: 17 | 1640 Jerrold Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x50 | 6015077.4 | 2097255.4 | 37.7395111076977 | -122.390397652393 | (37.7395111076977, -122.390397652393) | 10 | 3 | 8 | 58 | 1 | |||
26493 | 111657 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 1740 CESAR CHAVEZ ST | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 07/07/2015 12:00:00 AM | 3 | 6014066 | 2101066 | 37.7499180589901 | -122.394161367931 | (37.7499180589901, -122.394161367931) | 10 | 3 | 8 | 58 | 1 | |||
27429 | 116566 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1610 INNES AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015424 | 2097316 | 37.739696723386 | -122.38920348056 | (37.739696723386, -122.38920348056) | 10 | 3 | 8 | 58 | 1 | ||||
28472 | 108538 | Undocumented 4 | Washingtonia filifera :: California Fan Palm 176 | 400-422X Tocoloma Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012449.25025 | 2086560.52634 | 37.7099990266406 | -122.398734355673 | (37.7099990266406, -122.398734355673) | 10 | 3 | 8 | 309 | 1 | |||||
28904 | 255717 | Undocumented 4 | Prunus domestica 'Santa Rosa' :: Santa Rosa Plum 158 | 937x Meade Ave | 3 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6012763 | 2089349 | 37.7176730984513 | -122.397845439416 | (37.7176730984513, -122.397845439416) | 10 | 3 | 8 | 58 | 1 | ||||
28986 | 97431 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1696@ Newhall St McKinnon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014941.5 | 2096322.6 | 37.7369422906262 | -122.390802367297 | (37.7369422906262, -122.390802367297) | 10 | 3 | 8 | 58 | 1 | ||||
29044 | 256487 | Undocumented 4 | Prunus persica :: Peach 306 | 901 Ingerson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014644 | 2089423 | 37.7179808627223 | -122.391348788107 | (37.7179808627223, -122.391348788107) | 10 | 3 | 8 | 58 | 1 | ||||
29418 | 93757 | Undocumented 4 | Pyrus spp :: Pear Tree 281 | 61X Napoleon St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6013237.1 | 2100058.8 | 37.7471063957658 | -122.396957155424 | (37.7471063957658, -122.396957155424) | 10 | 3 | 8 | 58 | 1 | |||||
29678 | 112851 | Undocumented 4 | Podocarpus gracilor :: Fern Pine 51 | 2200 KEITH ST | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014766 | 2092880 | 37.7274798696224 | -122.391168591224 | (37.7274798696224, -122.391168591224) | 10 | 3 | 8 | 58 | 1 | ||||
30117 | 256072 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1800 Jennings St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x9 | 6015921 | 2093364 | 37.7288728663344 | -122.387209460387 | (37.7288728663344, -122.387209460387) | 10 | 3 | 8 | 58 | 1 | ||||
30888 | 198710 | Undocumented 4 | Ulmus spp :: Elm Spp 98 | 1575 Bay Shore Blvd | 6 | : | Tree | Private 2 | 10 | Width 3ft | 6011871.8158 | 2091922.88545 | 37.7246907932196 | -122.401106636374 | (37.7246907932196, -122.401106636374) | 10 | 3 | 8 | 58 | 1 | |||
31352 | 116135 | Undocumented 4 | Tree(s) :: 17 | 1601X Armstrong Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014258.08027 | 2092570.23406 | 37.7266011147526 | -122.392902822978 | (37.7266011147526, -122.392902822978) | 10 | 3 | 8 | 58 | 1 | |||||
32168 | 97432 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1696@ Newhall St McKinnon Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014941.5 | 2096322.6 | 37.7369422906262 | -122.390802367297 | (37.7369422906262, -122.390802367297) | 10 | 3 | 8 | 58 | 1 | ||||
32225 | 121022 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 200 Executive Park Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6014230 | 2086988 | 37.7112718434151 | -122.392609576957 | (37.7112718434151, -122.392609576957) | 10 | 3 | 8 | 58 | 1 | |||||
32485 | 256486 | Undocumented 4 | Prunus domestica 'Santa Rosa' :: Santa Rosa Plum 158 | 901 Ingerson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014644 | 2089423 | 37.7179808627223 | -122.391348788107 | (37.7179808627223, -122.391348788107) | 10 | 3 | 8 | 58 | 1 | ||||
34481 | 201714 | Undocumented 4 | Acacia stenophylla :: Shoestring Acacia 30 | 726 Jamestown Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6015317.96334 | 2088364.51894 | 37.7151118613908 | -122.388945312084 | (37.7151118613908, -122.388945312084) | 10 | 3 | 8 | 58 | 1 | |||
34742 | 254497 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1100x Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6018024 | 2094000 | 37.7307354351655 | -122.379983340658 | (37.7307354351655, -122.379983340658) | 10 | 3 | 8 | 58 | 1 | ||||
34794 | 83038 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 100X Cargo Way | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/04/2006 12:00:00 AM | 6018593.33009 | 2097780.6594 | 37.7411477742489 | -122.378277419086 | (37.7411477742489, -122.378277419086) | 10 | 3 | 8 | 58 | 1 | |||
35280 | 255716 | Undocumented 4 | Prunus domestica 'Santa Rosa' :: Santa Rosa Plum 158 | 937x Meade Ave | 2 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6012763 | 2089349 | 37.7176730984513 | -122.397845439416 | (37.7176730984513, -122.397845439416) | 10 | 3 | 8 | 58 | 1 | ||||
35402 | 93756 | Undocumented 4 | Pyrus spp :: Pear Tree 281 | 61X Napoleon St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6013237.1 | 2100058.8 | 37.7471063957658 | -122.396957155424 | (37.7471063957658, -122.396957155424) | 10 | 3 | 8 | 58 | 1 | |||||
35458 | 115141 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 EXECUTIVE PARK BLVD | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013586 | 2086931 | 37.7110795456085 | -122.394831429854 | (37.7110795456085, -122.394831429854) | 10 | 3 | 8 | 58 | 1 | ||||
36150 | 113586 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 99X AUGUSTA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2015 12:00:00 AM | 3x3 | 6011271 | 2095434 | 37.7342980459086 | -122.403430493306 | (37.7342980459086, -122.403430493306) | 10 | 3 | 8 | 58 | 1 | |||
36331 | 256763 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 1039 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6018789 | 2095103 | 37.7338062313868 | -122.377415095373 | (37.7338062313868, -122.377415095373) | 10 | 3 | 8 | 58 | 1 | ||||
37231 | 98898 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1420 Phelps St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6013939 | 2096227 | 37.7366241191951 | -122.39426179075 | (37.7366241191951, -122.39426179075) | 10 | 3 | 8 | 58 | 1 | |||
38494 | 111261 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 90 MADDUX AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012644 | 2095211 | 37.7337623267636 | -122.3986679149 | (37.7337623267636, -122.3986679149) | 10 | 3 | 8 | 58 | 1 | ||||
38711 | 116976 | Undocumented 4 | Salix spp :: Willow 203 | 100x CARGO WAY | 7 | Front Yard : Yard | Tree | PUC 8 | DPW for City Agency | 6019010 | 2097405 | 37.7401392444118 | -122.376810655394 | (37.7401392444118, -122.376810655394) | 10 | 3 | 8 | 58 | 1 | ||||
39661 | 103997 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1410X Hawes St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6017134.59054 | 2092698.10151 | 37.7271115716676 | -122.38296762653 | (37.7271115716676, -122.38296762653) | 10 | 3 | 8 | 58 | 1 | |||
39830 | 116130 | Undocumented 4 | Tree(s) :: 17 | 1601X Armstrong Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014258.08027 | 2092570.23406 | 37.7266011147526 | -122.392902822978 | (37.7266011147526, -122.392902822978) | 10 | 3 | 8 | 58 | 1 | |||||
41732 | 114444 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 140 LOOMIS ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6010781 | 2097775 | 37.7406985517125 | -122.405289390042 | (37.7406985517125, -122.405289390042) | 10 | 3 | 8 | 58 | 1 | ||||
43652 | 116560 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1620 INNES AVE | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015376 | 2097346 | 37.7397764361483 | -122.389371539928 | (37.7397764361483, -122.389371539928) | 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) );