Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, PlantDate, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5949 | 5949 | 19787 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 100 STAIRWAY19 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 50ST | ||||||||
| 13931 | 13931 | 19779 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 100 STAIRWAY19 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 50ST | ||||||||
| 16388 | 16388 | 115471 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 10X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | |||||||||
| 83779 | 83779 | 1867 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2555 Bay Shore Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6010748.9210869 | 2086419.1045134 | 37.7095158271004 | -122.404601102054 | (37.7095158271004, -122.404601102054) | |||
| 30170 | 30170 | 180579 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 2500 Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 6010790.74354 | 2086511.28723 | 37.7097712796836 | -122.404463040238 | (37.7097712796836, -122.404463040238) | |||
| 88504 | 88504 | 19105 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3155X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 32 | 3x3 | 5995592.56281 | 2086919.9321700002 | 37.7100322629968 | -122.457019923286 | (37.7100322629968, -122.457019923286) | |||
| 102679 | 102679 | 19106 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3155X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 5995592.56281 | 2086919.9321700002 | 37.7100322629968 | -122.457019923286 | (37.7100322629968, -122.457019923286) | |||
| 140037 | 140037 | 19107 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3155X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 5995592.56281 | 2086919.9321700002 | 37.7100322629968 | -122.457019923286 | (37.7100322629968, -122.457019923286) | |||
| 106977 | 106977 | 11873 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 1499X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 30 | 3 | 5991566.5284818 | 2087248.8358641004 | 37.7107033285334 | -122.470958490818 | (37.7107033285334, -122.470958490818) | |||
| 125399 | 125399 | 11871 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 1499X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 24 | 3 | 5991566.5284818 | 2087248.8358641004 | 37.7107033285334 | -122.470958490818 | (37.7107033285334, -122.470958490818) | |||
| 141240 | 141240 | 11874 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 1499X Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 30 | 3 | 5991566.5284818 | 2087248.8358641004 | 37.7107033285334 | -122.470958490818 | (37.7107033285334, -122.470958490818) | |||
| 69286 | 69286 | 58907 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 354 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/1980 12:00:00 AM | 29 | Permit Number 18182 | 6012260.63611 | 2086890.34143 | 37.7108941228427 | -122.39940938545601 | (37.7108941228427, -122.399409385456) | ||
| 84863 | 84863 | 1182 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3003 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 5996737.10872 | 2087300.2249 | 37.7111421206036 | -122.45309160658 | (37.7111421206036, -122.45309160658) | |||
| 116279 | 116279 | 1181 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3003 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3x3 | 5996737.10872 | 2087300.2249 | 37.7111421206036 | -122.45309160658 | (37.7111421206036, -122.45309160658) | |||
| 20889 | 20889 | 19100 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 281 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3x3 | 5994272.63935 | 2087395.39368 | 37.7112618807995 | -122.46161625041 | (37.7112618807995, -122.46161625041) | |||
| 21385 | 21385 | 19093 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 257 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 5994426.29409 | 2087392.8188099999 | 37.711263654258204 | -122.461084998394 | (37.7112636542582, -122.461084998394) | |||
| 74903 | 74903 | 215591 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 233 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5994635.3694400005 | 2087388.76073 | 37.711264541001206 | -122.460362092762 | (37.7112645410012, -122.460362092762) | |||
| 17794 | 17794 | 19085 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 231 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 5994662.28634 | 2087388.8423799998 | 37.711266313550794 | -122.46026906776501 | (37.7112663135508, -122.460269067765) | |||
| 17204 | 17204 | 19082 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 227 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 5994691.4790199995 | 2087389.19966 | 37.7112689737437 | -122.460168197108 | (37.7112689737437, -122.460168197108) | |||
| 19881 | 19881 | 19078 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 215 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 3X3 | 5994825.043959999 | 2087387.37086 | 37.711271633946296 | -122.459706433929 | (37.7112716339463, -122.459706433929) | |||
| 21339 | 21339 | 19071 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 203 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 5994967.06362 | 2087386.6571400003 | 37.7112778401642 | -122.459215529972 | (37.7112778401642, -122.459215529972) | |||
| 21264 | 21264 | 19063 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 175 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 5995252.88797 | 2087382.67456 | 37.7112833332178 | -122.45822736752501 | (37.7112833332178, -122.458227367525) | |||
| 165193 | 165193 | 215592 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 177 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5995226.8577 | 2087383.90223 | 37.7112852083174 | -122.458317422904 | (37.7112852083174, -122.458317422904) | |||
| 17410 | 17410 | 19053 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 141 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 5995501.70307 | 2087378.49279 | 37.711286145417496 | -122.457367103015 | (37.7112861454175, -122.457367103015) | |||
| 18280 | 18280 | 19057 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 155 Sagamore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 5995437.65535 | 2087381.5397299998 | 37.7112908326789 | -122.45758868696801 | (37.7112908326789, -122.457588686968) | |||
| 60841 | 60841 | 215593 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 103 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 5995757.42889 | 2087376.9000799998 | 37.7112964570463 | -122.45648314049801 | (37.7112964570463, -122.456483140498) | |||
| 18615 | 18615 | 19086 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 235 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 5994700.784889599 | 2087405.1340273 | 37.71131326103529 | -122.460137187577 | (37.7113132610353, -122.460137187577) | |||
| 143670 | 143670 | 19065 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 179 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 5995218.7218404 | 2087397.9242615001 | 37.711323242006294 | -122.45834655658399 | (37.7113232420063, -122.458346556584) | |||
| 94286 | 94286 | 19045 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 111 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 5995778.761022701 | 2087391.1107423 | 37.7113367008986 | -122.45641043862801 | (37.7113367008986, -122.456410438628) | |||
| 128855 | 128855 | 26823 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 260 Sagamore St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 5994408.88806 | 2087459.5005112998 | 37.711445744833796 | -122.461149987895 | (37.7114457448338, -122.461149987895) | |||
| 94881 | 94881 | 19090 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 260 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X4 | 5994507.8215972 | 2087458.0224558997 | 37.7114473793836 | -122.460807943318 | (37.7114473793836, -122.460807943318) | |||
| 144014 | 144014 | 1218 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 3575X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 5993629.70146 | 2087487.1964900002 | 37.711476919919 | -122.463845046869 | (37.711476919919, -122.463845046869) | |||
| 11320 | 11320 | 1260 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3827 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 5992804.99866 | 2087505.2482200002 | 37.7114789258702 | -122.46669672210301 | (37.7114789258702, -122.466696722103) | |||
| 23188 | 23188 | 25337 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 260 Sagamore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2000 12:00:00 AM | 15 | 3X3 | 5994336.66394 | 2087473.55865 | 37.71148018854171 | -122.46140062985799 | (37.7114801885417, -122.461400629858) | ||
| 18392 | 18392 | 19097 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 276 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 2X2 | 5994245.51556 | 2087475.81103 | 37.711481126537 | -122.46171582334298 | (37.711481126537, -122.461715823343) | |||
| 44608 | 44608 | 215594 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 246 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5994531.01193 | 2087471.53389 | 37.7114858129011 | -122.46072877062299 | (37.7114858129011, -122.460728770623) | |||
| 20873 | 20873 | 19088 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 238 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3X3 | 5994602.312969999 | 2087471.0641 | 37.7114886250695 | -122.460482303322 | (37.7114886250695, -122.460482303322) | |||
| 19211 | 19211 | 19069 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 200 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5994992.35128 | 2087465.62621 | 37.711496124512 | -122.45913384457701 | (37.711496124512, -122.459133844577) | |||
| 18427 | 18427 | 19072 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 204 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3x3 | 5994955.69063 | 2087466.73543 | 37.7114970625193 | -122.459260632792 | (37.7114970625193, -122.459260632792) | |||
| 10978 | 10978 | 1259 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3821 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 5992830.40302 | 2087513.47902 | 37.7115029917542 | -122.46660951663601 | (37.7115029917542, -122.466609516636) | |||
| 104642 | 104642 | 1257 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3801 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 1X3 | 5992919.7951 | 2087516.7094700001 | 37.7115170200575 | -122.46630079139099 | (37.7115170200575, -122.466300791391) | |||
| 11486 | 11486 | 1258 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3815 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5992861.70969 | 2087523.33873 | 37.7115318707666 | -122.466502029665 | (37.7115318707666, -122.466502029665) | |||
| 142032 | 142032 | 1248 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3731 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3x3 | 5993002.942009999 | 2087547.889 | 37.711607428767294 | -122.466015680425 | (37.7116074287673, -122.466015680425) | |||
| 12595 | 12595 | 1250 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3743 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X6 | 5993011.32335 | 2087550.57925 | 37.7116152990749 | -122.46598690787701 | (37.7116152990749, -122.465986907877) | |||
| 89901 | 89901 | 11849 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1401X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3 | 5991539.129622 | 2088082.4465586997 | 37.712990637147605 | -122.471113878415 | (37.7129906371476, -122.471113878415) | |||
| 837 | 837 | 175374 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 80x Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | Width 3ft | 5991412.70367 | 2088734.1730099998 | 37.714772806192606 | -122.47159830692699 | (37.7147728061926, -122.471598306927) | |||
| 846 | 846 | 175047 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 80X Junipero Serra Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | Width 3ft | 5991389.20246 | 2088805.53688 | 37.714967394312204 | -122.47168473357 | (37.7149673943122, -122.47168473357) | |||
| 160 | 160 | 175377 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 80X Junipero Serra Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5991371.46907 | 2088876.77956 | 37.715161983326794 | -122.471751215951 | (37.7151619833268, -122.471751215951) | |||
| 798 | 798 | 175378 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 80X Junipero Serra Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | Width 3ft | 5991360.88178 | 2088922.0136900002 | 37.715285572641 | -122.471791104494 | (37.715285572641, -122.471791104494) | |||
| 94747 | 94747 | 114034 | Significant Tree 6 | Ulmus pumila :: Siberian Elm 53 | 198x FONT BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3x3 | 5990818.0 | 2089012.0 | 37.7155012267577 | -122.473674083302 | (37.7155012267577, -122.473674083302) | |||
| 806 | 806 | 177713 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 80X Junipero Serra Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | Width 3ft | 5991322.37032 | 2089056.90035 | 37.715653710133296 | -122.471934040933 | (37.7156537101333, -122.471934040933) | |||
| 789 | 789 | 175382 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 80x Junipero Serra Blvd | 19 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 2 | Width 3ft | 5991305.518069999 | 2089124.29272 | 37.7158377779634 | -122.471997198511 | (37.7158377779634, -122.471997198511) | |||
| 124841 | 124841 | 11792 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1200X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 2 | 5991118.2706518 | 2089586.5464946998 | 37.7170961765154 | -122.472678089933 | (37.7170961765154, -122.472678089933) | |||
| 1048 | 1048 | 251423 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2162 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 5999946.0 | 2089791.0 | 37.718164612456604 | -122.44217960719999 | (37.7181646124566, -122.4421796072) | ||||
| 11990 | 11990 | 1085 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 2156 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 5999963.70084 | 2089791.4898700002 | 37.7181669663093 | -122.442118458302 | (37.7181669663093, -122.442118458302) | |||
| 34555 | 34555 | 180593 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 2136 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 4ft | 6000017.35738 | 2089840.46995 | 37.718304512220605 | -122.44193650477699 | (37.7183045122206, -122.441936504777) | |||
| 123626 | 123626 | 1081 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2144 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 5999999.92726 | 2089842.39347 | 37.718308800511 | -122.441996891163 | (37.718308800511, -122.441996891163) | |||
| 114875 | 114875 | 415 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3862 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 2X6 | 5990878.963880001 | 2090116.60552 | 37.718537732694394 | -122.473543893183 | (37.7185377326944, -122.473543893183) | |||
| 87555 | 87555 | 19303 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 2087X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6000281.49897 | 2089976.15715 | 37.7186921269443 | -122.44103321029101 | (37.7186921269443, -122.441033210291) | |||
| 9045 | 9045 | 1066 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2075X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6000333.402969999 | 2090026.65578 | 37.71883374095071 | -122.440857420165 | (37.7188337409507, -122.440857420165) | |||
| 101162 | 101162 | 87591 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3840 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 5990782.62319 | 2090250.3116099997 | 37.7188992769151 | -122.473886649335 | (37.7188992769151, -122.473886649335) | ||||
| 129303 | 129303 | 1061 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2061X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6000441.22371 | 2090128.4604599997 | 37.719119413653495 | -122.440492025318 | (37.7191194136535, -122.440492025318) | |||
| 112240 | 112240 | 1060 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2059X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6000457.1646300005 | 2090146.24433 | 37.7191691518296 | -122.440438198589 | (37.7191691518296, -122.440438198589) | |||
| 114194 | 114194 | 1058 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2055X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6000480.4143 | 2090166.82631 | 37.719226989106005 | -122.440359308841 | (37.719226989106, -122.440359308841) | |||
| 122792 | 122792 | 1056 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2049X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6000499.53685 | 2090188.3269099998 | 37.7192871136702 | -122.440294750677 | (37.7192871136702, -122.440294750677) | |||
| 125285 | 125285 | 1054 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2045X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6000521.13381 | 2090206.39855 | 37.7193379639287 | -122.440221393554 | (37.7193379639287, -122.440221393554) | |||
| 138406 | 138406 | 1052 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2039X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6000548.43841 | 2090229.36669 | 37.719402583767 | -122.44012865812 | (37.719402583767, -122.44012865812) | |||
| 39237 | 39237 | 215650 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 101 | : 4 | Tree 1 | Private 1 | 14 | Width 0ft | 5991145.973069999 | 2090449.2056 | 37.7194664300225 | -122.472645197812 | (37.7194664300225, -122.472645197812) | |||
| 140006 | 140006 | 1051 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 2035X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6000572.81835 | 2090254.9074400002 | 37.7194741008396 | -122.44004621634599 | (37.7194741008396, -122.440046216346) | |||
| 56269 | 56269 | 1048 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2029X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3X3 | 6000595.57615 | 2090275.75201 | 37.719532630863 | -122.439969044998 | (37.719532630863, -122.439969044998) | ||||
| 39462 | 39462 | 215649 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 93 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991151.37081 | 2090546.73366 | 37.7197345305043 | -122.472633646933 | (37.7197345305043, -122.472633646933) | |||
| 184159 | 184159 | 215648 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 92 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991148.46508 | 2090549.7895400003 | 37.7197427529995 | -122.472643913597 | (37.7197427529995, -122.472643913597) | |||
| 185313 | 185313 | 215647 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 90 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5991141.92136 | 2090550.26747 | 37.719743686490396 | -122.472666567521 | (37.7197436864904, -122.472666567521) | |||
| 64611 | 64611 | 215646 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 89 | : 4 | Tree 1 | Private 1 | 21 | Width 0ft | 5991144.95252 | 2090553.1611900001 | 37.71975180739361 | -122.47265630084999 | (37.7197518073936, -122.47265630085) | |||
| 36497 | 36497 | 215645 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 88 | : 4 | Tree 1 | Private 1 | 15 | Width 0ft | 5991139.08964 | 2090556.8339200001 | 37.7197615524271 | -122.47267683419099 | (37.7197615524271, -122.472676834191) | |||
| 38177 | 38177 | 215644 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 87 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991153.983659999 | 2090558.88602 | 37.7197680491356 | -122.472625500878 | (37.7197680491356, -122.472625500878) | |||
| 54836 | 54836 | 215643 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 86 | : 4 | Tree 1 | Private 1 | 7 | Width 0ft | 5991150.43358 | 2090559.55238 | 37.7197696732999 | -122.47263782068701 | (37.7197696732999, -122.472637820687) | |||
| 188100 | 188100 | 215642 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 85 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991146.327190001 | 2090562.0053700001 | 37.7197761709066 | -122.47265219363999 | (37.7197761709066, -122.47265219364) | |||
| 64737 | 64737 | 215641 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 84 | : 4 | Tree 1 | Private 1 | 24 | Width 0ft | 5991139.80827 | 2090562.73433 | 37.719777795098 | -122.472674780143 | (37.719777795098, -122.472674780143) | |||
| 133735 | 133735 | 215638 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 81 | : 4 | Tree 1 | Private 1 | 17 | Width 0ft | 5991161.28352 | 2090567.01377 | 37.7197907884826 | -122.47260086035801 | (37.7197907884826, -122.472600860358) | |||
| 70971 | 70971 | 215639 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 82 | : 4 | Tree 1 | Private 1 | 8 | Width 0ft | 5991150.62056 | 2090568.4216099998 | 37.719794036843794 | -122.472637820681 | (37.7197940368438, -122.472637820681) | |||
| 187609 | 187609 | 215640 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 83 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5991139.98278 | 2090571.01197 | 37.71980053355961 | -122.472674780143 | (37.7198005335596, -122.472674780143) | |||
| 155297 | 155297 | 215637 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 80 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991151.99496 | 2090577.2658 | 37.7198184003677 | -122.47263371439699 | (37.7198184003677, -122.472633714397) | |||
| 89332 | 89332 | 391 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3790X 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 34 | 2 | 5990530.65648 | 2090591.3498 | 37.7198210858115 | -122.474782468587 | (37.7198210858115, -122.474782468587) | |||
| 176243 | 176243 | 215636 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 79 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991147.9135 | 2090580.90098 | 37.7198281454204 | -122.472648087333 | (37.7198281454204, -122.472648087333) | |||
| 155249 | 155249 | 215634 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 77 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991150.9321800005 | 2090583.20344 | 37.7198346421452 | -122.47263782070101 | (37.7198346421452, -122.472637820701) | |||
| 41079 | 41079 | 215635 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 78 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991140.257019999 | 2090584.0200099999 | 37.7198362663069 | -122.47267478013 | (37.7198362663069, -122.47267478013) | |||
| 58824 | 58824 | 215633 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 76 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991148.619390001 | 2090586.20981 | 37.719842763020104 | -122.472646034205 | (37.7198427630201, -122.472646034205) | |||
| 75277 | 75277 | 215631 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 74 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991145.11917 | 2090589.24121 | 37.719850883885606 | -122.472658354026 | (37.7198508838856, -122.472658354026) | |||
| 129995 | 129995 | 215632 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 75 | : 4 | Tree 1 | Private 1 | 7 | Width 0ft | 5991152.25672 | 2090589.68226 | 37.7198525080596 | -122.472633714394 | (37.7198525080596, -122.472633714394) | |||
| 157916 | 157916 | 215630 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 73 | : 4 | Tree 1 | Private 1 | 9 | Width 0ft | 5991138.04395 | 2090591.7564599998 | 37.7198573805858 | -122.47268299363998 | (37.7198573805858, -122.47268299364) | |||
| 54677 | 54677 | 215629 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 72 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5991145.86247 | 2090596.3241400002 | 37.7198703748925 | -122.47265630087 | (37.7198703748925, -122.47265630087) | |||
| 43417 | 43417 | 215627 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 69 | : 4 | Tree 1 | Private 1 | 13 | Width 0ft | 5991161.91923 | 2090597.1686900002 | 37.7198736232612 | -122.472600860338 | (37.7198736232612, -122.472600860338) | |||
| 175424 | 175424 | 215628 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 71 | : 4 | Tree 1 | Private 1 | 11 | Width 0ft | 5991139.39343 | 2090599.4181400002 | 37.7198784957874 | -122.47267888733299 | (37.7198784957874, -122.472678887333) | |||
| 72528 | 72528 | 392 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3790X 19th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | 2 | 5990516.36157 | 2090620.3648599999 | 37.7198999256056 | -122.47483399727899 | (37.7198999256056, -122.474833997279) | |||
| 160644 | 160644 | 215625 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 67 | : 4 | Tree 1 | Private 1 | 7 | Width 0ft | 5991149.7740400005 | 2090612.8046400002 | 37.719915852707295 | -122.472643981029 | (37.7199158527073, -122.472643981029) | |||
| 57358 | 57358 | 215626 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 68 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991156.30566 | 2090612.66695 | 37.7199158527268 | -122.47262139367099 | (37.7199158527268, -122.472621393671) | |||
| 23924 | 23924 | 215624 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 66 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991139.11135 | 2090614.21248 | 37.7199191010706 | -122.47268094048201 | (37.7199191010706, -122.472680940482) | |||
| 38027 | 38027 | 215623 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 65 | : 4 | Tree 1 | Private 1 | 7 | Width 0ft | 5991145.2526 | 2090614.88415 | 37.7199213008035 | -122.472659761464 | (37.7199213008035, -122.472659761464) | |||
| 136462 | 136462 | 215621 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 63 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991148.3674800005 | 2090618.2199 | 37.7199306402575 | -122.47264923758999 | (37.7199306402575, -122.47264923759) |
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");