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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||||
| 90667 | 90667 | 94951 | 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) | ||||
| 103766 | 103766 | 85491 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 4400 24th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/2007 12:00:00 AM | 3x3 | Permit Number 52154 | 6000641.0 | 2101716.0 | 37.7509474670616 | -122.440632169404 | (37.7509474670616, -122.440632169404) | |||
| 107188 | 107188 | 94950 | 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) | ||||
| 140792 | 140792 | 94868 | Significant Tree 6 | Trachycarpus fortunei :: Windmill Palm 31 | 51 Princeton St | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 6007547.0 | 2093670.0 | 37.729245779959 | -122.416180705349 | (37.729245779959, -122.416180705349) | |||||
| 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) | |
| 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) | |
| 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) | |
| 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) | ||
| 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) | |
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 65029 | 65029 | 241191 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 3630 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006057.8545699995 | 2104359.21039 | 37.7585120893797 | -122.42208789256901 | (37.7585120893797, -122.422087892569) | |||
| 65216 | 65216 | 136751 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1142 Filbert St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 6007453.51921 | 2119553.70533 | 37.8003111329029 | -122.41833837521999 | (37.8003111329029, -122.41833837522) | |||
| 66969 | 66969 | 241217 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 4130 Cesar Chavez St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 6003092.5802 | 2100398.11558 | 37.7474681682247 | -122.432060274186 | (37.7474681682247, -122.432060274186) | |||
| 68564 | 68564 | 241227 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 104 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6003479.820730001 | 2097757.7557200002 | 37.7402402980644 | -122.430532852122 | (37.7402402980644, -122.430532852122) | |||
| 68713 | 68713 | 69181 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1335 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1994 12:00:00 AM | 12 | Permit Number 33220 | 5982114.4178 | 2105957.0803 | 37.761519851873295 | -122.505012044902 | (37.7615198518733, -122.505012044902) | |
| 69860 | 69860 | 241226 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 102 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6003452.26052 | 2097778.5444 | 37.740295817689294 | -122.43062962727 | (37.7402958176893, -122.43062962727) | |||
| 70744 | 70744 | 179963 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 85 South Hill Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 6002963.44574 | 2087110.53022 | 37.7109761365014 | -122.431558338255 | (37.7109761365014, -122.431558338255) | |||
| 80153 | 80153 | 82685 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 35 Jennings Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2009 12:00:00 AM | 3x3 | Permit Number 52459 | 6012802.99497586 | 2089176.16957459 | 37.7172007679129 | -122.397695078281 | (37.7172007679129, -122.397695078281) | ||
| 80952 | 80952 | 109314 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1516 BROADWAY | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006331.3 | 2118082.2 | 37.796207516174796 | -122.42211710536101 | (37.7962075161748, -122.422117105361) | ||||
| 82313 | 82313 | 64622 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 350 San Carlos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1988 12:00:00 AM | Permit Number 25527 | 6006698.09280064 | 2104074.24597744 | 37.75776573278821 | -122.41985343647801 | (37.7577657327882, -122.419853436478) | ||
| 83290 | 83290 | 11584 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 4001 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 0 | 3X3 | 5982142.686634201 | 2105549.2773534 | 37.7604018044904 | -122.504884056543 | (37.7604018044904, -122.504884056543) | |||
| 86818 | 86818 | 68587 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 104 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/24/1994 12:00:00 AM | Permit Number 32485 | 6003450.61209517 | 2097770.88653532 | 37.7402746975659 | -122.430634780555 | (37.7402746975659, -122.430634780555) | ||
| 87190 | 87190 | 106452 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 56 Lucy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2014 12:00:00 AM | 3 | Permit Number 772906 | 6014092.7 | 2093830.3 | 37.7300518134974 | -122.393562691323 | (37.7300518134974, -122.393562691323) | ||
| 87568 | 87568 | 67821 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 669 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1993 12:00:00 AM | Permit Number 31477 | 6014155.20534869 | 2104021.00071857 | 37.7580368157249 | -122.394059730987 | (37.7580368157249, -122.394059730987) | ||
| 87668 | 87668 | 103568 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 223 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5997125.5 | 2106655.6 | 37.76430954658429 | -122.45314559026801 | (37.7643095465843, -122.453145590268) | |||
| 87848 | 87848 | 100205 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 4085 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/2012 12:00:00 AM | 12 | 3x4 | Permit Number 769140 | 6003091.0 | 2104064.0 | 37.757533730328205 | -122.43232751517901 | (37.7575337303282, -122.432327515179) | |
| 89328 | 89328 | 31970 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1350 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/1995 12:00:00 AM | Permit Number 35371 | 6009512.01927897 | 2101306.3823381998 | 37.7503239226813 | -122.409926287411 | (37.7503239226813, -122.409926287411) | |||
| 90069 | 90069 | 40438 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 400 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/10/1999 12:00:00 AM | Permit Number 41530 | 6007160.84774193 | 2097270.742449 | 37.7391109088923 | -122.417770796303 | (37.7391109088923, -122.417770796303) | ||
| 91227 | 91227 | 67800 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 4318 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1992 12:00:00 AM | Permit Number 31444 | 6001831.31402978 | 2100620.67337741 | 37.7480076719463 | -122.43643756932501 | (37.7480076719463, -122.436437569325) | ||
| 93469 | 93469 | 69068 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1407 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1994 12:00:00 AM | Permit Number 33076 | 5991768.06854816 | 2105844.04694914 | 37.76177273191679 | -122.471616117782 | (37.7617727319168, -122.471616117782) | ||
| 94065 | 94065 | 41897 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 2500 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42262 | 6001987.05760353 | 2105790.14936536 | 37.762210660505 | -122.436268917311 | (37.762210660505, -122.436268917311) | ||
| 95230 | 95230 | 67807 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 6 Fountain St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1992 12:00:00 AM | Permit Number 31458 | 6000311.37446381 | 2101639.91617819 | 37.7507197829758 | -122.441766583241 | (37.7507197829758, -122.441766583241) | ||
| 96559 | 96559 | 16227 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 564X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 12 | 5 | 5998342.280841901 | 2094738.2735002 | 37.731657141982204 | -122.44807897208 | (37.7316571419822, -122.44807897208) | ||
| 97652 | 97652 | 4167 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 3781 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/04/1993 12:00:00 AM | 12 | 3X3 | 6005338.8489102 | 2100470.9859700003 | 37.7477953482432 | -122.424297997893 | (37.7477953482432, -122.424297997893) | ||
| 97974 | 97974 | 16284 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 700X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 12 | G | 5997448.036427 | 2094744.2173306 | 37.7316223027997 | -122.45117096626998 | (37.7316223027997, -122.45117096627) | ||
| 98234 | 98234 | 37726 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 2858 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/01/1998 12:00:00 AM | Permit Number 40090 | 6010246.00158069 | 2101670.73784629 | 37.7513654710612 | -122.407413798897 | (37.7513654710612, -122.407413798897) | ||
| 98559 | 98559 | 40735 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 84 Putnam St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/1999 12:00:00 AM | Permit Number 41714 | 6009129.35799057 | 2096983.96477733 | 37.7384340613324 | -122.410944305546 | (37.7384340613324, -122.410944305546) | ||
| 101513 | 101513 | 83941 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 60 13th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/2008 12:00:00 AM | 3X3 | Permit Number 50121 | 6008302.41836553 | 2108360.42350377 | 37.7696248364946 | -122.41460830425899 | (37.7696248364946, -122.414608304259) | ||
| 101992 | 101992 | 66205 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 285 Mullen Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/1990 12:00:00 AM | Permit Number 29289 | 6010420.85602386 | 2100006.0506029 | 37.746804390663 | -122.406691826217 | (37.746804390663, -122.406691826217) | |||
| 105088 | 105088 | 67713 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 557 02nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1992 12:00:00 AM | Permit Number 31325 | 6014732.24235944 | 2112894.33120186 | 37.782433074017504 | -122.392684800601 | (37.7824330740175, -122.392684800601) | ||
| 106791 | 106791 | 44009 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 2701X 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2015 12:00:00 AM | 3 | Permit Number 43559. Tree 1 on 17th St | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.41044985886299 | (37.7642662704227, -122.410449858863) | ||
| 109165 | 109165 | 44264 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 300 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2001 12:00:00 AM | Permit Number 43693 | 6004891.25445895 | 2108442.06671817 | 37.769656772496795 | -122.426413224583 | (37.7696567724968, -122.426413224583) | |||
| 109559 | 109559 | 98644 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2391 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6008222.0 | 2104509.0 | 37.7590452010005 | -122.414613883143 | (37.7590452010005, -122.414613883143) | |||
| 111680 | 111680 | 34054 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 375 Alabama St | 1 | 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) | ||
| 111888 | 111888 | 49075 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1970 Ocean Ave | 1 | 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) | ||
| 112598 | 112598 | 47560 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 580 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | Permit Number 45422 | 6007250.69827751 | 2103936.71356757 | 37.7574192165742 | -122.41793254418002 | (37.7574192165742, -122.41793254418) | ||
| 112993 | 112993 | 99104 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 3644 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006000.9 | 2104423.0 | 37.7586840282695 | -122.422289399469 | (37.7586840282695, -122.422289399469) | ||||
| 114868 | 114868 | 83791 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 369 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50933 | 6008828.16902132 | 2097088.78446754 | 37.7387049796432 | -122.411993079981 | (37.7387049796432, -122.411993079981) | ||
| 115414 | 115414 | 52311 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 4400HOFFMAN 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/2009 12:00:00 AM | 3x3 | Permit Number 52154 | 6000634.55195661 | 2101724.81174328 | 37.7509712947951 | -122.440655099281 | (37.7509712947951, -122.440655099281) | ||
| 116426 | 116426 | 65602 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 114 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1990 12:00:00 AM | 13 | Permit Number 28504 | 6004165.03379 | 2093741.9135900002 | 37.729252495484 | -122.427877581308 | (37.729252495484, -122.427877581308) | |
| 117278 | 117278 | 50801 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 466 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/11/2004 12:00:00 AM | Permit Number 47598 | 5997189.59146779 | 2093842.28323419 | 37.7291310061031 | -122.451999409113 | (37.7291310061031, -122.451999409113) | ||
| 117733 | 117733 | 62050 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 70 13th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/2008 12:00:00 AM | 3x3 | Permit Number 50122 | 6008120.0 | 2108416.0 | 37.769767186200795 | -122.41524321981701 | (37.7697671862008, -122.415243219817) | ||
| 119574 | 119574 | 47386 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 400 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/2002 12:00:00 AM | Permit Number 45302 | 5998534.7421818 | 2087640.83447452 | 37.712180218724896 | -122.446903063491 | (37.7121802187249, -122.446903063491) | |||
| 119778 | 119778 | 51920 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 45 Sheridan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/20/2005 12:00:00 AM | 2x3 | Permit Number 48123 | 6009316.82358159 | 2109402.74774996 | 37.772543755510895 | -122.41117313594499 | (37.7725437555109, -122.411173135945) | ||
| 120632 | 120632 | 42737 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 2155 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42735 | 6011836.19977805 | 2087516.89388515 | 37.712590845234296 | -122.400920338197 | (37.7125908452343, -122.400920338197) | ||
| 121741 | 121741 | 99249 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 435 Paul Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/2012 12:00:00 AM | 3x3 | Permit Number 769233 | 6012286.9 | 2091380.6 | 37.7232249352354 | -122.399633675727 | (37.7232249352354, -122.399633675727) | ||
| 122229 | 122229 | 123216 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 654 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5993193.61084 | 2111027.91211 | 37.7760886204879 | -122.46706267834298 | (37.7760886204879, -122.467062678343) | |||
| 123498 | 123498 | 49162 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 804 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/23/2003 12:00:00 AM | Permit Number 46282 | 5994926.32764665 | 2093370.69967083 | 37.7277062535492 | -122.45978949774499 | (37.7277062535492, -122.459789497745) | ||
| 123673 | 123673 | 65048 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 375 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/18/1994 12:00:00 AM | Permit Number 27001 | 6008641.92550277 | 2097033.56507471 | 37.7385429081789 | -122.41263312174401 | (37.7385429081789, -122.412633121744) | ||
| 125170 | 125170 | 63543 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1715 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/14/1994 12:00:00 AM | Permit Number 33376 | 6001376.18344652 | 2111778.57795299 | 37.7786186676026 | -122.43881084154499 | (37.7786186676026, -122.438810841545) | ||
| 127065 | 127065 | 84127 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 88 Mill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50980 | 6010360.09243836 | 2089687.02520781 | 37.7184671339256 | -122.406175049692 | (37.7184671339256, -122.406175049692) | ||
| 127307 | 127307 | 110182 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 339 ELSIE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/2015 12:00:00 AM | 3x3 | Permit Number 776744 | 6006513.8 | 2097161.9 | 37.7387756178582 | -122.420000276005 | (37.7387756178582, -122.420000276005) | ||
| 127349 | 127349 | 42308 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 249 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42531 | 5998732.34943109 | 2093642.59637242 | 37.7286709604577 | -122.446651628377 | (37.7286709604577, -122.446651628377) | ||
| 130161 | 130161 | 215412 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1407 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5991770.8881 | 2105805.69837 | 37.7616676000029 | -122.471603571552 | (37.7616676000029, -122.471603571552) | |||
| 135321 | 135321 | 215425 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 15 Fairfield Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5993828.92178 | 2092931.25645 | 37.7264364789445 | -122.463551338741 | (37.7264364789445, -122.463551338741) | |||
| 136987 | 136987 | 51838 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 135 Morse St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2005 12:00:00 AM | 8 | Permit Number 48065 | 6000803.77084 | 2087905.29553 | 37.713035738688504 | -122.43907959427 | (37.7130357386885, -122.43907959427) | ||
| 137872 | 137872 | 82840 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1379 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2009 12:00:00 AM | 13 | 3x3 | Permit Number 52465 | 6016423.5899 | 2093711.7525 | 37.729855545757 | -122.38549618052299 | (37.729855545757, -122.385496180523) | |
| 139874 | 139874 | 16201 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 500X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 12 | 5 | 5998782.1299536 | 2094714.7967047 | 37.7316178141427 | -122.446556643647 | (37.7316178141427, -122.446556643647) | ||
| 140788 | 140788 | 34085 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 2851X 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/2011 12:00:00 AM | 6 | 3x3 | Permit Number 768574 | 6007780.97837226 | 2105869.55428135 | 37.7627561815899 | -122.41623551068999 | (37.7627561815899, -122.41623551069) |
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");