trees
8,298 rows where qLegalStatus_id = 4 sorted by Fire Prevention Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10808 | 262250 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 4210 Ocean Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | ||||
11018 | 258435 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2511 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2019 06:07:00 PM | 3 | 3x3 | 5987985 | 2106413 | 37.7631153270305 | -122.484741815217 | (37.7631153270305, -122.484741815217) | 1 | 8 | 3 | 56 | 35 | ||
11037 | 262112 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 2021 16th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991247 | 2101647 | 37.7502185858925 | -122.473112177678 | (37.7502185858925, -122.473112177678) | 1 | 8 | 4 | 29491 | 12 | ||||
11227 | 106481 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 301X LAWTON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993233 | 2104592 | 37.7584195821345 | -122.466458543785 | (37.7584195821345, -122.466458543785) | 1 | 8 | 4 | 56 | 12 | |||||
11304 | 118290 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 275 OLYMPIA WAY | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5996383 | 2101914 | 37.7512477308097 | -122.455370966371 | (37.7512477308097, -122.455370966371) | 1 | 5 | 4 | 63 | 38 | ||||
11428 | 122390 | Undocumented 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1958 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x2 | 5991007 | 2102078 | 37.7513881006776 | -122.473973545995 | (37.7513881006776, -122.473973545995) | 1 | 8 | 4 | 29491 | 12 | |||
11446 | 111248 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3101x VICENTE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5983195 | 2097379 | 37.7380303412956 | -122.50064049243 | (37.7380303412956, -122.50064049243) | 1 | 8 | 3 | 29491 | 35 | |||
11602 | 122483 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1295 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5983305 | 2106338 | 37.7626357248351 | -122.500922549214 | (37.7626357248351, -122.500922549214) | 1 | 8 | 3 | 56 | 35 | ||||
11790 | 254293 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 110 Junipero Serra Blvd | 5 | Median : Yard | Tree | Private 2 | 3x3 | 5991396 | 2095383 | 37.7330278715114 | -122.472140394325 | (37.7330278715114, -122.472140394325) | 1 | 8 | 4 | 64 | 40 | ||||
11878 | 104919 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 732 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990421 | 2090607 | 37.719857702396 | -122.475162650507 | (37.719857702396, -122.475162650507) | 1 | 8 | 4 | 64 | 40 | |||||
11896 | 260629 | Undocumented 4 | Ulmus 'Frontier' :: Frontier Elm 115 | 290X Laguna Honda Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994814 | 2101552 | 37.7501636191697 | -122.460770471589 | (37.7501636191697, -122.460770471589) | 1 | 5 | 4 | 29491 | 40 | ||||
11919 | 260631 | Undocumented 4 | Ulmus 'Frontier' :: Frontier Elm 115 | 290X Laguna Honda Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994814 | 2101552 | 37.7501636191697 | -122.460770471589 | (37.7501636191697, -122.460770471589) | 1 | 5 | 4 | 29491 | 40 | ||||
12436 | 259039 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 3627 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5981920 | 2098711 | 37.7416127129705 | -122.505147411787 | (37.7416127129705, -122.505147411787) | 1 | 8 | 3 | 29491 | 35 | ||||
12565 | 104957 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 759 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990435 | 2090585 | 37.7197981072685 | -122.475112652722 | (37.7197981072685, -122.475112652722) | 1 | 8 | 4 | 64 | 40 | |||||
12754 | 109383 | Undocumented 4 | Tree(s) :: 17 | 25 17TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/23/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774251 | 5991142.1 | 2098329.7 | 37.7411040634818 | -122.473233017287 | (37.7411040634818, -122.473233017287) | 1 | 8 | 4 | 29491 | 40 | |
12903 | 258678 | Undocumented 4 | Ulmus 'Prospector' :: Prospector Elm 354 | 598X Dewey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994262 | 2099558 | 37.7446568233288 | -122.462534686315 | (37.7446568233288, -122.462534686315) | 1 | 8 | 4 | 59 | 40 | ||||
13061 | 111232 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2601X 15TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991704 | 2097685 | 37.7393664008113 | -122.471243228199 | (37.7393664008113, -122.471243228199) | 1 | 8 | 4 | 29491 | 40 | ||||
13098 | 254290 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 110 Junipero Serra Blvd | 2 | Median : Yard | Tree | Private 2 | 3x3 | 5991396 | 2095383 | 37.7330278715114 | -122.472140394325 | (37.7330278715114, -122.472140394325) | 1 | 8 | 4 | 64 | 40 | ||||
13163 | 255351 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700 Brotherhood Way | 32 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x21 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
13318 | 262248 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 4210 Ocean Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | ||||
13600 | 113384 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 127 CASTENADA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 5994537 | 2101046 | 37.748758329692 | -122.461691664015 | (37.748758329692, -122.461691664015) | 1 | 8 | 4 | 29491 | 40 | |||
13650 | 113526 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 16x SHELDON TER | 1 | Back Yard : Cutout | Tree | Private 2 | 30 | 3x3 | 5991843 | 2103332 | 37.7548796468533 | -122.471173938858 | (37.7548796468533, -122.471173938858) | 1 | 8 | 4 | 56 | 12 | |||
13893 | 264884 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 1624 48th Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5981321 | 2103997 | 37.7560913197894 | -122.50761065519 | (37.7560913197894, -122.50761065519) | 1 | 8 | 3 | 56 | 35 | ||||
13988 | 106896 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 2958 SLOAT BLVD | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5981703.3 | 2096579.8 | 37.7357482722765 | -122.505738719186 | (37.7357482722765, -122.505738719186) | 1 | 8 | 3 | 29491 | 35 | ||||||
14571 | 205488 | Undocumented 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1430 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2016 12:00:00 AM | 19 | Width 3ft | Permit Number 778800 | 5990862.44739 | 2105654.74875 | 37.761200533507 | -122.474734450646 | (37.761200533507, -122.474734450646) | 1 | 8 | 4 | 56 | 12 | |
14928 | 120545 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2195 18th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990654 | 2100514 | 37.7470733117967 | -122.475080088588 | (37.7470733117967, -122.475080088588) | 1 | 8 | 4 | 29491 | 40 | ||||
15037 | 262257 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2 Everglade Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986312 | 2095495 | 37.7330398702545 | -122.489725113139 | (37.7330398702545, -122.489725113139) | 1 | 8 | 4 | 64 | 35 | ||||
15050 | 106111 | Undocumented 4 | Magnolia champaca :: Champa 141 | 135 MENDOSA AVE | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 772704 | 5992893.2 | 2100790.2 | 37.747961208182 | -122.467357269235 | (37.747961208182, -122.467357269235) | 1 | 8 | 4 | 29491 | 40 | ||||
15210 | 260508 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 299 Laguna Honda Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994794 | 2101316 | 37.7495144720577 | -122.460822530701 | (37.7495144720577, -122.460822530701) | 1 | 8 | 4 | 29491 | 40 | ||||
15991 | 262259 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 2 Everglade Dr | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986312 | 2095495 | 37.7330398702545 | -122.489725113139 | (37.7330398702545, -122.489725113139) | 1 | 8 | 4 | 64 | 35 | ||||
16399 | 262491 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3940 Judah St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5982210 | 2105632 | 37.760632897171 | -122.504657384045 | (37.760632897171, -122.504657384045) | 1 | 8 | 3 | 56 | 35 | ||||
16415 | 104004 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 2179 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5992553.4 | 2100640.7 | 37.7475310970527 | -122.468521397227 | (37.7475310970527, -122.468521397227) | 1 | 8 | 4 | 29491 | 40 | |||||
16675 | 106131 | Undocumented 4 | Pittosporum spp :: Pittosporum spp 170 | 2402 26TH AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 5988342.2 | 2098891.1 | 37.7424830020357 | -122.482955078155 | (37.7424830020357, -122.482955078155) | 1 | 8 | 3 | 29491 | 35 | |||
16700 | 262531 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 23X Knollview Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10x10 | 5997470 | 2101306 | 37.7496406233362 | -122.451568168016 | (37.7496406233362, -122.451568168016) | 1 | 5 | 4 | 63 | 38 | ||||
16950 | 261148 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 3220x Santiago St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5982825 | 2099474 | 37.7437609086011 | -122.502074725774 | (37.7437609086011, -122.502074725774) | 1 | 8 | 3 | 29491 | 35 | ||||
16966 | 260630 | Undocumented 4 | Ulmus 'Frontier' :: Frontier Elm 115 | 290X Laguna Honda Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994814 | 2101552 | 37.7501636191697 | -122.460770471589 | (37.7501636191697, -122.460770471589) | 1 | 5 | 4 | 29491 | 40 | ||||
17011 | 97950 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 2 Mendosa Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993624.4 | 2101138.5 | 37.7489597362933 | -122.464854121346 | (37.7489597362933, -122.464854121346) | 1 | 8 | 4 | 29491 | 40 | |||||
17238 | 262489 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3940 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5982210 | 2105632 | 37.760632897171 | -122.504657384045 | (37.760632897171, -122.504657384045) | 1 | 8 | 3 | 56 | 35 | ||||
17612 | 262236 | Undocumented 4 | Juniperus chinensis :: Juniper 113 | 3540 Rivera St | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 3x3 | 5982153 | 2100195 | 37.7457010726591 | -122.504451707081 | (37.7457010726591, -122.504451707081) | 1 | 8 | 3 | 29491 | 35 | ||||
17827 | 262490 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3940 Judah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5982210 | 2105632 | 37.760632897171 | -122.504657384045 | (37.760632897171, -122.504657384045) | 1 | 8 | 3 | 56 | 35 | ||||
17829 | 106868 | Undocumented 4 | Tree(s) :: 17 | 1956 GREAT HWY | Sidewalk: Property side : Cutout | Tree | Private 2 | 5981193.7 | 2101737.6 | 37.7498801477899 | -122.507883225183 | (37.7498801477899, -122.507883225183) | 1 | 8 | 3 | 29491 | 35 | ||||||
18421 | 122404 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 340 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x6 | 5994085 | 2099826 | 37.7453824890774 | -122.46316615516 | (37.7453824890774, -122.46316615516) | 1 | 8 | 4 | 29491 | 40 | ||||
18453 | 260632 | Undocumented 4 | Maytenus boaria :: Mayten 58 | 801 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991525 | 2103169 | 37.7544136927394 | -122.472261779786 | (37.7544136927394, -122.472261779786) | 1 | 8 | 4 | 56 | 12 | ||||
18623 | 99145 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 302X Pacheco St | 29 | Median : Cutout | Tree | Private 2 | 9 | 5994341.5 | 2100725.2 | 37.7478662384021 | -122.46234443277 | (37.7478662384021, -122.46234443277) | 1 | 8 | 4 | 29491 | 40 | ||||
18670 | 259040 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 3615 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5981969 | 2098712 | 37.7416183416682 | -122.504978063323 | (37.7416183416682, -122.504978063323) | 1 | 8 | 3 | 29491 | 35 | ||||
18960 | 262582 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 2801X 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992317 | 2097142 | 37.7379108993029 | -122.469084256099 | (37.7379108993029, -122.469084256099) | 1 | 8 | 4 | 59 | 40 | ||||
19136 | 102260 | Undocumented 4 | Tree(s) :: 17 | 1350 46th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 24 | 4x6 | 5981875.8 | 2105892.8 | 37.7613293147111 | -122.505832545781 | (37.7613293147111, -122.505832545781) | 1 | 8 | 3 | 56 | 35 | |||
19150 | 259041 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 3614 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5981967 | 2098808 | 37.7418818134636 | -122.504992090975 | (37.7418818134636, -122.504992090975) | 1 | 8 | 3 | 29491 | 35 | ||||
19357 | 256415 | Undocumented 4 | Ligustrum ovalifolium :: California privet 382 | 3001 Sunset Blvd | 3 | Median : Yard | Tree | Private 2 | 10x10 | 5984960 | 2094729 | 37.7308576064943 | -122.49434282122 | (37.7308576064943, -122.49434282122) | 1 | 8 | 4 | 64 | 35 | ||||
19448 | 254323 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 220 Junipero Serra Blvd | 4 | Median : Cutout | Tree | Private 2 | 10x10 | 5991369 | 2094955 | 37.731851128725 | -122.472202551974 | (37.731851128725, -122.472202551974) | 1 | 8 | 4 | 64 | 40 | ||||
19564 | 264882 | Undocumented 4 | Juniperus chinensis :: Juniper 113 | 2801 Lawton St | 1 | Sidewalk: Property side : Yard | Landscaping | Private 2 | 3x3 | 5985570 | 2104278 | 37.7571122644181 | -122.49293709397 | (37.7571122644181, -122.49293709397) | 1 | 8 | 3 | 56 | 35 | ||||
19643 | 105261 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 619 GONZALEZ DR | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 5988914.8 | 2089258.8 | 37.7160684695332 | -122.48027037241 | (37.7160684695332, -122.48027037241) | 1 | 8 | 4 | 64 | 14 | |||||
19648 | 114286 | Undocumented 4 | Melaleuca quinquenervia :: Cajeput 10 | 1801X 16TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x4 | 5991146 | 2103109 | 37.7542270070727 | -122.473568070103 | (37.7542270070727, -122.473568070103) | 1 | 8 | 4 | 56 | 12 | ||||
20036 | 102216 | Undocumented 4 | Tree(s) :: 17 | 46 Aloha Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5991937.9 | 2104336.6 | 37.7576435040563 | -122.470918928367 | (37.7576435040563, -122.470918928367) | 1 | 8 | 4 | 56 | 12 | |||
20180 | 99132 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 302X Pacheco St | 15 | Median : Cutout | Tree | Private 2 | 3 | 5994341.5 | 2100725.2 | 37.7478662384021 | -122.46234443277 | (37.7478662384021, -122.46234443277) | 1 | 8 | 4 | 29491 | 40 | ||||
20319 | 106193 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 3040 TARAVAL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5983698.2 | 2098878.7 | 37.742177638004 | -122.499011481047 | (37.742177638004, -122.499011481047) | 1 | 8 | 3 | 29491 | 35 | ||||
20658 | 116460 | Undocumented 4 | Tree(s) :: 17 | 66 AERIAL WAY | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 30 | 3x3 | Permit Number 777893 | 5992280 | 2102576 | 37.7528291346084 | -122.469607652393 | (37.7528291346084, -122.469607652393) | 1 | 8 | 4 | 56 | 12 | ||
20678 | 212769 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 101 Vicente St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5992862.56204 | 2097797.59669 | 37.7397425107158 | -122.467245652071 | (37.7397425107158, -122.467245652071) | 1 | 8 | 4 | 59 | 40 | |||
20737 | 114465 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 404 Noriega St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5992802 | 2103239 | 37.754679716601 | -122.467850713731 | (37.754679716601, -122.467850713731) | 1 | 8 | 4 | 56 | 12 | |||||
20921 | 118291 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 275 OLYMPIA WAY | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5996383 | 2101914 | 37.7512477308097 | -122.455370966371 | (37.7512477308097, -122.455370966371) | 1 | 5 | 4 | 63 | 38 | ||||
21032 | 121651 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 306 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993098 | 2103247 | 37.7547187703987 | -122.466827655897 | (37.7547187703987, -122.466827655897) | 1 | 8 | 4 | 56 | 12 | ||||
21294 | 98016 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1561@21st Ave Taraval St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5988339.7 | 2098919.1 | 37.7425597372021 | -122.482965774008 | (37.7425597372021, -122.482965774008) | 1 | 8 | 3 | 29491 | 35 | ||||
21352 | 106884 | Undocumented 4 | Ulmus pumila :: Siberian Elm 99 | 180X SAN MARCOS AVE | 6 | Median : Cutout | Tree | Private 2 | DPW | 4 | 5993452.8 | 2100406.9 | 37.7469410536635 | -122.465394372338 | (37.7469410536635, -122.465394372338) | 1 | 8 | 4 | 29491 | 40 | |||
21446 | 107856 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 2938 SLOAT BLVD | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5981725.3 | 2096580 | 37.7357501162313 | -122.505662672753 | (37.7357501162313, -122.505662672753) | 1 | 8 | 3 | 29491 | 35 | |||||
21554 | 256452 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 2901 Sunset Blvd | 1 | Median : Yard | Tree | Private 2 | 3x3 | 5984945 | 2095183 | 37.7321032922905 | -122.494428131787 | (37.7321032922905, -122.494428131787) | 1 | 8 | 4 | 64 | 35 | ||||
21923 | 92943 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 2800X 15TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | tree 1 on 15th st | 5991935 | 2096694 | 37.7366587249535 | -122.470372388311 | (37.7366587249535, -122.470372388311) | 1 | 8 | 4 | 59 | 40 | |||
22036 | 254321 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 220 Junipero Serra Blvd | 2 | Median : Cutout | Tree | Private 2 | 10x10 | 5991369 | 2094955 | 37.731851128725 | -122.472202551974 | (37.731851128725, -122.472202551974) | 1 | 8 | 4 | 64 | 40 | ||||
22107 | 104828 | Undocumented 4 | Juglans regia :: Walnut: English 396 | 22 FOREST SIDE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6x3 | 5992639.6 | 2098939.5 | 37.7428650146746 | -122.468099596108 | (37.7428650146746, -122.468099596108) | 1 | 8 | 4 | 29491 | 40 | |||
22331 | 254742 | Undocumented 4 | Juniperus chinensis :: Juniper 113 | 1301X 39th Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 1x4 | 5984000 | 2105977 | 37.7616853026946 | -122.498492164913 | (37.7616853026946, -122.498492164913) | 1 | 8 | 3 | 56 | 35 | ||||
22388 | 98555 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2360 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5991737.8 | 2099355.8 | 37.7439559460975 | -122.471248063337 | (37.7439559460975, -122.471248063337) | 1 | 8 | 4 | 29491 | 40 | |||||
22557 | 117553 | Undocumented 4 | Tree(s) :: 17 | 1684 09TH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/02/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778514 | 5993454 | 2104036 | 37.7569057003212 | -122.465653839882 | (37.7569057003212, -122.465653839882) | 1 | 8 | 4 | 56 | 12 | |
22607 | 254291 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 110 Junipero Serra Blvd | 3 | Median : Yard | Tree | Private 2 | 3x3 | 5991396 | 2095383 | 37.7330278715114 | -122.472140394325 | (37.7330278715114, -122.472140394325) | 1 | 8 | 4 | 64 | 40 | ||||
22782 | 116019 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 2023 09TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 5993447 | 2101700 | 37.7504912419676 | -122.465508351594 | (37.7504912419676, -122.465508351594) | 1 | 8 | 4 | 29491 | 40 | ||||
23118 | 104735 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1499X 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 5982473.05016 | 2105245.16297 | 37.7595862228156 | -122.503718978789 | (37.7595862228156, -122.503718978789) | 1 | 8 | 3 | 56 | 35 | ||||
23211 | 94019 | Undocumented 4 | Maytenus boaria :: Mayten 58 | 801 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5991550 | 2103152 | 37.754368462002 | -122.472174085076 | (37.754368462002, -122.472174085076) | 1 | 8 | 4 | 56 | 12 | |||
23306 | 92939 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 363 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 5992054.1 | 2096847.4 | 37.7370868080983 | -122.469971777828 | (37.7370868080983, -122.469971777828) | 1 | 8 | 4 | 59 | 40 | ||||
23430 | 111771 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1350 12TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992447 | 2106254 | 37.7629376108266 | -122.469297826347 | (37.7629376108266, -122.469297826347) | 1 | 8 | 11 | 56 | 12 | ||||
23703 | 108349 | Undocumented 4 | Juniperus chinensis :: Juniper 113 | 1501x RIVERA ST | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5988383 | 2100343 | 37.7464719103157 | -122.482920391178 | (37.7464719103157, -122.482920391178) | 1 | 8 | 3 | 29491 | 35 | ||||
23714 | 120955 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2498x 34th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5985867 | 2098260 | 37.7406058338313 | -122.491467021888 | (37.7406058338313, -122.491467021888) | 1 | 8 | 3 | 29491 | 35 | ||||
23741 | 99131 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 302X Pacheco St | 14 | Median : Cutout | Tree | Private 2 | 3 | 5994341.5 | 2100725.2 | 37.7478662384021 | -122.46234443277 | (37.7478662384021, -122.46234443277) | 1 | 8 | 4 | 29491 | 40 | ||||
23753 | 97949 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 2 Mendosa Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993624.4 | 2101138.5 | 37.7489597362933 | -122.464854121346 | (37.7489597362933, -122.464854121346) | 1 | 8 | 4 | 29491 | 40 | ||||
23868 | 205774 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 367 Kensington Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 5ft | 5994104.03782 | 2099097.57437 | 37.7433835122355 | -122.463047484554 | (37.7433835122355, -122.463047484554) | 1 | 8 | 4 | 59 | 40 | |||
24114 | 116895 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 998X KIRKHAM ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991857 | 2105283 | 37.7602373900467 | -122.471267663471 | (37.7602373900467, -122.471267663471) | 1 | 8 | 4 | 56 | 12 | ||||
24252 | 112667 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2550 IRVING ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5988170 | 2106474 | 37.7632935889767 | -122.48410644406 | (37.7632935889767, -122.48410644406) | 1 | 8 | 3 | 56 | 35 | ||||
24527 | 114055 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 700X LAKE MERCED BLVD | 1 | Median : Cutout | Tree | Private 2 | 50 | 5987837 | 2092819 | 37.7257811856502 | -122.484256664993 | (37.7257811856502, -122.484256664993) | 1 | 8 | 4 | 64 | 14 | ||||
24658 | 106897 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 2768 GREAT HWY | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5981642.5 | 2096616.3 | 37.735844912626 | -122.505951630112 | (37.735844912626, -122.505951630112) | 1 | 8 | 3 | 29491 | 35 | |||||
24671 | 99980 | Undocumented 4 | Corymbia maculata :: Spotted Gum 69 | 441 Castenada Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993079.9 | 2099895.8 | 37.7455161901456 | -122.466646671257 | (37.7455161901456, -122.466646671257) | 1 | 8 | 4 | 29491 | 40 | |||||
24901 | 256416 | Undocumented 4 | Ligustrum ovalifolium :: California privet 382 | 3001 Sunset Blvd | 4 | Median : Yard | Tree | Private 2 | 10x10 | 5984960 | 2094729 | 37.7308576064943 | -122.49434282122 | (37.7308576064943, -122.49434282122) | 1 | 8 | 4 | 64 | 35 | ||||
25186 | 98556 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2360 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5991737.8 | 2099355.8 | 37.7439559460975 | -122.471248063337 | (37.7439559460975, -122.471248063337) | 1 | 8 | 4 | 29491 | 40 | |||||
26575 | 209525 | Undocumented 4 | Maytenus boaria :: Mayten 58 | 1975 08th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 5993787.23171 | 2102090.81527 | 37.7515839380697 | -122.464360185395 | (37.7515839380697, -122.464360185395) | 1 | 8 | 4 | 29491 | 12 | |||
26584 | 104941 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 133X Gonzalez Dr | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990327.80869 | 2090136.76282 | 37.718561145924 | -122.475450461306 | (37.718561145924, -122.475450461306) | 1 | 8 | 4 | 64 | 14 | ||||||
26601 | 258075 | Undocumented 4 | Sequoia sempervirens :: Coast Redwood 155 | 1300X Wawona St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10x10 | 5988924 | 2097013 | 37.7373600650942 | -122.480805942066 | (37.7373600650942, -122.480805942066) | 1 | 8 | 3 | 29491 | 35 | ||||
26795 | 122525 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2401X 14th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991964 | 2099053 | 37.7431376164688 | -122.470443874693 | (37.7431376164688, -122.470443874693) | 1 | 8 | 4 | 29491 | 40 | ||||
26965 | 111402 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 50x SANTA RITA AVE | 7 | Median : Yard | Tree | Private 2 | 29 | 5993713 | 2100532 | 37.7472995494238 | -122.464503713167 | (37.7472995494238, -122.464503713167) | 1 | 8 | 4 | 29491 | 40 | ||||
27037 | 106347 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 415 DEWEY BLVD | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5995172.1 | 2100351 | 37.7468865723154 | -122.459445180048 | (37.7468865723154, -122.459445180048) | 1 | 8 | 4 | 59 | 40 | |||||
27147 | 251588 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1430 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990886 | 2105639 | 37.7611586563939 | -122.474651843595 | (37.7611586563939, -122.474651843595) | 1 | 8 | 4 | 56 | 12 | ||||
27823 | 106820 | Undocumented 4 | Tree(s) :: 17 | 171 Wawona St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2014 12:00:00 AM | Permit Number 773294 | 5992783 | 2098017 | 37.7403403436725 | -122.467536692567 | (37.7403403436725, -122.467536692567) | 1 | 8 | 4 | 59 | 40 | |||
28156 | 114119 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1200X JUNIPERO SERRA BLVD | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
28517 | 94060 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 1401X 08th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993648 | 2105942 | 37.7621502689837 | -122.465121353228 | (37.7621502689837, -122.465121353228) | 1 | 8 | 11 | 56 | 12 | ||||
28614 | 182551 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2565 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5986541.5452 | 2105693.4321 | 37.7610554202125 | -122.489681251316 | (37.7610554202125, -122.489681251316) | 1 | 8 | 3 | 56 | 35 |
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) );