Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, PlotSize, PermitNotes
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 868 | 868 | 219533 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 3794 19th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 5 | Width 8ft | 5990481.81422 | 2090701.1507700002 | 37.7201197416248 | -122.474959308131 | (37.7201197416248, -122.474959308131) | |||
| 1902 | 1902 | 242360 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 388 Coleridge St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | Width 3ft | 6006031.24378 | 2097876.97394 | 37.7407118512751 | -122.421719507764 | (37.7407118512751, -122.421719507764) | |||
| 1920 | 1920 | 242361 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 388 Coleridge St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 23 | Width 3ft | 6006038.377780001 | 2097891.2102200002 | 37.740751343191796 | -122.421695851975 | (37.7407513431918, -122.421695851975) | |||
| 3816 | 3816 | 219559 | Undocumented 2 | Ulmus americana :: American Elm 119 | 4 Cortes Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | Width 3ft | 5993189.55754 | 2099585.29183 | 37.7446699411581 | -122.46624493416799 | (37.7446699411581, -122.466244934168) | |||
| 5293 | 5293 | 117054 | Undocumented 2 | Ulmus americana :: American Elm 119 | 3570 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/2016 12:00:00 AM | 3 | 4x4 | Permit Number 778339 | 5997182.58708 | 2116049.71281 | 37.7901065984817 | -122.453626513253 | (37.7901065984817, -122.453626513253) | |
| 9491 | 9491 | 19089 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 245 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 5994528.080019999 | 2087391.0087 | 37.7112645409908 | -122.460733072089 | (37.7112645409908, -122.460733072089) | |||
| 10320 | 10320 | 1171 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 2900 Alemany Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 5996917.80808 | 2087537.65552 | 37.7118044049283 | -122.452484191688 | (37.7118044049283, -122.452484191688) | |||
| 10424 | 10424 | 1169 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 2900 Alemany Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 5996958.76452 | 2087574.1832599998 | 37.71190704815329 | -122.452345269826 | (37.7119070481533, -122.452345269826) | |||
| 10451 | 10451 | 1084 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 2155 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6000026.48644 | 2089733.6034400002 | 37.71801160122929 | -122.441897283559 | (37.7180116012293, -122.441897283559) | |||
| 10527 | 10527 | 25438 | Permitted Site 1 | Ulmus americana :: American Elm 119 | 2445 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/2000 12:00:00 AM | 3 | 3X3 | 6010976.31597 | 2086829.29062 | 37.7106548222305 | -122.403844026987 | (37.7106548222305, -122.403844026987) | ||
| 10682 | 10682 | 1210 | Permitted Site 1 | Ulmus americana :: American Elm 119 | 3149 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5995849.95134 | 2086935.5222599998 | 37.7100898474467 | -122.456131470508 | (37.7100898474467, -122.456131470508) | |||
| 10687 | 10687 | 1080 | Permitted Site 1 | Ulmus americana :: American Elm 119 | 2143 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6000078.80203 | 2089782.4585099998 | 37.718148727148794 | -122.441719956114 | (37.7181487271488, -122.441719956114) | |||
| 10758 | 10758 | 25439 | Permitted Site 1 | Ulmus americana :: American Elm 119 | 2401 Bay Shore Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/1997 12:00:00 AM | 3 | 3x3 | 6011150.97537 | 2087110.40453 | 37.7114364608051 | -122.403260124179 | (37.7114364608051, -122.403260124179) | ||
| 10925 | 10925 | 1176 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 2900 Alemany Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 6x7 | 5996790.08186 | 2087431.5724799999 | 37.711505806616394 | -122.45291799408399 | (37.7115058066164, -122.452917994084) | |||
| 11009 | 11009 | 1207 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 3141 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3x3 | 5995985.58699 | 2086962.1779200002 | 37.710170822386 | -122.455664615342 | (37.710170822386, -122.455664615342) | |||
| 11151 | 11151 | 1023 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 1925 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6000937.4135 | 2090832.4174 | 37.7210805620079 | -122.43882731013599 | (37.7210805620079, -122.438827310136) | |||
| 11316 | 11316 | 1020 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 1871 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 26 | 3x3 | 6001188.68996 | 2091314.6663799998 | 37.72241900141479 | -122.437993248302 | (37.7224190014148, -122.437993248302) | |||
| 11328 | 11328 | 1307 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 4001 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X6 | 5991965.2566 | 2087108.33774 | 37.7103406072022 | -122.46957018821999 | (37.7103406072022, -122.46957018822) | |||
| 11388 | 11388 | 1022 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 1909 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6000975.40411 | 2090904.61398 | 37.721280958817296 | -122.43870115865101 | (37.7212809588173, -122.438701158651) | |||
| 11403 | 11403 | 1077 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 2125 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6000118.830569999 | 2089820.5947599998 | 37.7182557213131 | -122.44158433025 | (37.7182557213131, -122.44158433025) | |||
| 11442 | 11442 | 17221 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 1875X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x3 | 6001098.52222 | 2091140.53503 | 37.7219357480204 | -122.438292468038 | (37.7219357480204, -122.438292468038) | |||
| 11506 | 11506 | 1018 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 1867 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 32 | 3x3 | 6001202.49586 | 2091340.5101 | 37.7224907475345 | -122.43794737479799 | (37.7224907475345, -122.437947374798) | |||
| 11549 | 11549 | 1173 | Permitted Site 1 | Ulmus americana :: American Elm 119 | 2900 Alemany Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 3X3 | 5996863.34156 | 2087489.7045 | 37.7116696217356 | -122.45266898350599 | (37.7116696217356, -122.452668983506) | |||
| 11551 | 11551 | 25433 | Permitted Site 1 | Ulmus americana :: American Elm 119 | 2520 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/1997 12:00:00 AM | 3 | 3X3 | 6010733.72503 | 2086629.56111 | 37.710092849374796 | -122.404668428307 | (37.7100928493748, -122.404668428307) | ||
| 11614 | 11614 | 1310 | Permitted Site 1 | Ulmus americana :: American Elm 119 | 4035 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X6 | 5991848.72186 | 2087031.07112 | 37.7101217158162 | -122.469967330646 | (37.7101217158162, -122.469967330646) | |||
| 11617 | 11617 | 1174 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 2900 Alemany Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 5996843.31726 | 2087475.0183299999 | 37.7116281495005 | -122.452737133232 | (37.7116281495005, -122.452737133232) | |||
| 11638 | 11638 | 1178 | Permitted Site 1 | Ulmus americana :: American Elm 119 | 2900 Alemany Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 5996742.67365 | 2087394.8020099998 | 37.7114021264716 | -122.453079195751 | (37.7114021264716, -122.453079195751) | |||
| 11733 | 11733 | 1082 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 2149 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6000045.941869999 | 2089750.00425 | 37.7180577427488 | -122.44183121126001 | (37.7180577427488, -122.44183121126) | |||
| 11790 | 11790 | 1012 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 1845 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3X3 | 6001257.97709 | 2091441.7763099999 | 37.722771956545294 | -122.437762838379 | (37.7227719565453, -122.437762838379) | |||
| 11998 | 11998 | 1070 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 2101 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 32 | 3X3 | 6000193.5332 | 2089890.50062 | 37.718451922793605 | -122.441331128839 | (37.7184519227936, -122.441331128839) | |||
| 12067 | 12067 | 1192 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 3047 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 1X2 | 5996542.59797 | 2087158.2651799999 | 37.710741182331 | -122.453753635137 | (37.710741182331, -122.453753635137) | |||
| 12082 | 12082 | 1313 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 4055 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | 4X6 | 5991770.79861 | 2086968.57426 | 37.7099456096734 | -122.470232098246 | (37.7099456096734, -122.470232098246) | |||
| 12121 | 12121 | 1864 | Permitted Site 1 | Ulmus americana :: American Elm 119 | 2555 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/1998 12:00:00 AM | 3 | 3X3 | 6010698.44639 | 2086315.70345 | 37.7092290874102 | -122.404768277337 | (37.7092290874102, -122.404768277337) | ||
| 12128 | 12128 | 25430 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 2118 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/01/1997 12:00:00 AM | 6 | 3X3 | 6011929.296130001 | 2087786.5725 | 37.7133365214367 | -122.400617498717 | (37.7133365214367, -122.400617498717) | ||
| 12130 | 12130 | 1286 | Permitted Site 1 | Ulmus americana :: American Elm 119 | 3928 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 6x5 | 5992480.71384 | 2087450.6133299998 | 37.7113101914743 | -122.46781355416799 | (37.7113101914743, -122.467813554168) | |||
| 12144 | 12144 | 1177 | Permitted Site 1 | Ulmus americana :: American Elm 119 | 2900 Alemany Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5996769.26781 | 2087415.3926099997 | 37.7114601876211 | -122.452988765336 | (37.7114601876211, -122.452988765336) | |||
| 12167 | 12167 | 17220 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 1875X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x3 | 6001085.65168 | 2091116.1737099998 | 37.7218681252969 | -122.438335213721 | (37.7218681252969, -122.438335213721) | |||
| 12221 | 12221 | 1017 | Permitted Site 1 | Ulmus americana :: American Elm 119 | 1863 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6001211.31639 | 2091358.64779 | 37.7225410511223 | -122.437918182794 | (37.7225410511223, -122.437918182794) | |||
| 12654 | 12654 | 1209 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 3147 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 23 | 3x3 | 5995880.33209 | 2086940.0526400001 | 37.710104030654605 | -122.456026796619 | (37.7101040306546, -122.456026796619) | |||
| 12747 | 12747 | 1132 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 2565 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 4x4 | 5998605.297809999 | 2088582.84713 | 37.7147708016152 | -122.446726940623 | (37.7147708016152, -122.446726940623) | |||
| 12838 | 12838 | 17219 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 1875X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3x3 | 6001071.69008 | 2091082.82466 | 37.7217757622246 | -122.438381087239 | (37.7217757622246, -122.438381087239) | |||
| 12841 | 12841 | 1829 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 2155 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6011803.61651 | 2087487.56349 | 37.7125084922469 | -122.401030897272 | (37.7125084922469, -122.401030897272) | |||
| 12967 | 12967 | 1067 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 2087X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6000311.61814 | 2090004.87585 | 37.7187726974675 | -122.440931159865 | (37.7187726974675, -122.440931159865) | |||
| 13046 | 13046 | 1233 | Permitted Site 1 | Ulmus americana :: American Elm 119 | 3627 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 5993343.79351 | 2087539.5057 | 37.7116040683488 | -122.46483700771601 | (37.7116040683488, -122.464837007716) | |||
| 13211 | 13211 | 25442 | Permitted Site 1 | Ulmus americana :: American Elm 119 | 2177 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/1997 12:00:00 AM | 3 | 3X3 | 6011778.870709999 | 2087467.6541400002 | 37.712452444692396 | -122.40111502882799 | (37.7124524446924, -122.401115028828) | ||
| 13222 | 13222 | 1814 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 2090 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/01/1997 12:00:00 AM | 6 | 3X3 | 6012058.52275 | 2087947.72362 | 37.713786216628996 | -122.400182154876 | (37.713786216629, -122.400182154876) | ||
| 13379 | 13379 | 84297 | Permitted Site 1 | Ulmus americana :: American Elm 119 | 1369-1369 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52440 | 6008956.5592 | 2109575.0604 | 37.772996675036 | -122.41243151373999 | (37.772996675036, -122.41243151374) | |
| 15168 | 15168 | 82753 | Permitted Site 1 | Ulmus americana :: American Elm 119 | 1369-1369 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52440 | 6008965.8436 | 2109583.1338 | 37.7730193637194 | -122.412399968507 | (37.7730193637194, -122.412399968507) | |
| 16983 | 16983 | 19096 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 265 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 5994373.4122 | 2087391.6665599998 | 37.7112574471572 | -122.46126768668002 | (37.7112574471572, -122.46126768668) | |||
| 17229 | 17229 | 19098 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 277 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5994301.47387 | 2087394.14332 | 37.7112601073303 | -122.461516501212 | (37.7112601073303, -122.461516501212) | |||
| 17630 | 17630 | 259 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 3100 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 2X3 | 5990639.72639 | 2094599.99663 | 37.7308341475716 | -122.47469787612499 | (37.7308341475716, -122.474697876125) | |||
| 17763 | 17763 | 23637 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 116 Virginia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/1998 12:00:00 AM | 10 | 3X3 | 6006587.56141 | 2098481.46204 | 37.74240299581479 | -122.419838851803 | (37.7424029958148, -122.419838851803) | ||
| 17990 | 17990 | 21036 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 2101X Sunset Blvd | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | 5984980.9284488 | 2100900.997098 | 37.7478054765444 | -122.49472533299699 | (37.7478054765444, -122.494725332997) | |||
| 18239 | 18239 | 247 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 3040 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 2 | 5990628.1224 | 2094940.11862 | 37.7317673641661 | -122.47476280805401 | (37.7317673641661, -122.474762808054) | |||
| 18243 | 18243 | 19076 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 212 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3x3 | 5994913.18282 | 2087466.94262 | 37.711495187435006 | -122.459407564904 | (37.711495187435, -122.459407564904) | |||
| 18653 | 18653 | 408 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 3830 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 2x3 | 5990724.80287 | 2090303.6548900001 | 37.7190423951686 | -122.474090399377 | (37.7190423951686, -122.474090399377) | |||
| 18908 | 18908 | 19087 | Permitted Site 1 | Ulmus americana :: American Elm 119 | 237 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 5994597.479119999 | 2087391.16897 | 37.7112689737487 | -122.46049322468299 | (37.7112689737487, -122.460493224683) | |||
| 19323 | 19323 | 407 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 3826 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 2X3 | 5990704.40844 | 2090329.91237 | 37.7191133102994 | -122.47416280918002 | (37.7191133102994, -122.47416280918) | |||
| 19490 | 19490 | 6886 | Permitted Site 1 | Ulmus americana :: American Elm 119 | 289X Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 5x6 | 6006058.26796 | 2110694.64672 | 37.77590771621411 | -122.42253664434799 | (37.7759077162141, -122.422536644348) | |||
| 19542 | 19542 | 29962 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 400X Junipero Serra Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3x3 | 5991375.88875 | 2094170.02081 | 37.729696171533 | -122.472121539675 | (37.729696171533, -122.472121539675) | ||
| 19817 | 19817 | 405 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 3818 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 2X5 | 5990665.105330001 | 2090381.89852 | 37.719253774519 | -122.474302455007 | (37.719253774519, -122.474302455007) | |||
| 20282 | 20282 | 19054 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 147 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 5995468.13357 | 2087379.87793 | 37.7112880204961 | -122.457483227074 | (37.7112880204961, -122.457483227074) | |||
| 20582 | 20582 | 233 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 2980 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X4 | 5990616.421680001 | 2095336.99138 | 37.732856398203104 | -122.474832216845 | (37.7328563982031, -122.474832216845) | |||
| 20607 | 20607 | 390 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 3790X 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 2 | 5990465.39673 | 2090774.00996 | 37.720318843429496 | -122.475021373044 | (37.7203188434295, -122.475021373044) | |||
| 20705 | 20705 | 403 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 3810 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 5990630.76678 | 2090432.7869 | 37.7193915120005 | -122.474424860828 | (37.7193915120005, -122.474424860828) | |||
| 21186 | 21186 | 19079 | Permitted Site 1 | Ulmus americana :: American Elm 119 | 219 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 5994761.182159999 | 2087388.38548 | 37.7112707472265 | -122.459927228278 | (37.7112707472265, -122.459927228278) | |||
| 21272 | 21272 | 410 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 3840 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 2X6 | 5990764.1166900005 | 2090252.16515 | 37.7189032943325 | -122.473950753525 | (37.7189032943325, -122.473950753525) | |||
| 21868 | 21868 | 258 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 3100 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 2X3 | 5990642.03803 | 2094556.09253 | 37.7307137319489 | -122.47468668135201 | (37.7307137319489, -122.474686681352) | |||
| 22016 | 22016 | 404 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 3814 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 2X4 | 5990648.68908 | 2090407.57525 | 37.7193233254004 | -122.47436107192199 | (37.7193233254004, -122.474361071922) | |||
| 22249 | 22249 | 411 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 3850 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/24/2008 12:00:00 AM | 15 | 2 | 5990800.34516 | 2090196.27007 | 37.7187519186484 | -122.473821451697 | (37.7187519186484, -122.473821451697) | ||
| 23738 | 23738 | 215457 | Undocumented 2 | Ulmus americana :: American Elm 119 | 170 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 5ft | 5992608.79004 | 2095578.76173 | 37.7336354943765 | -122.467961730965 | (37.7336354943765, -122.467961730965) | |||
| 24044 | 24044 | 219480 | Undocumented 2 | Ulmus americana :: American Elm 119 | 40 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 8ft | 5992573.35664 | 2096580.23843 | 37.736383252376704 | -122.468157060102 | (37.7363832523767, -122.468157060102) | |||
| 25554 | 25554 | 219562 | Undocumented 2 | Ulmus americana :: American Elm 119 | 474 Magellan Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5993376.84863 | 2099471.9511 | 37.7443695406169 | -122.465589090967 | (37.7443695406169, -122.465589090967) | |||
| 25593 | 25593 | 215447 | Undocumented 2 | Ulmus americana :: American Elm 119 | 110 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 5ft | 5992597.98393 | 2095879.53795 | 37.7344607266837 | -122.468020961215 | (37.7344607266837, -122.468020961215) | |||
| 25628 | 25628 | 242358 | Undocumented 2 | Ulmus americana :: American Elm 119 | 569 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6007471.61723 | 2096250.01155 | 37.7363256903806 | -122.416624004798 | (37.7363256903806, -122.416624004798) | |||
| 25736 | 25736 | 180490 | Undocumented 2 | Ulmus americana :: American Elm 119 | 3019 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 2ft | 5996681.72081 | 2087250.51406 | 37.7110024515725 | -122.453279453211 | (37.7110024515725, -122.453279453211) | |||
| 26125 | 26125 | 219558 | Undocumented 2 | Ulmus americana :: American Elm 119 | 500 Cortes Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | Width 3ft | 5993196.248869999 | 2099494.9896299997 | 37.7444223802847 | -122.466215235845 | (37.7444223802847, -122.466215235845) | |||
| 26312 | 26312 | 219566 | Undocumented 2 | Ulmus americana :: American Elm 119 | 450 Magellan Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | Width 3ft | 5993496.23714 | 2099482.27291 | 37.744404767069895 | -122.465177023412 | (37.7444047670699, -122.465177023412) | |||
| 26508 | 26508 | 215465 | Undocumented 2 | Ulmus americana :: American Elm 119 | 155 Magellan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 5995078.643630001 | 2100761.22837 | 37.748007582495 | -122.45979805143601 | (37.748007582495, -122.459798051436) | |||
| 26712 | 26712 | 219482 | Undocumented 2 | Ulmus americana :: American Elm 119 | 50 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 8ft | 5992576.61335 | 2096511.16113 | 37.736193771533706 | -122.46814077699601 | (37.7361937715337, -122.468140776996) | |||
| 27018 | 27018 | 215471 | Undocumented 2 | Ulmus americana :: American Elm 119 | 50 Sola Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | Width 4ft | 5994846.246 | 2100781.0539 | 37.7480486509235 | -122.46060310387101 | (37.7480486509235, -122.460603103871) | |||
| 27131 | 27131 | 215446 | Undocumented 2 | Ulmus americana :: American Elm 119 | 110 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 5ft | 5992597.86385 | 2095891.15575 | 37.7344926193226 | -122.468022221156 | (37.7344926193226, -122.468022221156) | |||
| 27536 | 27536 | 219486 | Undocumented 2 | Ulmus americana :: American Elm 119 | 60 Santa Ana Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 8ft | 5992579.41042 | 2096404.2389200001 | 37.7359003515064 | -122.468123331026 | (37.7359003515064, -122.468123331026) | |||
| 27812 | 27812 | 219489 | Undocumented 2 | Ulmus americana :: American Elm 119 | 72 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 8ft | 5992583.968309999 | 2096317.0443099998 | 37.735661200197605 | -122.468101231991 | (37.7356612001976, -122.468101231991) | |||
| 29056 | 29056 | 219541 | Undocumented 2 | Ulmus americana :: American Elm 119 | 300 Junipero Serra Blvd | 20 | : 4 | Tree 1 | Private 1 | 11 | Width 0ft | 5991386.1412 | 2094492.53294 | 37.730582302308896 | -122.472109594875 | (37.7305823023089, -122.472109594875) | |||
| 29175 | 29175 | 219547 | Undocumented 2 | Ulmus americana :: American Elm 119 | 500 Junipero Serra Blvd | 49 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991319.77336 | 2093416.99308 | 37.727625298167204 | -122.47226066389999 | (37.7276252981672, -122.4722606639) | |||
| 29496 | 29496 | 215453 | Undocumented 2 | Ulmus americana :: American Elm 119 | 130 Santa Ana Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 5ft | 5992604.15491 | 2095739.66057 | 37.734077014732705 | -122.46798945526501 | (37.7340770147327, -122.467989455265) | |||
| 30550 | 30550 | 219479 | Undocumented 2 | Ulmus americana :: American Elm 119 | 40 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 8ft | 5992572.274130001 | 2096608.73557 | 37.7364614358501 | -122.468162875133 | (37.7364614358501, -122.468162875133) | |||
| 31282 | 31282 | 180489 | Undocumented 2 | Ulmus americana :: American Elm 119 | 434 Huron Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5998732.6593 | 2088560.74965 | 37.7147174016639 | -122.446285139651 | (37.7147174016639, -122.446285139651) | |||
| 31613 | 31613 | 219582 | Undocumented 2 | Ulmus americana :: American Elm 119 | 201 Montalvo Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | Width 3ft | 5993843.784419999 | 2099442.0098200003 | 37.7443142502938 | -122.46397236443998 | (37.7443142502938, -122.46397236444) | |||
| 33490 | 33490 | 219554 | Undocumented 2 | Ulmus americana :: American Elm 119 | 540 Magellan Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 3ft | 5992988.819519999 | 2099440.93268 | 37.7442619835139 | -122.46692854841801 | (37.7442619835139, -122.466928548418) | |||
| 33548 | 33548 | 215452 | Undocumented 2 | Ulmus americana :: American Elm 119 | 130 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 5ft | 5992604.2406 | 2095761.0748 | 37.7341358178054 | -122.467990716115 | (37.7341358178054, -122.467990716115) | |||
| 33633 | 33633 | 180494 | Undocumented 2 | Ulmus americana :: American Elm 119 | 3163 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 5995762.75975 | 2086924.30814 | 37.7100540508169 | -122.45643200953998 | (37.7100540508169, -122.45643200954) | |||
| 35979 | 35979 | 215448 | Undocumented 2 | Ulmus americana :: American Elm 119 | 110 Santa Ana Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 5ft | 5992599.75801 | 2095859.8997900002 | 37.7344069076591 | -122.46801339970501 | (37.7344069076591, -122.468013399705) | |||
| 36374 | 36374 | 219457 | Undocumented 2 | Ulmus americana :: American Elm 119 | 125 Santa Ana Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 5992642.51774 | 2095825.25253 | 37.734314244193 | -122.467863047447 | (37.734314244193, -122.467863047447) | |||
| 36786 | 36786 | 219532 | Undocumented 2 | Ulmus americana :: American Elm 119 | 3794 19th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 3ft | 5990477.6688 | 2090693.78822 | 37.720099285646896 | -122.474973100146 | (37.7200992856469, -122.474973100146) | |||
| 36856 | 36856 | 219485 | Undocumented 2 | Ulmus americana :: American Elm 119 | 60 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 8ft | 5992578.713380001 | 2096435.07341 | 37.7359849750264 | -122.468127983245 | (37.7359849750264, -122.468127983245) | |||
| 37072 | 37072 | 219517 | Undocumented 2 | Ulmus americana :: American Elm 119 | 25 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 8ft | 5992610.84668 | 2096683.2976799998 | 37.7366683923157 | -122.468034936661 | (37.7366683923157, -122.468034936661) | |||
| 37147 | 37147 | 219498 | Undocumented 2 | Ulmus americana :: American Elm 119 | 89 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 8ft | 5992626.79103 | 2096177.7893599998 | 37.7352813139843 | -122.467943052944 | (37.7352813139843, -122.467943052944) | |||
| 37258 | 37258 | 219584 | Undocumented 2 | Ulmus americana :: American Elm 119 | 241 Montalvo Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 3ft | 5993880.71075 | 2099373.6943 | 37.7441288011066 | -122.463839724345 | (37.7441288011066, -122.463839724345) |
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");