trees
458 rows where Supervisor Districts = 4 and qLegalStatus_id = 6 sorted by Longitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
48955 | 255537 | Significant Tree 6 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 93X Monterey Blvd | 1 | Side Yard : Cutout | Tree | Private 2 | 10x10 | 6001470 | 2094575 | 37.7313871286154 | -122.437254157834 | (37.7313871286154, -122.437254157834) | 9 | 7 | 4 | 63 | 40 | ||||
59778 | 112374 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 1247 Bosworth St | 1 | Front Yard : Yard | Tree | Private 2 | 20x20 | Permit Number 775819 | 6000424.11007 | 2096055.79143 | 37.7353935258967 | -122.440976176652 | (37.7353935258967, -122.440976176652) | 9 | 7 | 4 | 63 | 40 | |||
57424 | 101476 | Significant Tree 6 | :: 45 | 541 Congo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2015 12:00:00 AM | 3 | Permit Number 775316 | 6000089 | 2095440.1 | 37.7336838892166 | -122.442090592963 | (37.7336838892166, -122.442090592963) | 9 | 7 | 4 | 63 | 40 | ||
13663 | 258677 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 607 Congo St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10x10 | 6000094 | 2095817 | 37.7347190533418 | -122.442100351643 | (37.7347190533418, -122.442100351643) | 9 | 7 | 4 | 63 | 40 | ||||
4898 | 211279 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 350 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 28 | Width 10ft | 5999756.13451 | 2094992.8184 | 37.7324367835174 | -122.443209289192 | (37.7324367835174, -122.443209289192) | 9 | 7 | 4 | 63 | 40 | |||
63394 | 106833 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 174 STILLINGS AVE | 1 | Front Yard : Yard | Tree | Private 2 | 5999619.6 | 2095804.2 | 37.7346568605649 | -122.443739589791 | (37.7346568605649, -122.443739589791) | 9 | 7 | 4 | 63 | 40 | |||||
135306 | 253899 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 127 | 380 Monterey Blvd | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6x10 | Permit Number 780835 | 5999528 | 2094735 | 37.7317158633652 | -122.443979483467 | (37.7317158633652, -122.443979483467) | 9 | 7 | 4 | 63 | 40 | |||
10088 | 253978 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 441 Detroit St | 1 | Unaccepted Street : Yard | Tree | Private 2 | 3x10 | 5999396 | 2094599 | 37.7313349085161 | -122.444426062201 | (37.7313349085161, -122.444426062201) | 9 | 7 | 4 | 59 | 40 | ||||
146280 | 255793 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 441 Detroit St | 1 | Unaccepted Street : Yard | Tree | Private 2 | 30x30 | Permit Number 782172 | 5999396 | 2094599 | 37.7313349085161 | -122.444426062201 | (37.7313349085161, -122.444426062201) | 9 | 7 | 4 | 59 | 40 | |||
194175 | 116308 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 699X DETROIT ST | 9 | Back Yard : Yard | Tree | Private 2 | 3x20 | 5999400 | 2095202 | 37.7329908332996 | -122.444455553893 | (37.7329908332996, -122.444455553893) | 9 | 7 | 4 | 59 | 40 | ||||
37139 | 98289 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 300 Mangels Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/24/2012 12:00:00 AM | Permit Number 768637 | 5999381.8 | 2095276.6 | 37.7331946288913 | -122.444523835506 | (37.7331946288913, -122.444523835506) | 9 | 7 | 4 | 59 | 40 | |||
143852 | 98290 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 300 Mangels Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/24/2012 12:00:00 AM | Permit Number 768637 | 5999381.8 | 2095276.6 | 37.7331946288913 | -122.444523835506 | (37.7331946288913, -122.444523835506) | 9 | 7 | 4 | 59 | 40 | |||
165161 | 98288 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 300 Mangels Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/24/2012 12:00:00 AM | Permit Number 768637 | 5999381.8 | 2095276.6 | 37.7331946288913 | -122.444523835506 | (37.7331946288913, -122.444523835506) | 9 | 7 | 4 | 59 | 40 | |||
61064 | 253428 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3 Valletta Ct | 1 | Side Yard : Cutout | Tree | Private 2 | 6x10 | Permit Number 780575 | 5999319 | 2096479 | 37.7364925519579 | -122.444827352142 | (37.7364925519579, -122.444827352142) | 9 | 7 | 4 | 63 | 40 | |||
71228 | 253470 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 3 Valletta Ct | 2 | Side Yard : Cutout | Tree | Private 2 | 6x10 | 5999319 | 2096479 | 37.7364925519579 | -122.444827352142 | (37.7364925519579, -122.444827352142) | 9 | 7 | 4 | 63 | 40 | ||||
23065 | 98547 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 555@Rio Teresita Blvd | 3 | Front Yard : Yard | Tree | Private 2 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | 9 | 7 | 4 | 59 | 40 | |||||
38717 | 98546 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 555@Rio Teresita Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | 9 | 7 | 4 | 59 | 40 | |||||
116509 | 98545 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 555@Rio Teresita Blvd | 1 | Front Yard : Yard | Tree | Private 2 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | 9 | 7 | 4 | 59 | 40 | |||||
17429 | 103965 | Significant Tree 6 | Tree(s) :: 17 | 141 Marview Way | 1 | Front Yard : Yard | Tree | Private 2 | 07/11/2013 12:00:00 AM | Permit Number 770303 | 5998318.6 | 2103174 | 37.7548182509721 | -122.448768222318 | (37.7548182509721, -122.448768222318) | 1 | 5 | 4 | 63 | 38 | |||
47483 | 113358 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 702 Foerster St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5998153.40008835 | 2095558.62470631 | 37.7338988325043 | -122.448791034412 | (37.7338988325043, -122.448791034412) | 9 | 7 | 4 | 59 | 40 | |||||
110581 | 113359 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 702 Foerster St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5998153.40008835 | 2095558.62470631 | 37.7338988325043 | -122.448791034412 | (37.7338988325043, -122.448791034412) | 9 | 7 | 4 | 59 | 40 | |||||
56399 | 254401 | Significant Tree 6 | Cedrus atlantica Glauca :: Blue Atlas Cedar 208 | 755 Ocean Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | Permit Number 779678 | 5998027 | 2091524 | 37.7228134749722 | -122.448937504689 | (37.7228134749722, -122.448937504689) | 9 | 7 | 4 | 28861 | 24 | |||
119037 | 112769 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 1X HOWTH ST | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5998027 | 2091524 | 37.7228134749722 | -122.448937504689 | (37.7228134749722, -122.448937504689) | 9 | 7 | 4 | 28861 | 24 | ||||
133887 | 112770 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 1X HOWTH ST | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5998027 | 2091524 | 37.7228134749722 | -122.448937504689 | (37.7228134749722, -122.448937504689) | 9 | 7 | 4 | 28861 | 24 | ||||
136074 | 112773 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 1X HOWTH ST | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5998027 | 2091524 | 37.7228134749722 | -122.448937504689 | (37.7228134749722, -122.448937504689) | 9 | 7 | 4 | 28861 | 24 | ||||
137248 | 112771 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 1X HOWTH ST | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5998027 | 2091524 | 37.7228134749722 | -122.448937504689 | (37.7228134749722, -122.448937504689) | 9 | 7 | 4 | 28861 | 24 | ||||
140130 | 112774 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 1X HOWTH ST | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5998027 | 2091524 | 37.7228134749722 | -122.448937504689 | (37.7228134749722, -122.448937504689) | 9 | 7 | 4 | 28861 | 24 | ||||
165386 | 112772 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 1X HOWTH ST | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5998027 | 2091524 | 37.7228134749722 | -122.448937504689 | (37.7228134749722, -122.448937504689) | 9 | 7 | 4 | 28861 | 24 | ||||
39767 | 254934 | Significant Tree 6 | Cedrus atlantica Glauca :: Blue Atlas Cedar 208 | 755 Ocean Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x6 | 5998003.33154 | 2091542.89024 | 37.7228639895457 | -122.449020681299 | (37.7228639895457, -122.449020681299) | 9 | 7 | 4 | 28861 | 24 | ||||
168489 | 254935 | Significant Tree 6 | Cedrus atlantica Glauca :: Blue Atlas Cedar 208 | 755 Ocean Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x6 | Permit Number 779678 | 5998003.33154 | 2091542.89024 | 37.7228639895457 | -122.449020681299 | (37.7228639895457, -122.449020681299) | 9 | 7 | 4 | 28861 | 24 | |||
178948 | 117208 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 25 MIDCREST WAY | 1 | Front Yard : Cutout | Tree | Private 2 | 20 | 5997992 | 2100464 | 37.7473585772285 | -122.44970241305 | (37.7473585772285, -122.44970241305) | 1 | 5 | 4 | 63 | 38 | ||||
178383 | 254277 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 105 Gladeview Way | 1 | Front Yard : Cutout | Tree | Private 2 | 3x6 | Permit Number 781296 | 5997754 | 2101950 | 37.7514251480437 | -122.450632514859 | (37.7514251480437, -122.450632514859) | 1 | 5 | 4 | 63 | 38 | |||
182728 | 102583 | Significant Tree 6 | Tree(s) :: 17 | 22 Gennessee St | 1 | Front Yard : Yard | Tree | Private 2 | 02/27/2013 12:00:00 AM | Permit Number 769949 | 5997479.4 | 2093692.8 | 37.7287371564084 | -122.450986747444 | (37.7287371564084, -122.450986747444) | 9 | 7 | 4 | 28861 | 40 | |||
6519 | 251515 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 99x Mountview Ct | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5997620 | 2100449 | 37.7472961010623 | -122.450987675073 | (37.7472961010623, -122.450987675073) | 1 | 5 | 4 | 63 | 38 | ||||
109594 | 251514 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 99x Mountview Ct | 2 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5997620 | 2100449 | 37.7472961010623 | -122.450987675073 | (37.7472961010623, -122.450987675073) | 1 | 5 | 4 | 63 | 38 | ||||
100026 | 254674 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 44X Starview Way | 2 | Back Yard : Yard | Tree | Private 2 | 10x10 | 5997596 | 2101581 | 37.7504029202392 | -122.451152286969 | (37.7504029202392, -122.451152286969) | 1 | 5 | 4 | 63 | 38 | ||||
129904 | 254673 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 44X Starview Way | 1 | Back Yard : Yard | Tree | Private 2 | 10x10 | 5997596 | 2101581 | 37.7504029202392 | -122.451152286969 | (37.7504029202392, -122.451152286969) | 1 | 5 | 4 | 63 | 38 | ||||
163180 | 254675 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 44X Starview Way | 3 | Back Yard : Yard | Tree | Private 2 | 10x10 | 5997596 | 2101581 | 37.7504029202392 | -122.451152286969 | (37.7504029202392, -122.451152286969) | 1 | 5 | 4 | 63 | 38 | ||||
135834 | 102467 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 36 Saint Germain Ave | 1 | Front Yard : Yard | Tree | Private 2 | 5997576.7 | 2104111.9 | 37.757351037011 | -122.451401547119 | (37.757351037011, -122.451401547119) | 15 | 5 | 4 | 28862 | 38 | |||||
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 | |
139544 | 104085 | Significant Tree 6 | Populus spp :: Poplar Spp 262 | 1329 Stanyan St | 1 | Front Yard : Yard | Tree | Private 2 | 08/07/2013 12:00:00 AM | Permit Number 770194 | 5997530.4 | 2104741.3 | 37.7590765601241 | -122.451607069148 | (37.7590765601241, -122.451607069148) | 15 | 5 | 4 | 28862 | 12 | |||
104794 | 115276 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 598X PORTOLA DR | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3x3 | 5997411 | 2099824 | 37.7455680371271 | -122.451665301061 | (37.7455680371271, -122.451665301061) | 1 | 7 | 4 | 59 | 40 | ||||
160307 | 110393 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 451 LOS PALMOS DR | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x8 | 5997298 | 2095759 | 37.7344000615683 | -122.451762846846 | (37.7344000615683, -122.451762846846) | 9 | 7 | 4 | 59 | 40 | ||||
17949 | 100194 | Significant Tree 6 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 | 361 Dellbrook Ave | 2 | Front Yard : Yard | Tree | Private 2 | 5997322.2 | 2102403.9 | 37.7526467193673 | -122.45215846969 | (37.7526467193673, -122.45215846969) | 1 | 5 | 4 | 63 | 38 | |||||
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 | |||||
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 | |||||
134725 | 187654 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 375 Woodside Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3x3 | 5997267 | 2099886 | 37.7457300260474 | -122.452167701039 | (37.7457300260474, -122.452167701039) | 1 | 5 | 4 | 59 | 38 | ||||
148062 | 85032 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 411 Panorama Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5997300 | 2101977 | 37.7514732863106 | -122.452204440653 | (37.7514732863106, -122.452204440653) | 1 | 5 | 4 | 63 | 38 | |||||
132961 | 108177 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 201 PANORAMA DR | 1 | Front Yard : Yard | Tree | Private 2 | 22 | 3x3 | 5997273.1 | 2100946.6 | 37.7486425219839 | -122.452223122411 | (37.7486425219839, -122.452223122411) | 1 | 5 | 4 | 63 | 38 | |||
7631 | 256540 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 379X Cresta Vista Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997117 | 2096261 | 37.7357680647268 | -122.452424833384 | (37.7357680647268, -122.452424833384) | 9 | 7 | 4 | 59 | 40 | ||||
143508 | 256539 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 379X Cresta Vista Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997117 | 2096261 | 37.7357680647268 | -122.452424833384 | (37.7357680647268, -122.452424833384) | 9 | 7 | 4 | 59 | 40 | ||||
2352 | 101748 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 700X Panorama Dr | 1 | Back Yard : Yard | Tree | Private 2 | 5997177.2 | 2102739.1 | 37.7535587877907 | -122.452684092588 | (37.7535587877907, -122.452684092588) | 1 | 5 | 4 | 63 | 38 | |||||
178454 | 96779 | Significant Tree 6 | Tree(s) :: 17 | 555 Melrose Ave | 1 | Back Yard : Yard | Tree | Private 2 | 07/18/2011 12:00:00 AM | Permit Number 767966 | 5996882.6 | 2095364.1 | 37.7332919614683 | -122.45317051412 | (37.7332919614683, -122.45317051412) | 9 | 7 | 4 | 59 | 40 | |||
85195 | 98151 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 850 Rockdale Dr | 3 | Front Yard : Yard | Tree | Private 2 | Permit Number 768501 | 5996729.9 | 2098301.3 | 37.7413480470066 | -122.453910481227 | (37.7413480470066, -122.453910481227) | 9 | 7 | 4 | 59 | 40 | ||||
76095 | 106244 | Significant Tree 6 | Magnolia spp :: Magnolia 224 | 735 MANGELS AVE | 1 | Front Yard : Yard | Tree | Private 2 | 06/02/2014 12:00:00 AM | 14 | Permit Number 772876 | 5996640.8 | 2095225.8 | 37.7328983615352 | -122.453996493912 | (37.7328983615352, -122.453996493912) | 9 | 7 | 4 | 59 | 40 | ||
89599 | 98156 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 149x Chaves Ave | 1 | Front Yard : Yard | Tree | Private 2 | 5996703.5 | 2098396.7 | 37.7416084783757 | -122.454008650942 | (37.7416084783757, -122.454008650942) | 9 | 7 | 4 | 59 | 40 | |||||
183500 | 98157 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 149x Chaves Ave | 2 | Front Yard : Yard | Tree | Private 2 | 5996703.5 | 2098396.7 | 37.7416084783757 | -122.454008650942 | (37.7416084783757, -122.454008650942) | 9 | 7 | 4 | 59 | 40 | |||||
9495 | 261033 | Significant Tree 6 | Tree(s) :: 17 | 551 Los Palmos Dr | 1 | Front Yard : Yard | Tree | Private 2 | 01/14/2020 12:00:00 AM | 3 | 10x10 | Permit Number 784596 | 5996615 | 2095626 | 37.7339957349096 | -122.454114584985 | (37.7339957349096, -122.454114584985) | 9 | 7 | 4 | 59 | 40 | |
7245 | 251144 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 200X Clarendon Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5996559 | 2104265 | 37.7577130831875 | -122.454932197022 | (37.7577130831875, -122.454932197022) | 15 | 5 | 4 | 63 | 12 | ||||
10388 | 251145 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 200X Clarendon Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5996559 | 2104265 | 37.7577130831875 | -122.454932197022 | (37.7577130831875, -122.454932197022) | 15 | 5 | 4 | 63 | 12 | ||||
29607 | 101467 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 185 | 301 Hazelwood Ave | 2 | Front Yard : Yard | Tree | Private 2 | 5996219.7 | 2095283.8 | 37.7330334614805 | -122.455456526637 | (37.7330334614805, -122.455456526637) | 9 | 7 | 4 | 59 | 40 | |||||
78343 | 101466 | Significant Tree 6 | Afrocarpus gracilior :: Fern Pine 89 | 301 Hazelwood Ave | 1 | Front Yard : Yard | Tree | Private 2 | 5996219.7 | 2095283.8 | 37.7330334614805 | -122.455456526637 | (37.7330334614805, -122.455456526637) | 9 | 7 | 4 | 59 | 40 | |||||
156524 | 101468 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 185 | 301 Hazelwood Ave | 3 | Front Yard : Yard | Tree | Private 2 | 5996219.7 | 2095283.8 | 37.7330334614805 | -122.455456526637 | (37.7330334614805, -122.455456526637) | 9 | 7 | 4 | 59 | 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 | |||
172767 | 98696 | Significant Tree 6 | Aesculus californica :: California Buckeye 168 | 191@Clarendon Forest Knolls Dr | 3 | 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 | |||
175269 | 98695 | Significant Tree 6 | Aesculus californica :: California Buckeye 168 | 191@Clarendon Forest Knolls Dr | 2 | 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 | |||
36038 | 115661 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 341 HAZELWOOD AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 5996066 | 2095432 | 37.7334315621613 | -122.455998615118 | (37.7334315621613, -122.455998615118) | 9 | 7 | 4 | 59 | 40 | |||
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 | |
183899 | 253897 | Significant Tree 6 | Tree(s) :: 17 | 201X Oak Park Dr | 1 | 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 | |
7288 | 264692 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 1500 Plymouth Ave | 1 | Side Yard : Yard | Tree | Private 2 | 10x10 | 5995893.6658 | 2094152.61505 | 37.7299087874515 | -122.456501934539 | (37.7299087874515, -122.456501934539) | 9 | 7 | 4 | 28861 | 40 | ||||
104704 | 256850 | Significant Tree 6 | Calocedrus decurrens :: Incense Cedar 206 | 100 Brentwood Ave | 1 | Front Yard : Yard | Tree | Private 2 | 6x6 | 5995843 | 2095739 | 37.7342617075966 | -122.456791779994 | (37.7342617075966, -122.456791779994) | 9 | 7 | 4 | 59 | 40 | ||||
15224 | 264691 | Significant Tree 6 | Leucodendron argenteum :: Silver Tree 46 | 1560 Plymouth Ave | 1 | Front Yard : Yard | Tree | Private 2 | 10x10 | 5995798 | 2094356 | 37.730461740667 | -122.45684736471 | (37.730461740667, -122.45684736471) | 9 | 7 | 4 | 28861 | 40 | ||||
139989 | 100474 | Significant Tree 6 | Pinus halepensis :: Allepo Pine 330 | 930 Monterey Blvd | 2 | Front Yard : Yard | Tree | Private 2 | 5995794.4 | 2094643.4 | 37.7312506649165 | -122.456880589247 | (37.7312506649165, -122.456880589247) | 9 | 7 | 4 | 59 | 40 | |||||
189375 | 100473 | Significant Tree 6 | Pinus halepensis :: Allepo Pine 330 | 930 Monterey Blvd | 1 | Front Yard : Yard | Tree | Private 2 | 5995794.4 | 2094643.4 | 37.7312506649165 | -122.456880589247 | (37.7312506649165, -122.456880589247) | 9 | 7 | 4 | 59 | 40 | |||||
161712 | 92964 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 380 Valdez Ave | 1 | Front Yard : Yard | Tree | Private 2 | 17 | 5995792.2 | 2095482.9 | 37.7335556021648 | -122.456948893253 | (37.7335556021648, -122.456948893253) | 9 | 7 | 4 | 59 | 40 | ||||
21762 | 100124 | Significant Tree 6 | Radermachera sinica :: China Doll Tree 394 | 40@ San Ramon Eastwood Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5995635 | 2092781 | 37.7261278087338 | -122.457296979484 | (37.7261278087338, -122.457296979484) | 9 | 7 | 4 | 28861 | 40 | |||||
12289 | 254085 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 411 Lansdale Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 6x6 | 5995707 | 2096451 | 37.7362088759349 | -122.457313463895 | (37.7362088759349, -122.457313463895) | 9 | 7 | 4 | 59 | 40 | ||||
128997 | 109708 | Significant Tree 6 | Tree(s) :: 17 | 621 Laguna Honda Blvd | 3 | Front Yard : Cutout | Tree | Private 2 | FUF | 07/29/2015 12:00:00 AM | Permit Number 774799 | 5995723.9 | 2099907.4 | 37.7457002690083 | -122.457505029341 | (37.7457002690083, -122.457505029341) | 1 | 5 | 4 | 59 | 40 | ||
139381 | 109706 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 96 CRESTA VISTA DR | Back Yard : Cutout | Tree | Private 2 | 5995602.1 | 2096103.5 | 37.7352487002973 | -122.457651008037 | (37.7352487002973, -122.457651008037) | 9 | 7 | 4 | 59 | 40 | ||||||
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 | ||||
122782 | 255708 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 200X Blairwood Ln | 2 | Unaccepted Street : Yard | Tree | Private 2 | 10x10 | 5995660 | 2102951 | 37.7540535603115 | -122.457946200633 | (37.7540535603115, -122.457946200633) | 1 | 5 | 4 | 63 | 12 | ||||
64560 | 87191 | Significant Tree 6 | Tree(s) :: 17 | 640 Miramar Ave | 1 | Front Yard : Yard | Tree | Private 2 | 01/29/2008 12:00:00 AM | Permit Number 50212 | 5995439 | 2093622 | 37.7284257331327 | -122.458035371987 | (37.7284257331327, -122.458035371987) | 9 | 7 | 4 | 28861 | 40 | |||
3096 | 100121 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 690 Miramar Ave | 1 | Front Yard : Yard | Tree | Private 2 | 5995444.4 | 2093941.6 | 37.7293035878447 | -122.458039824042 | (37.7293035878447, -122.458039824042) | 9 | 7 | 4 | 28861 | 40 | |||||
153493 | 256541 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 126X Warren Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995584 | 2102944 | 37.754029973308 | -122.458208518647 | (37.754029973308, -122.458208518647) | 1 | 5 | 4 | 63 | 12 | ||||
194504 | 265143 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 333 Lansdale Ave | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5995416 | 2096422 | 37.7361125310636 | -122.458317465478 | (37.7361125310636, -122.458317465478) | 9 | 7 | 4 | 59 | 40 | ||||
14356 | 264786 | Significant Tree 6 | Cedrus atlantica :: Atlas Cedar 233 | 451 Yerba Buena Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 10x10 | 5995368 | 2094795 | 37.7316424274687 | -122.458365690275 | (37.7316424274687, -122.458365690275) | 9 | 7 | 4 | 59 | 40 | ||||
34696 | 253950 | Significant Tree 6 | Cedrus atlantica :: Atlas Cedar 233 | 431 Yerba Buena Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 10x10 | 5995366 | 2094904 | 37.7319416000564 | -122.458380491445 | (37.7319416000564, -122.458380491445) | 9 | 7 | 4 | 59 | 40 | ||||
130286 | 253951 | Significant Tree 6 | Tree(s) :: 17 | 431 Yerba Buena Ave | 2 | Front Yard : Cutout | Tree | Private 2 | 01/17/2018 12:00:00 AM | 3 | 10x10 | Permit Number 780852 | 5995366 | 2094904 | 37.7319416000564 | -122.458380491445 | (37.7319416000564, -122.458380491445) | 9 | 7 | 4 | 59 | 40 | |
6370 | 261832 | Significant Tree 6 | Ilex spp :: Holly Species 81 | 16 Merced Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995265 | 2100184 | 37.7464333732005 | -122.459111852123 | (37.7464333732005, -122.459111852123) | 1 | 8 | 4 | 59 | 40 | ||||
24927 | 107413 | Significant Tree 6 | Pseudotsuga menziesii :: Douglas Fir 285 | 276 Yerba Buena Ave | 1 | Front Yard : Yard | Tree | Private 2 | 28 | 5995080.66446 | 2095640.15746 | 37.7339465073544 | -122.459420244296 | (37.7339465073544, -122.459420244296) | 9 | 8 | 4 | 59 | 40 | ||||
12287 | 95982 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 Vasquez Ave | 1 | Back Yard : Yard | Tree | Private 2 | 5995122.4 | 2099706.3 | 37.7451135296363 | -122.459570350972 | (37.7451135296363, -122.459570350972) | 1 | 8 | 4 | 59 | 40 | |||||
12152 | 255704 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 201X Hernandez Ave | 1 | Side Yard : Yard | Tree | Private 2 | 10x10 | 5995122 | 2099706 | 37.7451126829106 | -122.459571712369 | (37.7451126829106, -122.459571712369) | 1 | 8 | 4 | 59 | 40 | ||||
168009 | 254385 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 178X Warren Dr | 1 | Side Yard : Yard | Tree | Private 2 | 3x3 | 5995100 | 2102878 | 37.7538209308694 | -122.459877514706 | (37.7538209308694, -122.459877514706) | 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 | ||||
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 | ||||
107229 | 255805 | Significant Tree 6 | Ailanthus altissima :: Tree Of Heaven 333 | 2 Sola Ave | 1 | Front Yard : Yard | Tree | Private 2 | 10x10 | 5994994 | 2100719 | 37.7478867659483 | -122.460087684856 | (37.7478867659483, -122.460087684856) | 1 | 8 | 4 | 29491 | 40 | ||||
158256 | 104037 | Significant Tree 6 | Tree(s) :: 17 | 520X Oak Park Dr | 2 | Front Yard : Yard | Tree | Private 2 | 5995008.5 | 2103700.7 | 37.7560745928775 | -122.460253542676 | (37.7560745928775, -122.460253542676) | 1 | 5 | 4 | 63 | 12 | |||||
178069 | 104027 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 520X Oak Park Dr | 1 | Back Yard : Yard | Tree | Private 2 | 07/25/2013 12:00:00 AM | Permit Number 770238 | 5995008.5 | 2103700.7 | 37.7560745928775 | -122.460253542676 | (37.7560745928775, -122.460253542676) | 1 | 5 | 4 | 63 | 12 | |||
103685 | 248958 | Significant Tree 6 | Pinus Spp :: Pine Spp 100 | 98x Rosewood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/06/2017 12:00:00 AM | 3 | 3x3 | 5994824 | 2095658 | 37.7339807377795 | -122.460308897898 | (37.7339807377795, -122.460308897898) | 9 | 8 | 4 | 59 | 40 |
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) );