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 ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||
| 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) |
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 62037 | 62037 | 187814 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 1020 Le Conte Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 2ft | 6013124.66356 | 2089609.91274 | 37.718409647453 | -122.39661360273199 | (37.718409647453, -122.396613602732) | |||
| 25750 | 25750 | 187815 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 1020 Le Conte Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 2ft | 6013104.719330001 | 2089623.63357 | 37.7184462121049 | -122.39668350344601 | (37.7184462121049, -122.396683503446) | |||
| 70951 | 70951 | 187816 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 1020 Le Conte Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 2ft | 6013083.517469999 | 2089639.6532599998 | 37.7184890189273 | -122.396757912441 | (37.7184890189273, -122.396757912441) | |||
| 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) | |||
| 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) | |||
| 11186 | 11186 | 108449 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 90-98X Prague St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2014 12:00:00 AM | 3 | 3x3 | 6004652.59412 | 2090606.81694 | 37.7206717805504 | -122.42596895909901 | (37.7206717805504, -122.425968959099) | |
| 67335 | 67335 | 187818 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 205 Salinas Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6012618.73899 | 2090601.3502900002 | 37.7211037654109 | -122.398431913204 | (37.7211037654109, -122.398431913204) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 52846 | 52846 | 175093 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 44 Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003678.86336 | 2093990.74117 | 37.7299082046944 | -122.42957605349599 | (37.7299082046944, -122.429576053496) | |||
| 107625 | 107625 | 108820 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 44 Ney St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774656 | 6003753.01786 | 2093991.98953 | 37.7299158308761 | -122.429319781668 | (37.7299158308761, -122.429319781668) | |
| 105240 | 105240 | 92132 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 82 West View Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2009 12:00:00 AM | 3x3 | Permit Number 52485 | 6007205.2 | 2094288.6 | 37.7309250963222 | -122.41740616237699 | (37.7309250963222, -122.417406162377) | ||
| 63535 | 63535 | 40710 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 82 West View Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52485 | 6007191.35202 | 2094307.49546 | 37.7309761999828 | -122.417455375872 | (37.7309761999828, -122.417455375872) | |
| 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) | |||
| 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) | ||||
| 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) | |||
| 95733 | 95733 | 221618 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 629 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6007896.11595 | 2095711.2544900002 | 37.7348702464625 | -122.415118207847 | (37.7348702464625, -122.415118207847) | |||
| 84833 | 84833 | 108920 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 749 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772808 | 6007640.7 | 2095906.5 | 37.7353919909288 | -122.416015094544 | (37.7353919909288, -122.416015094544) |
| 54343 | 54343 | 32512 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 749 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | 3 | Permit Number 37014 | 6007623.73976 | 2095909.7203400002 | 37.7353998796966 | -122.416073960571 | (37.7353998796966, -122.416073960571) | |
| 74572 | 74572 | 221602 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 316 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006655.32871 | 2096032.7581099998 | 37.7356832173971 | -122.419430851854 | (37.7356832173971, -122.419430851854) | |||
| 40592 | 40592 | 221622 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 583 Ogden Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6007865.83541 | 2096101.4446400001 | 37.7359399216775 | -122.41525051070299 | (37.7359399216775, -122.415250510703) | |||
| 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) | |||
| 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) | |||
| 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) | |
| 89519 | 89519 | 115390 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 431 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2016 12:00:00 AM | 3 | Permit Number 776328 | 6008802.0 | 2096760.6 | 37.737802388298995 | -122.412060373619 | (37.737802388299, -122.412060373619) | ||
| 55164 | 55164 | 221603 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 431 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6008783.89037 | 2096761.2657 | 37.7378032000621 | -122.41212303465599 | (37.7378032000621, -122.412123034656) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 19184 | 19184 | 28312 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 828 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2003 12:00:00 AM | 6 | 3X3 | 6008226.9471 | 2097154.6773099997 | 37.7388521566921 | -122.414076488066 | (37.7388521566921, -122.414076488066) | ||
| 21439 | 21439 | 28322 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 904 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2003 12:00:00 AM | 16 | 3X3 | 6008321.70986 | 2097162.43684 | 37.738878784720505 | -122.413749390244 | (37.7388787847205, -122.413749390244) | ||
| 18947 | 18947 | 28316 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 623 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2003 12:00:00 AM | 3 | 3X3 | 6007820.63247 | 2097225.98476 | 37.73902512151621 | -122.41548638578199 | (37.7390251215162, -122.415486385782) | ||
| 18213 | 18213 | 28317 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 605 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2003 12:00:00 AM | 3 | 3X3 | 6007774.74538 | 2097230.6167 | 37.7390352604705 | -122.41564537064501 | (37.7390352604705, -122.415645370645) | ||
| 21618 | 21618 | 28318 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 605 Cortland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2003 12:00:00 AM | 3 | 3X3 | 6007759.23813 | 2097233.8884799997 | 37.739043372340205 | -122.41569921937 | (37.7390433723402, -122.41569921937) | ||
| 88712 | 88712 | 60745 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 422 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/22/2003 12:00:00 AM | Permit Number 20409 | 6007334.40549184 | 2097245.88253216 | 37.7390524145146 | -122.41716894979099 | (37.7390524145146, -122.417168949791) | ||
| 18459 | 18459 | 24557 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 420 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6007316.28855 | 2097251.9421200003 | 37.7390680335725 | -122.417232019338 | (37.7390680335725, -122.417232019338) | |||
| 35249 | 35249 | 221604 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 463 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6007492.2907300005 | 2097272.2195900003 | 37.739133611216005 | -122.416624918515 | (37.739133611216, -122.416624918515) | |||
| 21595 | 21595 | 28320 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 461 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2003 12:00:00 AM | 4 | 3X3 | 6007471.94186 | 2097274.48269 | 37.73913868071671 | -122.416695436156 | (37.7391386807167, -122.416695436156) | ||
| 17223 | 17223 | 24550 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 322 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2003 12:00:00 AM | 12 | 3X3 | 6007090.05329 | 2097287.3868400003 | 37.739152626479004 | -122.418016751571 | (37.739152626479, -122.418016751571) | ||
| 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) | ||
| 9477 | 9477 | 81759 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 461 Cortland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2003 12:00:00 AM | 4 | 3x3 | 6007414.19918083 | 2097287.04503193 | 37.7391699263071 | -122.416895974515 | (37.7391699263071, -122.416895974515) | ||
| 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) | ||
| 36454 | 36454 | 221621 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 337 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007130.842069999 | 2097321.03633 | 37.739247316122295 | -122.417878106717 | (37.7392473161223, -122.417878106717) | |||
| 108033 | 108033 | 61291 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 399 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/22/2003 12:00:00 AM | Permit Number 21183 | 6007155.55605938 | 2097324.01854012 | 37.739256895439794 | -122.417792867933 | (37.7392568954398, -122.417792867933) | ||
| 21057 | 21057 | 28321 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 249 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2003 12:00:00 AM | 3 | 3X3 | 6006883.15104 | 2097391.09073 | 37.7394257272014 | -122.418739480066 | (37.7394257272014, -122.418739480066) | ||
| 17144 | 17144 | 28496 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 249 Cortland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2003 12:00:00 AM | 4 | 3X3 | 6006869.20175 | 2097398.39703 | 37.7394450032725 | -122.41878822871 | (37.7394450032725, -122.41878822871) | ||
| 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) | |||
| 20306 | 20306 | 4842 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 144 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/20/2003 12:00:00 AM | 3 | 4X4 | 6006504.57355 | 2097544.92188 | 37.7398267906861 | -122.420059351163 | (37.7398267906861, -122.420059351163) | ||
| 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) | ||
| 44480 | 44480 | 221620 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 47 Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6005942.12801 | 2097717.69488 | 37.740269481050895 | -122.42201632449499 | (37.7402694810509, -122.422016324495) | |||
| 25119 | 25119 | 221619 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 47 Santa Marina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005932.22047 | 2097722.32528 | 37.7402816363019 | -122.42205090971599 | (37.7402816363019, -122.422050909716) | |||
| 66737 | 66737 | 52400 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 47@ MISSION Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/01/2005 12:00:00 AM | Permit Number 48521 | 6005927.537671201 | 2097730.99268597 | 37.7403051709369 | -122.42206771657101 | (37.7403051709369, -122.422067716571) | ||
| 123106 | 123106 | 52401 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 47@ MISSION Santa Marina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/01/2005 12:00:00 AM | Permit Number 48521 | 6005927.537671201 | 2097730.99268597 | 37.7403051709369 | -122.42206771657101 | (37.7403051709369, -122.422067716571) | ||
| 118738 | 118738 | 50684 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 143 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2004 12:00:00 AM | Permit Number 47256 | 6007969.07490995 | 2097962.19651327 | 37.741054939322204 | -122.41502523375799 | (37.7410549393222, -122.415025233758) | |||
| 29503 | 29503 | 221651 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 26 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004255.76182 | 2098095.16165 | 37.7412106638496 | -122.427873994815 | (37.7412106638496, -122.427873994815) | |||
| 26330 | 26330 | 221652 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 303 30th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004504.7671 | 2098377.5922 | 37.742000237123605 | -122.42703313408701 | (37.7420002371236, -122.427033134087) | |||
| 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) | |||
| 117309 | 117309 | 109236 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 284 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/04/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773603 | 6004130.6 | 2098710.6 | 37.7428934350545 | -122.428350613465 | (37.7428934350545, -122.428350613465) |
| 52378 | 52378 | 221595 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 206 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6004515.099330001 | 2098718.51485 | 37.7429369170054 | -122.42702168481199 | (37.7429369170054, -122.427021684812) | |||
| 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) | |||
| 107156 | 107156 | 95403 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 385 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767277 | 6003420.0 | 2099198.0 | 37.744191487367104 | -122.43084244532301 | (37.7441914873671, -122.430842445323) | |
| 119305 | 119305 | 221591 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 1705 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009346.65041 | 2099513.2038 | 37.745390981613 | -122.410371547427 | (37.745390981613, -122.410371547427) | |||
| 111935 | 111935 | 95399 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 1485 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767273 | 6003966.0 | 2099628.0 | 37.74540308852521 | -122.42898514766 | (37.7454030885252, -122.42898514766) |
| 25964 | 25964 | 221597 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 1485 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6003972.054219999 | 2099640.99596 | 37.7454391151181 | -122.428965139531 | (37.7454391151181, -122.428965139531) | |||
| 119731 | 119731 | 102080 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 27 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/2012 12:00:00 AM | 3x3 | Permit Number 769730 | 6007460.8 | 2099922.6 | 37.7464091944673 | -122.416921530448 | (37.7464091944673, -122.416921530448) | |
| 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) |
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");