Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18253 | 18253 | 4301 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 4374 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6001502.87912 | 2100307.76951 | 37.7471298441855 | -122.43755087718 | (37.7471298441855, -122.43755087718) | |||
| 18482 | 18482 | 50084 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 163 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46816 | 5992385.51984068 | 2098065.73695017 | 37.7404512063716 | -122.468914554715 | (37.7404512063716, -122.468914554715) | ||
| 18523 | 18523 | 18424 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 974 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6010455.61637 | 2103584.4912099997 | 37.7566319433297 | -122.40682378579099 | (37.7566319433297, -122.406823785791) | |||
| 18542 | 18542 | 31283 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2574 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2016 12:00:00 AM | 3 | Permit Number 778680 | 5991125.83447 | 2097900.24985 | 37.7399239615173 | -122.47325794369199 | (37.7399239615173, -122.473257943692) | |
| 18701 | 18701 | 22848 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 120 Turquoise Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 1X1 | 5999801.2823 | 2099039.75864 | 37.743551298748 | -122.44334377921601 | (37.743551298748, -122.443343779216) | |||
| 18838 | 18838 | 43257 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 400 Burrows St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | Permit Number 43041 | 6010158.39254276 | 2093206.15154528 | 37.728118638728105 | -122.407120168437 | (37.7281186387281, -122.407120168437) | ||
| 18880 | 18880 | 25589 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1380X Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 6009160.7320011 | 2097455.9675674997 | 37.7397318376167 | -122.410869155933 | (37.7397318376167, -122.410869155933) | |||
| 18906 | 18906 | 5095 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 2611 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/04/2004 12:00:00 AM | 6 | 3X3 | 6002301.7516 | 2096545.88638 | 37.7368459778655 | -122.43451950896099 | (37.7368459778655, -122.434519508961) | ||
| 18974 | 18974 | 10193 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1170 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 2x2 | 6005736.259869999 | 2102154.58599 | 37.752440559408896 | -122.42304341594699 | (37.7524405594089, -122.423043415947) | |||
| 19048 | 19048 | 10142 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 915 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2x2 | 6005723.61297 | 2103645.6305400003 | 37.7565339082426 | -122.42319312877599 | (37.7565339082426, -122.423193128776) | |||
| 19102 | 19102 | 48673 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 420 Collingwood St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/2002 12:00:00 AM | Permit Number 45956 | 6002102.91710872 | 2103385.70582138 | 37.7556152218159 | -122.43569617174101 | (37.7556152218159, -122.435696171741) | |||
| 19264 | 19264 | 10115 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 827 Guerrero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6005698.17392 | 2104144.57278 | 37.75790245155879 | -122.42331657330901 | (37.7579024515588, -122.423316573309) | |||
| 19389 | 19389 | 9994 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 102 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6005389.27087 | 2108406.08421 | 37.7695861126487 | -122.424688040346 | (37.7695861126487, -122.424688040346) | |||
| 19412 | 19412 | 68594 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1776 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32496 | 5991255.24615708 | 2103348.30667764 | 37.754890406441895 | -122.47320772508499 | (37.7548904064419, -122.473207725085) | ||
| 19495 | 19495 | 40538 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 384 San Benito Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/1999 12:00:00 AM | Permit Number 41587 | 5992631.08642927 | 2094049.19194754 | 37.7294369636011 | -122.46777343904101 | (37.7294369636011, -122.467773439041) | |||
| 19522 | 19522 | 17054 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1267 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000942.0344 | 2109636.8826 | 37.77271340359871 | -122.44015910616301 | (37.7727134035987, -122.440159106163) | |||
| 19524 | 19524 | 8290 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 50 Garcia Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 8 | 5995181.45452 | 2099378.2291200003 | 37.7442161243666 | -122.45934239824899 | (37.7442161243666, -122.459342398249) | |||
| 19736 | 19736 | 121676 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 65 Sotelo Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993867.0 | 2101351.0 | 37.7495571916966 | -122.464030639739 | (37.7495571916966, -122.464030639739) | ||||
| 19737 | 19737 | 43124 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 306 Elsie St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/2000 12:00:00 AM | Permit Number 42942 | 6006590.61283403 | 2097446.1617064998 | 37.7395604645493 | -122.41975485718001 | (37.7395604645493, -122.41975485718) | |||
| 19778 | 19778 | 10042 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 360 Guerrero St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6005475.5325 | 2106875.27322 | 37.7653877427782 | -122.424280773365 | (37.7653877427782, -122.424280773365) | |||
| 19803 | 19803 | 40552 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 380 San Leandro Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/1999 12:00:00 AM | Permit Number 41594 | 5992231.83033974 | 2094391.07598337 | 37.7303526300924 | -122.46917856626301 | (37.7303526300924, -122.469178566263) | ||
| 19839 | 19839 | 46807 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 170 San Felipe Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | Permit Number 44891 | 5994047.88467272 | 2095052.68932043 | 37.7322740285646 | -122.46294824520201 | (37.7322740285646, -122.462948245202) | ||
| 19854 | 19854 | 22847 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 120 Turquoise Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 1X1 | 5999792.57079 | 2099032.92975 | 37.7435320514679 | -122.44337341096 | (37.7435320514679, -122.44337341096) | |||
| 19892 | 19892 | 10082 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 635 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6005631.678069999 | 2105272.5638099997 | 37.7609958972634 | -122.42362674139 | (37.7609958972634, -122.42362674139) | |||
| 19919 | 19919 | 22857 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 140 Turquoise Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 5999962.5857 | 2099158.01646 | 37.743885203545396 | -122.442794523662 | (37.7438852035454, -122.442794523662) | ||||
| 19926 | 19926 | 10117 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 845 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005699.222580001 | 2104067.01691 | 37.757689560440795 | -122.42330743349301 | (37.7576895604408, -122.423307433493) | |||
| 19941 | 19941 | 28386 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2749 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2016 12:00:00 AM | 9 | 3X3 | 6009842.67473 | 2101317.3868299997 | 37.750372664569504 | -122.408783629764 | (37.7503726645695, -122.408783629764) | ||
| 20053 | 20053 | 5099 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2621 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6002328.495730001 | 2096416.0838900001 | 37.736491088285796 | -122.434417765086 | (37.7364910882858, -122.434417765086) | |||
| 20087 | 20087 | 4439 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1302 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004459.83721 | 2101280.4453 | 37.749968261937106 | -122.42739523262699 | (37.7499682619371, -122.427395232627) | |||
| 20164 | 20164 | 8289 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 50 Garcia Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8 | 5995199.8326 | 2099398.11528 | 37.7442717834334 | -122.459280291049 | (37.7442717834334, -122.459280291049) | |||
| 20385 | 20385 | 39056 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2800X 18th St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009422.123 | 2105494.394 | 37.7618182216771 | -122.410532856099 | (37.7618182216771, -122.410532856099) | ||
| 20450 | 20450 | 10113 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 827 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6005696.52511 | 2104103.91625 | 37.757790725171 | -122.423319385483 | (37.757790725171, -122.423319385483) | |||
| 20484 | 20484 | 39027 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 501X Florida St | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009258.495 | 2105867.224 | 37.7628327529372 | -122.41112511890101 | (37.7628327529372, -122.411125118901) | ||
| 20490 | 20490 | 68099 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 9 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/1993 12:00:00 AM | Permit Number 31844 | 6006420.25408514 | 2099944.49896622 | 37.7464107382986 | -122.42052117977501 | (37.7464107382986, -122.420521179775) | ||
| 20555 | 20555 | 10100 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 750 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/22/1995 12:00:00 AM | 40 | 2x2 | 6005607.26399 | 2104540.55602 | 37.758984597670896 | -122.423659132264 | (37.7589845976709, -122.423659132264) | ||
| 20623 | 20623 | 39050 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1900 Bryant St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009499.38 | 2105599.429 | 37.762110954787005 | -122.410273070025 | (37.762110954787, -122.410273070025) | ||
| 20643 | 20643 | 26635 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 359 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/24/1998 12:00:00 AM | 3 | 3X3 | 6005539.477000001 | 2106921.88393 | 37.7655193351826 | -122.42406291888001 | (37.7655193351826, -122.42406291888) | ||
| 20708 | 20708 | 10039 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 360 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/1991 12:00:00 AM | 20 | 3X3 | 6005477.1925800005 | 2106955.99773 | 37.765609486820004 | -122.424280773358 | (37.76560948682, -122.424280773358) | ||
| 20712 | 20712 | 10140 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 906 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/1991 12:00:00 AM | 8 | 2x2 | 6005653.96599 | 2103626.9979 | 37.7564788166491 | -122.423432668582 | (37.7564788166491, -122.423432668582) | ||
| 20911 | 20911 | 50946 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1134 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2014 12:00:00 AM | 3 | Permit Number 773916 | 6007565.24376916 | 2118876.40998362 | 37.7984577381814 | -122.417903725033 | (37.7984577381814, -122.417903725033) | ||
| 20981 | 20981 | 40426 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 572 Wildwood Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1999 12:00:00 AM | Permit Number 41522 | 5994442.84312797 | 2093351.87569512 | 37.7276267513816 | -122.46145953493901 | (37.7276267513816, -122.461459534939) | ||
| 21005 | 21005 | 4464 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1467 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/1992 12:00:00 AM | 6 | 3X3 | 6004576.21057 | 2100336.17551 | 37.7473820968062 | -122.42692556438801 | (37.7473820968062, -122.426925564388) | ||
| 21103 | 21103 | 10099 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 750 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1995 12:00:00 AM | 30 | 2x2 | 6005606.10854 | 2104557.89173 | 37.7590321322447 | -122.423664360924 | (37.7590321322447, -122.423664360924) | ||
| 21203 | 21203 | 47373 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 800 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/2002 12:00:00 AM | Permit Number 45290 | 5991938.31220881 | 2089883.64331253 | 37.7179593670507 | -122.469865242758 | (37.7179593670507, -122.469865242758) | |||
| 21241 | 21241 | 41670 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 500 Corbett Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42131 | 5999528.76445246 | 2104225.15584588 | 37.7577735947767 | -122.44465870166599 | (37.7577735947767, -122.444658701666) | ||
| 21320 | 21320 | 10210 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1306 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/1992 12:00:00 AM | 18 | 2X2 | 6005782.73241 | 2101317.8159 | 37.7501456037461 | -122.42282324301901 | (37.7501456037461, -122.422823243019) | ||
| 21423 | 21423 | 10225 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1399 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005877.37579 | 2100867.12021 | 37.748913436323704 | -122.422463939564 | (37.7489134363237, -122.422463939564) | |||
| 21429 | 21429 | 4275 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 4215 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002481.0949 | 2100316.7179400004 | 37.7472099827631 | -122.434168929879 | (37.7472099827631, -122.434168929879) | |||
| 21476 | 21476 | 16622 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 133 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002888.88219 | 2107504.60291 | 37.766969331884 | -122.433272362446 | (37.766969331884, -122.433272362446) | |||
| 21625 | 21625 | 27417 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1368 Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6004484.17444 | 2100908.10154 | 37.7489472688119 | -122.427284553046 | (37.7489472688119, -122.427284553046) | |||
| 21684 | 21684 | 10064 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 512 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/1991 12:00:00 AM | 30 | 3X3 | 6005527.25593 | 2105966.68025 | 37.762895882361 | -122.42403725491 | (37.762895882361, -122.42403725491) | ||
| 21692 | 21692 | 26 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 736 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/12/1992 12:00:00 AM | 12 | 3X3 | 6003885.725319999 | 2107769.72577 | 37.7677537952191 | -122.4298433527 | (37.7677537952191, -122.4298433527) | ||
| 21743 | 21743 | 5096 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 2617 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/08/2005 12:00:00 AM | 15 | 4x7 | 6002321.1773 | 2096442.08451 | 37.7365620645731 | -122.43444492640499 | (37.7365620645731, -122.434444926405) | ||
| 21867 | 21867 | 4450 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1368 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6004484.29512 | 2100913.96053 | 37.748963363065 | -122.427284553034 | (37.748963363065, -122.427284553034) | |||
| 21899 | 21899 | 24817 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 400X Alemany Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/17/2015 12:00:00 AM | 4 | 3x3 | 6007985.05958 | 2094993.5090299998 | 37.7329044714678 | -122.41475991886101 | (37.7329044714678, -122.414759918861) | ||
| 21906 | 21906 | 10040 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 360 Guerrero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005476.568580001 | 2106925.6543400004 | 37.7655261358546 | -122.424280773346 | (37.7655261358546, -122.424280773346) | |||
| 21918 | 21918 | 26668 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 102 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 2X2 | 6005390.51366 | 2108390.09444 | 37.769542278768505 | -122.42468260394199 | (37.7695422787685, -122.424682603942) | |||
| 22000 | 22000 | 4189 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 3854 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/17/1998 12:00:00 AM | 6 | 3X3 | 6004813.31142 | 2100488.37375 | 37.747813401782 | -122.426116518959 | (37.747813401782, -122.426116518959) | ||
| 22170 | 22170 | 17373 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1050X Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3X3 | 5999390.9816 | 2109231.8772 | 37.771512935512796 | -122.44549522045601 | (37.7715129355128, -122.445495220456) | |||
| 22175 | 22175 | 10077 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 611 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6005621.78486 | 2105416.8204099997 | 37.761391433480895 | -122.423671214664 | (37.7613914334809, -122.423671214664) | |||
| 22236 | 22236 | 4405 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1050 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/01/1993 12:00:00 AM | 12 | 3X3 | 6004381.0178 | 2102775.98302 | 37.7540702011025 | -122.42777434091299 | (37.7540702011025, -122.427774340913) | ||
| 22284 | 22284 | 196235 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 474 Minna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010444.82065 | 2112504.83625 | 37.781124561999995 | -122.407490004484 | (37.781124562, -122.407490004484) | |||
| 22288 | 22288 | 237856 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 636 30th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 6ft | 6002455.57988 | 2098272.49197 | 37.7415955682714 | -122.434111048608 | (37.7415955682714, -122.434111048608) | |||
| 22376 | 22376 | 2581 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1671 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/1990 12:00:00 AM | 12 | 4X4 | 6005533.42791 | 2115131.9638 | 37.7880618747142 | -122.42466793237699 | (37.7880618747142, -122.424667932377) | ||
| 22815 | 22815 | 237464 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 4255 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6001532.2528099995 | 2101727.17835 | 37.7510288729044 | -122.437550937446 | (37.7510288729044, -122.437550937446) | |||
| 22845 | 22845 | 34928 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 106 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/1997 12:00:00 AM | 3 | Permit Number 38520 | 5996566.0494 | 2113710.9366 | 37.7836495810368 | -122.455590554827 | (37.7836495810368, -122.455590554827) | ||
| 22877 | 22877 | 58835 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 465 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/1984 12:00:00 AM | 12 | Permit Number 21290 | 5985916.00894 | 2112750.62267 | 37.7803959336596 | -122.492364376017 | (37.7803959336596, -122.492364376017) | ||
| 23107 | 23107 | 1354 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 290 Amber Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 3X3 | 5999954.53574 | 2099301.98481 | 37.7442800472965 | -122.442832694476 | (37.7442800472965, -122.442832694476) | |||
| 23254 | 23254 | 22843 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 120 Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 3X3 | 5999765.52429 | 2099012.7663 | 37.7434751450586 | -122.443465482663 | (37.7434751450586, -122.443465482663) | |||
| 23318 | 23318 | 1917 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 12 Bell Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 6016599.627230001 | 2095217.01267 | 37.7339984292864 | -122.384992424754 | (37.7339984292864, -122.384992424754) | |||
| 23375 | 23375 | 218050 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 72 San Rafael Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5991878.2117099995 | 2095609.0189900002 | 37.7336763568794 | -122.470489732417 | (37.7336763568794, -122.470489732417) | |||
| 23401 | 23401 | 202171 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 20 Kalmanovitz St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 2ft | 6013157.586080001 | 2093193.49557 | 37.7282512748665 | -122.39675089323799 | (37.7282512748665, -122.396750893238) | |||
| 23403 | 23403 | 236934 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 586 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008695.69019 | 2096102.34104 | 37.735988986904104 | -122.412381425157 | (37.7359889869041, -122.412381425157) | |||
| 23405 | 23405 | 237701 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 59 Landers St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004493.49891 | 2107447.38395 | 37.7669031211042 | -122.427718167486 | (37.7669031211042, -122.427718167486) | |||
| 23409 | 23409 | 218091 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 62 Eastwood Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5995658.864080001 | 2092992.02847 | 37.726708612908 | -122.45722974236601 | (37.726708612908, -122.457229742366) | |||
| 23415 | 23415 | 65130 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 38 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/13/1989 12:00:00 AM | 8 | Permit Number 27100 | 5989605.43837 | 2114945.94466 | 37.7866386771259 | -122.479761743811 | (37.7866386771259, -122.479761743811) | |
| 23427 | 23427 | 217997 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2626 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5990831.30116 | 2097513.28208 | 37.738844388362295 | -122.47424807748301 | (37.7388443883623, -122.474248077483) | |||
| 23431 | 23431 | 213073 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 50 Castenada Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5994467.524230001 | 2101712.07423 | 37.7505832012692 | -122.46198020334299 | (37.7505832012692, -122.461980203343) | |||
| 23463 | 23463 | 185056 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 82 Crestlake Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5988580.6885 | 2096305.5585 | 37.735397653561 | -122.481941107831 | (37.735397653561, -122.481941107831) | |||
| 23469 | 23469 | 217939 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 931 Ortega St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991070.881569999 | 2102443.07073 | 37.7523941894478 | -122.47377926811001 | (37.7523941894478, -122.47377926811) | |||
| 23481 | 23481 | 218410 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 205 Castenada Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5994280.90702 | 2100599.38004 | 37.7475172792951 | -122.462544833698 | (37.7475172792951, -122.462544833698) | |||
| 23534 | 23534 | 95373 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 291 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767242 | 6013500.99875 | 2105751.1740599996 | 37.7627511113032 | -122.39644354544599 | (37.7627511113032, -122.396443545446) | |
| 23540 | 23540 | 50495 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 678 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | 3 | Permit Number 47131 | 6001459.37999 | 2089596.3595900002 | 37.7177163070325 | -122.436934583487 | (37.7177163070325, -122.436934583487) | |
| 23580 | 23580 | 212649 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 321 Vernon St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 5992450.10328 | 2090020.5964400002 | 37.7183649772426 | -122.468106177365 | (37.7183649772426, -122.468106177365) | |||
| 23591 | 23591 | 237541 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 351 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004042.14499 | 2103330.47017 | 37.755573516829 | -122.428985775399 | (37.755573516829, -122.428985775399) | |||
| 23616 | 23616 | 236591 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1087 Florida St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6009469.71038 | 2102846.00835 | 37.754549020845204 | -122.41018128234501 | (37.7545490208452, -122.410181282345) | |||
| 23619 | 23619 | 248592 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 825 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5997630.862000001 | 2107647.8664 | 37.7670630083716 | -122.45146926878701 | (37.7670630083716, -122.451469268787) | |||
| 23672 | 23672 | 45504 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3071 23rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2001 12:00:00 AM | 3 | Permit Number 44274 | 5989334.51674 | 2094909.25358 | 37.731607570812294 | -122.47923275968 | (37.7316075708123, -122.47923275968) | |
| 23687 | 23687 | 235690 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 63 Laussat St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6004411.60055 | 2109266.67882 | 37.7718938314631 | -122.428131106459 | (37.7718938314631, -122.428131106459) | |||
| 23696 | 23696 | 212999 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1639 08th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5993681.9391 | 2104325.0016900003 | 37.7577123690443 | -122.46488653520201 | (37.7577123690443, -122.464886535202) | |||
| 23712 | 23712 | 114789 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 30 Walnut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5998464.24696 | 2116358.615 | 37.7910281517879 | -122.44921435656401 | (37.7910281517879, -122.449214356564) | |||
| 23723 | 23723 | 142204 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 363 LYON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6000185.7051 | 2110200.5827 | 37.7742180933985 | -122.442815809613 | (37.7742180933985, -122.442815809613) | |||
| 23751 | 23751 | 196085 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 899 Tennessee St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6015519.48704 | 2104939.50859 | 37.760634573050794 | -122.389405564436 | (37.7606345730508, -122.389405564436) | |||
| 23850 | 23850 | 52657 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 17 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/2006 12:00:00 AM | 4 | Permit Number 48738 | 5996482.1208 | 2114462.9099 | 37.785709482825204 | -122.455935294079 | (37.7857094828252, -122.455935294079) | ||
| 23853 | 23853 | 235939 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 114 Ripley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008703.15909 | 2099068.47895 | 37.744133771662895 | -122.41256521244101 | (37.7441337716629, -122.412565212441) | |||
| 23857 | 23857 | 235906 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3400 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6005630.30801 | 2103749.3730099997 | 37.7568134948552 | -122.423523186264 | (37.7568134948552, -122.423523186264) | |||
| 23899 | 23899 | 72385 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 686 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/1996 12:00:00 AM | 8 | 5995057.69186 | 2110887.03516 | 37.775809229939206 | -122.460604158861 | (37.7758092299392, -122.460604158861) | ||
| 23934 | 23934 | 248050 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 38 Rutledge St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6010496.13368 | 2099436.61391 | 37.7452450531093 | -122.406391405264 | (37.7452450531093, -122.406391405264) | ||||
| 23970 | 23970 | 212728 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1287 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 5992976.77161 | 2106756.7423799997 | 37.764348608513 | -122.467502106342 | (37.764348608513, -122.467502106342) | |||
| 23993 | 23993 | 236308 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 480 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006778.703509999 | 2100983.33732 | 37.749283347246205 | -122.419355383451 | (37.7492833472462, -122.419355383451) |
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");