8,298 rows where qLegalStatus_id = 4 sorted by Fire Prevention Districts

View and edit SQL

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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);