trees

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

✎ View and edit SQL

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)
28773 114213 Undocumented 4 Pinus radiata :: Monterey Pine 15 230 SERRANO DR 1 Sidewalk: Curb side : Yard Tree Private 2     60     5988981 2090766 37.7202107101289 -122.480151800691 (37.7202107101289, -122.480151800691) 1 8 4 64 14
28786 121671 Undocumented 4 Tree(s) :: 17 2 Edgehill Way 1 Sidewalk: Curb side : Cutout Tree Private 2   02/03/2017 12:00:00 AM 3 3x3 Permit Number 779402 5994953 2099187 37.7436779193362 -122.460118487781 (37.7436779193362, -122.460118487781) 1 8 4 59 40
28982 104551 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 428 PANORAMA DR   Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   5997536 2102327 37.7524478160364 -122.451413569464 (37.7524478160364, -122.451413569464) 1 5 4 63 38
29569 105213 Undocumented 4 Geijera parviflora :: Australian Willow 25 2400X 21ST AVE 2 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   5989837 2098691 37.7420204448441 -122.477771936587 (37.7420204448441, -122.477771936587) 1 8 3 29491 35
29783 258501 Undocumented 4 Tree(s) :: 17 1354 24th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5988698 2106101 37.7623001590834 -122.482252958001 (37.7623001590834, -122.482252958001) 1 8 3 56 35
29849 99121 Undocumented 4 Pinus radiata :: Monterey Pine 15 302X Pacheco St 2 Median : Cutout Tree Private 2     3     5994341.5 2100725.2 37.7478662384021 -122.46234443277 (37.7478662384021, -122.46234443277) 1 8 4 29491 40
29942 122392 Undocumented 4 Prunus cerasifera :: Cherry Plum 7 150 Magellan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5995041 2100839 37.7482189589569 -122.459933853654 (37.7482189589569, -122.459933853654) 1 8 4 29491 40
30007 114128 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 1200X JUNIPERO SERRA BLVD 21 Sidewalk: Property side : Yard Tree Private 2     18     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
30069 256475 Undocumented 4 Pinus radiata :: Monterey Pine 15 2901X Sunset Blvd Off Ramp 1 Median : Yard Tree Private 2       3x3   5985408 2095918 37.7341484934627 -122.49288158081 (37.7341484934627, -122.49288158081) 1 8 3 29491 35
30374 112344 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 40 WEST PORTAL AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5993136 2098044 37.7404348530896 -122.466318130629 (37.7404348530896, -122.466318130629) 1 8 4 59 40
30545 111071 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 1908 15TH AVE 1 Sidewalk: Curb side : Yard Tree Private 2       3x3   5991632 2102414 37.7523468518329 -122.471836728689 (37.7523468518329, -122.471836728689) 1 8 4 29491 12
30619 114927 Undocumented 4 Pinus radiata :: Monterey Pine 15 4400x OCEAN AVE 1 Front Yard : Cutout Tree Private 2       3x3   5985931 2095134 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892) 1 8 4 64 35
30697 105509 Undocumented 4 Tree(s) :: 17 140 TARAVAL ST 1 Sidewalk: Curb side : Cutout Tree Private 2     8 9x3   5992997.9 2099204.1 37.743612225158 -122.466879936751 (37.743612225158, -122.466879936751) 1 8 4 29491 40
30805 106785 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 335 Lawton St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 6x8   5993281 2104569 37.7583591997637 -122.466290868324 (37.7583591997637, -122.466290868324) 1 8 4 56 12
31127 116016 Undocumented 4 Tree(s) :: 17 469 PACHECO ST 1 Sidewalk: Curb side : Cutout Tree Private 2   04/05/2016 12:00:00 AM 3 6x18 Permit Number 777821 5993702 2101802 37.7507860118971 -122.464633955158 (37.7507860118971, -122.464633955158) 1 8 4 29491 40
31215 118300 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 275 OLYMPIA WAY 11 Sidewalk: Property side : Cutout Tree Private 2       3x3   5996383 2101914 37.7512477308097 -122.455370966371 (37.7512477308097, -122.455370966371) 1 5 4 63 38
31356 106089 Undocumented 4 Syzygium paniculatum :: Brush Cherry 243 1446 36TH AVE 2 Sidewalk: Curb side : Cutout Tree Private 2     14 6x6   5984998.6 2105346.4 37.7600123616364 -122.494991962302 (37.7600123616364, -122.494991962302) 1 8 3 56 35
31691 112077 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1901x SANTIAGO ST 5 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   5986971 2099566 37.7442562155119 -122.487745790198 (37.7442562155119, -122.487745790198) 1 8 3 29491 35
31746 104753 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 2328 12TH AVE   Front Yard : Cutout Tree Private 2     22   Permit Number 770921 5992676.8 2099585.2 37.7446400909628 -122.468017927356 (37.7446400909628, -122.468017927356) 1 8 4 29491 40
31991 106187 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 1353 ULLOA ST 2 Sidewalk: Curb side : Yard Tree Private 2     12 4x15   5991777 2098367.4 37.7412443198206 -122.471040528993 (37.7412443198206, -122.471040528993) 1 8 4 59 40
32419 110166 Undocumented 4 Pinus radiata :: Monterey Pine 15 131x GARCES DR 1 Front Yard : Yard Tree Private 2     28     5989202 2088902 37.7151054701837 -122.479251597893 (37.7151054701837, -122.479251597893) 1 8 4 64 14
32576 99657 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 1325 Portola Dr 1 Sidewalk: Curb side : Cutout Tree Private 2           5993615.2 2097760.6 37.7396843456359 -122.464640684629 (37.7396843456359, -122.464640684629) 1 8 4 59 40
32643 99129 Undocumented 4 Pinus radiata :: Monterey Pine 15 302X Pacheco St 12 Median : Cutout Tree Private 2     18     5994341.5 2100725.2 37.7478662384021 -122.46234443277 (37.7478662384021, -122.46234443277) 1 8 4 29491 40
32748 108347 Undocumented 4 Juniperus chinensis :: Juniper 113 1501x RIVERA ST 3 Sidewalk: Property side : Yard Tree Private 2       3x3   5988383 2100343 37.7464719103157 -122.482920391178 (37.7464719103157, -122.482920391178) 1 8 3 29491 35
32853 99729 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 2645 Ocean Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5990840.1 2094977 37.7318809123737 -122.474032655501 (37.7318809123737, -122.474032655501) 1 8 4 64 40
32903 102217 Undocumented 4 Tree(s) :: 17 38 Aloha Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   5991980.4 2104319.5 37.7575990098106 -122.470770701837 (37.7575990098106, -122.470770701837) 1 8 4 56 12
32908 104998 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 286X CASTENADA AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     60 4x18   5993881 2100258 37.746556897942 -122.463902900317 (37.746556897942, -122.463902900317) 1 8 4 29491 40
33112 104928 Undocumented 4 Washingtonia robusta :: Mexican Fan Palm 72 810 Gonzalez Dr 3 Median : Yard Tree Private 2     12     5990385 2090588 37.7198034465129 -122.47528570222 (37.7198034465129, -122.47528570222) 1 8 4 64 14
33148 106883 Undocumented 4 Ulmus pumila :: Siberian Elm 99 180X SAN MARCOS AVE 4 Median : Cutout Tree Private 2 DPW   4     5993452.8 2100406.9 37.7469410536635 -122.465394372338 (37.7469410536635, -122.465394372338) 1 8 4 29491 40
33460 115831 Undocumented 4 Pinus radiata :: Monterey Pine 15 1X JUNIPERO SERRA BLVD OFF RAMP 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5991168 2088425 37.713909732222 -122.472421570074 (37.713909732222, -122.472421570074) 1 8 4 64 14
33575 101270 Undocumented 4 Myoporum laetum :: Myoporum 62 1290X 24th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5988657 2106549.8 37.7635300567879 -122.482427645612 (37.7635300567879, -122.482427645612) 1 8 3 56 35
33654 117552 Undocumented 4 Prunus cerasifera :: Cherry Plum 7 1684 09TH AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5993454 2104036 37.7569057003212 -122.465653839882 (37.7569057003212, -122.465653839882) 1 8 4 56 12
33668 102791 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 1400X 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5983413 2105597.3 37.7606083127672 -122.500494252669 (37.7606083127672, -122.500494252669) 1 8 3 56 35
33801 114265 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 800x BROTHERHOOD WAY 6 Front Yard : Cutout Tree Private 2     26     5990271 2088582 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779) 1 8 4 64 14
33960 121681 Undocumented 4 Maytenus boaria :: Mayten 58 900 Lawton St 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5991505 2104920 37.7592203205256 -122.472458589604 (37.7592203205256, -122.472458589604) 1 8 4 56 12
33969 103647 Undocumented 4 Tree(s) :: 17 500X Oak Park Dr 2 Sidewalk: Property side : Yard Tree Private 2     7 3x10   5994983.3 2103652.8 37.7559416221353 -122.460337221652 (37.7559416221353, -122.460337221652) 1 5 4 63 12
34066 100190 Undocumented 4 Tree(s) :: 17 404 Noriega St 2 Sidewalk: Property side : Yard Tree Private 2   01/07/2016 12:00:00 AM     Permit Number 776979 5992802 2103239 37.754679716601 -122.467850713731 (37.754679716601, -122.467850713731) 1 8 4 56 12
34147 110720 Undocumented 4 Callistemon viminalis :: Weeping Bottlebrush 60 1898X 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2           5993137.43282 2102888.05903 37.753735486992 -122.466665198088 (37.753735486992, -122.466665198088) 1 8 4 56 12
34411 114369 Undocumented 4 Betula pendula :: European White Birch 253 823 GONZALEZ DR 1 Sidewalk: Curb side : Yard Tree Private 2     4     5988303 2089566 37.7168763935413 -122.482407513776 (37.7168763935413, -122.482407513776) 1 8 4 64 14
34416 110631 Undocumented 4 Tree(s) :: 17 1001X Mandalay Ln   Unaccepted Street : Cutout Tree Private 2           5991736.20076 2101819.33429 37.7507200830769 -122.47143306251 (37.7507200830769, -122.47143306251) 1 8 4 29491 12
34419 116605 Undocumented 4 Ficus Spp. :: 101 1325x 08TH AVE 2 Front Yard : Yard Tree MTA 3           5993613 2106469 37.7635952548206 -122.465280685608 (37.7635952548206, -122.465280685608) 1 8 11 56 12
34459 110395 Undocumented 4 Maytenus boaria :: Mayten 58 150 CORTES AVE 2 Sidewalk: Curb side : Cutout Tree Private 2       3x20   5993201 2099275 37.7438186186199 -122.466182823803 (37.7438186186199, -122.466182823803) 1 8 4 29491 40
34737 111082 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 130 JUNIPERO SERRA BLVD 1 Median : Cutout Tree Private 2       3x3   5991393 2095322 37.7328602072681 -122.472146321186 (37.7328602072681, -122.472146321186) 1 8 4 64 40
34968 258294 Undocumented 4 Ficus microcarpa :: Chinese Banyan 97 2498X 17th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5991168 2098442 37.7414139101312 -122.473151653247 (37.7414139101312, -122.473151653247) 1 8 4 29491 40
35142 102666 Undocumented 4 Pittosporum crassifolium :: Karo Tree 95 3399X Wawona St 7 Sidewalk: Property side : Cutout Tree Private 2       3x3   5982463.4 2096719.2 37.7361757338901 -122.503121118731 (37.7361757338901, -122.503121118731) 1 8 3 29491 35
35165 114121 Undocumented 4 Pinus radiata :: Monterey Pine 15 1200X JUNIPERO SERRA BLVD 14 Sidewalk: Property side : Yard Tree Private 2     28     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
35318 105910 Undocumented 4 Tree(s) :: 17 80 LINARES AVE 5 Sidewalk: Curb side : Yard Tree Private 2           5994154.8 2102090.7 37.7516048020548 -122.463089089164 (37.7516048020548, -122.463089089164) 1 8 4 29491 40
35372 94058 Undocumented 4 Ficus nitida :: Laurel Fig 53 1401X 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   5993648 2105942 37.7621502689837 -122.465121353228 (37.7621502689837, -122.465121353228) 1 8 11 56 12
35560 98376 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 199X Cragmont Ave 1 Unaccepted Street : Yard Tree Private 2           5992899 2101153 37.7489576989052 -122.467363590244 (37.7489576989052, -122.467363590244) 1 8 4 29491 40
35855 98006 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 2400@Taraval 19th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5990522.5 2099005.4 37.7429234655348 -122.475424670664 (37.7429234655348, -122.475424670664) 1 8 4 29491 40
36157 112873 Undocumented 4 Calocedrus decurrens :: Incense Cedar 206 1899x 21ST AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   5989645 2102484 37.752423882657 -122.478713138519 (37.752423882657, -122.478713138519) 1 8 3 56 35
36199 255343 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 700 Brotherhood Way 3 Sidewalk: Curb side : Cutout Tree Private 2       3x21   5991178 2088065 37.7129218386335 -122.472360778797 (37.7129218386335, -122.472360778797) 1 8 4 64 14
36528 107066 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 1758 12th Ave 1 Front Yard : Yard Tree Private 2   07/24/2014 12:00:00 AM     Permit Number 773344 5992506.32742 2103625.79831 37.7557246862805 -122.468901366602 (37.7557246862805, -122.468901366602) 1 8 4 56 12
36629 100302 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 250 Kirkham St 4 Sidewalk: Curb side : Cutout Tree Private 2       6x6   5994135.4 2105324.6 37.7604831423825 -122.463390830401 (37.7604831423825, -122.463390830401) 1 5 11 56 12
37040 122522 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 2401X 14th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   5991964 2099053 37.7431376164688 -122.470443874693 (37.7431376164688, -122.470443874693) 1 8 4 29491 40
37079 104885 Undocumented 4 Pinus radiata :: Monterey Pine 15 134 Gonzalez Dr 2 Sidewalk: Curb side : Yard Tree Private 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
37123 111405 Undocumented 4 Pinus radiata :: Monterey Pine 15 50x SANTA RITA AVE 10 Median : Yard Tree Private 2     50     5993713 2100532 37.7472995494238 -122.464503713167 (37.7472995494238, -122.464503713167) 1 8 4 29491 40
37154 254306 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 170 Junipero Serra Blvd 3 Median : Cutout Tree Private 2       10x10   5991380 2095134 37.732343254282 -122.47217756607 (37.732343254282, -122.47217756607) 1 8 4 64 40
37469 92936 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 345 West Portal Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     6     5992182.7 2096880.8 37.7371859491769 -122.469529584198 (37.7371859491769, -122.469529584198) 1 8 4 59 40
37581 114212 Undocumented 4 Pinus radiata :: Monterey Pine 15 302 SERRANO DR 1 Sidewalk: Curb side : Yard Tree Private 2     64     5988825 2090618 37.7197952736455 -122.480680205506 (37.7197952736455, -122.480680205506) 1 8 4 64 14
37610 107715 Undocumented 4 Pittosporum spp :: Pittosporum spp 170 206 Castenada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 773987 5994256.34656 2100642.25376 37.7476335852577 -122.462632871159 (37.7476335852577, -122.462632871159) 1 8 4 29491 40
37718 110162 Undocumented 4 Tree(s) :: 17 123x GARCES DR 2 Front Yard : Yard Tree Private 2   06/06/2016 12:00:00 AM 3   Permit Number 777996 5989202 2088902 37.7151054701837 -122.479251597893 (37.7151054701837, -122.479251597893) 1 8 4 64 14
37912 110359 Undocumented 4 Magnolia grandiflora :: Southern Magnolia 19 1850 IRVING ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5989944 2106611 37.763772878654 -122.477980844758 (37.763772878654, -122.477980844758) 1 8 3 56 35
38004 108351 Undocumented 4 Juniperus chinensis :: Juniper 113 1501x RIVERA ST 7 Sidewalk: Property side : Yard Tree Private 2       3x3   5988383 2100343 37.7464719103157 -122.482920391178 (37.7464719103157, -122.482920391178) 1 8 3 29491 35
38057 102472 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 66 Sotelo Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       6x15   5993897.9 2101386.8 37.7496572701738 -122.463926385697 (37.7496572701738, -122.463926385697) 1 8 4 29491 40
38206 106185 Undocumented 4 Gleditsia triacanthos 'Aurea' :: Honey Locust 'Aurea' 442 1349 ULLOA ST 2 Sidewalk: Curb side : Cutout Tree Private 2     8 4x4   5991806.5 2098368.4 37.7412487717429 -122.470938602248 (37.7412487717429, -122.470938602248) 1 8 4 59 40
38294 107304 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 1499X 17TH AVE 2 Sidewalk: Curb side : Cutout Tree Private 2           5990843 2105531 37.7608596255093 -122.47479267759 (37.7608596255093, -122.47479267759) 1 8 4 56 12
38297 101271 Undocumented 4 Myoporum laetum :: Myoporum 62 1290X 24th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5988657 2106549.8 37.7635300567879 -122.482427645612 (37.7635300567879, -122.482427645612) 1 8 3 56 35
38900 97781 Undocumented 4 Eucalyptus Spp :: Eucalyptus 52 249 Wawona St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 strip   5992441.6 2097612.4 37.7392096976829 -122.468687674985 (37.7392096976829, -122.468687674985) 1 8 4 59 40
39038 97647 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 1844 Noriega St   Sidewalk: Curb side : Cutout Tree Private 2       3x3   5988207.7 2103154.5 37.7541813368782 -122.483732655057 (37.7541813368782, -122.483732655057) 1 8 3 56 35
39366 98015 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1561@21st Ave Taraval St 2 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
39520 92928 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 301 West Portal Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     10   tree 2 on 14th st 5992361 2097058 37.7376827987343 -122.468926016741 (37.7376827987343, -122.468926016741) 1 8 4 59 40
39528 184186 Undocumented 4 Myoporum laetum :: Myoporum 62 1651 47th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     13 Width 0ft   5981569.4938 2103830.3301 37.7556483274352 -122.50673893378 (37.7556483274352, -122.50673893378) 1 8 3 56 35
39545 101317 Undocumented 4 Magnolia grandiflora :: Southern Magnolia 19 273 Magellan Ave 2 Sidewalk: Curb side : Cutout Tree Private 2           5994674.1 2100293.4 37.7466997707371 -122.461163031194 (37.7466997707371, -122.461163031194) 1 8 4 29491 40
39547 114133 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 1200X JUNIPERO SERRA BLVD 26 Sidewalk: Property side : Yard Tree Private 2     28     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
39787 255358 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 700 Brotherhood Way 39 Sidewalk: Curb side : Cutout Tree Private 2       3x21   5991178 2088065 37.7129218386335 -122.472360778797 (37.7129218386335, -122.472360778797) 1 8 4 64 14
40027 255997 Undocumented 4 Tree(s) :: 17 119 Serrano Dr 1 Sidewalk: Curb side : Cutout Tree Private 2   04/12/2019 12:00:00 AM 3 3x3 Permit Number 782200 5989797 2090440 37.7193629757475 -122.477307378715 (37.7193629757475, -122.477307378715) 1 8 4 64 14
40666 110721 Undocumented 4 Callistemon viminalis :: Weeping Bottlebrush 60 1898X 10th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2           5993137.43282 2102888.05903 37.753735486992 -122.466665198088 (37.753735486992, -122.466665198088) 1 8 4 56 12
40697 108348 Undocumented 4 Juniperus chinensis :: Juniper 113 1501x RIVERA ST 4 Sidewalk: Property side : Yard Tree Private 2     8 3x3   5988501 2100296 37.7463497260509 -122.482508921927 (37.7463497260509, -122.482508921927) 1 8 3 29491 35
40755 95686 Undocumented 4 Pinus radiata :: Monterey Pine 15 373 Castenada Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   03/08/2011 12:00:00 AM     Permit Number 56980 5993476.3 2100002.1 37.7458309308973 -122.465283713064 (37.7458309308973, -122.465283713064) 1 8 4 29491 40
40783 104040 Undocumented 4 Acacia spp :: Acacia Spp 105 2487 15th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       2x3   5991681.3 2098507.3 37.7416229139376 -122.471381613625 (37.7416229139376, -122.471381613625) 1 8 4 29491 40
41472 98007 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 2400@Taraval 19th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5990522.5 2099005.4 37.7429234655348 -122.475424670664 (37.7429234655348, -122.475424670664) 1 8 4 29491 40
41577 108877 Undocumented 4 Eucalyptus microtheca :: Flooded Box: Coolibah 455 240X NORIEGA ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5993306.5 2103252.9 37.7547470014972 -122.466107040855 (37.7547470014972, -122.466107040855) 1 8 4 56 12
41733 102223 Undocumented 4 Tree(s) :: 17 30 Aloha Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   5992101.6 2104316.3 37.7575972316932 -122.470351313846 (37.7575972316932, -122.470351313846) 1 8 4 56 12
41763 114139 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 1200X JUNIPERO SERRA BLVD 34 Sidewalk: Property side : Yard Tree Private 2     36     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
41812 115588 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 2574 28th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   5987741.7 2097778.5 37.7393931357191 -122.484949795247 (37.7393931357191, -122.484949795247) 1 8 3 29491 35
41895 100296 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 1494 07th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       4.5x5   5994028.4 2105353.7 37.7605568782163 -122.463763003523 (37.7605568782163, -122.463763003523) 1 5 11 56 12
42100 114131 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 1200X JUNIPERO SERRA BLVD 24 Sidewalk: Property side : Yard Tree Private 2     30     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
42366 114061 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 700X LAKE MERCED BLVD 7 Median : Cutout Tree Private 2     52     5987837 2092819 37.7257811856502 -122.484256664993 (37.7257811856502, -122.484256664993) 1 8 4 64 14
42565 98009 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 2400@Taraval 19th Ave 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5990522.5 2099005.4 37.7429234655348 -122.475424670664 (37.7429234655348, -122.475424670664) 1 8 4 29491 40
42687 111231 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 398X VICENTE ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5991792 2097792 37.7396652854914 -122.470946758559 (37.7396652854914, -122.470946758559) 1 8 4 59 40
42840 97952 Undocumented 4 Prunus cerasifera :: Cherry Plum 7 2 Mendosa Ave 3 Sidewalk: Curb side : Cutout Tree Private 2           5993624.4 2101138.5 37.7489597362933 -122.464854121346 (37.7489597362933, -122.464854121346) 1 8 4 29491 40
42934 114111 Undocumented 4 Pinus radiata :: Monterey Pine 15 1200X JUNIPERO SERRA BLVD 2 Sidewalk: Property side : Yard Tree Private 2     40     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
43218 92923 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 2725X 14th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3 tree 3 on 14th st 5992210 2097192 37.7380420035645 -122.46945784276 (37.7380420035645, -122.46945784276) 1 8 4 59 40
43226 112951 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 300X VICENTE ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5992030 2097800 37.7397010133852 -122.470124446456 (37.7397010133852, -122.470124446456) 1 8 4 59 40
43332 110591 Undocumented 4 Pinus radiata :: Monterey Pine 15 1160X PORTOLA DR 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5994964 2098019 37.7404715144277 -122.459995857341 (37.7404715144277, -122.459995857341) 1 8 4 59 40
43604 114263 Undocumented 4 Pinus radiata :: Monterey Pine 15 800x BROTHERHOOD WAY 4 Front Yard : Cutout Tree Private 2     29     5990271 2088582 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779) 1 8 4 64 14
43607 116022 Undocumented 4 Tree(s) :: 17 100 CORTES AVE 2 Sidewalk: Curb side : Cutout Tree Private 2   04/21/2016 12:00:00 AM 3 3x10 Permit Number 777819 5993193 2099364 37.7440625285098 -122.466216952212 (37.7440625285098, -122.466216952212) 1 8 4 29491 40
43872 112950 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 300X VICENTE ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5992030 2097800 37.7397010133852 -122.470124446456 (37.7397010133852, -122.470124446456) 1 8 4 59 40
44179 111235 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 2601X 15TH AVE 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5991704 2097685 37.7393664008113 -122.471243228199 (37.7393664008113, -122.471243228199) 1 8 4 29491 40

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