trees

1,732 rows where qLegalStatus_id = 6 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)
21303 115100 Significant Tree 6 Tree(s) :: 17 710 PACHECO ST 1 Front Yard : Cutout Tree Private 2   02/04/2016 12:00:00 AM 3 3x3 Permit Number 777305 5992727 2102215 37.7518637464828 -122.468035600741 (37.7518637464828, -122.468035600741) 1 8 4 29491 12
21577 114229 Significant Tree 6 Acacia longifolia :: Golden Wattle 150 99x FONT BLVD 5 Sidewalk: Curb side : Yard Tree Private 2     13     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
22895 256572 Significant Tree 6 Ilex aquifolium :: European Holly 390 175 Castenada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5994536 2100823 37.748145970457 -122.461678955671 (37.748145970457, -122.461678955671) 1 8 4 29491 40
23985 114387 Significant Tree 6 Prunus cerasifera :: Cherry Plum 7 417x ARBALLO DR 1 Sidewalk: Curb side : Yard Tree Private 2     7     5988152 2090574 37.7196353223366 -122.483003277928 (37.7196353223366, -122.483003277928) 1 8 4 64 14
24761 101258 Significant Tree 6 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 1049 Irving St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5992548 2106581 37.7638413023971 -122.468972303767 (37.7638413023971, -122.468972303767) 1 8 11 56 12
26401 114389 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 345x ARBALLO DR 1 Front Yard : Yard Tree Private 2     8     5988176 2090635 37.7198042094326 -122.48292478788 (37.7198042094326, -122.48292478788) 1 8 4 64 14
27121 114234 Significant Tree 6 Acacia longifolia :: Golden Wattle 150 99x FONT BLVD 10 Sidewalk: Curb side : Yard Tree Private 2     20     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
27831 98834 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 333 Pacheco St 3 Sidewalk: Curb side : Cutout Tree Private 2           5994230.9 2100817.4 37.748113026994 -122.462733567037 (37.748113026994, -122.462733567037) 1 8 4 29491 40
28176 114157 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1200x JUNIPERO SERRA BLVD 18 Front Yard : Yard Tree Private 2     32     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
28871 100193 Significant Tree 6 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 361 Dellbrook Ave 1 Front Yard : Yard Tree Private 2           5997322.2 2102403.9 37.7526467193673 -122.45215846969 (37.7526467193673, -122.45215846969) 1 5 4 63 38
30455 114232 Significant Tree 6 Acacia longifolia :: Golden Wattle 150 99x FONT BLVD 8 Sidewalk: Curb side : Yard Tree Private 2     15     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
30556 104909 Significant Tree 6 Pinus radiata :: Monterey Pine 15 533 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990435 2090585 37.7197981072685 -122.475112652722 (37.7197981072685, -122.475112652722) 1 8 4 64 40
31451 114152 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1200X JUNIPERO SERRA BLVD 11 Front Yard : Yard Tree Private 2     8     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
31720 254395 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 1286 26th Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x3 Permit Number 781556 5988061 2106558 37.7635178832746 -122.484489596097 (37.7635178832746, -122.484489596097) 1 8 3 56 35
33433 104433 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 1601X PORTOLA DR 2 Front Yard : Yard Tree Private 2     16     5991823 2096240 37.7354056792703 -122.47072655808 (37.7354056792703, -122.47072655808) 1 8 4 59 40
34293 111094 Significant Tree 6 Pinus radiata :: Monterey Pine 15 150x FONT BLVD   Sidewalk: Curb side : Cutout Tree Private 2   06/04/2015 12:00:00 AM 30 3x3 Permit Number 775594 5990976 2089133 37.7158426125161 -122.473136789074 (37.7158426125161, -122.473136789074) 1 8 4 64 14
35139 104434 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 1601X PORTOLA DR 3 Front Yard : Yard Tree Private 2     13     5991823 2096240 37.7354056792703 -122.47072655808 (37.7354056792703, -122.47072655808) 1 8 4 59 40
35440 97955 Significant Tree 6 Liquidambar styraciflua 'Slender Silhoutte' :: Upright Liquidambar 438 2 Mendosa Ave 1 Front Yard : Yard Tree Private 2   12/05/2011 12:00:00 AM     Permit Number 768165 5993624.4 2101138.5 37.7489597362933 -122.464854121346 (37.7489597362933, -122.464854121346) 1 8 4 29491 40
36915 117645 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 2901 21ST AVE 1 Back Yard : Yard Tree Private 2       3x3   5989904 2095901 37.734363711699 -122.477336418651 (37.734363711699, -122.477336418651) 1 8 4 64 35
37092 254109 Significant Tree 6 Tree(s) :: 17 38X Starview Way 1 Sidewalk: Property side : Yard Tree Private 2   02/06/2018 12:00:00 AM 3 6x6 Permit Number 781050 5997469 2101545 37.7502968010125 -122.451588863361 (37.7502968010125, -122.451588863361) 1 5 4 63 38
37232 256765 Significant Tree 6 Tree(s) :: 17 355 Serrano Dr 1 Sidewalk: Property side : Yard Tree Private 2   01/15/2019 12:00:00 AM 3 3x3 Permit Number 782555 5988732 2090042 37.7182083166364 -122.480959519123 (37.7182083166364, -122.480959519123) 1 8 4 64 14
38129 114239 Significant Tree 6 Acacia longifolia :: Golden Wattle 150 1300x JUNIPERO SERRA BLVD 1 Sidewalk: Curb side : Yard Tree Private 2     28     5991168 2088425 37.713909732222 -122.472421570074 (37.713909732222, -122.472421570074) 1 8 4 64 14
38864 114149 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1200X JUNIPERO SERRA BLVD 8 Front Yard : Yard Tree Private 2     12     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
39382 114391 Significant Tree 6 Pyrus kawakamii :: Evergreen Pear 83 23x PINTO AVE 2 Front Yard : Yard Tree Private 2     7     5988521 2090808 37.7202992922588 -122.481744923362 (37.7202992922588, -122.481744923362) 1 8 4 64 14
39757 104892 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 201 Gonzalez Dr   Front Yard : Yard Tree Private 2           5990435 2090585 37.7197981072685 -122.475112652722 (37.7197981072685, -122.475112652722) 1 8 4 64 40
40036 104493 Significant Tree 6 Acer circinatum :: Vine Maple 452 171 SAN MARCOS AVE 1 Front Yard : Yard Tree Private 2         Permit Number 770388 5993514 2100282 37.7466016393389 -122.465173679454 (37.7466016393389, -122.465173679454) 1 8 4 29491 40
41336 96569 Significant Tree 6 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1101 Eucalyptus Dr   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.7310370666678 -122.483566221845 (37.7310370666678, -122.483566221845) 1 8 4 64 14
41877 114072 Significant Tree 6 Magnolia grandiflora :: Southern Magnolia 19 454 ARBALLO DR 1 Sidewalk: Curb side : Yard Tree Private 2     4     5987903 2090420 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784) 1 8 4 64 14
42536 97945 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 2 Mendosa Ave 1 Front Yard : Yard Tree Private 2         Permit Number 768165 5993624.4 2101138.5 37.7489597362933 -122.464854121346 (37.7489597362933, -122.464854121346) 1 8 4 29491 40
43088 112378 Significant Tree 6 :: 45 1850 19TH AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   5990394 2102783 37.7532883185876 -122.476144836826 (37.7532883185876, -122.476144836826) 1 8 4 56 12
43131 116576 Significant Tree 6 Eucalyptus Spp :: Eucalyptus 52 2500x OCEAN AVE 1 Sidewalk: Property side : Yard Tree MTA 3 DPW   30 10X10   5991377 2094742 37.7312667472315 -122.472159374256 (37.7312667472315, -122.472159374256) 1 8 4 64 40
43207 111069 Significant Tree 6 Ilex spp :: Holly Species 81 1836 08TH AVE 3 Front Yard : Cutout Tree Private 2       3x15   5993799 2102987 37.7540453100112 -122.464384550175 (37.7540453100112, -122.464384550175) 1 8 4 56 12
44052 114240 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 99x FONT BLVD 16 Sidewalk: Curb side : Yard Tree Private 2           5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
44150 105208 Significant Tree 6 Myoporum laetum :: Myoporum 62 2694 47TH AVE   Front Yard : Yard Tree Private 2           5981878.3 2096771.8 37.7362857499502 -122.505147911282 (37.7362857499502, -122.505147911282) 1 8 3 29491 35
44683 114406 Significant Tree 6 Cedrus atlantica Glauca :: Blue Atlas Cedar 208 500X ARBALLO DR 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5987859 2089716 37.7172624174607 -122.483953179035 (37.7172624174607, -122.483953179035) 1 8 4 64 14
44754 253482 Significant Tree 6 Juniperus chinensis :: Juniper 113 2179 41st Ave 1 Front Yard : Yard Tree Private 2       3x5   5983532 2100331 37.7461555051432 -122.499693454208 (37.7461555051432, -122.499693454208) 1 8 3 29491 35
44804 114228 Significant Tree 6 Acacia longifolia :: Golden Wattle 150 99x FONT BLVD 4 Sidewalk: Curb side : Yard Tree Private 2     7     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
45348 93222 Significant Tree 6 Tree(s) :: 17 85 Santa Rita Ave 2 Front Yard : Yard Tree Private 2   02/26/2010 12:00:00 AM     Permit Number 53213 5993788 2100441 37.7470540096767 -122.464237765204 (37.7470540096767, -122.464237765204) 1 8 4 29491 40
45577 92320 Significant Tree 6 Metrosideros excelsa :: New Zealand Xmas Tree 16 2733 Wawona St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/18/2008 12:00:00 AM 3 3x3   5984522 2096783 37.7364716996862 -122.496008508371 (37.7364716996862, -122.496008508371) 1 8 3 29491 35
48743 253145 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 801X Santiago St 1 Side Yard : Yard Tree Private 2           5990274 2099728 37.7448931297685 -122.476336677657 (37.7448931297685, -122.476336677657) 1 8 3 29491 35
50522 93931 Significant Tree 6 Pinus Spp :: Pine Spp 100     Front Yard : Yard Tree Private 2   04/28/2010 12:00:00 AM     Permit Number 53387 5990375.96797 2090932.55284 37.7207489795508 -122.475342064841 (37.7207489795508, -122.475342064841) 1 8 4 64 14
51304 255705 Significant Tree 6 Pinus radiata :: Monterey Pine 15 200X Blairwood Ln 1 Unaccepted Street : Yard Tree Private 2       10x10   5995660 2102951 37.7540535603115 -122.457946200633 (37.7540535603115, -122.457946200633) 1 5 4 63 12
51737 116458 Significant Tree 6 Eucalyptus lehmanni :: Bushy Yate 260 777 Brotherhood Way 1 Sidewalk: Curb side : Yard Tree Private 2     12 10x20   5989819.39068 2088633.8654 37.7144050769972 -122.477098071327 (37.7144050769972, -122.477098071327) 1 8 4 64 14
51852 114156 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1200x JUNIPERO SERRA BLVD 17 Front Yard : Yard Tree Private 2     32     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
52128 112811 Significant Tree 6 Tree(s) :: 17 2023 43rd Ave 1 Front Yard : Yard Tree Private 2           5982877.4 2101339.2 37.7488853101021 -122.502031530859 (37.7488853101021, -122.502031530859) 1 8 3 29491 35
52558 255280 Significant Tree 6 Olea europaea :: Olive Tree 9 320 Magellan Ave 1 Front Yard : Yard Tree Private 2   05/01/2018 12:00:00 AM 3 10x20 Permit Number 781012 5994287.14264 2099988.88368 37.7458413694018 -122.462478996433 (37.7458413694018, -122.462478996433) 1 8 4 29491 40
52837 99659 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 1325 Portola Dr 3 Front Yard : Yard Tree Private 2           5993615.2 2097760.6 37.7396843456359 -122.464640684629 (37.7396843456359, -122.464640684629) 1 8 4 59 40
53875 254255 Significant Tree 6 Pinus radiata :: Monterey Pine 15 45X Everglade Dr 2 Sidewalk: Property side : Yard Tree Private 2       3x3   5986312 2095495 37.7330398702545 -122.489725113139 (37.7330398702545, -122.489725113139) 1 8 4 64 35
54288 115736 Significant Tree 6 Acer rubrum :: Red Maple 75 66 Yerba Buena Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3   Permit Number 776551 5993801.4 2096894.7 37.7373175329251 -122.463934052027 (37.7373175329251, -122.463934052027) 1 8 4 59 40
54493 114150 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1200X JUNIPERO SERRA BLVD 9 Front Yard : Yard Tree Private 2     12     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
54868 96570 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 1101 Eucalyptus Dr   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.7310370666678 -122.483566221845 (37.7310370666678, -122.483566221845) 1 8 4 64 14
55399 92310 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2591 26th Ave 1 Sidewalk: Property side : Cutout Tree Private 2 FUF 10/18/2008 12:00:00 AM   3x3   5988279 2097698.2 37.7392039339278 -122.483086187221 (37.7392039339278, -122.483086187221) 1 8 3 29491 35
55614 104904 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 417 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990435 2090585 37.7197981072685 -122.475112652722 (37.7197981072685, -122.475112652722) 1 8 4 64 40
55746 98694 Significant Tree 6 Aesculus californica :: California Buckeye 168 191@Clarendon Forest Knolls Dr 1 Back Yard : Yard Tree Private 2   05/01/2012 12:00:00 AM     Permit Number 768674 5996330.9 2103059.9 37.7543910951738 -122.455633951336 (37.7543910951738, -122.455633951336) 1 5 4 63 12
56298 114392 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 104x TAPIA DR 1 Front Yard : Cutout Tree Private 2     10     5988688 2090939 37.7206686952673 -122.481177253578 (37.7206686952673, -122.481177253578) 1 8 4 64 14
57870 96483 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 1101 Eucalyptus Dr   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF       In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.7310370666678 -122.483566221845 (37.7310370666678, -122.483566221845) 1 8 4 64 14
58321 114094 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 57 239x VIDAL DR 1 Front Yard : Yard Tree Private 2     24     5987668 2090475 37.7193353179991 -122.484669012602 (37.7193353179991, -122.484669012602) 1 8 4 64 14
58512 253898 Significant Tree 6 Tree(s) :: 17 201X Oak Park Dr 2 Back Yard : Yard Tree Private 2   01/17/2018 12:00:00 AM 3 10x10 Permit Number 780818 5996124 2103402 37.7553185401494 -122.45637419556 (37.7553185401494, -122.45637419556) 1 5 4 63 12
58933 116864 Significant Tree 6 Pinus radiata :: Monterey Pine 15 262X OAK PARK DR 3 Back Yard : Cutout Tree Private 2       10x10   5995091 2103085 37.7543887826633 -122.459923632558 (37.7543887826633, -122.459923632558) 1 5 4 63 12
59764 105504 Significant Tree 6 Pinus radiata :: Monterey Pine 15 39 MAGELLAN AVE 1 Front Yard : Yard Tree Private 2     18     5994694.1 2101166.3 37.7490976851152 -122.461157135733 (37.7490976851152, -122.461157135733) 1 8 4 29491 40
60308 99100 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 60 Santa Monica Way 1 Sidewalk: Curb side : Cutout Tree Private 2           5993700.7 2097327 37.7384987171226 -122.464313592449 (37.7384987171226, -122.464313592449) 1 8 4 59 40
62078 114235 Significant Tree 6 Acacia longifolia :: Golden Wattle 150 99x FONT BLVD 11 Sidewalk: Curb side : Yard Tree Private 2     13     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
63542 116459 Significant Tree 6 Eucalyptus lehmanni :: Bushy Yate 260 777 Brotherhood Way 2 Sidewalk: Curb side : Yard Tree Private 2     20 10x20 Permit Number 777772 5989848.42836 2088633.83291 37.7144066723949 -122.476997704287 (37.7144066723949, -122.476997704287) 1 8 4 64 14
63888 254137 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1619 47th Ave 1 Side Yard : Yard Tree Private 2       6x6   5981543 2104041 37.756225206981 -122.506846181577 (37.756225206981, -122.506846181577) 1 8 3 56 35
64792 114144 Significant Tree 6 Acacia longifolia :: Golden Wattle 150 1200x JUNIPERO SERRA BLVD 1 Front Yard : Yard Tree Private 2     10     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
66315 109521 Significant Tree 6 Tree(s) :: 17 1308 Ulloa St 1 Front Yard : Yard Tree Private 2       3x3   5991965.5 2098469.9 37.7415366593774 -122.470396231887 (37.7415366593774, -122.470396231887) 1 8 4 29491 40
66594 114103 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 5 ACEVEDO AVE 2 Front Yard : Yard Tree Private 2     15     5987903 2090420 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784) 1 8 4 64 14
66926 253251 Significant Tree 6 Pinus radiata :: Monterey Pine 15 99X Lopez Ave 2 Front Yard : Yard Tree Private 2       10x10   5994049 2100330 37.746764271907 -122.463327202712 (37.746764271907, -122.463327202712) 1 8 4 29491 40
67970 93221 Significant Tree 6 Tree(s) :: 17 85 Santa Rita Ave 1 Front Yard : Yard Tree Private 2   02/26/2010 12:00:00 AM     Permit Number 53213 5993788 2100441 37.7470540096767 -122.464237765204 (37.7470540096767, -122.464237765204) 1 8 4 29491 40
69013 254092 Significant Tree 6 Tree(s) :: 17 716 Gonzalez Dr 1 Front Yard : Yard Tree Private 2   01/24/2018 12:00:00 AM 3 10x10 Permit Number 781051 5988732 2090042 37.7182083166364 -122.480959519123 (37.7182083166364, -122.480959519123) 1 8 4 64 14
69183 104494 Significant Tree 6 Acer circinatum :: Vine Maple 452 171 SAN MARCOS AVE 2 Front Yard : Yard Tree Private 2         Permit Number 770388 5993514 2100282 37.7466016393389 -122.465173679454 (37.7466016393389, -122.465173679454) 1 8 4 29491 40
69364 114151 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1200X JUNIPERO SERRA BLVD 10 Front Yard : Yard Tree Private 2     8     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
71364 115730 Significant Tree 6 Acer rubrum :: Red Maple 75 10x Yerba Buena Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3   Permit Number 776540 5993642.27748 2097056.19499 37.7377517864641 -122.46449593033 (37.7377517864641, -122.46449593033) 1 8 4 59 40
71845 114379 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 443X ARBALLO DR 1 Front Yard : Yard Tree Private 2     36     5988110 2090275 37.7188118998372 -122.483126550771 (37.7188118998372, -122.483126550771) 1 8 4 64 14
72430 114147 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1200x JUNIPERO SERRA BLVD 4 Front Yard : Yard Tree Private 2     7     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
72767 114153 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1200x JUNIPERO SERRA BLVD 12 Front Yard : Yard Tree Private 2     40     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
73267 115729 Significant Tree 6 Acer rubrum :: Red Maple 75 10x Yerba Buena Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3   Permit Number 776540 5993642.27748 2097056.19499 37.7377517864641 -122.46449593033 (37.7377517864641, -122.46449593033) 1 8 4 59 40
74024 114155 Significant Tree 6 Pittosporum spp :: Pittosporum spp 170 1200X JUNIPERO SERRA BLVD 16 Front Yard : Yard Tree Private 2           5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
74248 208929 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 501 Saint Francis Blvd 1 Sidewalk: Curb side : Pot Tree Private 2     34 Width 6ft   5993145.62708 2096072.03007 37.735020873007 -122.466141577798 (37.735020873007, -122.466141577798) 1 8 4 59 40
74628 88281 Significant Tree 6 Prunus cerasifera :: Cherry Plum 7 935 Ulloa St 2 Front Yard : Yard Tree Private 2   07/09/2008 12:00:00 AM   3x3 Permit Number 51275 5993125 2098282 37.7410877064311 -122.466373457073 (37.7410877064311, -122.466373457073) 1 8 4 59 40
75557 254361 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 1749 09th Ave 1 Front Yard : Yard Tree Private 2       6x6   5993372 2103579 37.7556461665355 -122.465904219148 (37.7556461665355, -122.465904219148) 1 8 4 56 12
75962 111070 Significant Tree 6 Prunus cerasifera :: Cherry Plum 7 1836 08TH AVE 2 Front Yard : Cutout Tree Private 2     2 3x15   5993799 2102987 37.7540453100112 -122.464384550175 (37.7540453100112, -122.464384550175) 1 8 4 56 12
76029 114099 Significant Tree 6 Liriodendron tulipifera :: Tulip Tree 145 201x VIDAL DR 1 Sidewalk: Curb side : Cutout Tree Private 2     14     5987665 2090646 37.7198046658936 -122.484691919383 (37.7198046658936, -122.484691919383) 1 8 4 64 14
76411 104900 Significant Tree 6 Betula pendula :: European White Birch 253 317 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
76823 255913 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 121 San Marcos Ave 1 Side Yard : Yard Tree Private 2       10x10   5993694 2100263 37.7465598483618 -122.464549884035 (37.7465598483618, -122.464549884035) 1 8 4 29491 40
78664 114390 Significant Tree 6 Pyrus kawakamii :: Evergreen Pear 83 23x PINTO AVE 1 Front Yard : Yard Tree Private 2     7     5988521 2090808 37.7202992922588 -122.481744923362 (37.7202992922588, -122.481744923362) 1 8 4 64 14
80551 100195 Significant Tree 6 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 361 Dellbrook Ave 3 Front Yard : Yard Tree Private 2           5997322.2 2102403.9 37.7526467193673 -122.45215846969 (37.7526467193673, -122.45215846969) 1 5 4 63 38
81276 114097 Significant Tree 6 Pinus thunbergii :: Japanese Black Pine 207 221x VIDAL DR 1 Front Yard : Yard Tree Private 2     14     5987664 2090556 37.7195574904968 -122.484688777519 (37.7195574904968, -122.484688777519) 1 8 4 64 14
81808 114407 Significant Tree 6 Calocedrus decurrens :: Incense Cedar 206 500X ARBALLO DR 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5987859 2089716 37.7172624174607 -122.483953179035 (37.7172624174607, -122.483953179035) 1 8 4 64 14
81883 106311 Significant Tree 6 Pinus canariensis :: Canary Island Pine 35 99X Clearfield Dr 5 Sidewalk: Property side : Yard Tree Private 2   04/15/2014 12:00:00 AM     Permit Number 772542 5985798.26078 2095453.46484 37.7328958169551 -122.491498163849 (37.7328958169551, -122.491498163849) 1 8 4 64 35
82758 106514 Significant Tree 6 Tree(s) :: 17 190 EUCALYPTUS DR 2 Front Yard : Yard Tree Private 2           5990695.4 2094728.8 37.7311910349726 -122.474514801842 (37.7311910349726, -122.474514801842) 1 8 4 64 40
82975 255461 Significant Tree 6 Tree(s) :: 17 37 Santa Paula Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/24/2018 12:00:00 AM 3 10x6 Permit Number 777804 5994021.13024 2097608.02637 37.7392888101295 -122.463226093964 (37.7392888101295, -122.463226093964) 1 8 4 59 40
83163 115737 Significant Tree 6 Acer rubrum :: Red Maple 75 9x Yerba Buena Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3   Permit Number 776557 5993642.27748 2097056.19499 37.7377517864641 -122.46449593033 (37.7377517864641, -122.46449593033) 1 8 4 59 40
83312 254136 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1623 47th Ave 1 Front Yard : Yard Tree Private 2       10x6 Permit Number 781075 5981544 2104016 37.7561566229771 -122.506840869024 (37.7561566229771, -122.506840869024) 1 8 3 56 35
84029 102075 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 57 273 Magellan Ave 5 Front Yard : Yard Tree Private 2           5994674.1 2100293.4 37.7466997707371 -122.461163031194 (37.7466997707371, -122.461163031194) 1 8 4 29491 40
84826 174950 Significant Tree 6 Metrosideros excelsa :: New Zealand Xmas Tree 16 309 Crestlake Dr 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5987294 2096147 37.7348873783654 -122.486377975564 (37.7348873783654, -122.486377975564) 1 8 3 64 35
85339 115176 Significant Tree 6 Tree(s) :: 17 460 Pacheco St 1 Front Yard : Yard Tree Private 2   01/14/2016 12:00:00 AM   10x10 Permit Number 775764 5993727.4 2101897.6 37.7510499693469 -122.464553061226 (37.7510499693469, -122.464553061226) 1 8 4 29491 12
86997 116863 Significant Tree 6 Pinus radiata :: Monterey Pine 15 262X OAK PARK DR 2 Back Yard : Cutout Tree Private 2       10x10   5995091 2103085 37.7543887826633 -122.459923632558 (37.7543887826633, -122.459923632558) 1 5 4 63 12
87199 116862 Significant Tree 6 Pinus radiata :: Monterey Pine 15 262X OAK PARK DR 1 Back Yard : Cutout Tree Private 2       10x10   5995091 2103085 37.7543887826633 -122.459923632558 (37.7543887826633, -122.459923632558) 1 5 4 63 12
89112 106184 Significant Tree 6 Olea europaea :: Olive Tree 9 1327 ULLOA ST 1 Front Yard : Cutout Tree Private 2 FUF   2 4x4   5991893.8 2098371.4 37.7412620575898 -122.470636971077 (37.7412620575898, -122.470636971077) 1 8 4 59 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)
);