Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo, qCaretaker, qCareAssistant
PermitNotes ✖
qLegalStatus ✖
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
999 | 999 | 251422 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 480x De Long St | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 5992963.0 | 2086633.0 | 37.709093057147996 | -122.466087289133 | (37.709093057148, -122.466087289133) | |||||
90230 | 90230 | 98140 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 315 San Marcos Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 5992920.8 | 2100212.1 | 37.746375486546704 | -122.467219803339 | (37.7463754865467, -122.467219803339) | ||||||
99355 | 99355 | 106961 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 325 DWIGHT ST | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6010604.0 | 2091349.0 | 37.7230442144558 | -122.405448941518 | (37.7230442144558, -122.405448941518) | ||||||
109226 | 109226 | 109516 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 105 MIDCREST WAY | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | 12x12 | 5998180.4 | 2101012.8 | 37.748876224655795 | -122.4490904711 | (37.7488762246558, -122.4490904711) | ||||
112771 | 112771 | 109706 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 96 CRESTA VISTA DR | Back Yard : Cutout 16 | Tree 1 | Private 1 | 5995602.1 | 2096103.5 | 37.7352487002973 | -122.45765100803699 | (37.7352487002973, -122.457651008037) | ||||||
114948 | 114948 | 113440 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 190 BEACON ST | Back Yard : Yard 13 | Tree 1 | Private 1 | 32 | 3x3 | 6003193.0 | 2097540.0 | 37.739626138558705 | -122.43150902083299 | (37.7396261385587, -122.431509020833) | ||||
122333 | 122333 | 97685 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 84 Coventry Ct | Back Yard : Yard 13 | Tree 1 | Private 1 | 5997084.0 | 2096485.0 | 37.7363812239889 | -122.452555087132 | (37.7363812239889, -122.452555087132) | ||||||
122936 | 122936 | 107159 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 1000 ESMERALDA AVE | Front Yard : Yard 7 | Tree 1 | Private 1 | 6009839.0 | 2098688.0 | 37.7431527400861 | -122.408610872619 | (37.7431527400861, -122.408610872619) | ||||||
128066 | 128066 | 98503 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 208 Glenview Dr | Back Yard : Yard 13 | Tree 1 | Private 1 | 5998871.0 | 2100779.0 | 37.74827374071911 | -122.44668556582701 | (37.7482737407191, -122.446685565827) | ||||||
143207 | 143207 | 98706 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 353 UPPER TER | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 5999086.1 | 2105914.9 | 37.7623879420949 | -122.446311165521 | (37.7623879420949, -122.446311165521) | ||||||
145874 | 145874 | 100769 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 3701 21st St | Front Yard : Yard 7 | Tree 1 | Private 1 | 55 | Street tree w/in RoW | 6003717.0 | 2103606.0 | 37.7563116466144 | -122.43012988292 | (37.7563116466144, -122.43012988292) | ||||
6533 | 6533 | 19565 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY1 | -11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 100ST | ||||||||
8903 | 8903 | 19566 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY1 | -9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 100ST | ||||||||
293 | 293 | 251262 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630x 19th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 779147 | |||||||||
362 | 362 | 187139 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2301 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 39 | Width 0ft | 5984937.035 | 2099496.8257 | 37.7439474344515 | -122.494773601416 | (37.7439474344515, -122.494773601416) | |||
484 | 484 | 205880 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 44 Mendosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 43 | Width 3ft | 5993348.04769 | 2101170.42115 | 37.7490314462559 | -122.46581205990499 | (37.7490314462559, -122.465812059905) | |||
549 | 549 | 251321 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 100X Monument Way | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | ||||||||||
713 | 713 | 251364 | Private 5 | Cupressus macrocarpa :: Monterey Cypress 47 | 138x Gladeview Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | ||||||||||
763 | 763 | 251373 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 401 Portola Dr | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 5998962.0 | 2100210.0 | 37.7467166026546 | -122.446329965078 | (37.7467166026546, -122.446329965078) | |||||
784 | 784 | 251384 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 138x Gladeview Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5997939.0 | 2102166.0 | 37.7520288182083 | -122.45000833213699 | (37.7520288182083, -122.450008332137) | ||||
869 | 869 | 124177 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 8X Almaden Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 10 | Width 9ft | 5995876.0 | 2112606.0 | 37.7805760973259 | -122.457897862346 | (37.7805760973259, -122.457897862346) | |||
961 | 961 | 251408 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 75 Christmas Tree Point Rd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998776.0 | 2103023.0 | 37.75442978774979 | -122.447175546291 | (37.7544297877498, -122.447175546291) | ||||
1029 | 1029 | 251428 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 5030 Diamond Heights Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5999555.0 | 2100128.0 | 37.7465253005744 | -122.444273545879 | (37.7465253005744, -122.444273545879) | ||||
1030 | 1030 | 251424 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 5016 Diamond Heights Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5999555.0 | 2100128.0 | 37.7465253005744 | -122.444273545879 | (37.7465253005744, -122.444273545879) | ||||
1098 | 1098 | 251438 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2501X Santiago St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
1398 | 1398 | 251517 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 145 Bonview St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6007188.0 | 2098162.0 | 37.7415596321362 | -122.417740072125 | (37.7415596321362, -122.417740072125) | ||||
1604 | 1604 | 251632 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 14R Amethyst Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999202.0 | 2100044.0 | 37.746274510978395 | -122.445488137723 | (37.7462745109784, -122.445488137723) | |||||
1625 | 1625 | 251623 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 76R Amber Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999293.0 | 2100015.0 | 37.746200078593205 | -122.44517138727 | (37.7462000785932, -122.44517138727) | |||||
1626 | 1626 | 251635 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 18R Amethyst Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999176.0 | 2100050.0 | 37.746289501198795 | -122.445578473632 | (37.7462895011988, -122.445578473632) | |||||
1628 | 1628 | 251629 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 8R Amethyst Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999237.0 | 2100032.0 | 37.7462435599048 | -122.44536624972099 | (37.7462435599048, -122.445366249721) | |||||
1633 | 1633 | 251599 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 740 Moraga St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 5992006.0 | 2103899.0 | 37.756445907456396 | -122.470651540396 | (37.7564459074564, -122.470651540396) | ||||
1643 | 1643 | 251614 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 64R Amber Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999367.0 | 2100045.0 | 37.746286674920704 | -122.44491766156601 | (37.7462866749207, -122.444917661566) | |||||
1645 | 1645 | 251626 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 2R Amethyst Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999263.0 | 2100016.0 | 37.746201111936706 | -122.44527519504999 | (37.7462011119367, -122.44527519505) | |||||
1650 | 1650 | 251608 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 56R Amber Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999423.0 | 2100048.0 | 37.7462981080439 | -122.44472423658002 | (37.7462981080439, -122.44472423658) | |||||
1652 | 1652 | 251618 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 72R Amber Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999318.0 | 2100030.0 | 37.746242691915 | -122.445086018875 | (37.746242691915, -122.445086018875) | |||||
1736 | 1736 | 251677 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 772x Panorama Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5996636.0 | 2102785.0 | 37.7536537924326 | -122.454558985212 | (37.7536537924326, -122.454558985212) | ||||
1820 | 1820 | 251716 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3929 19th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003450.0 | 2104734.0 | 37.75939373993371 | -122.431133769968 | (37.7593937399337, -122.431133769968) | |||||
1822 | 1822 | 251717 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1000X San Jose Ave | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6004710.0 | 2096486.0 | 37.736817957153605 | -122.426188866367 | (37.7368179571536, -122.426188866367) | |||||
2151 | 2151 | 252916 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 101 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001472.0 | 2098865.0 | 37.7431665844065 | -122.437554349716 | (37.7431665844065, -122.437554349716) | ||||
2186 | 2186 | 252924 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 700 Sanchez St | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6003672.0 | 2104202.0 | 37.757945572264 | -122.430328029181 | (37.757945572264, -122.430328029181) | |||||
2764 | 2764 | 253207 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 89 Woodhaven Ct | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 3x3 | 5996069.0 | 2103645.0 | 37.75598259914371 | -122.45658197288401 | (37.7559825991437, -122.456581972884) | ||||
3121 | 3121 | 253303 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
3132 | 3132 | 253339 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 2019X 24th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | PUC 13 | 3x3 | 5988853.0 | 2101569.0 | 37.7498655183494 | -122.481384971136 | (37.7498655183494, -122.481384971136) | ||||
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) | ||||
3361 | 3361 | 253428 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3 Valletta Ct | 1 | Side Yard : Cutout 18 | Tree 1 | Private 1 | 6x10 | 5999319.0 | 2096479.0 | 37.736492551957895 | -122.44482735214198 | (37.7364925519579, -122.444827352142) | ||||
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) | ||||
3981 | 3981 | 18927 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2691 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6001960.28459 | 2115686.06098 | 37.7893808348161 | -122.437070045665 | (37.7893808348161, -122.437070045665) | |||
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) | ||||
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) | ||||
4923 | 4923 | 253718 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 227 Madison St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6005690.0 | 2092595.0 | 37.726189474375204 | -122.422524168298 | (37.7261894743752, -122.422524168298) | ||||
5088 | 5088 | 206891 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1675x 15th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 24 | Width 3ft | 5991393.559640001 | 2103864.47578 | 37.756315678748706 | -122.472767037095 | (37.7563156787487, -122.472767037095) | |||
5090 | 5090 | 253789 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1651X 15th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x2 | 5991453.0 | 2104016.0 | 37.756735165128205 | -122.47257252055401 | (37.7567351651282, -122.472572520554) | ||||
5096 | 5096 | 253768 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 Raccoon Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5998692.0 | 2104165.0 | 37.7575606372552 | -122.44754823773899 | (37.7575606372552, -122.447548237739) | |||||
5102 | 5102 | 253784 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1709X 15th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x2 | 5991403.0 | 2103783.0 | 37.756092514171904 | -122.472728448949 | (37.7560925141719, -122.472728448949) | ||||
5105 | 5105 | 253777 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 90 Cuesta Ct | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 5999757.0 | 2101744.0 | 37.750973968576496 | -122.443691128062 | (37.7509739685765, -122.443691128062) | |||||
6006 | 6006 | 20312 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 101X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 60 | ||||||||
6023 | 6023 | 19905 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY35 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 120ST | ||||||||
6399 | 6399 | 20412 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 453X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | ||||||||
7834 | 7834 | 119605 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 299x Avalon Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | ||||||||||
9172 | 9172 | 173599 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 100X Warren Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 5995367.0 | 2102770.0 | 37.7535397418859 | -122.458946354326 | (37.7535397418859, -122.458946354326) | |||
9683 | 9683 | 173631 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 99X Everglade Dr | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5986361.0 | 2095495.0 | 37.733042731061104 | -122.48955570953301 | (37.7330427310611, -122.489555709533) | ||||
9916 | 9916 | 173733 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 14 Richland Ave | 1 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 3x3 | 6004601.0 | 2096122.0 | 37.7358123337564 | -122.426539816145 | (37.7358123337564, -122.426539816145) | ||||
10134 | 10134 | 173877 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2651 San Jose Ave | 1 | Side Yard : Cutout 18 | Tree 1 | Private 1 | 3x3 | 5997397.0 | 2088796.0 | 37.7152869722449 | -122.450918658158 | (37.7152869722449, -122.450918658158) | ||||
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) | ||||
10256 | 10256 | 173933 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 190 Beacon St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003193.0 | 2097540.0 | 37.739626138558705 | -122.43150902083299 | (37.7396261385587, -122.431509020833) | |||||
11591 | 11591 | 20428 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 485X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 40 | ||||||||
12151 | 12151 | 19869 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY33 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 25ST | ||||||||
13184 | 13184 | 20013 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY47 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 100ST | ||||||||
13268 | 13268 | 187627 | Private 5 | Cupressus macrocarpa :: Monterey Cypress 47 | 88 States St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6001213.0 | 2106258.0 | 37.7634512529938 | -122.438979613423 | (37.7634512529938, -122.438979613423) | |||||
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) | ||||
13307 | 13307 | 187654 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 375 Woodside Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3x3 | 5997267.0 | 2099886.0 | 37.7457300260474 | -122.452167701039 | (37.7457300260474, -122.452167701039) | ||||
13314 | 13314 | 187669 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 554 Valley St | 1 | Median : Yard 3 | Tree 1 | Private 1 | 6002324.0 | 2099197.0 | 37.7441265828549 | -122.434632098307 | (37.7441265828549, -122.434632098307) | |||||
14425 | 14425 | 19694 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY7 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 12ST | ||||||||
14521 | 14521 | 20280 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 20X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | ||||||||
14992 | 14992 | 19932 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY38 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10ST | ||||||||
15767 | 15767 | 19699 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY11 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 40ST | ||||||||
16807 | 16807 | 106757 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 999 Key Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 06/02/2014 12:00:00 AM | 36 | 6013321.202330001 | 2089752.82506 | 37.718812992515105 | -122.395944254446 | (37.7188129925151, -122.395944254446) | |||
18889 | 18889 | 106642 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 4540X 17TH ST | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 5999139.0 | 2105833.0 | 37.762166086231204 | -122.446122313424 | (37.7621660862312, -122.446122313424) | ||||
19685 | 19685 | 92559 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 222 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52905 | 5996693.0 | 2111182.0 | 37.776713072168704 | -122.454968563419 | (37.7767130721687, -122.454968563419) | |||
21086 | 21086 | 23592 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 200X Vasquez Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 5994656.2966599995 | 2099224.9929400003 | 37.7437651683354 | -122.461147162215 | (37.7437651683354, -122.461147162215) | |||
22920 | 22920 | 251148 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 625 Brotherhood Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991521.0 | 2087959.0 | 37.7126506341802 | -122.471167551627 | (37.7126506341802, -122.471167551627) | ||||
22926 | 22926 | 251147 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 113x Gladeview Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5997915.0 | 2102038.0 | 37.7516759885035 | -122.450082102397 | (37.7516759885035, -122.450082102397) | ||||
23079 | 23079 | 8464 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1900 Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | 8 | 6002427.515 | 2113723.6274 | 37.784019039174794 | -122.435313053048 | (37.7840190391748, -122.435313053048) | |||
24119 | 24119 | 184645 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 3430 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 37 | Width 0ft | 5983573.582 | 2103608.0944 | 37.7551559377943 | -122.49979184963699 | (37.7551559377943, -122.499791849637) | |||
24947 | 24947 | 206807 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 11x Saint Francis Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 5991689.221530001 | 2095992.9314700002 | 37.734719554257296 | -122.471171081279 | (37.7347195542573, -122.471171081279) | ||||
25672 | 25672 | 247989 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 130 Mullen Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | Width 10ft | 6009899.29934 | 2099821.3308900003 | 37.7462679959733 | -122.40848229933901 | (37.7462679959733, -122.408482299339) | |||
26174 | 26174 | 206899 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 901 Monterey Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5996026.341440001 | 2094620.2534900003 | 37.731200426151794 | -122.456077057924 | (37.7312004261518, -122.456077057924) | |||
26275 | 26275 | 223757 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 5745 Diamond Heights Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 10ft | 6000755.6342 | 2096957.8752099997 | 37.7378893137452 | -122.439894635432 | (37.7378893137452, -122.439894635432) | |||
30020 | 30020 | 218148 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 35 Ashton Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 25 | 5994122.86099 | 2090034.3755400002 | 37.7184992748049 | -122.462325196761 | (37.7184992748049, -122.462325196761) | ||||
30529 | 30529 | 102468 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 50 Saint Germain Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5998217.7 | 2104179.8 | 37.757574157371295 | -122.44918961776699 | (37.7575741573713, -122.449189617767) | |||||
30531 | 30531 | 21160 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2301 Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | 5985027.9083074005 | 2099542.6271361 | 37.744078511576 | -122.49446276258301 | (37.744078511576, -122.494462762583) | |||
34240 | 34240 | 247903 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 582 Esmeralda Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 31 | 6009830.823 | 2098729.7061900003 | 37.743266798225605 | -122.40864208815701 | (37.7432667982256, -122.408642088157) | ||||
34630 | 34630 | 205915 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 506 Congo St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 6000129.85009 | 2095267.01455 | 37.7332109649183 | -122.44193694363199 | (37.7332109649183, -122.441936943632) | |||
35760 | 35760 | 223799 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 8 Laidley St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 34 | 6003000.19412 | 2098305.51493 | 37.741717135947205 | -122.43223031618601 | (37.7417171359472, -122.432230316186) | ||||
35815 | 35815 | 249711 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2901 Broadway | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 5999592.84448 | 2116997.53125 | 37.7928469352999 | -122.44535542411501 | (37.7928469352999, -122.445355424115) | ||||
36295 | 36295 | 176117 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 3500 Great Hwy | 1 | : 4 | Tree 1 | Private 1 | 27 | Width 0ft | 5982122.73417 | 2092919.02565 | 37.725721454959896 | -122.50401753028099 | (37.7257214549599, -122.504017530281) | |||
38550 | 38550 | 205889 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 25 Stanford Heights Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 5997824.88709 | 2095746.51675 | 37.734395947598 | -122.449940335175 | (37.734395947598, -122.449940335175) | |||
38782 | 38782 | 139327 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1350x GEARY BLVD | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 22 | Width 0ft | 6005396.3086 | 2114138.3218 | 37.785325835852795 | -122.425071614426 | (37.7853258358528, -122.425071614426) | |||
39207 | 39207 | 186925 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2800x Sunset Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 32 | Width 0ft | 5985117.1657 | 2095920.8688 | 37.734139358467104 | -122.493887283293 | (37.7341393584671, -122.493887283293) |
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");