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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 899 | 899 | 23949 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 2400X Sacramento St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/15/2014 12:00:00 AM | 3 | 4x4 | Permit Number 773408 | 6003202.444680001 | 2115904.93175 | 37.7900523252984 | -122.43278795880501 | (37.7900523252984, -122.432787958805) | |
| 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) | ||
| 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) | ||
| 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) | ||||
| 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) | |||
| 6203 | 6203 | 23950 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 2400X Sacramento St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/15/2014 12:00:00 AM | 3 | 4x4 | Permit Number 773408 | 6003173.29907 | 2115903.30394 | 37.7900462027047 | -122.432888683778 | (37.7900462027047, -122.432888683778) | |
| 7359 | 7359 | 23947 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 2400X Sacramento St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/15/2014 12:00:00 AM | 3 | 4x4 | Permit Number 773408 | 6003237.41295 | 2115911.3949 | 37.7900720546314 | -122.432667433453 | (37.7900720546314, -122.432667433453) | |
| 7562 | 7562 | 23953 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 2400X Sacramento St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2001 12:00:00 AM | 3 | 4x4 | 6003112.92633 | 2115895.6310799997 | 37.790021710572795 | -122.433097019816 | (37.7900217105728, -122.433097019816) | ||
| 7630 | 7630 | 23948 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 2400X Sacramento St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/15/2014 12:00:00 AM | 3 | 4x4 | Permit Number 773408 | 6003227.15919 | 2115908.88128 | 37.7900645713585 | -122.432702730963 | (37.7900645713585, -122.432702730963) | |
| 8191 | 8191 | 23946 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 2400X Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/15/2014 12:00:00 AM | 3 | 4x4 | Permit Number 773408 | 6003257.60965 | 2115913.45554 | 37.7900788579916 | -122.43259770183201 | (37.7900788579916, -122.432597701832) | |
| 8361 | 8361 | 23951 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 2400X Sacramento St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/15/2014 12:00:00 AM | 3 | 4x4 | Permit Number 773408 | 6003144.33072 | 2115898.20328 | 37.790030554519205 | -122.432988547211 | (37.7900305545192, -122.432988547211) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 13390 | 13390 | 19368 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 352-360 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 54655 | 6011200.48284 | 2111246.22274 | 37.7777109702346 | -122.40478714063299 | (37.7777109702346, -122.404787140633) | |
| 13411 | 13411 | 86613 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 1060 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6010229.125990001 | 2109123.9963599998 | 37.7718294894697 | -122.40799771313601 | (37.7718294894697, -122.407997713136) | ||
| 13424 | 13424 | 86619 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 1090 Bryant St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6010092.09688 | 2109000.58526 | 37.7714829581888 | -122.408463001672 | (37.7714829581888, -122.408463001672) | ||
| 13530 | 13530 | 39587 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 1028 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773106 | 6011879.4313 | 2103580.86378 | 37.756701548162205 | -122.401899435531 | (37.7567015481622, -122.401899435531) |
| 13655 | 13655 | 86615 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 1090 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/03/2011 12:00:00 AM | 3 | 3x3 | 6010138.02723 | 2109041.45906 | 37.7715977602665 | -122.40830700887 | (37.7715977602665, -122.40830700887) | ||
| 13769 | 13769 | 85678 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 750 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/23/2007 12:00:00 AM | 3 | 3x3 | 6012220.56503 | 2111028.15837 | 37.777169179061104 | -122.40124297808501 | (37.7771691790611, -122.401242978085) | ||
| 13830 | 13830 | 85692 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 598 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/23/2007 12:00:00 AM | 3 | 3x3 | 6013183.76112 | 2111957.2599 | 37.7797739691436 | -122.397976147576 | (37.7797739691436, -122.397976147576) | ||
| 14109 | 14109 | 85683 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 660 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/23/2007 12:00:00 AM | 3 | 3x3 | 6012787.21783 | 2111572.91246 | 37.7786965462587 | -122.39932098479099 | (37.7786965462587, -122.399320984791) | ||
| 14118 | 14118 | 85688 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 510 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/23/2007 12:00:00 AM | 3 | 3x3 | 6013697.52765 | 2112441.63878 | 37.7811325632525 | -122.396232748844 | (37.7811325632525, -122.396232748844) | ||
| 14169 | 14169 | 85694 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 474 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/23/2007 12:00:00 AM | 3 | 3x3 | 6013953.88261 | 2112679.45572 | 37.7817998152473 | -122.39536254686001 | (37.7817998152473, -122.39536254686) | ||
| 14208 | 14208 | 85682 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 660 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/23/2007 12:00:00 AM | 3 | 3x3 | 6012794.814730001 | 2111581.55636 | 37.778720703824604 | -122.39929531095 | (37.7787207038246, -122.39929531095) | ||
| 14700 | 14700 | 86617 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 1090 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6010113.47615 | 2109019.50593 | 37.771536107226794 | -122.408390384123 | (37.7715361072268, -122.408390384123) | ||
| 14735 | 14735 | 30648 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 15 Lafayette St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 10 | 3x3 | Permit Number 34588 | 6007479.3068699995 | 2109694.71788 | 37.7732422146752 | -122.417550006149 | (37.7732422146752, -122.417550006149) |
| 14743 | 14743 | 85681 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 660 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/23/2007 12:00:00 AM | 3 | 3x3 | 6012801.64822 | 2111587.40032 | 37.7787371308451 | -122.39927208143801 | (37.7787371308451, -122.399272081438) | ||
| 14982 | 14982 | 86620 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 1000x Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6010457.56671 | 2109345.4237900004 | 37.772450265390795 | -122.407223128867 | (37.7724502653908, -122.407223128867) | ||
| 15336 | 15336 | 86631 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 760 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6012051.41665 | 2110873.5779 | 37.7767352984212 | -122.40181725096701 | (37.7767352984212, -122.401817250967) | ||
| 15462 | 15462 | 85684 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 660 Bryant St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/23/2007 12:00:00 AM | 3 | 3x3 | 6012659.22444 | 2111448.1134 | 37.7783467423358 | -122.399755001218 | (37.7783467423358, -122.399755001218) | ||
| 15905 | 15905 | 86630 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 760 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6012073.82351 | 2110895.00183 | 37.77679537403711 | -122.40174124476101 | (37.7767953740371, -122.401741244761) | ||
| 15929 | 15929 | 85680 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 600 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/23/2007 12:00:00 AM | 3 | 3x3 | 6012945.936430001 | 2111731.57619 | 37.7791410451674 | -122.398783049916 | (37.7791410451674, -122.398783049916) | ||
| 15968 | 15968 | 86616 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 1090 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6010124.54627 | 2109028.5712099997 | 37.771561618305796 | -122.408352731315 | (37.7715616183058, -122.408352731315) | ||
| 16091 | 16091 | 85690 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 570 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/05/2011 12:00:00 AM | 3 | 3x3 | 6013313.890430001 | 2112083.07139 | 37.780126665260795 | -122.39753479629 | (37.7801266652608, -122.39753479629) | ||
| 16175 | 16175 | 86618 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 1090 Bryant St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6010101.61266 | 2109009.68223 | 37.7715084692605 | -122.40843072772101 | (37.7715084692605, -122.408430727721) | ||
| 16293 | 16293 | 85677 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 750 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/23/2007 12:00:00 AM | 3 | 3x3 | 6012237.71739 | 2111051.30981 | 37.7772337045105 | -122.401185269499 | (37.7772337045105, -122.401185269499) | ||
| 16321 | 16321 | 40819 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 1040 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2004 12:00:00 AM | 8 | 3x3 | Permit Number 47715 | 6010221.45597 | 2111748.6305299997 | 37.7790356940769 | -122.40820938834999 | (37.7790356940769, -122.40820938835) | |
| 16351 | 16351 | 108976 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 542 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774122 | 6010644.88245 | 2105682.8661 | 37.7624041987112 | -122.406317076271 | (37.7624041987112, -122.406317076271) |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 23501 | 23501 | 187800 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 2 Heron St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6009988.42633 | 2110014.66553 | 37.7742615809293 | -122.40889316451499 | (37.7742615809293, -122.408893164515) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 26621 | 26621 | 221649 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 2012 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6004056.31613 | 2107188.28381 | 37.76616695496121 | -122.429211835283 | (37.7661669549612, -122.429211835283) | |||
| 27135 | 27135 | 187803 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 1022 Minna St | 7 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6007519.609019999 | 2109677.8407099997 | 37.7731981416251 | -122.417409398951 | (37.7731981416251, -122.417409398951) | |||
| 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) | |||
| 27584 | 27584 | 221634 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 3647 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6003905.15604 | 2103026.4808 | 37.7547310787034 | -122.4294378484 | (37.7547310787034, -122.4294378484) | |||
| 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) | |||
| 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) | |||
| 29083 | 29083 | 42197 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 1102 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | 2 | Permit Number 42472 | 6009958.1347199995 | 2108871.8243 | 37.771121907368496 | -122.408917299608 | (37.7711219073685, -122.408917299608) | |
| 29130 | 29130 | 41280 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 850 Battery St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2013 12:00:00 AM | 2 | Permit Number 770203 | 6012418.570230001 | 2119124.3074 | 37.7994103467575 | -122.401127041994 | (37.7994103467575, -122.401127041994) | ||
| 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) | |||
| 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) | ||
| 30842 | 30842 | 221642 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 841 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004373.46148 | 2103997.0216 | 37.757422458193105 | -122.427887472929 | (37.7574224581931, -122.427887472929) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 34896 | 34896 | 36034 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 1660X BRYANT ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | 4 | Permit Number 39178 | 6009346.0 | 2106886.0 | 37.7656349852358 | -122.410894426294 | (37.7656349852358, -122.410894426294) | |
| 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) | |||
| 35257 | 35257 | 187812 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 501 Beale St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6015686.38843 | 2114228.8053599996 | 37.7861501840288 | -122.389477068617 | (37.7861501840288, -122.389477068617) | |||
| 35559 | 35559 | 221645 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 841 Church St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004369.11216 | 2104095.58562 | 37.7576928456553 | -122.42790953781099 | (37.7576928456553, -122.427909537811) | |||
| 35619 | 35619 | 221580 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 440 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6005817.51141 | 2107873.4848700003 | 37.7681478988217 | -122.42316890642701 | (37.7681478988217, -122.423168906427) | |||
| 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) | |||
| 37830 | 37830 | 221585 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 1801 Bryant St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6009531.49923 | 2106200.8664599997 | 37.7637641652204 | -122.410204446196 | (37.7637641652204, -122.410204446196) | |||
| 37897 | 37897 | 221643 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 841 Church St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004370.46442 | 2104050.63168 | 37.757569489259 | -122.42790165793899 | (37.757569489259, -122.427901657939) | |||
| 37925 | 37925 | 187805 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 1022 Minna St | 9 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6007514.255059999 | 2109673.0649599996 | 37.7731847273119 | -122.41742758053499 | (37.7731847273119, -122.417427580535) | |||
| 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) | |||
| 38768 | 38768 | 221592 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 1555 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010533.99072 | 2100457.08761 | 37.7480491689492 | -122.40633238993799 | (37.7480491689492, -122.406332389938) | |||
| 39556 | 39556 | 49560 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 49 Pixley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2015 12:00:00 AM | 1 | Permit Number 777029 | 6003156.442369999 | 2119085.5556099997 | 37.798782890681 | -122.433174477517 | (37.798782890681, -122.433174477517) | ||
| 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) | |||
| 40973 | 40973 | 125330 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 1335 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007763.34926 | 2117482.29154 | 37.794640982941104 | -122.41711938017201 | (37.7946409829411, -122.417119380172) |
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");