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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) |
| 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) |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 44098 | 44098 | 95820 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 266 Dore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/29/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767557 | 6009763.87551 | 2108880.1615 | 37.771133916033705 | -122.409589840524 | (37.7711339160337, -122.409589840524) |
| 44148 | 44148 | 244420 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 668 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6003363.0563 | 2109673.0349 | 37.7729502042816 | -122.43178711268 | (37.7729502042816, -122.43178711268) | |||
| 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) | |||
| 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) | |||
| 44843 | 44843 | 187791 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 470 Bryant St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6013974.48447 | 2112705.93616 | 37.7818736702837 | -122.395293129083 | (37.7818736702837, -122.395293129083) | |||
| 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) | |||
| 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) | |||
| 46547 | 46547 | 187813 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 773 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6009053.1077 | 2110262.78133 | 37.774890413007704 | -122.41214615264299 | (37.7748904130077, -122.412146152643) | |||
| 46648 | 46648 | 221610 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 2795 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008166.3608 | 2106770.27621 | 37.7652510179325 | -122.414966360021 | (37.7652510179325, -122.414966360021) | |||
| 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) | |||
| 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) | |||
| 51691 | 51691 | 42196 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 1102 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | 3 | Permit Number 42472 | 6009955.25206 | 2108867.5099299997 | 37.7711098996337 | -122.408926966424 | (37.7711098996337, -122.408926966424) | |
| 51730 | 51730 | 221586 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 59 Balmy St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 6008822.996169999 | 2101800.14465 | 37.75164104320879 | -122.412343880284 | (37.7516410432088, -122.412343880284) | |||
| 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) | |||
| 52454 | 52454 | 221575 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 98 Elgin Park | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6005819.47243 | 2108576.64689 | 37.7700787243885 | -122.423212112556 | (37.7700787243885, -122.423212112556) | |||
| 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) | |||
| 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) | |||
| 53518 | 53518 | 125331 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 133 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6012433.641009999 | 2119151.44833 | 37.7994857099489 | -122.40107679955 | (37.7994857099489, -122.40107679955) | |||
| 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) | |
| 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) | |||
| 55635 | 55635 | 221639 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 262 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004605.60731 | 2103984.0713400003 | 37.7574000299964 | -122.42708369757601 | (37.7574000299964, -122.427083697576) | |||
| 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) | |||
| 56317 | 56317 | 41432 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 1759 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/10/2015 12:00:00 AM | 2 | Permit Number 775670 | 6004639.03495 | 2118408.77646 | 37.7970086191102 | -122.427995972535 | (37.7970086191102, -122.427995972535) | |
| 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) | ||
| 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) | |||
| 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) | |||
| 58346 | 58346 | 221648 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 2010 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6004071.5645 | 2107189.7014200003 | 37.766171710583 | -122.429159195237 | (37.766171710583, -122.429159195237) | |||
| 59932 | 59932 | 83369 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 1055 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/2014 12:00:00 AM | 1 | Permit Number 772823 | 6012226.746040001 | 2103450.91527 | 37.7563641153385 | -122.40068915850401 | (37.7563641153385, -122.400689158504) | |
| 60033 | 60033 | 221607 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 851 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6009134.025909999 | 2104222.54134 | 37.758309848032205 | -122.411439415915 | (37.7583098480322, -122.411439415915) |
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");