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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 56866 | 56866 | 182405 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 1543 34th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5985575.3942 | 2104706.1132 | 37.7582880604292 | -122.492949973167 | (37.7582880604292, -122.492949973167) | |||
| 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) | |||
| 41082 | 41082 | 120843 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 295 19th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 2ft | 5989915.80244 | 2113424.7782 | 37.782480005786205 | -122.47857668806002 | (37.7824800057862, -122.47857668806) | |||
| 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) | |||
| 38145 | 38145 | 120849 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 459 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5989969.644669999 | 2112229.77717 | 37.779201991488705 | -122.47830301452 | (37.7792019914887, -122.47830301452) | |||
| 56292 | 56292 | 122090 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 743 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5990658.64233 | 2110307.2925 | 37.7739633495154 | -122.475779083636 | (37.7739633495154, -122.475779083636) | |||
| 63687 | 63687 | 203296 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 1969 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5990940.45703 | 2102022.49787 | 37.751231851693 | -122.474199607622 | (37.751231851693, -122.474199607622) | |||
| 112534 | 112534 | 108521 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 1969 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Fire Dept 12 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773668 | 5990944.21476 | 2102008.8699 | 37.751194650539205 | -122.47418561882401 | (37.7511946505392, -122.474185618824) |
| 56429 | 56429 | 56179 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 771 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/1973 12:00:00 AM | 2 | Permit Number 12287 | 5990973.49009 | 2110147.22925 | 37.7735421082814 | -122.474678298875 | (37.7735421082814, -122.474678298875) | ||
| 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) | |||
| 44438 | 44438 | 203305 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 2667 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991737.11692 | 2097295.21425 | 37.7382980636965 | -122.471100336118 | (37.7382980636965, -122.471100336118) | |||
| 123710 | 123710 | 203306 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 2667 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991739.00321 | 2097275.58019 | 37.7382442626515 | -122.471092384324 | (37.7382442626515, -122.471092384324) | |||
| 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) | |||
| 98535 | 98535 | 51303 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 3995 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/07/2004 12:00:00 AM | Permit Number 47671 | 5992078.32104931 | 2087181.87180329 | 37.7105490480114 | -122.46918476594401 | (37.7105490480114, -122.469184765944) | |||
| 106456 | 106456 | 110029 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 1531 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/19/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775205 | 5992093.6 | 2105006.6 | 37.759492151604796 | -122.47042925308399 | (37.7594921516048, -122.470429253084) |
| 27288 | 27288 | 203304 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 1531 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5992105.89675 | 2105003.70672 | 37.759484918408496 | -122.470386514529 | (37.7594849184085, -122.470386514529) | |||
| 11052 | 11052 | 1284 | Significant Tree 6 | Acer buergeranum :: Trident Maple 120 | 3995X Alemany Blvd | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12 | 3X10 | Permit Number 778829 | 5992111.480830001 | 2087185.8440900003 | 37.7105618710011 | -122.469070448459 | (37.7105618710011, -122.469070448459) | ||
| 11470 | 11470 | 1268 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 3995X Alemany Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 3X3 | 5992221.4773699995 | 2087241.7214099998 | 37.7107216517569 | -122.468694342994 | (37.7107216517569, -122.468694342994) | ||
| 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) | |||
| 45145 | 45145 | 203298 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 1405 11th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992698.7106099995 | 2105851.9736 | 37.7618482944917 | -122.46839800376301 | (37.7618482944917, -122.468398003763) | |||
| 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) | |||
| 114607 | 114607 | 112776 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 366 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2015 12:00:00 AM | Permit Number 774291 | 5992832.6 | 2113015.6 | 37.781525427838396 | -122.46845614796699 | (37.7815254278384, -122.468456147967) | ||
| 11698 | 11698 | 1252 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 3802X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X5 | 5992874.60396 | 2087610.17758 | 37.7117710535519 | -122.46646377159401 | (37.7117710535519, -122.466463771594) | |||
| 48101 | 48101 | 203299 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 301 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992897.6032300005 | 2094839.0024700002 | 37.7316209734226 | -122.4669094675 | (37.7316209734226, -122.4669094675) | |||
| 41171 | 41171 | 1251 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 3802X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 3X5 | 5992934.9168 | 2087623.17149 | 37.7118102118326 | -122.466256259321 | (37.7118102118326, -122.466256259321) | ||
| 13039 | 13039 | 1238 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 3702X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2006 12:00:00 AM | 3 | 3X5 | 5993066.57599 | 2087635.7513400002 | 37.7118523486814 | -122.46580212597 | (37.7118523486814, -122.46580212597) | ||
| 12461 | 12461 | 1247 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 3725 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/2008 12:00:00 AM | 3 | 3X3 | 5993078.34594 | 2087556.76692 | 37.7116361552477 | -122.46575571108299 | (37.7116361552477, -122.465755711083) | ||
| 12850 | 12850 | 1245 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 3715 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/2008 12:00:00 AM | 3 | 3X3 | 5993121.79741 | 2087558.19139 | 37.711642572828495 | -122.465605635801 | (37.7116425728285, -122.465605635801) | ||
| 12877 | 12877 | 1237 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 3702X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/1992 12:00:00 AM | 25 | 3X5 | 5993171.03745 | 2087640.69975 | 37.7118719610995 | -122.465441440287 | (37.7118719610995, -122.465441440287) | ||
| 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) |
| 45580 | 45580 | 175089 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 3602 Alemany Blvd | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5993467.05206 | 2087598.8302799999 | 37.711774065400895 | -122.46441530123501 | (37.7117740654009, -122.464415301235) | |||
| 19836 | 19836 | 1214 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 3435 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/08/2005 12:00:00 AM | 3 | 3X3 | 5993805.15459 | 2087379.06858 | 37.7111901355994 | -122.463230798779 | (37.7111901355994, -122.463230798779) | ||
| 104647 | 104647 | 107423 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 251 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 2 | 3x3 | 5993968.46376 | 2113916.3836 | 37.7840642796834 | -122.46459206338498 | (37.7840642796834, -122.464592063385) | |||
| 68226 | 68226 | 113035 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 251 06th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 1 | 3x3 | 5993975.80165 | 2113783.25834 | 37.7836991768592 | -122.464557007516 | (37.7836991768592, -122.464557007516) | |||
| 33875 | 33875 | 123291 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 506 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5994083.888830001 | 2112023.10777 | 37.778872508647204 | -122.464055253517 | (37.7788725086472, -122.464055253517) | |||
| 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) | |||
| 67121 | 67121 | 203302 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 974 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5995940.56903 | 2090377.0190299999 | 37.71954459370029 | -122.456066927048 | (37.7195445937003, -122.456066927048) | |||
| 23337 | 23337 | 99375 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 3921 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/08/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768860 | 5996022.78804 | 2115189.92908 | 37.7876793085021 | -122.45757706543002 | (37.7876793085021, -122.45757706543) | |
| 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) | |||
| 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) | |||
| 68031 | 68031 | 175084 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 3143 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5996169.48396 | 2087012.03723 | 37.710318276130295 | -122.455032634746 | (37.7103182761303, -122.455032634746) | |||
| 11008 | 11008 | 1185 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 3018 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2006 12:00:00 AM | 3 | 3x3 | 5996600.75581 | 2087299.21077 | 37.7111315204793 | -122.453562799904 | (37.7111315204793, -122.453562799904) | ||
| 91454 | 91454 | 116214 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 3801 SACRAMENTO ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778748 | 5996623.0 | 2114922.0 | 37.7869781063352 | -122.45548108802099 | (37.7869781063352, -122.455481088021) | |
| 105985 | 105985 | 116213 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 3801 SACRAMENTO ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778748 | 5996623.0 | 2114922.0 | 37.7869781063352 | -122.45548108802099 | (37.7869781063352, -122.455481088021) | |
| 119992 | 119992 | 116212 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 3801 SACRAMENTO ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778748 | 5996623.0 | 2114922.0 | 37.7869781063352 | -122.45548108802099 | (37.7869781063352, -122.455481088021) | |
| 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) | |||
| 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) | |||
| 31377 | 31377 | 140826 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 510 Euclid Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5996775.194 | 2113867.2875 | 37.7840908785082 | -122.45487829896601 | (37.7840908785082, -122.454878298966) | |||
| 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) | |||
| 69597 | 69597 | 140825 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 500 Euclid Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5996795.1609 | 2113868.6412 | 37.784095740758 | -122.454809318923 | (37.784095740758, -122.454809318923) | |||
| 76278 | 76278 | 141263 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 57 PARKER AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5996811.9128 | 2114193.0185 | 37.7849873555455 | -122.45477480773899 | (37.7849873555455, -122.454774807739) | |||
| 12928 | 12928 | 1172 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 2900 Alemany Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/06/2006 12:00:00 AM | 3 | 3X3 | 5996885.41862 | 2087511.8997099998 | 37.7117318296412 | -122.45259428042 | (37.7117318296412, -122.45259428042) | ||
| 10901 | 10901 | 1162 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 2849X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/06/2006 12:00:00 AM | 3 | 3X3 | 5997216.55451 | 2087707.3234400002 | 37.7122873858304 | -122.451463876663 | (37.7122873858304, -122.451463876663) | ||
| 2743 | 2743 | 1163 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 2849X Alemany Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/06/2006 12:00:00 AM | 3 | 3X3 | 5997232.586019999 | 2087721.56451 | 37.7123274065466 | -122.451409493752 | (37.7123274065466, -122.451409493752) | ||
| 81611 | 81611 | 81834 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 298X Shrader St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/2007 12:00:00 AM | 6x6 | Permit Number 49798 | 5997424.88906207 | 2109543.24349754 | 37.772255430160605 | -122.452318476797 | (37.7722554301606, -122.452318476797) | ||
| 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) | |||
| 2745 | 2745 | 1164 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 2849X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/06/2006 12:00:00 AM | 3 | 3X3 | 5997509.5346800005 | 2087964.66518 | 37.7130107600005 | -122.450469794845 | (37.7130107600005, -122.450469794845) | ||
| 12897 | 12897 | 1152 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 2685 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 5998075.461730001 | 2088293.5285 | 37.713946117887104 | -122.448537441353 | (37.7139461178871, -122.448537441353) | ||
| 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) | |||
| 57251 | 57251 | 175092 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 318 Foote Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5998127.55186 | 2088899.90602 | 37.7156140698133 | -122.44840104028098 | (37.7156140698133, -122.448401040281) | |||
| 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) | |||
| 53496 | 53496 | 221601 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 418 Belvedere St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5998530.76454 | 2106730.59265 | 37.7645958968999 | -122.448290597257 | (37.7645958968999, -122.448290597257) | |||
| 104131 | 104131 | 115162 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 615 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | Permit Number 775225 | 5998622.9 | 2105584.3 | 37.7614537320174 | -122.44788939310499 | (37.7614537320174, -122.447889393105) | |||
| 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) | |||
| 63690 | 63690 | 175085 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 2555 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5998719.5083099995 | 2088640.5978599999 | 37.714935895553396 | -122.44633633538 | (37.7149358955534, -122.44633633538) | |||
| 2759 | 2759 | 253203 | Planning Code 138.1 required 4 | Acer buergeranum :: Trident Maple 120 | 349 Mangels Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5999103.0 | 2095207.0 | 37.732987611392005 | -122.44548271607799 | (37.732987611392, -122.445482716078) | ||||
| 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) |
| 30150 | 30150 | 57960 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 340 Hanover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/1977 12:00:00 AM | 1 | Permit Number 772773 | 5999451.90276 | 2086477.9387 | 37.709039522936294 | -122.443649609852 | (37.7090395229363, -122.443649609852) | ||
| 71142 | 71142 | 203308 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 254 Mangels Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5999724.87507 | 2095247.89 | 37.7331353678889 | -122.443335674514 | (37.7331353678889, -122.443335674514) | |||
| 90118 | 90118 | 122683 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 425 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000126.0 | 2110519.0 | 37.7750889825958 | -122.443045211806 | (37.7750889825958, -122.443045211806) | ||||
| 30959 | 30959 | 140762 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 48 TERRA VISTA AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6000287.3355 | 2112871.989 | 37.7815588874389 | -122.4426561036 | (37.7815588874389, -122.4426561036) | |||
| 32185 | 32185 | 221611 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 80 Fountain St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 6000341.50521 | 2101241.8769099996 | 37.749628579901206 | -122.441633827157 | (37.7496285799012, -122.441633827157) | |||
| 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) | ||
| 33273 | 33273 | 175090 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 137 Otsego Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6000668.43551 | 2092436.91423 | 37.7254708381835 | -122.43987206783702 | (37.7254708381835, -122.439872067837) | |||
| 73369 | 73369 | 221615 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 4272 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6000685.78925 | 2102891.27532 | 37.754177039641796 | -122.440561570886 | (37.7541770396418, -122.440561570886) | |||
| 3717 | 3717 | 240414 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 4529 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6000856.95656 | 2105193.67931 | 37.760508625697 | -122.440134724763 | (37.760508625697, -122.440134724763) | |||
| 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) | |
| 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) | |||
| 27631 | 27631 | 221613 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 803 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6001111.65366 | 2102583.28849 | 37.7533556231836 | -122.439066758249 | (37.7533556231836, -122.439066758249) | |||
| 31035 | 31035 | 221614 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 801 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6001153.3381 | 2102585.1825099997 | 37.7533631954543 | -122.43892274080099 | (37.7533631954543, -122.438922740801) | |||
| 108765 | 108765 | 65169 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 650 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/17/1989 12:00:00 AM | 6x18 | Permit Number 49965 | 6001191.63682568 | 2102599.3727913 | 37.7534043375019 | -122.438791312875 | (37.7534043375019, -122.438791312875) | ||
| 104922 | 104922 | 122841 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 20x Seymour St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001693.0 | 2112151.0 | 37.77965926371179 | -122.437741533251 | (37.7796592637118, -122.437741533251) | ||||
| 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) | |||
| 124707 | 124707 | 92974 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 1739 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/04/2010 12:00:00 AM | Permit Number 53130 | 6001710.0 | 2112178.0 | 37.7797343655013 | -122.437684657223 | (37.7797343655013, -122.437684657223) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 61083 | 61083 | 221616 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 162 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001900.7177800005 | 2096497.17148 | 37.7366894445647 | -122.43590257274799 | (37.7366894445647, -122.435902572748) | |||
| 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) | |||
| 116349 | 116349 | 87984 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 809 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 51021 | 6002006.0 | 2111228.0 | 37.777142730335 | -122.43659264798 | (37.777142730335, -122.43659264798) | ||
| 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) | |||
| 27841 | 27841 | 221612 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 443 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6002290.76795 | 2100888.56087 | 37.748769324440204 | -122.43486795308901 | (37.7487693244402, -122.434867953089) | |||
| 12709 | 12709 | 106100 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 420 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6002342.776000001 | 2090999.30829 | 37.721618662355795 | -122.433981312389 | (37.7216186623558, -122.433981312389) | |||
| 41475 | 41475 | 221629 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 1013 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002523.57066 | 2102515.3470799997 | 37.7532493089089 | -122.434179203726 | (37.7532493089089, -122.434179203726) | |||
| 64673 | 64673 | 221637 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 4055 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002643.00734 | 2104710.17858 | 37.759282569163 | -122.43392303991502 | (37.759282569163, -122.433923039915) | |||
| 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) | |||
| 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) | |||
| 49743 | 49743 | 221647 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 2186 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6002993.82098 | 2107132.2152 | 37.765952798501296 | -122.43288278961701 | (37.7659527985013, -122.432882789617) | |||
| 23957 | 23957 | 125326 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 2460 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6003032.79755 | 2115883.1633599997 | 37.7899829318237 | -122.433373367088 | (37.7899829318237, -122.433373367088) | |||
| 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) |
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");