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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 96261 | 96261 | 64409 | Permitted Site 1 | Ulmus americana :: American Elm 119 | 215 Virginia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/1988 12:00:00 AM | 8 | 3x3 | Permit Number 25255 | 6006726.83577731 | 2098456.71661789 | 37.7423428955731 | -122.419355526894 | (37.7423428955731, -122.419355526894) | |
| 128602 | 128602 | 1312 | Permitted Site 1 | Ulmus americana :: American Elm 119 | 4043 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x5 | 5991834.02635 | 2087022.6898 | 37.71009785321571 | -122.47001751090201 | (37.7100978532157, -122.470017510902) | |||
| 141711 | 141711 | 11726 | Permitted Site 1 | Ulmus americana :: American Elm 119 | 899X Junipero Serra Blvd | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 06/15/1995 12:00:00 AM | 18 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960661998 | (37.7216528879997, -122.47220960662) | ||
| 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) | |
| 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) | |||
| 38616 | 38616 | 215454 | Undocumented 2 | Ulmus americana :: American Elm 119 | 160 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 5ft | 5992606.05096 | 2095656.4975700001 | 37.733848779404795 | -122.46797685305401 | (37.7338487794048, -122.467976853054) | |||
| 39016 | 39016 | 215462 | Undocumented 2 | Ulmus americana :: American Elm 119 | 196 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 5ft | 5992612.6930599995 | 2095452.3609 | 37.733288654633704 | -122.467939046451 | (37.7332886546337, -122.467939046451) | |||
| 39484 | 39484 | 219525 | Undocumented 2 | Ulmus americana :: American Elm 119 | 251 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5994459.68695 | 2087392.44193 | 37.7112645410103 | -122.46096955782 | (37.7112645410103, -122.46096955782) | |||
| 39919 | 39919 | 219569 | Undocumented 2 | Ulmus americana :: American Elm 119 | 400 Magellan Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 3ft | 5993620.64115 | 2099492.8462799997 | 37.7444409719637 | -122.464747631304 | (37.7444409719637, -122.464747631304) | |||
| 40025 | 40025 | 242357 | Undocumented 2 | Ulmus americana :: American Elm 119 | 619 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6007454.61895 | 2096052.8946099998 | 37.7357834945126 | -122.416668815323 | (37.7357834945126, -122.416668815323) | |||
| 40178 | 40178 | 219552 | Undocumented 2 | Ulmus americana :: American Elm 119 | 560 Magellan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 5992845.00519 | 2099427.10194 | 37.744215706187 | -122.46742481772499 | (37.744215706187, -122.467424817725) | |||
| 40205 | 40205 | 219512 | Undocumented 2 | Ulmus americana :: American Elm 119 | 41 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 8ft | 5992615.5560800005 | 2096571.3112400002 | 37.736361177626705 | -122.46801051107599 | (37.7363611776267, -122.468010511076) | |||
| 40219 | 40219 | 219565 | Undocumented 2 | Ulmus americana :: American Elm 119 | 456 Magellan Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 3ft | 5993467.92544 | 2099480.37304 | 37.744397917845504 | -122.465274780618 | (37.7443979178455, -122.465274780618) | |||
| 40330 | 40330 | 219586 | Undocumented 2 | Ulmus americana :: American Elm 119 | 45 Pacheco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 31 | Width 4ft | 5994631.61405 | 2099807.81481 | 37.745364030718605 | -122.46127474814199 | (37.7453640307186, -122.461274748142) | |||
| 40492 | 40492 | 215456 | Undocumented 2 | Ulmus americana :: American Elm 119 | 170 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 5ft | 5992607.47204 | 2095602.74615 | 37.73370127349371 | -122.46796803159599 | (37.7337012734937, -122.467968031596) | |||
| 40840 | 40840 | 219464 | Undocumented 2 | Ulmus americana :: American Elm 119 | 151 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 5992648.371590001 | 2095634.82133 | 37.733791705711 | -122.467828963142 | (37.733791705711, -122.467828963142) | |||
| 41474 | 41474 | 180491 | Undocumented 2 | Ulmus americana :: American Elm 119 | 3019 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 2ft | 5996704.34387 | 2087265.5919599999 | 37.711045148673705 | -122.45320235073099 | (37.7110451486737, -122.453202350731) | |||
| 41637 | 41637 | 219544 | Undocumented 2 | Ulmus americana :: American Elm 119 | 300 Junipero Serra Blvd | 28 | : 4 | Tree 1 | Private 1 | 19 | Width 0ft | 5991391.011519999 | 2094448.55765 | 37.7304618390337 | -122.472089553508 | (37.7304618390337, -122.472089553508) | |||
| 41848 | 41848 | 215469 | Undocumented 2 | Ulmus americana :: American Elm 119 | 160 Magellan Ave | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 4ft | 5995028.58035 | 2100711.10786 | 37.7478670849985 | -122.45996753678499 | (37.7478670849985, -122.459967536785) | |||
| 42070 | 42070 | 219456 | Undocumented 2 | Ulmus americana :: American Elm 119 | 115 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 5992639.24928 | 2095904.23823 | 37.734530930444 | -122.467880090494 | (37.734530930444, -122.467880090494) | |||
| 42634 | 42634 | 219504 | Undocumented 2 | Ulmus americana :: American Elm 119 | 65 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 8ft | 5992624.10653 | 2096354.05467 | 37.735765139345105 | -122.467965151081 | (37.7357651393451, -122.467965151081) | |||
| 42920 | 42920 | 219543 | Undocumented 2 | Ulmus americana :: American Elm 119 | 300 Junipero Serra Blvd | 25 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991389.009880001 | 2094463.6090099998 | 37.7305030504606 | -122.472097570066 | (37.7305030504606, -122.472097570066) | |||
| 43894 | 43894 | 219521 | Undocumented 2 | Ulmus americana :: American Elm 119 | 15 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 8ft | 5992605.36477 | 2096774.53089 | 37.7369185792154 | -122.468060524183 | (37.7369185792154, -122.468060524183) | |||
| 43988 | 43988 | 219460 | Undocumented 2 | Ulmus americana :: American Elm 119 | 131 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 5992644.33525 | 2095767.44219 | 37.7341556163962 | -122.46785256046999 | (37.7341556163962, -122.46785256047) | |||
| 44494 | 44494 | 219471 | Undocumented 2 | Ulmus americana :: American Elm 119 | 2 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 8ft | 5992545.99069 | 2096862.54215 | 37.7371568069404 | -122.46827220569901 | (37.7371568069404, -122.468272205699) | |||
| 45324 | 45324 | 219531 | Undocumented 2 | Ulmus americana :: American Elm 119 | 3796 19th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5990484.55998 | 2090665.82939 | 37.7200229169975 | -122.474947240127 | (37.7200229169975, -122.474947240127) | |||
| 46437 | 46437 | 180486 | Undocumented 2 | Ulmus americana :: American Elm 119 | 2091 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6000288.07511 | 2089979.94333 | 37.7187028974975 | -122.441010750768 | (37.7187028974975, -122.441010750768) | |||
| 48177 | 48177 | 219579 | Undocumented 2 | Ulmus americana :: American Elm 119 | 396 Magellan Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5993828.6385699995 | 2099567.99676 | 37.7446593057809 | -122.464033878966 | (37.7446593057809, -122.464033878966) | |||
| 48365 | 48365 | 219528 | Undocumented 2 | Ulmus americana :: American Elm 119 | 3800 19th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 3ft | 5990523.17081 | 2090581.0778299998 | 37.7197924477439 | -122.474807594299 | (37.7197924477439, -122.474807594299) | |||
| 49824 | 49824 | 117053 | Undocumented 2 | Ulmus americana :: American Elm 119 | 3570 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 4x4 | 5997209.5044 | 2116053.97345 | 37.790119840100495 | -122.45353368975401 | (37.7901198401005, -122.453533689754) | |||
| 50381 | 50381 | 180508 | Undocumented 2 | Ulmus americana :: American Elm 119 | 2500 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010763.65816 | 2086463.1644700002 | 37.709637630535205 | -122.404553267433 | (37.7096376305352, -122.404553267433) | |||
| 52295 | 52295 | 219509 | Undocumented 2 | Ulmus americana :: American Elm 119 | 45 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 8ft | 5992617.13851 | 2096502.6038900001 | 37.736172615865 | -122.46800004386999 | (37.736172615865, -122.46800004387) | |||
| 52896 | 52896 | 180493 | Undocumented 2 | Ulmus americana :: American Elm 119 | 3163 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5995731.65538 | 2086919.46942 | 37.7100389790737 | -122.456539161954 | (37.7100389790737, -122.456539161954) | |||
| 53535 | 53535 | 219477 | Undocumented 2 | Ulmus americana :: American Elm 119 | 30 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 8ft | 5992571.34305 | 2096676.4237 | 37.736647236684206 | -122.46817101669399 | (37.7366472366842, -122.468171016694) | |||
| 54548 | 54548 | 219587 | Undocumented 2 | Ulmus americana :: American Elm 119 | 100 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 5992597.45757 | 2095923.8327099998 | 37.734582318619296 | -122.468026001902 | (37.7345823186193, -122.468026001902) | |||
| 54815 | 54815 | 180511 | Undocumented 2 | Ulmus americana :: American Elm 119 | 3597 Alemany Blvd | 1 | : 4 | Tree 1 | Private 1 | 18 | Width 3ft | 5993538.56271 | 2087481.65959 | 37.711456464415996 | -122.464159641976 | (37.711456464416, -122.464159641976) | |||
| 54896 | 54896 | 248413 | Undocumented 2 | Ulmus americana :: American Elm 119 | 715 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5997910.6761 | 2108085.9087 | 37.76828178007379 | -122.450533022459 | (37.7682817800738, -122.450533022459) | |||
| 55349 | 55349 | 215455 | Undocumented 2 | Ulmus americana :: American Elm 119 | 160 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 5ft | 5992606.291130001 | 2095633.2616299998 | 37.733784993186205 | -122.467974333173 | (37.7337849931862, -122.467974333173) | |||
| 55412 | 55412 | 242353 | Undocumented 2 | Ulmus americana :: American Elm 119 | 472 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 4ft | 5998570.9732 | 2106433.24481 | 37.7637817532369 | -122.448130115038 | (37.7637817532369, -122.448130115038) | |||
| 55857 | 55857 | 219530 | Undocumented 2 | Ulmus americana :: American Elm 119 | 3798 19th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 3ft | 5990495.45016 | 2090638.2830400001 | 37.719947912658895 | -122.474907587234 | (37.7199479126589, -122.474907587234) | |||
| 57107 | 57107 | 215460 | Undocumented 2 | Ulmus americana :: American Elm 119 | 180 Santa Ana Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 5ft | 5992612.98876 | 2095518.41795 | 37.7334700478853 | -122.467942827217 | (37.7334700478853, -122.467942827217) | |||
| 57335 | 57335 | 180503 | Undocumented 2 | Ulmus americana :: American Elm 119 | 1985 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 2ft | 6000822.0474 | 2090606.84585 | 37.7204546293715 | -122.43920993661301 | (37.7204546293715, -122.439209936613) | |||
| 57563 | 57563 | 219473 | Undocumented 2 | Ulmus americana :: American Elm 119 | 2 Santa Ana Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 8ft | 5992552.54486 | 2096838.2851099998 | 37.7370905817533 | -122.468247781032 | (37.7370905817533, -122.468247781032) | |||
| 58021 | 58021 | 219497 | Undocumented 2 | Ulmus americana :: American Elm 119 | 89 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 8ft | 5992628.805240001 | 2096145.5872400003 | 37.7351930113401 | -122.46793374764 | (37.7351930113401, -122.46793374764) | |||
| 58121 | 58121 | 219523 | Undocumented 2 | Ulmus americana :: American Elm 119 | 851 Junipero Serra Blvd | 19 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 3ft | 5991345.30581 | 2091866.1011599998 | 37.7233684121017 | -122.472059404642 | (37.7233684121017, -122.472059404642) | |||
| 59648 | 59648 | 180498 | Undocumented 2 | Ulmus americana :: American Elm 119 | 2059 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6000514.10075 | 2090205.66552 | 37.7193355507714 | -122.44024565161301 | (37.7193355507714, -122.440245651613) | |||
| 59802 | 59802 | 215449 | Undocumented 2 | Ulmus americana :: American Elm 119 | 120 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 5ft | 5992601.94776 | 2095825.37047 | 37.7343122252356 | -122.46800331831301 | (37.7343122252356, -122.468003318313) | |||
| 60812 | 60812 | 180507 | Undocumented 2 | Ulmus americana :: American Elm 119 | 1971 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 2ft | 6000896.20852 | 2090750.67644 | 37.7208537754604 | -122.438963888373 | (37.7208537754604, -122.438963888373) | |||
| 61099 | 61099 | 219580 | Undocumented 2 | Ulmus americana :: American Elm 119 | 320 Magellan Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 3ft | 5994238.61211 | 2099950.79183 | 37.7457339839424 | -122.462644044196 | (37.7457339839424, -122.462644044196) | |||
| 61415 | 61415 | 215472 | Undocumented 2 | Ulmus americana :: American Elm 119 | 1 Sola Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 4ft | 5994924.36549 | 2100698.72724 | 37.7478270966613 | -122.46032700748002 | (37.7478270966613, -122.46032700748) | |||
| 61980 | 61980 | 219526 | Undocumented 2 | Ulmus americana :: American Elm 119 | 121 Sagamore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5995598.71297 | 2087377.82947 | 37.711289895587896 | -122.45703176651699 | (37.7112898955879, -122.457031766517) |
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");