Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSpecies, qSiteInfo, qCaretaker, PlantDate, DBH, PermitNotes
qLegalStatus ✖
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
238 | 238 | 251251 | DPW Maintained 3 | Prunus amygdalus :: Almond 63 | 321X Corbett Ave | 2 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 10x10 | 5999565.0 | 2105069.0 | 37.7600926500434 | -122.444594033425 | (37.7600926500434, -122.444594033425) | ||||
239 | 239 | 251252 | DPW Maintained 3 | Prunus amygdalus :: Almond 63 | 321X Corbett Ave | 3 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 10x10 | 5999565.0 | 2105069.0 | 37.7600926500434 | -122.444594033425 | (37.7600926500434, -122.444594033425) | ||||
247 | 247 | 251250 | DPW Maintained 3 | Prunus amygdalus :: Almond 63 | 321X Corbett Ave | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 10x10 | 5999565.0 | 2105069.0 | 37.7600926500434 | -122.444594033425 | (37.7600926500434, -122.444594033425) | ||||
563 | 563 | 173951 | Significant Tree 6 | Tree(s) :: 17 | 2646 Union St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 04/11/2017 12:00:00 AM | 3 | 10x10 | Permit Number 779549 | 6000338.0 | 2118225.0 | 37.796259749404605 | -122.442865342513 | (37.7962597494046, -122.442865342513) | |
2144 | 2144 | 252907 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 25 Point Lobos Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10x10 | 5982783.76519 | 2112486.06679 | 37.7794859217892 | -122.50318049806101 | (37.7794859217892, -122.503180498061) | ||||
2180 | 2180 | 251495 | Significant Tree 6 | Tree(s) :: 17 | 2448 Clay St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 06/28/2017 12:00:00 AM | 3 | 10x10 | Permit Number 780000 | 6003026.0 | 2116224.0 | 37.7909183964794 | -122.433421252488 | (37.7909183964794, -122.433421252488) | |
2848 | 2848 | 253255 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 270 Castenada Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10x10 | 5994049.0 | 2100330.0 | 37.746764271907 | -122.46332720271201 | (37.746764271907, -122.463327202712) | ||||
2854 | 2854 | 253253 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 99X Lopez Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10x10 | 5994049.0 | 2100330.0 | 37.746764271907 | -122.46332720271201 | (37.746764271907, -122.463327202712) | ||||
2859 | 2859 | 253251 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 99X Lopez Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10x10 | 5994049.0 | 2100330.0 | 37.746764271907 | -122.46332720271201 | (37.746764271907, -122.463327202712) | ||||
2869 | 2869 | 253250 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 99X Lopez Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10x10 | 5994049.0 | 2100330.0 | 37.746764271907 | -122.46332720271201 | (37.746764271907, -122.463327202712) | ||||
2874 | 2874 | 253252 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 99X Lopez Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10x10 | 5994049.0 | 2100330.0 | 37.746764271907 | -122.46332720271201 | (37.746764271907, -122.463327202712) | ||||
3007 | 3007 | 253279 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 201X Laguna Honda Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 10x10 | ROW IS 10' tree is street tree | ||||||||
3059 | 3059 | 126695 | Significant Tree 6 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2829 Divisadero St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 10x10 | Permit Number 779774 | 6000551.43021 | 2118023.61416 | 37.7957189625051 | -122.44211236900601 | (37.7957189625051, -122.442112369006) | ||
3138 | 3138 | 253254 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 270 Castenada Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10x10 | 5994049.0 | 2100330.0 | 37.746764271907 | -122.46332720271201 | (37.746764271907, -122.463327202712) | ||||
3208 | 3208 | 253368 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 236 Moncada Way | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 10x10 | 5992398.0 | 2093455.0 | 37.7277919980392 | -122.468536018982 | (37.7277919980392, -122.468536018982) | ||||
3283 | 3283 | 253384 | Significant Tree 6 | Cedrus atlantica Glauca :: Blue Atlas Cedar 203 | 55 Cerritos Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10x10 | 5992588.0 | 2092941.0 | 37.7263916542788 | -122.46784182223999 | (37.7263916542788, -122.46784182224) | ||||
3390 | 3390 | 253422 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 2X Miraloma Dr | 1 | Side Yard : Cutout 18 | Tree 1 | DPW 2 | 10x10 | 5994995.0 | 2097925.0 | 37.740215196600396 | -122.459881864698 | (37.7402151966004, -122.459881864698) | ||||
3496 | 3496 | 253449 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 330 Twin Peaks Blvd | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 10x10 | 5998688.0 | 2103995.0 | 37.7570936308358 | -122.44754983450599 | (37.7570936308358, -122.447549834506) | ||||
4063 | 4063 | 253608 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 400X Portola Dr | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 5998814.0 | 2100235.0 | 37.746776792757004 | -122.44684353081101 | (37.746776792757, -122.446843530811) | ||||
4447 | 4447 | 253626 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 1671 Funston Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10x10 | 5992125.0 | 2104081.0 | 37.756952512450205 | -122.47025325330601 | (37.7569525124502, -122.470253253306) | ||||
4659 | 4659 | 253652 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 131 Font Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10x10 | 5990844.0 | 2088883.0 | 37.7151485301311 | -122.473574812248 | (37.7151485301311, -122.473574812248) | ||||
4884 | 4884 | 253710 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Monument Way | 4 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 10x10 | 5999088.0 | 2105836.0 | 37.7621714109075 | -122.446298918118 | (37.7621714109075, -122.446298918118) | ||||
4891 | 4891 | 253709 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Monument Way | 3 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 10x10 | 5999088.0 | 2105836.0 | 37.7621714109075 | -122.446298918118 | (37.7621714109075, -122.446298918118) | ||||
4893 | 4893 | 253707 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Monument Way | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 10x10 | 5999088.0 | 2105836.0 | 37.7621714109075 | -122.446298918118 | (37.7621714109075, -122.446298918118) | ||||
4898 | 4898 | 253711 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Monument Way | 5 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 10x10 | 5999088.0 | 2105836.0 | 37.7621714109075 | -122.446298918118 | (37.7621714109075, -122.446298918118) | ||||
4906 | 4906 | 253708 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Monument Way | 2 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 10x10 | 5999088.0 | 2105836.0 | 37.7621714109075 | -122.446298918118 | (37.7621714109075, -122.446298918118) | ||||
5112 | 5112 | 253808 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 2 Garfield St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10x10 | 5993976.0 | 2090624.0 | 37.7201097842726 | -122.462875584037 | (37.7201097842726, -122.462875584037) | ||||
5161 | 5161 | 253809 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 2 Garfield St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10x10 | 5993976.0 | 2090624.0 | 37.7201097842726 | -122.462875584037 | (37.7201097842726, -122.462875584037) | ||||
10255 | 10255 | 112606 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 100X Monument Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10x10 | 5999003.0 | 2105766.0 | 37.761974353511896 | -122.446587863076 | (37.7619743535119, -122.446587863076) | ||||
10627 | 10627 | 1283 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 44 | 3995X Alemany Blvd | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 10x10 | 5992081.50866 | 2087171.0422099999 | 37.710519496741206 | -122.469172961285 | (37.7105194967412, -122.469172961285) | |||
13271 | 13271 | 187638 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 875 El Camino Del Mar | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10x10 | 5985641.0 | 2114972.0 | 37.786479112006 | -122.493479464676 | (37.786479112006, -122.493479464676) | ||||
13275 | 13275 | 187637 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 875 El Camino Del Mar | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10x10 | 5985641.0 | 2114972.0 | 37.786479112006 | -122.493479464676 | (37.786479112006, -122.493479464676) | ||||
18486 | 18486 | 106393 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
47434 | 47434 | 96416 | Permitted Site 1 | Magnolia spp :: Magnolia 89 | 2749 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 10x10 | 6008995.5323 | 2102438.8768 | 37.7534045389876 | -122.411792354923 | (37.7534045389876, -122.411792354923) | |||
50494 | 50494 | 110477 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 131X Washington St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 04/16/2015 12:00:00 AM | 3 | 10x10 | Permit Number 774729 | 6013427.21844 | 2117958.83498 | 37.796266453658795 | -122.397554954018 | (37.7962664536588, -122.397554954018) | |
79534 | 79534 | 121404 | Property Tree 7 | Sequoia sempervirens :: Coast Redwood 116 | 1900 08th Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | 10x10 | 5993817.0 | 2102486.0 | 37.7526707300666 | -122.464285931649 | (37.7526707300666, -122.464285931649) | |||
79975 | 79975 | 106399 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 26 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
80883 | 80883 | 106374 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
81473 | 81473 | 106380 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
82039 | 82039 | 116084 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 127 Edgehill Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10x10 | Permit Number 773426 | 5994851.1 | 2098962.7 | 37.7430561859317 | -122.46045458158301 | (37.7430561859317, -122.460454581583) | |||
82181 | 82181 | 106395 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
83897 | 83897 | 106386 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
83946 | 83946 | 106379 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
85674 | 85674 | 113134 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 50 03rd St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/09/2015 12:00:00 AM | 10x10 | Permit Number 775860 | 6011822.9 | 2114512.2 | 37.7867133521926 | -122.402863731968 | (37.7867133521926, -122.402863731968) | ||
86001 | 86001 | 115786 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 75 MARIETTA DR | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10x10 | 5998284.0 | 2098359.0 | 37.7415954597605 | -122.448541125431 | (37.7415954597605, -122.448541125431) | ||||
88463 | 88463 | 116012 | Undocumented 2 | Salix discolor :: Pussy Willow 437 | 250 HAZELWOOD AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 18 | 10x10 | Permit Number 777957 | 5996359.0 | 2095057.0 | 37.7324187155695 | -122.454958550665 | (37.7324187155695, -122.454958550665) | ||
88523 | 88523 | 116864 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 262X OAK PARK DR | 3 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 10x10 | 5995091.0 | 2103085.0 | 37.7543887826633 | -122.459923632558 | (37.7543887826633, -122.459923632558) | ||||
89830 | 89830 | 106376 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
92047 | 92047 | 106392 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
92228 | 92228 | 122453 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 217 San Marcos Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10x10 | 5993325.07095 | 2100296.14299 | 37.7466295758311 | -122.465827998209 | (37.7466295758311, -122.465827998209) | ||||
92541 | 92541 | 115176 | Significant Tree 6 | Tree(s) :: 17 | 460 Pacheco St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | 10x10 | Permit Number 775764 | 5993727.4 | 2101897.6 | 37.7510499693469 | -122.464553061226 | (37.7510499693469, -122.464553061226) | ||
94414 | 94414 | 106389 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
94753 | 94753 | 110144 | Undocumented 2 | Araucaria heterophylla :: Norfolk Island Pine 24 | 129 DE SOTO ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 15 | 10x10 | 5993256.9 | 2092045.6 | 37.723971707155705 | -122.465464466989 | (37.7239717071557, -122.465464466989) | |||
96425 | 96425 | 116863 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 262X OAK PARK DR | 2 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 10x10 | 5995091.0 | 2103085.0 | 37.7543887826633 | -122.459923632558 | (37.7543887826633, -122.459923632558) | ||||
97264 | 97264 | 106377 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
97425 | 97425 | 116862 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 262X OAK PARK DR | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 10x10 | 5995091.0 | 2103085.0 | 37.7543887826633 | -122.459923632558 | (37.7543887826633, -122.459923632558) | ||||
97640 | 97640 | 106384 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
99119 | 99119 | 121475 | Undocumented 2 | Araucaria heterophylla :: Norfolk Island Pine 24 | 705 Victoria St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10x10 | 5993498.0 | 2091842.0 | 37.723426573455896 | -122.464616252006 | (37.7234265734559, -122.464616252006) | ||||
99197 | 99197 | 106956 | Significant Tree 6 | Tree(s) :: 17 | 50 Fell St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 10x10 | 6007226.0 | 2110908.0 | 37.7765593411304 | -122.418512280303 | (37.7765593411304, -122.418512280303) | |||
100855 | 100855 | 114731 | Property Tree 7 | Eucalyptus globulus :: Blue Gum 103 | 934 BRANNAN ST | Back Yard : Yard 13 | Tree 1 | Private 1 | Dept of Real Estate 9 | 10x10 | 6010724.0 | 2108745.0 | 37.7708165471861 | -122.40625919407302 | (37.7708165471861, -122.406259194073) | ||||
103968 | 103968 | 106387 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
105877 | 105877 | 106381 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
107759 | 107759 | 120952 | Significant Tree 6 | Tree(s) :: 17 | 100X 32nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 08/30/2016 12:00:00 AM | 3 | 10x10 | Permit Number 778529 | 5985781.0 | 2114962.0 | 37.7864598433405 | -122.492994369609 | (37.7864598433405, -122.492994369609) | |
110134 | 110134 | 117310 | Permitted Site 1 | Tree(s) :: 17 | 126X Juan Bautista Cir | 1 | Median : Yard 3 | Tree 1 | Private 1 | 06/06/2016 12:00:00 AM | 3 | 10x10 | Permit Number 777998 | 5989282.4 | 2089642.3 | 37.7171428191075 | -122.479027821944 | (37.7171428191075, -122.479027821944) | |
110313 | 110313 | 106397 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
110760 | 110760 | 110019 | Undocumented 2 | Tree(s) :: 17 | 1970X Pacheco St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 03/17/2015 12:00:00 AM | 3 | 10x10 | Permit Number 775175 | 5988957.75596 | 2101724.09263 | 37.7502974516687 | -122.48103407887899 | (37.7502974516687, -122.481034078879) | |
111683 | 111683 | 114761 | Private 5 | Pinus radiata :: Monterey Pine 3 | 2155 10TH AVE | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10x10 | 5993160.0 | 2101036.0 | 37.7486515109126 | -122.466452556212 | (37.7486515109126, -122.466452556212) | ||||
115281 | 115281 | 106394 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
115311 | 115311 | 106383 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
115524 | 115524 | 117309 | Significant Tree 6 | Tree(s) :: 17 | 3711 19th Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 06/06/2016 12:00:00 AM | 3 | 10x10 | Permit Number 777997 | 5990297.3 | 2090806.0 | 37.7203969366505 | -122.475604756889 | (37.7203969366505, -122.475604756889) | |
120659 | 120659 | 106375 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
125606 | 125606 | 106382 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
126031 | 126031 | 110476 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3700 Washington St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 04/16/2015 12:00:00 AM | 3 | 10x10 | Permit Number 774729 | 5997015.1 | 2115715.0 | 37.7891779638687 | -122.454181816252 | (37.7891779638687, -122.454181816252) | |
126630 | 126630 | 115885 | Planning Code 138.1 required 4 | Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 482 | 134 Lunado Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 03/01/2016 12:00:00 AM | 3 | 10x10 | Permit Number 772714 | 5991633.6 | 2092401.5 | 37.7248551637156 | -122.471101821397 | (37.7248551637156, -122.471101821397) | |
139009 | 139009 | 106388 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
139171 | 139171 | 106385 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
139787 | 139787 | 68987 | Planning Code 138.1 required 4 | Cordyline australis :: Dracena Palm 141 | 767 Marina Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/2016 12:00:00 AM | 3 | 10x10 | Permit Number 775182 | 5999291.63198947 | 2121477.34728573 | 37.8051301110493 | -122.44672010757 | (37.8051301110493, -122.44672010757) | |
140337 | 140337 | 113133 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 50 03rd St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/09/2015 12:00:00 AM | 10x10 | Permit Number 775860 | 6011822.9 | 2114512.2 | 37.7867133521926 | -122.402863731968 | (37.7867133521926, -122.402863731968) | ||
140616 | 140616 | 106396 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 23 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
142197 | 142197 | 112354 | Significant Tree 6 | Tree(s) :: 17 | 300 Moncada Way | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/04/2016 12:00:00 AM | 10x10 | Permit Number 775546 | 5992209.2 | 2093928.1 | 37.729080105492 | -122.469223117768 | (37.729080105492, -122.469223117768) | ||
142322 | 142322 | 106398 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 25 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
142776 | 142776 | 106390 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
143350 | 143350 | 106391 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
143771 | 143771 | 106378 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");