Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 76 | 76 | 241180 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 300 Duboce Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/20/2001 12:00:00 AM | 7 | Width 3ft | Permit Number 43693 | 6004770.13014 | 2108408.30025 | 37.7695572102182 | -122.426829784767 | (37.7695572102182, -122.426829784767) | |
| 82 | 82 | 241178 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 300 Duboce Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/20/2001 12:00:00 AM | 8 | Width 3ft | Permit Number 43693 | 6004795.3896699995 | 2108410.1055900003 | 37.769563595403106 | -122.42674254153299 | (37.7695635954031, -122.426742541533) | |
| 90 | 90 | 241179 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 300 Duboce Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/20/2001 12:00:00 AM | 7 | Width 3ft | Permit Number 43693 | 6004783.47466 | 2108409.88584 | 37.769562318364 | -122.426783739481 | (37.769562318364, -122.426783739481) | |
| 91 | 91 | 241181 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 300 Duboce Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/20/2001 12:00:00 AM | 8 | Width 3ft | Permit Number 43693 | 6004757.3052900005 | 2108409.26199 | 37.7695591257908 | -122.42687421397 | (37.7695591257908, -122.42687421397) | |
| 3525 | 3525 | 253489 | Planning Code 138.1 required 4 | Trachycarpus fortunei :: Windmill Palm 31 | 1x Gordon St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763.0 | 2109812.0 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | |
| 3532 | 3532 | 253483 | Planning Code 138.1 required 4 | Trachycarpus fortunei :: Windmill Palm 31 | 1x Gordon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763.0 | 2109812.0 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | |
| 3533 | 3533 | 253491 | Planning Code 138.1 required 4 | Trachycarpus fortunei :: Windmill Palm 31 | 1x Gordon St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763.0 | 2109812.0 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | |
| 3538 | 3538 | 253485 | Planning Code 138.1 required 4 | Trachycarpus fortunei :: Windmill Palm 31 | 1x Gordon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763.0 | 2109812.0 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | |
| 3546 | 3546 | 253495 | Planning Code 138.1 required 4 | Trachycarpus fortunei :: Windmill Palm 31 | 1x Gordon St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763.0 | 2109812.0 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | |
| 3553 | 3553 | 253492 | Planning Code 138.1 required 4 | Trachycarpus fortunei :: Windmill Palm 31 | 1x Gordon St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763.0 | 2109812.0 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | |
| 3554 | 3554 | 253490 | Planning Code 138.1 required 4 | Trachycarpus fortunei :: Windmill Palm 31 | 1x Gordon St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763.0 | 2109812.0 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | |
| 3555 | 3555 | 253487 | Planning Code 138.1 required 4 | Trachycarpus fortunei :: Windmill Palm 31 | 1x Gordon St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763.0 | 2109812.0 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | |
| 3562 | 3562 | 253488 | Planning Code 138.1 required 4 | Trachycarpus fortunei :: Windmill Palm 31 | 1x Gordon St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763.0 | 2109812.0 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | |
| 3563 | 3563 | 253493 | Planning Code 138.1 required 4 | Trachycarpus fortunei :: Windmill Palm 31 | 1x Gordon St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763.0 | 2109812.0 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | |
| 3573 | 3573 | 253496 | Planning Code 138.1 required 4 | Trachycarpus fortunei :: Windmill Palm 31 | 1x Gordon St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763.0 | 2109812.0 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | |
| 3581 | 3581 | 253486 | Planning Code 138.1 required 4 | Trachycarpus fortunei :: Windmill Palm 31 | 1x Gordon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763.0 | 2109812.0 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | |
| 3582 | 3582 | 253484 | Planning Code 138.1 required 4 | Trachycarpus fortunei :: Windmill Palm 31 | 1x Gordon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763.0 | 2109812.0 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | |
| 3587 | 3587 | 253494 | Planning Code 138.1 required 4 | Trachycarpus fortunei :: Windmill Palm 31 | 1x Gordon St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763.0 | 2109812.0 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | |
| 6292 | 6292 | 87392 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 3322 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773384 | 6002333.63287 | 2119648.2941900003 | 37.800281314083705 | -122.43606195061199 | (37.8002813140837, -122.436061950612) | |
| 6671 | 6671 | 87391 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 3322 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773384 | 6002335.87278 | 2119635.99284 | 37.800247665053 | -122.43605331890801 | (37.800247665053, -122.436053318908) | |
| 7036 | 7036 | 16366 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 1306X Montgomery St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 8 | 6011454.042780001 | 2119896.37482 | 37.8014764015683 | -122.40451904281299 | (37.8014764015683, -122.404519042813) | |||
| 13285 | 13285 | 187639 | Planning Code 138.1 required 4 | Trachycarpus fortunei :: Windmill Palm 31 | 1671 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/22/2017 12:00:00 AM | 3 | 3x6 | 5985585.0 | 2103854.0 | 37.7559489545124 | -122.492853989295 | (37.7559489545124, -122.492853989295) | ||
| 15504 | 15504 | 49998 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1101X 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2003 12:00:00 AM | 12 | 3x3 | Permit Number 46740 | 6014225.48172 | 2105233.1729900003 | 37.7613690835438 | -122.39390153433901 | (37.7613690835438, -122.393901534339) |
| 17013 | 17013 | 16027 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 160 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/2005 12:00:00 AM | 3 | 3X3 | 6001078.56062 | 2094701.12537 | 37.7317111799206 | -122.43861646769899 | (37.7317111799206, -122.438616467699) | ||
| 18197 | 18197 | 34055 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 375 Alabama St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | Permit Number 37958 | 6008950.19472335 | 2106493.86234805 | 37.7645360636147 | -122.41223571697999 | (37.7645360636147, -122.41223571698) | ||
| 18492 | 18492 | 63236 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 3634 20th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | FUF 1 | 01/13/1987 12:00:00 AM | 12 | Permit Number 23784 | 6006063.67565171 | 2104362.69748074 | 37.7585219924343 | -122.422068008351 | (37.7585219924343, -122.422068008351) | |
| 18713 | 18713 | 34080 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 240 Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | 6 | 3x3 | Permit Number 37968 | 6007780.97837226 | 2105869.55428135 | 37.7627561815899 | -122.41623551068999 | (37.7627561815899, -122.41623551069) |
| 19051 | 19051 | 582 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 3013 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/23/1992 12:00:00 AM | 12 | 3x3 | 6008818.92095 | 2102127.6459 | 37.7525400594852 | -122.41238111940099 | (37.7525400594852, -122.412381119401) | ||
| 19758 | 19758 | 4166 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 3771 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/18/1999 12:00:00 AM | 3 | 3X3 | 6005390.77926 | 2100476.4482400003 | 37.747813278574 | -122.424118813557 | (37.747813278574, -122.424118813557) | ||
| 21324 | 21324 | 621 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 3151 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/23/1992 12:00:00 AM | 18 | 3X3 | 6007979.07595 | 2102079.2423799997 | 37.7523599891254 | -122.41528202924101 | (37.7523599891254, -122.415282029241) | ||
| 23598 | 23598 | 179958 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 162 Tunnel Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6011915.65824 | 2087516.33041 | 37.7125937299935 | -122.40064566366999 | (37.7125937299935, -122.40064566367) | |||
| 24481 | 24481 | 117708 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 4001 Clement St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 7ft | 5983029.04687 | 2113077.7485700003 | 37.7811249212832 | -122.50237578006501 | (37.7811249212832, -122.502375780065) | |||
| 24952 | 24952 | 34654 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 2000 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 3 | Permit Number 38332 | 5988619.0903 | 2105142.8889 | 37.7596648557466 | -122.482455667505 | (37.7596648557466, -122.482455667505) | |
| 25124 | 25124 | 241190 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2858 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010222.306919999 | 2101664.86224 | 37.7513480117 | -122.407495323966 | (37.7513480117, -122.407495323966) | |||
| 26649 | 26649 | 49071 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1970 Ocean Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/07/2003 12:00:00 AM | Permit Number 46231 | 5993706.31601319 | 2092791.54243423 | 37.7260457932168 | -122.46396504093 | (37.7260457932168, -122.46396504093) | ||
| 26722 | 26722 | 136742 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2900 Broderick St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 6000053.33945 | 2118542.13589 | 37.79711428765071 | -122.443873120143 | (37.7971142876507, -122.443873120143) | |||
| 27219 | 27219 | 215426 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 15 Fairfield Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5993822.27885 | 2092914.3969599998 | 37.7263898041365 | -122.463573079846 | (37.7263898041365, -122.463573079846) | |||
| 27397 | 27397 | 241185 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 3781 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6005371.2767199995 | 2100474.34138 | 37.7478063924621 | -122.424186102634 | (37.7478063924621, -122.424186102634) | |||
| 27769 | 27769 | 215436 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 670 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 5996989.65534 | 2095298.72051 | 37.7331185802561 | -122.452795679095 | (37.7331185802561, -122.452795679095) | |||
| 27899 | 27899 | 136747 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2859 Filbert St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 5999233.55999 | 2118349.36625 | 37.796538199022606 | -122.446695870812 | (37.7965381990226, -122.446695870812) | |||
| 28207 | 28207 | 179962 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 299 Lathrop Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6012155.6977 | 2086855.9290099998 | 37.710793783685006 | -122.39976966465599 | (37.710793783685, -122.399769664656) | |||
| 28350 | 28350 | 215435 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 271 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 6ft | 5999640.40097 | 2095213.2119999998 | 37.7330353327146 | -122.443625232838 | (37.7330353327146, -122.443625232838) | |||
| 28815 | 28815 | 182351 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1501 35th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 0ft | 5985257.4301 | 2104935.3862 | 37.758898980602005 | -122.49406651392 | (37.758898980602, -122.49406651392) | |||
| 29244 | 29244 | 215411 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1939 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5991245.12391 | 2102202.13663 | 37.7517427376545 | -122.473159145982 | (37.7517427376545, -122.473159145982) | |||
| 29943 | 29943 | 83166 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1089 Gilman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52361 | 6015096.6014 | 2089812.1317 | 37.719074451264 | -122.389811494874 | (37.719074451264, -122.389811494874) | |
| 29979 | 29979 | 241228 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 128 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6003596.19295 | 2097670.1680900003 | 37.740006394279796 | -122.43012423703699 | (37.7400063942798, -122.430124237037) | |||
| 30518 | 30518 | 179954 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 40 Tomaso Ct | 1 | : 4 | Tree 1 | Private 1 | 23 | Width 2ft | 6009197.20014 | 2086405.9588 | 37.709392885454 | -122.409963207553 | (37.709392885454, -122.409963207553) | |||
| 31101 | 31101 | 66988 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1445 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/1992 12:00:00 AM | 12 | Permit Number 30339 | 6006117.71616 | 2118619.27503 | 37.7976701397196 | -122.422894339811 | (37.7976701397196, -122.422894339811) | ||
| 31251 | 31251 | 241193 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 699 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6010149.76354 | 2105082.07302 | 37.7607268479899 | -122.40798714698299 | (37.7607268479899, -122.407987146983) | |||
| 32139 | 32139 | 215423 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 15 Fairfield Way | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5993769.4086 | 2092813.96021 | 37.72611098282629 | -122.46374856183998 | (37.7261109828263, -122.46374856184) | |||
| 33234 | 33234 | 215420 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2085 09th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5993528.81827 | 2101394.66819 | 37.7496575974161 | -122.46520324492799 | (37.7496575974161, -122.465203244928) | |||
| 34328 | 34328 | 241212 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2801 17th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009052.89196 | 2106353.81264 | 37.7641572813666 | -122.411870616529 | (37.7641572813666, -122.411870616529) | |||
| 34372 | 34372 | 241223 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2800 17th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009004.56515 | 2106399.07167 | 37.7642788409211 | -122.41204096432699 | (37.7642788409211, -122.412040964327) | |||
| 34503 | 34503 | 215417 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 286 Orizaba Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | 5994025.97554 | 2088461.57938 | 37.7141751725286 | -122.46254606394699 | (37.7141751725286, -122.462546063947) | ||||
| 34945 | 34945 | 113776 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1710 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6000070.198 | 2114878.1306 | 37.7870548531015 | -122.443551447546 | (37.7870548531015, -122.443551447546) | |||
| 35031 | 35031 | 241196 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 285 Mullen Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6010370.46966 | 2100029.8165599997 | 37.7468668275408 | -122.406867732983 | (37.7468668275408, -122.406867732983) | |||
| 35762 | 35762 | 241219 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 4130 Cesar Chavez St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 6003095.93223 | 2100399.3712299997 | 37.7474718059861 | -122.432048772745 | (37.7474718059861, -122.432048772745) | |||
| 35806 | 35806 | 136746 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2908 Broderick St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 6000043.09421 | 2118605.60705 | 37.7972879782152 | -122.44391313370501 | (37.7972879782152, -122.443913133705) | |||
| 37345 | 37345 | 197979 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 601 Wisconsin St | 21 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 6012714.266419999 | 2104668.82572 | 37.759735409279706 | -122.39908861614599 | (37.7597354092797, -122.399088616146) | |||
| 37469 | 37469 | 241216 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 6 Fountain St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 3ft | 6000321.631 | 2101619.05614 | 37.7506630907493 | -122.44172961845301 | (37.7506630907493, -122.441729618453) | |||
| 37691 | 37691 | 136745 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2908 Broderick St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 6000044.84961 | 2118592.59728 | 37.797252356970205 | -122.44390612438801 | (37.7972523569702, -122.443906124388) | |||
| 39377 | 39377 | 241220 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2800 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009102.18096 | 2106403.8524599997 | 37.7642974442959 | -122.41170367540899 | (37.7642974442959, -122.411703675409) | |||
| 39697 | 39697 | 241201 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 26 Carl St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 5998490.815219999 | 2107264.4937400003 | 37.7660595705173 | -122.44846722318898 | (37.7660595705173, -122.448467223189) | |||
| 40655 | 40655 | 197995 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 881 Jamestown Ave | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6014417.48937 | 2089293.51791 | 37.717612756412 | -122.392122692435 | (37.717612756412, -122.392122692435) | |||
| 41547 | 41547 | 215416 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 286 Orizaba Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | 5994027.68196 | 2088444.22736 | 37.7141276262766 | -122.462538908049 | (37.7141276262766, -122.462538908049) | ||||
| 41866 | 41866 | 181367 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 4019 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5982046.1498 | 2105540.3564 | 37.76037163028771 | -122.505217265817 | (37.7603716302877, -122.505217265817) | |||
| 42049 | 42049 | 197980 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 601 Wisconsin St | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 6ft | 6012727.8948800005 | 2104659.33214 | 37.759710101458204 | -122.399040815374 | (37.7597101014582, -122.399040815374) | |||
| 42196 | 42196 | 183595 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2639 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5989548.2713 | 2097387.6993 | 37.7384251583472 | -122.478674965089 | (37.7384251583472, -122.478674965089) | |||
| 42264 | 42264 | 246217 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 725 Buena Vista Ave West | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5999828.0384 | 2107849.3991 | 37.7677419398126 | -122.443884078726 | (37.7677419398126, -122.443884078726) | |||
| 42490 | 42490 | 241188 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 419 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6007442.12211 | 2107229.45736 | 37.7664710984984 | -122.417503881697 | (37.7664710984984, -122.417503881697) | |||
| 44646 | 44646 | 119965 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 518 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5987217.06494 | 2112373.1551 | 37.7794354929176 | -122.48783573328801 | (37.7794354929176, -122.487835733288) | |||
| 44751 | 44751 | 197981 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 601 Wisconsin St | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 6012726.35291 | 2104657.30852 | 37.759704459115795 | -122.39904600628 | (37.7597044591158, -122.39904600628) | |||
| 44829 | 44829 | 94949 | Significant Tree 6 | Trachycarpus fortunei :: Windmill Palm 31 | 50 Pomona St | : Cutout 24 | Tree 1 | SFUSD 4 | FUF 1 | 04/04/2009 12:00:00 AM | 6014124.7 | 2094445.3 | 37.7317422564721 | -122.39349508644399 | (37.7317422564721, -122.393495086444) | ||||
| 46627 | 46627 | 182665 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2618 Ortega St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 0ft | 5985884.1902 | 2102331.3321 | 37.7517856167847 | -122.491707219971 | (37.7517856167847, -122.491707219971) | |||
| 47070 | 47070 | 83362 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 3325 Rivera St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51120 | 5982822.4546 | 2100126.935 | 37.745553538391206 | -122.50213183404101 | (37.7455535383912, -122.502131834041) | |
| 47759 | 47759 | 241195 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 699 Hampshire St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6010149.3192300005 | 2105113.8429400004 | 37.7608140561404 | -122.407990924146 | (37.7608140561404, -122.407990924146) | |||
| 48125 | 48125 | 36793 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1350 Donner Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | 8 | 3x3 | Permit Number 39527 | 6015250.697000001 | 2090820.757 | 37.721852482589796 | -122.38934923747601 | (37.7218524825898, -122.389349237476) | |
| 48830 | 48830 | 215419 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 1x Minerva St | 36 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 5996348.606369999 | 2088999.95907 | 37.7157869222005 | -122.454557070559 | (37.7157869222005, -122.454557070559) | |||
| 48849 | 48849 | 198000 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 828x Jamestown Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 5ft | 6014844.30096 | 2089001.4675099999 | 37.7168345316683 | -122.390626989449 | (37.7168345316683, -122.390626989449) | |||
| 49851 | 49851 | 197983 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1809 19th St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6012297.3164 | 2105130.82765 | 37.760980720296295 | -122.400563103211 | (37.7609807202963, -122.400563103211) | |||
| 50744 | 50744 | 197985 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 669 Mississippi St | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6014155.897999999 | 2104063.80675 | 37.758154390328 | -122.394060332116 | (37.758154390328, -122.394060332116) | |||
| 50962 | 50962 | 179971 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 160 Baltimore Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 6ft | 6002384.15556 | 2086207.4195700001 | 37.708463540423104 | -122.43349600315001 | (37.7084635404231, -122.43349600315) | |||
| 51116 | 51116 | 179953 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 240 Peabody St | 1 | : 4 | Tree 1 | Private 1 | 17 | Width 3ft | 6009701.772480001 | 2086128.1297 | 37.708658289510204 | -122.408199733244 | (37.7086582895102, -122.408199733244) | |||
| 51602 | 51602 | 197989 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 28 15th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6012209.71616 | 2107476.11774 | 37.7674154774686 | -122.401030868501 | (37.7674154774686, -122.401030868501) | |||
| 51881 | 51881 | 197988 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 82 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6012221.12319 | 2107462.35445 | 37.7673783228879 | -122.40099044576 | (37.7673783228879, -122.40099044576) | |||
| 53611 | 53611 | 109316 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1516 BROADWAY | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006331.3 | 2118082.2 | 37.796207516174796 | -122.42211710536101 | (37.7962075161748, -122.422117105361) | ||||
| 54785 | 54785 | 66435 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 154 Highland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/2016 12:00:00 AM | 3 | Permit Number 776442 | 6005832.64379623 | 2096619.46427693 | 37.7372478105316 | -122.422316867971 | (37.7372478105316, -122.422316867971) | |
| 54816 | 54816 | 57900 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1324 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/1977 12:00:00 AM | 5 | Permit Number 16856 | 6001502.5818 | 2110462.7186 | 37.77501283944979 | -122.438279288937 | (37.7750128394498, -122.438279288937) | ||
| 55123 | 55123 | 198002 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 860x Jamestown Ave | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 5ft | 6014610.54339 | 2089241.6149400002 | 37.717480958049 | -122.39145176041 | (37.717480958049, -122.39145176041) | |||
| 55615 | 55615 | 182655 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2618 Ortega St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 0ft | 5985877.3992 | 2102330.3619999997 | 37.7517825562574 | -122.49173063243201 | (37.7517825562574, -122.491730632432) | |||
| 55655 | 55655 | 198001 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 860x Jamestown Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 5ft | 6014795.93259 | 2089063.22643 | 37.7170014260431 | -122.390798490171 | (37.7170014260431, -122.390798490171) | |||
| 56645 | 56645 | 247209 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 800 Duboce Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 6001860.515269999 | 2108286.6653 | 37.7690582897368 | -122.436885307832 | (37.7690582897368, -122.436885307832) | |||
| 56686 | 56686 | 241210 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2801 17th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009103.79641 | 2106355.71742 | 37.764165367153204 | -122.41169468665899 | (37.7641653671532, -122.411694686659) | |||
| 57252 | 57252 | 199656 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1395 Donner Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6015030.8215 | 2090912.727 | 37.7220928214053 | -122.39011571883199 | (37.7220928214053, -122.390115718832) | |||
| 58250 | 58250 | 215427 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 15 Fairfield Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5993797.5326 | 2092869.7349099999 | 37.726265747145604 | -122.463655385788 | (37.7262657471456, -122.463655385788) | |||
| 59497 | 59497 | 215415 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 484 Faxon Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 5994798.18805 | 2091784.9127099998 | 37.7233446951982 | -122.460117638125 | (37.7233446951982, -122.460117638125) | |||
| 59569 | 59569 | 115612 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1400 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 4x4 | 6012209.3182 | 2107055.3618 | 37.7662601539356 | -122.401002678345 | (37.7662601539356, -122.401002678345) | |||
| 59765 | 59765 | 241209 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2801 17th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6009128.3617 | 2106356.68814 | 37.76416941052621 | -122.411609790669 | (37.7641694105262, -122.411609790669) | |||
| 59883 | 59883 | 179956 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 78 Sala Ter | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 6ft | 5998852.5351599995 | 2088480.84158 | 37.7145048379104 | -122.44586505733999 | (37.7145048379104, -122.44586505734) | |||
| 60020 | 60020 | 241221 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2800 17th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009078.922 | 2106403.19833 | 37.764294343422996 | -122.411784075669 | (37.764294343423, -122.411784075669) |
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");