trees
416 rows where Police Districts = 8 and qLegalStatus_id = 6 sorted by Latitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
34238 | 1283 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 22 | 3995X Alemany Blvd | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10 | 10x10 | 5992081.50866 | 2087171.04221 | 37.7105194967412 | -122.469172961285 | (37.7105194967412, -122.469172961285) | 9 | 8 | 4 | 64 | 24 | |||
69574 | 1284 | Significant Tree 6 | Acer buergeranum :: Trident Maple 110 | 3995X Alemany Blvd | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12 | 3X10 | Permit Number 778829 | 5992111.48083 | 2087185.84409 | 37.7105618710011 | -122.469070448459 | (37.7105618710011, -122.469070448459) | 9 | 8 | 4 | 64 | 24 | ||
22688 | 120924 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 3995X Alemany Blvd | 7 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | ||||
47402 | 120930 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3995X Alemany Blvd | 13 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | ||||
50856 | 1263 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3995X Alemany Blvd | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12/02/1998 12:00:00 AM | 10 | 3X3 | Permit Number 778829 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | |
51080 | 120925 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3995X Alemany Blvd | 8 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | Permit Number 778829 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | |||
60656 | 120926 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 3995X Alemany Blvd | 9 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | ||||
73917 | 120923 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3995X Alemany Blvd | 6 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | Permit Number 778829 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | |||
81897 | 120931 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3995X Alemany Blvd | 14 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | Permit Number 778829 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | |||
94421 | 120922 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3995X Alemany Blvd | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | Permit Number 778829 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | |||
109715 | 120932 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 3995X Alemany Blvd | 15 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | ||||
124817 | 120927 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3995X Alemany Blvd | 10 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | Permit Number 778829 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | |||
136239 | 120933 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 3995X Alemany Blvd | 16 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | ||||
145282 | 120934 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 3995X Alemany Blvd | 17 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | ||||
156900 | 120929 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 3995X Alemany Blvd | 12 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | ||||
162123 | 120936 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 3995X Alemany Blvd | 19 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | ||||
162461 | 120921 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 3995X Alemany Blvd | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | ||||
171046 | 120928 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3995X Alemany Blvd | 11 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | Permit Number 778829 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | |||
178015 | 120935 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3995X Alemany Blvd | 18 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | Permit Number 778829 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | |||
15657 | 259657 | Significant Tree 6 | Tree(s) :: 17 | 132 Sagamore St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5995545 | 2087474 | 37.7115508726991 | -122.457224363425 | (37.7115508726991, -122.457224363425) | 9 | 8 | 6 | 28861 | 24 | ||||
81780 | 206842 | Significant Tree 6 | Tree(s) :: 17 | 218 Sadowa St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 03/13/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 779008 | 5994803.1874 | 2087784.4983 | 37.712360795684 | -122.45981072288 | (37.712360795684, -122.45981072288) | 9 | 8 | 6 | 28861 | 24 | |
9908 | 215094 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 51 | 218 Sadowa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/13/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 779008 | 5994821.63014 | 2087784.20309 | 37.7123610457095 | -122.459746958272 | (37.7123610457095, -122.459746958272) | 9 | 8 | 6 | 28861 | 24 | |
137083 | 106962 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 218 SADOWA ST | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 22 | 5994814 | 2087793.9 | 37.7123872323548 | -122.459774032106 | (37.7123872323548, -122.459774032106) | 9 | 8 | 6 | 28861 | 24 | ||||
127076 | 104193 | Significant Tree 6 | Calocedrus decurrens :: Incense Cedar 206 | 122 Arch St | 1 | Front Yard : Yard | Tree | Private 2 | 5992720.4 | 2088013.1 | 37.7128684825751 | -122.467026013031 | (37.7128684825751, -122.467026013031) | 9 | 8 | 6 | 64 | 24 | |||||
93552 | 104749 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1X Junipero Serra Blvd Off Ramp | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 770709 | 5991326.15861 | 2088181.65405 | 37.7132507161795 | -122.47185719554 | (37.7132507161795, -122.47185719554) | 1 | 8 | 4 | 64 | 14 | ||||
142019 | 104750 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1X Junipero Serra Blvd Off Ramp | 2 | Front Yard : Yard | Tree | Private 2 | 08/30/2016 12:00:00 AM | 3 | Permit Number 770709 | 5991326.15861 | 2088181.65405 | 37.7132507161795 | -122.47185719554 | (37.7132507161795, -122.47185719554) | 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 | ||||
188169 | 173629 | Significant Tree 6 | Tibochina urvilleana :: Princess Flower 154 | 10X Junipero Serra Blvd Off Ramp | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/20/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779383 | 5991168 | 2088425 | 37.713909732222 | -122.472421570074 | (37.713909732222, -122.472421570074) | 1 | 8 | 4 | 64 | 14 | |
92919 | 115827 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 60X CHUMASERO DR | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/30/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777531 | 5990913 | 2088468 | 37.714013037331 | -122.473306070941 | (37.714013037331, -122.473306070941) | 1 | 8 | 4 | 64 | 14 | |
177784 | 114257 | Significant Tree 6 | Leptospermum quinquenervia :: Tea Tree 470 | 50x CHUMASERO DR | 1 | Front Yard : Yard | Tree | Private 2 | 5990913 | 2088468 | 37.714013037331 | -122.473306070941 | (37.714013037331, -122.473306070941) | 1 | 8 | 4 | 64 | 14 | |||||
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 | |||
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 | ||
19388 | 114226 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | |||||
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 | ||||
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 | ||||
109646 | 114230 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 30 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
126287 | 114225 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 99x FONT BLVD | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 48 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
128045 | 114227 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
141272 | 114231 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
154745 | 114237 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
173544 | 114236 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 22 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
179418 | 114233 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
185977 | 114238 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 14 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
10661 | 114250 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 131 FONT BLVD | 1 | Front Yard : Yard | Tree | Private 2 | 36 | 5990844 | 2088883 | 37.7151485301311 | -122.473574812248 | (37.7151485301311, -122.473574812248) | 1 | 8 | 4 | 64 | 14 | ||||
133059 | 253652 | Significant Tree 6 | Tree(s) :: 17 | 131 Font Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/20/2017 12:00:00 AM | 3 | 10x10 | Permit Number 780806 | 5990844 | 2088883 | 37.7151485301311 | -122.473574812248 | (37.7151485301311, -122.473574812248) | 1 | 8 | 4 | 64 | 14 | |
164291 | 253651 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 131 Font Blvd | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5990844 | 2088883 | 37.7151485301311 | -122.473574812248 | (37.7151485301311, -122.473574812248) | 1 | 8 | 4 | 64 | 14 | ||||
133714 | 111093 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 100x FONT BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2015 12:00:00 AM | 50 | 3x3 | Permit Number 775594 | 5990916 | 2088996 | 37.715462969911 | -122.473334188491 | (37.715462969911, -122.473334188491) | 1 | 8 | 4 | 64 | 14 | |
92766 | 114034 | Significant Tree 6 | Ulmus pumila :: Siberian Elm 99 | 198x FONT BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 3x3 | 5990818 | 2089012 | 37.7155012267577 | -122.473674083302 | (37.7155012267577, -122.473674083302) | 1 | 8 | 4 | 64 | 14 | |||
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 | ||
98944 | 253568 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 301X Sargent St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 5993018 | 2089140 | 37.7159798527116 | -122.466079257059 | (37.7159798527116, -122.466079257059) | 9 | 8 | 6 | 64 | 24 | ||||
2183 | 117295 | Significant Tree 6 | Tree(s) :: 17 | 130 CAMBON DR | 1 | Side Yard : Yard | Tree | Private 2 | 3x3 | 5990450 | 2089482 | 37.7167704112637 | -122.474980331165 | (37.7167704112637, -122.474980331165) | 1 | 8 | 4 | 64 | 14 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | |||||
91798 | 173615 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200X JUNIPERO SERRA BLVD | 14 | Front Yard : Yard | Tree | Private 2 | 01/20/2017 12:00:00 AM | 3 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | |||
95053 | 114148 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1200X JUNIPERO SERRA BLVD | 7 | Front Yard : Yard | Tree | Private 2 | 19 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
95557 | 114140 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1200X JUNIPERO SERRA BLVD | 5 | Side Yard : Yard | Tree | Private 2 | 01/20/2017 12:00:00 AM | 3 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | |||
105349 | 114158 | Significant Tree 6 | Prunus armeniaca :: Apricot 296 | 1200X JUNIPERO SERRA BLVD | 6 | Front Yard : Yard | Tree | Private 2 | 01/20/2017 12:00:00 AM | 3 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | |||
145813 | 173616 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1200X JUNIPERO SERRA BLVD | 15 | Front Yard : Yard | Tree | Private 2 | 01/20/2017 12:00:00 AM | 3 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | |||
165218 | 114145 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 1200x JUNIPERO SERRA BLVD | 2 | Front Yard : Yard | Tree | Private 2 | 6 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
180735 | 114146 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 1200x JUNIPERO SERRA BLVD | 3 | Front Yard : Yard | Tree | Private 2 | 12 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
181284 | 114154 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200x JUNIPERO SERRA BLVD | 13 | Front Yard : Yard | Tree | Private 2 | 20 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
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 | ||||
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 | ||||
119656 | 114409 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 500X ARBALLO DR | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5987859 | 2089716 | 37.7172624174607 | -122.483953179035 | (37.7172624174607, -122.483953179035) | 1 | 8 | 4 | 64 | 14 | ||||
130345 | 114408 | Significant Tree 6 | Cedrus atlantica Glauca :: Blue Atlas Cedar 208 | 500X ARBALLO DR | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5987859 | 2089716 | 37.7172624174607 | -122.483953179035 | (37.7172624174607, -122.483953179035) | 1 | 8 | 4 | 64 | 14 | ||||
149016 | 114404 | Significant Tree 6 | Cedrus atlantica Glauca :: Blue Atlas Cedar 208 | 500X ARBALLO DR | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 5987859 | 2089716 | 37.7172624174607 | -122.483953179035 | (37.7172624174607, -122.483953179035) | 1 | 8 | 4 | 64 | 14 | |||
175794 | 114405 | Significant Tree 6 | Cedrus atlantica Glauca :: Blue Atlas Cedar 208 | 500X ARBALLO DR | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5987859 | 2089716 | 37.7172624174607 | -122.483953179035 | (37.7172624174607, -122.483953179035) | 1 | 8 | 4 | 64 | 14 | ||||
125248 | 106038 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 230 Lakeview Ave | Front Yard : Yard | Tree | Private 2 | Permit Number 772456 | 5997013.1 | 2089546.6 | 37.7173259605404 | -122.452299707743 | (37.7173259605404, -122.452299707743) | 9 | 8 | 6 | 28861 | 24 | |||||
19616 | 262407 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 300 Font Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6x5 | 5990018 | 2089729 | 37.7174235665943 | -122.476491559856 | (37.7174235665943, -122.476491559856) | 1 | 8 | 4 | 64 | 14 | ||||
13120 | 258703 | Significant Tree 6 | Tree(s) :: 17 | 131X Juan Bautista Cir | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11/25/2019 12:00:00 AM | 3 | 3x3 | Permit Number 783241 | 5989556 | 2089774 | 37.7175203194228 | -122.478091750656 | (37.7175203194228, -122.478091750656) | 1 | 8 | 4 | 64 | 14 | |
15674 | 258702 | Significant Tree 6 | Tree(s) :: 17 | 131X Juan Bautista Cir | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11/25/2019 12:00:00 AM | 3 | 3x3 | Permit Number 783241 | 5989556 | 2089774 | 37.7175203194228 | -122.478091750656 | (37.7175203194228, -122.478091750656) | 1 | 8 | 4 | 64 | 14 | |
194291 | 264997 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 909 Shields St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x9 | 5991621 | 2089826 | 37.7177827456648 | -122.470957844969 | (37.7177827456648, -122.470957844969) | 9 | 8 | 6 | 64 | 24 | ||||
105921 | 102569 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 0 Diaz Ave | 1 | Front Yard : Yard | Tree | Private 2 | 02/04/2013 12:00:00 AM | 2 | Permit Number 769785 | 5990053.95839 | 2089992.81974 | 37.7181500356804 | -122.476386530439 | (37.7181500356804, -122.476386530439) | 1 | 8 | 4 | 64 | 14 | ||
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 | |
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 | |
114129 | 254093 | Significant Tree 6 | Tree(s) :: 17 | 716 Gonzalez Dr | 2 | 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 | |
115084 | 104751 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 13X JUAN BAUTISTA CIR | 2 | Front Yard : Yard | Tree | Private 2 | 5989494 | 2090180 | 37.7186314952818 | -122.47833572412 | (37.7186314952818, -122.47833572412) | 1 | 8 | 4 | 64 | 14 | |||||
91742 | 114074 | Significant Tree 6 | Betula pendula :: European White Birch 253 | 18x HIGUERA AVE | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 5988029 | 2090212 | 37.7186342037977 | -122.483401916227 | (37.7186342037977, -122.483401916227) | 1 | 8 | 4 | 64 | 14 | ||||
161250 | 114073 | Significant Tree 6 | Betula pendula :: European White Birch 253 | 18x HIGUERA AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 5988029 | 2090212 | 37.7186342037977 | -122.483401916227 | (37.7186342037977, -122.483401916227) | 1 | 8 | 4 | 64 | 14 | ||||
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 | ||||
1773 | 116537 | Significant Tree 6 | Tree(s) :: 17 | 598x MOUNT VERNON AVE | 6 | Back Yard : Yard | Tree | Private 2 | 05/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777833 | 5997754 | 2090179 | 37.7191048016003 | -122.449784323005 | (37.7191048016003, -122.449784323005) | 9 | 8 | 6 | 28861 | 24 | |
84393 | 116534 | Significant Tree 6 | Tree(s) :: 17 | 598x MOUNT VERNON AVE | 3 | Back Yard : Yard | Tree | Private 2 | 05/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777833 | 5997754 | 2090179 | 37.7191048016003 | -122.449784323005 | (37.7191048016003, -122.449784323005) | 9 | 8 | 6 | 28861 | 24 | |
105492 | 116536 | Significant Tree 6 | Tree(s) :: 17 | 598x MOUNT VERNON AVE | 5 | Back Yard : Yard | Tree | Private 2 | 05/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777833 | 5997754 | 2090179 | 37.7191048016003 | -122.449784323005 | (37.7191048016003, -122.449784323005) | 9 | 8 | 6 | 28861 | 24 | |
143694 | 116535 | Significant Tree 6 | Tree(s) :: 17 | 598x MOUNT VERNON AVE | 4 | Back Yard : Yard | Tree | Private 2 | 05/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777833 | 5997754 | 2090179 | 37.7191048016003 | -122.449784323005 | (37.7191048016003, -122.449784323005) | 9 | 8 | 6 | 28861 | 24 | |
124365 | 116951 | Significant Tree 6 | Araucaria heterophylla :: Norfolk Island Pine 238 | 299 Tara St | 1 | Front Yard : Yard | Tree | Private 2 | 5997754 | 2090179.6 | 37.7191064490611 | -122.449784366221 | (37.7191064490611, -122.449784366221) | 9 | 8 | 6 | 28861 | 24 | |||||
9206 | 114067 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 37 | 6 Higuera Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 20 | 5987898 | 2090420 | 37.7191976939958 | -122.48386996767 | (37.7191976939958, -122.48386996767) | 1 | 8 | 4 | 64 | 14 | ||||
149040 | 114068 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 37 | 8 HIGUERA AVE | 1 | Front Yard : Yard | Tree | Private 2 | 20 | 5987898 | 2090420 | 37.7191976939958 | -122.48386996767 | (37.7191976939958, -122.48386996767) | 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 |
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) );