Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 188707 | 188707 | 200960 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 1527 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6008413.1986 | 2109048.8424 | 37.7715212967515 | -122.414273832498 | (37.7715212967515, -122.414273832498) | |||
| 188333 | 188333 | 221626 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 1062 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007406.75349 | 2101144.5043200003 | 37.749761228112504 | -122.417194987955 | (37.7497612281125, -122.417194987955) | |||
| 188142 | 188142 | 175091 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 315 Foote Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5998119.37359 | 2088859.0564599999 | 37.7155014387137 | -122.44842636790301 | (37.7155014387137, -122.448426367903) | |||
| 187824 | 187824 | 221628 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 4000 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001765.60614 | 2102951.6080400003 | 37.7544041283635 | -122.43683162277901 | (37.7544041283635, -122.436831622779) | |||
| 186501 | 186501 | 187806 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 2136 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6011324.11202 | 2105592.91777 | 37.7621951926664 | -122.40396152970501 | (37.7621951926664, -122.403961529705) | |||
| 185778 | 185778 | 187794 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 600 Bryant St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6012957.46909 | 2111742.60396 | 37.7791719674623 | -122.398743927591 | (37.7791719674623, -122.398743927591) | |||
| 184787 | 184787 | 221578 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 98 Elgin Park | 4 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6005821.59995 | 2108544.12288 | 37.769989541308 | -122.42320244124201 | (37.769989541308, -122.423202441242) | |||
| 184052 | 184052 | 203300 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 518 Molimo Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5997436.98618 | 2097718.90035 | 37.7397894346335 | -122.45142364098601 | (37.7397894346335, -122.451423640986) | |||
| 181903 | 181903 | 221623 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 583 Ogden Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6007846.60865 | 2096102.95015 | 37.735942974893 | -122.415317092012 | (37.735942974893, -122.415317092012) | |||
| 181821 | 181821 | 221579 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 365 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6005497.37078 | 2101576.73958 | 37.7508404433343 | -122.423828450348 | (37.7508404433343, -122.423828450348) | |||
| 181090 | 181090 | 221582 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 1801 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6009541.12472 | 2106040.44893 | 37.7633242348594 | -122.410159828117 | (37.7633242348594, -122.410159828117) | |||
| 180606 | 180606 | 187810 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 501 Beale St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6015691.66972 | 2114223.10975 | 37.786134837994496 | -122.38945839869 | (37.7861348379945, -122.38945839869) | |||
| 180430 | 180430 | 221574 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 80 Elgin Park | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6005813.30509 | 2108654.41752 | 37.770291915861705 | -122.423238974413 | (37.7702919158617, -122.423238974413) | |||
| 180353 | 180353 | 32979 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 1078 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 5 | Permit Number 37292 | 6015506.5779800005 | 2104082.98749 | 37.758282033796 | -122.389390396476 | (37.758282033796, -122.389390396476) | |
| 180342 | 180342 | 221630 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 1188 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6003175.61372 | 2101336.19411 | 37.7500486190657 | -122.431840120148 | (37.7500486190657, -122.431840120148) | |||
| 179672 | 179672 | 175080 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 105 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6001743.4757199995 | 2090827.1646099999 | 37.7211119654402 | -122.43604061777701 | (37.7211119654402, -122.436040617777) | |||
| 179216 | 179216 | 32938 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 1530 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 6 | Permit Number 37258 | 6013021.6210199995 | 2105688.27422 | 37.7625517136065 | -122.398097141493 | (37.7625517136065, -122.398097141493) | |
| 178792 | 178792 | 187811 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 501 Beale St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6015693.4534599995 | 2114236.6161 | 37.7861720222617 | -122.389453170937 | (37.7861720222617, -122.389453170937) | |||
| 178213 | 178213 | 221646 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 24 Henry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003262.27959 | 2107436.4130599997 | 37.7668032747714 | -122.431975970832 | (37.7668032747714, -122.431975970832) | |||
| 178185 | 178185 | 200959 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 1527 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6008393.6527 | 2109024.2847 | 37.7714527691166 | -122.414339705165 | (37.7714527691166, -122.414339705165) | |||
| 177160 | 177160 | 221644 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 841 Church St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004368.616830001 | 2104071.54426 | 37.7576268057401 | -122.427909537788 | (37.7576268057401, -122.427909537788) | |||
| 177040 | 177040 | 221600 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 617 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5998650.226869999 | 2105582.31202 | 37.7614498354487 | -122.44779473806001 | (37.7614498354487, -122.44779473806) | |||
| 176877 | 176877 | 187797 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 703 Bryant St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6012415.74144 | 2111222.3221400003 | 37.7777131951528 | -122.400581439494 | (37.7777131951528, -122.400581439494) | |||
| 176828 | 176828 | 125328 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 2432 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6003036.129819999 | 2116537.38571 | 37.7917794481001 | -122.43340860792 | (37.7917794481001, -122.43340860792) | |||
| 176508 | 176508 | 175088 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 375 London St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6002107.93429 | 2091559.7629 | 37.7231442147086 | -122.434833155628 | (37.7231442147086, -122.434833155628) | |||
| 175754 | 175754 | 187795 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 660 Bryant St | 5 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6012596.8957 | 2111389.55131 | 37.7781824694894 | -122.399966507348 | (37.7781824694894, -122.399966507348) | |||
| 175362 | 175362 | 221577 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 98 Elgin Park | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6005820.32066 | 2108557.45054 | 37.7700260636763 | -122.423207813799 | (37.7700260636763, -122.423207813799) | |||
| 174976 | 174976 | 187792 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 474 Bryant St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013963.38885 | 2112691.5592900002 | 37.7818335775918 | -122.39533050761699 | (37.7818335775918, -122.395330507617) | |||
| 174633 | 174633 | 203303 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 1256 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5994883.997719999 | 2106952.30042 | 37.7649954872656 | -122.46091976594101 | (37.7649954872656, -122.460919765941) | |||
| 172920 | 172920 | 175094 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 43 Cordova St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6001705.80324 | 2087761.46541 | 37.7126920978345 | -122.435951589399 | (37.7126920978345, -122.435951589399) | |||
| 172641 | 172641 | 175083 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 3143 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5996140.52774 | 2087004.46938 | 37.7102958353443 | -122.455132166333 | (37.7102958353443, -122.455132166333) | |||
| 172481 | 172481 | 221650 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 81 Ord St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000873.42277 | 2105941.92407 | 37.7625640595034 | -122.44013143234 | (37.7625640595034, -122.44013143234) | |||
| 172284 | 172284 | 175087 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 339 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6004286.79403 | 2090457.00677 | 37.7202397543384 | -122.427222750735 | (37.7202397543384, -122.427222750735) | |||
| 171885 | 171885 | 32219 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 544 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2005 12:00:00 AM | 4 | Permit Number 48561 | 6009486.27914 | 2100215.48999 | 37.7473271311603 | -122.409938299007 | (37.7473271311603, -122.409938299007) | |
| 171688 | 171688 | 40153 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 1175 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 3 | Permit Number 42703 | 6007420.25533 | 2118807.46679 | 37.7982602766535 | -122.418400539955 | (37.7982602766535, -122.418400539955) | |
| 171475 | 171475 | 221583 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 1801 Bryant St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6009538.42395 | 2106083.68166 | 37.7634427906806 | -122.410172221696 | (37.7634427906806, -122.410172221696) | |||
| 171247 | 171247 | 221599 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 3834 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6004934.18141 | 2100789.3668299997 | 37.748646690198896 | -122.425719976397 | (37.7486466901989, -122.425719976397) | |||
| 170307 | 170307 | 41951 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 780 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 2 | 3x3 | Permit Number 42308 | 5993221.22207 | 2110189.0199700003 | 37.7737868415675 | -122.466906164856 | (37.7737868415675, -122.466906164856) |
| 168627 | 168627 | 221573 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 40 Elgin Park | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6005806.54195 | 2108839.22973 | 37.7707989842145 | -122.42327550758101 | (37.7707989842145, -122.423275507581) | |||
| 168345 | 168345 | 203307 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 2675 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991740.2588599995 | 2097238.14622 | 37.7381415510917 | -122.47108531655898 | (37.7381415510917, -122.471085316559) | |||
| 168269 | 168269 | 187804 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 1022 Minna St | 8 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6007516.81394 | 2109678.2468 | 37.7731990993886 | -122.417419096312 | (37.7731990993886, -122.417419096312) | |||
| 168040 | 168040 | 221638 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 685 Sanchez St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 5ft | 6003710.0195 | 2104258.56211 | 37.7581030318426 | -122.430200576896 | (37.7581030318426, -122.430200576896) | |||
| 167547 | 167547 | 221627 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 3348 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006051.64751 | 2103193.30025 | 37.7553104210429 | -122.422026534497 | (37.7553104210429, -122.422026534497) | |||
| 166983 | 166983 | 187793 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 570 Bryant St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013291.53911 | 2112061.35383 | 37.780065789244205 | -122.397610596567 | (37.7800657892442, -122.397610596567) | |||
| 166711 | 166711 | 41281 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 850 Battery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2013 12:00:00 AM | 1 | Permit Number 770203 | 6012419.16584 | 2119105.18058 | 37.79935786234 | -122.401123636248 | (37.79935786234, -122.401123636248) | ||
| 166458 | 166458 | 125332 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 133 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6012465.96545 | 2119155.6928 | 37.799499167399 | -122.40096524315099 | (37.799499167399, -122.400965243151) | |||
| 165264 | 165264 | 221636 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 180 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002670.2536 | 2104875.6925 | 37.759738576691 | -122.433840639551 | (37.759738576691, -122.433840639551) | |||
| 164658 | 164658 | 187809 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 501 Beale St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6015698.950669999 | 2114230.91613 | 37.7861566762234 | -122.389433753673 | (37.7861566762234, -122.389433753673) | |||
| 164461 | 164461 | 175082 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 3117 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5996116.72669 | 2086995.74182 | 37.7102705059528 | -122.455213796889 | (37.7102705059528, -122.455213796889) | |||
| 164444 | 164444 | 121985 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 454 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5991269.55621 | 2112312.02155 | 37.779503186990794 | -122.473812131609 | (37.7795031869908, -122.473812131609) | |||
| 164152 | 164152 | 175086 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 812 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6001790.79227 | 2089105.5974299998 | 37.7163876144767 | -122.43575394898501 | (37.7163876144767, -122.435753948985) | |||
| 163943 | 163943 | 120842 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 295 19th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 2ft | 5989915.896240001 | 2113429.21441 | 37.7824921918256 | -122.47857668807501 | (37.7824921918256, -122.478576688075) | |||
| 163219 | 163219 | 221632 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 1045 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003827.6004800005 | 2102209.17649 | 37.7524825622315 | -122.42964776905501 | (37.7524825622315, -122.429647769055) | |||
| 162787 | 162787 | 182734 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 1751 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5985931.2126 | 2103316.1262 | 37.754492340305 | -122.49161709709499 | (37.754492340305, -122.491617097095) | |||
| 162243 | 162243 | 187817 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 205 Salinas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6012612.74982 | 2090602.9708900002 | 37.7211078816055 | -122.39845272981199 | (37.7211078816055, -122.398452729812) | |||
| 160215 | 160215 | 221608 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 2901 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009434.747819999 | 2102163.68308 | 37.752673548562605 | -122.41025402043199 | (37.7526735485626, -122.410254020432) | |||
| 160000 | 160000 | 203301 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 363 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 1ft | 5998344.73161 | 2094075.4618900002 | 37.72983735791 | -122.448022794439 | (37.72983735791, -122.448022794439) | |||
| 157648 | 157648 | 221594 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 385 Valley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6003453.78732 | 2099196.86888 | 37.7441902958577 | -122.430725535475 | (37.7441902958577, -122.430725535475) | |||
| 156359 | 156359 | 221576 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 98 Elgin Park | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 6005820.21347 | 2108567.35172 | 37.7700532438971 | -122.42320888847799 | (37.7700532438971, -122.423208888478) | |||
| 155178 | 155178 | 61790 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 1249 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1985 12:00:00 AM | 5 | Permit Number 21813 | 6011995.77759 | 2102561.7862 | 37.7539098771551 | -122.401425448751 | (37.7539098771551, -122.401425448751) | |
| 154541 | 154541 | 114545 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 1219 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/2015 12:00:00 AM | 2 | Permit Number 772772 | 6011988.90891 | 2102695.16148 | 37.7542757132549 | -122.401458575266 | (37.7542757132549, -122.401458575266) | ||
| 154291 | 154291 | 125333 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 133 Vallejo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6012493.13402 | 2119160.53204 | 37.7995139702525 | -122.400871569787 | (37.7995139702525, -122.400871569787) | |||
| 153713 | 153713 | 187799 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 804 Bryant St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6011732.346 | 2110569.44577 | 37.7758824101801 | -122.402899621945 | (37.7758824101801, -122.402899621945) | |||
| 153122 | 153122 | 221584 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 1801 Bryant St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6009533.60745 | 2106163.71232 | 37.763662266614396 | -122.410194531154 | (37.7636622666144, -122.410194531154) | |||
| 151802 | 151802 | 125325 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 2400 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6003273.61956 | 2115917.5849 | 37.7900911040648 | -122.43254260396601 | (37.7900911040648, -122.432542603966) | |||
| 150298 | 150298 | 122935 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 366 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5992808.12502 | 2113018.7034 | 37.7815325351796 | -122.468541044774 | (37.7815325351796, -122.468541044774) | |||
| 148662 | 148662 | 125327 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 2472 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6002987.36795 | 2115876.17314 | 37.789961161030504 | -122.433530049682 | (37.7899611610305, -122.433530049682) | |||
| 147779 | 147779 | 221581 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 1801 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6009543.08005 | 2105995.8040400003 | 37.7632017597825 | -122.410149913112 | (37.7632017597825, -122.410149913112) | |||
| 146949 | 146949 | 221609 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 2795 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008187.06848 | 2106771.35973 | 37.7652551566233 | -122.414894813551 | (37.7652551566233, -122.414894813551) | |||
| 145351 | 145351 | 108823 | Section 143 8 | Acer buergeranum :: Trident Maple 120 | 101x FREMONT ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5x5 | 6013648.6 | 2115847.1 | 37.7904804500674 | -122.396640813258 | (37.7904804500674, -122.396640813258) | ||||
| 141977 | 141977 | 82695 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 1555-1557 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2008 12:00:00 AM | 3x3 | Permit Number 50231 | 6010513.29558366 | 2100547.672123 | 37.7482967364932 | -122.40641033512199 | (37.7482967364932, -122.406410335122) | ||
| 140426 | 140426 | 175081 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 27 Sears St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 1ft | 5996779.12148 | 2087015.14863 | 37.71036177455 | -122.45292583705601 | (37.71036177455, -122.452925837056) | |||
| 139955 | 139955 | 111059 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 1851 Bryant St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6009528.24804625 | 2106163.95855958 | 37.7636626423221 | -122.410213085123 | (37.7636626423221, -122.410213085123) | ||||
| 139258 | 139258 | 64715 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 144 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2005 12:00:00 AM | Permit Number 25667 | 6006489.13363316 | 2097549.49596669 | 37.739838480174896 | -122.42011306053301 | (37.7398384801749, -122.420113060533) | ||
| 139130 | 139130 | 36036 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 1660X BRYANT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | 5 | 3x3 | Permit Number 39178 | 6009450.0 | 2107109.0 | 37.7662531230435 | -122.410550460301 | (37.7662531230435, -122.410550460301) |
| 138881 | 138881 | 109056 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 340 Hanover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772773 | 5999449.8 | 2086496.1 | 37.7090892698694 | -122.443658181084 | (37.7090892698694, -122.443658181084) |
| 137914 | 137914 | 32476 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 81 Ord St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/2016 12:00:00 AM | 2 | Permit Number 773566 | 6000872.741090001 | 2105927.69482 | 37.7625249506752 | -122.440132769612 | (37.7625249506752, -122.440132769612) | |
| 137911 | 137911 | 221640 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 264 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004586.45702 | 2103983.55816 | 37.7573975379924 | -122.427149890352 | (37.7573975379924, -122.427149890352) | |||
| 137601 | 137601 | 221617 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 800 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008123.889830001 | 2097149.5121799998 | 37.7388321854502 | -122.41443244780899 | (37.7388321854502, -122.414432447809) | |||
| 136841 | 136841 | 187808 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 145 Fremont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6013749.718309999 | 2115764.74251 | 37.7902599427975 | -122.396285173032 | (37.7902599427975, -122.396285173032) | |||
| 136373 | 136373 | 140828 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 522 Euclid Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5996742.3671 | 2113865.9338 | 37.7840852784904 | -122.454991769706 | (37.7840852784904, -122.454991769706) | |||
| 135663 | 135663 | 203297 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 1405 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5992697.6604 | 2105877.8341900003 | 37.761919240208705 | -122.468403517504 | (37.7619192402087, -122.468403517504) | |||
| 135285 | 135285 | 58364 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 830 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/1978 12:00:00 AM | 1 | Permit Number 17393 | 6000499.2722 | 2111849.5321 | 37.7787635613104 | -122.441849500148 | (37.7787635613104, -122.441849500148) | ||
| 134867 | 134867 | 221593 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 3882 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004614.75579 | 2101353.13137 | 37.7501766015869 | -122.426864691973 | (37.7501766015869, -122.426864691973) | |||
| 134714 | 134714 | 140827 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 520 Euclid Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5996759.2882 | 2113866.2722 | 37.7840871783405 | -122.454933253599 | (37.7840871783405, -122.454933253599) | |||
| 134635 | 134635 | 221596 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 284 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004141.2523 | 2098697.9231 | 37.7428592299584 | -122.42831287746401 | (37.7428592299584, -122.428312877464) | |||
| 133313 | 133313 | 221605 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 126 Ellert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6007327.7514 | 2096972.1243 | 37.738300360572296 | -122.41717256337799 | (37.7383003605723, -122.417172563378) | |||
| 132355 | 132355 | 50434 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 809 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Permit Number 47087 | 6001988.949 | 2111327.3401 | 37.7774145243393 | -122.436658745183 | (37.7774145243393, -122.436658745183) | |||
| 131590 | 131590 | 221598 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 3835 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004922.63411 | 2100744.76364 | 37.7485235676072 | -122.42575673258001 | (37.7485235676072, -122.42575673258) | |||
| 131028 | 131028 | 221624 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 620 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6007869.47892 | 2104261.8393099997 | 37.7583467427219 | -122.41581557003599 | (37.7583467427219, -122.415815570036) | |||
| 130826 | 130826 | 221606 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 879 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6009142.75703 | 2104069.9032 | 37.757891228003004 | -122.411398436495 | (37.757891228003, -122.411398436495) | |||
| 130714 | 130714 | 51533 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 772 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2005 12:00:00 AM | 5 | Permit Number 47835 | 6012012.485780001 | 2110839.92908 | 37.7766407338169 | -122.40194955921801 | (37.7766407338169, -122.401949559218) | ||
| 130044 | 130044 | 221625 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 1060 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007407.136969999 | 2101163.221 | 37.74981264145671 | -122.41719498797501 | (37.7498126414567, -122.417194987975) | |||
| 129721 | 129721 | 187798 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 804 Bryant St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6011724.43838 | 2110559.62838 | 37.775855012333395 | -122.402926285945 | (37.7758550123334, -122.402926285945) | |||
| 129640 | 129640 | 246995 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 45 Clipper St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 6004848.08627 | 2101031.4237599997 | 37.7493064571266 | -122.42603492168502 | (37.7493064571266, -122.426034921685) | |||
| 128820 | 128820 | 111061 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 1851 Bryant St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6009528.24804625 | 2106163.95855958 | 37.7636626423221 | -122.410213085123 | (37.7636626423221, -122.410213085123) | ||||
| 128251 | 128251 | 62905 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 322 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/22/2003 12:00:00 AM | Permit Number 23280 | 6006976.21109695 | 2097296.87142555 | 37.739172261084 | -122.418411039627 | (37.739172261084, -122.418411039627) | ||
| 127962 | 127962 | 104973 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 752 Carolina St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 770765 | 6012376.8 | 2104435.9 | 37.7590770349231 | -122.400239393453 | (37.7590770349231, -122.400239393453) | |||
| 127134 | 127134 | 28319 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 471 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2003 12:00:00 AM | 3 | 3X3 | 6007441.9784165 | 2097282.0813106005 | 37.739157859552996 | -122.416799574637 | (37.739157859553, -122.416799574637) | ||
| 127123 | 127123 | 52160 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 1565 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52359 | 6015412.30091 | 2096564.37197 | 37.737632257829205 | -122.389191461922 | (37.7376322578292, -122.389191461922) |
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");