trees
175 rows where SiteOrder = 1 and qSpecies_id = 116
This data as json, CSV (advanced)
| rowid ▼ | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 124668 | 181320 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2126 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5989173 | 2106514 | 37.7634617628894 | -122.480640365287 | (37.7634617628894, -122.480640365287) | 1 | 8 | 3 | 56 | 35 | |||
| 125141 | 182441 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1529 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5985572.6922 | 2104787.172 | 37.7585104674539 | -122.492965288536 | (37.7585104674539, -122.492965288536) | 1 | 8 | 3 | 56 | 35 | |||
| 127274 | 143059 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 440 GREENWICH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6010738.656 | 2120349.8129 | 37.8026814253217 | -122.407026593467 | (37.8026814253217, -122.407026593467) | 3 | 1 | 10 | 308 | 23 | |||
| 127663 | 258439 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2341 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5988410 | 2106416 | 37.7631483069578 | -122.483272121252 | (37.7631483069578, -122.483272121252) | 1 | 8 | 3 | 56 | 35 | ||||
| 127894 | 97338 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1917 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5989797.6411 | 2106487.0994 | 37.7634241851075 | -122.478477988866 | (37.7634241851075, -122.478477988866) | 1 | 8 | 3 | 56 | 35 | |||
| 128857 | 181647 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1810 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5990056.3621 | 2106554.5578 | 37.763624424605 | -122.477588097139 | (37.763624424605, -122.477588097139) | 1 | 8 | 3 | 56 | 35 | |||
| 129179 | 241191 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 3630 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006057.85457 | 2104359.21039 | 37.7585120893797 | -122.422087892569 | (37.7585120893797, -122.422087892569) | 2 | 4 | 5 | 28859 | 19 | |||
| 129318 | 197986 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 498 Mississippi St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6014051.93568 | 2104880.86729 | 37.7603920825505 | -122.394477092339 | (37.7603920825505, -122.394477092339) | 10 | 3 | 8 | 28856 | 29 | |||
| 129342 | 44264 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 300 Duboce Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/2001 12:00:00 AM | Permit Number 43693 | 6004891.25445895 | 2108442.06671817 | 37.7696567724968 | -122.426413224583 | (37.7696567724968, -122.426413224583) | 7 | 4 | 5 | 28852 | 10 | |||
| 129697 | 98644 | Undocumented 4 | Trachycarpus fortunei :: Windmill Palm 116 | 2391 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6008222 | 2104509 | 37.7590452010005 | -122.414613883143 | (37.7590452010005, -122.414613883143) | 2 | 4 | 7 | 28859 | 19 | |||
| 130674 | 101284 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2034 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5989388.4992 | 2106533.1127 | 37.7635267635243 | -122.479896429915 | (37.7635267635243, -122.479896429915) | 1 | 8 | 3 | 56 | 35 | |||
| 133818 | 52311 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 4400HOFFMAN 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2009 12:00:00 AM | 3x3 | Permit Number 52154 | 6000634.55195661 | 2101724.81174328 | 37.7509712947951 | -122.440655099281 | (37.7509712947951, -122.440655099281) | 2 | 4 | 5 | 28862 | 22 | ||
| 136147 | 119965 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 518 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5987217.06494 | 2112373.1551 | 37.7794354929176 | -122.487835733288 | (37.7794354929176, -122.487835733288) | 11 | 6 | 2 | 55 | 26 | |||
| 136184 | 43754 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 367 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/2000 12:00:00 AM | 14 | Permit Number 43390 | 5991197.85001 | 2112958.02747 | 37.781272787853 | -122.474107339564 | (37.781272787853, -122.474107339564) | 11 | 6 | 2 | 54 | 26 | |
| 137988 | 56678 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2400 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5988274.3719 | 2106490.5517 | 37.7633451115211 | -122.483746674042 | (37.7633451115211, -122.483746674042) | 1 | 8 | 3 | 56 | 35 | |||
| 140476 | 258418 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1839 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 5990060 | 2106509 | 37.7634995462716 | -122.477572184802 | (37.7634995462716, -122.477572184802) | 1 | 8 | 3 | 56 | 35 | ||||
| 141092 | 101260 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1900 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5989805.9135 | 2106546.133 | 37.7635867556905 | -122.478453694684 | (37.7635867556905, -122.478453694684) | 1 | 8 | 3 | 56 | 35 | |||
| 142005 | 83791 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 369 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50933 | 6008828.16902132 | 2097088.78446754 | 37.7387049796432 | -122.411993079981 | (37.7387049796432, -122.411993079981) | 10 | 7 | 7 | 28859 | 2 | ||
| 142119 | 183595 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2639 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5989548.2713 | 2097387.6993 | 37.7384251583472 | -122.478674965089 | (37.7384251583472, -122.478674965089) | 1 | 8 | 3 | 29491 | 35 | |||
| 142402 | 99104 | Undocumented 4 | Trachycarpus fortunei :: Windmill Palm 116 | 3644 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006000.9 | 2104423 | 37.7586840282695 | -122.422289399469 | (37.7586840282695, -122.422289399469) | 2 | 4 | 5 | 28859 | 19 | ||||
| 143055 | 49075 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 1970 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2003 12:00:00 AM | Permit Number 46231 | 5993706.31601319 | 2092791.54243423 | 37.7260457932168 | -122.46396504093 | (37.7260457932168, -122.46396504093) | 9 | 8 | 4 | 59 | 40 | ||
| 144411 | 179957 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 162 Tunnel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6011927.16714 | 2087557.34531 | 37.7127069906044 | -122.400608764476 | (37.7127069906044, -122.400608764476) | 10 | 3 | 8 | 309 | 1 | |||
| 145354 | 199656 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1395 Donner Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6015030.8215 | 2090912.727 | 37.7220928214053 | -122.390115718832 | (37.7220928214053, -122.390115718832) | 10 | 3 | 8 | 58 | 1 | |||
| 147492 | 254374 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 343 Woolsey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781359 | 6010747.56272 | 2091896.11912 | 37.7245545163839 | -122.404991175416 | (37.7245545163839, -122.404991175416) | 10 | 3 | 7 | 309 | 28 |
| 147565 | 47560 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45422 | 6007250.69827751 | 2103936.71356757 | 37.7574192165742 | -122.41793254418 | (37.7574192165742, -122.41793254418) | 2 | 4 | 7 | 28859 | 19 | ||
| 149347 | 101281 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2049 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 5989322.9543 | 2106470.5284 | 37.7633511157788 | -122.480118545713 | (37.7633511157788, -122.480118545713) | 1 | 8 | 3 | 56 | 35 | |||
| 149786 | 34054 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 375 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37958 | 6008950.19472335 | 2106493.86234805 | 37.7645360636147 | -122.41223571698 | (37.7645360636147, -122.41223571698) | 8 | 4 | 7 | 28859 | 19 | ||
| 150208 | 101279 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2301 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5988600.1162 | 2106446.7223 | 37.7632437243179 | -122.482616832407 | (37.7632437243179, -122.482616832407) | 1 | 8 | 3 | 56 | 35 | |||
| 150770 | 95069 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1924 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5989718.6012 | 2106543.0694 | 37.7635732745448 | -122.478755452983 | (37.7635732745448, -122.478755452983) | 1 | 8 | 3 | 56 | 35 | |||
| 152787 | 241202 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 154 Highland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6005836.15299 | 2096624.27881 | 37.7372612281114 | -122.42230507703 | (37.7372612281114, -122.42230507703) | 2 | 7 | 7 | 28859 | 2 | |||
| 152907 | 50801 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 466 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/11/2004 12:00:00 AM | Permit Number 47598 | 5997189.59146779 | 2093842.28323419 | 37.7291310061031 | -122.451999409113 | (37.7291310061031, -122.451999409113) | 9 | 7 | 4 | 28861 | 40 | ||
| 153365 | 101268 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2240 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5988685.6106 | 2106506.2437 | 37.7634121273454 | -122.482325500356 | (37.7634121273454, -122.482325500356) | 1 | 8 | 3 | 56 | 35 | |||
| 155074 | 42737 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 2155 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42735 | 6011836.19977805 | 2087516.89388515 | 37.7125908452343 | -122.400920338197 | (37.7125908452343, -122.400920338197) | 10 | 3 | 8 | 309 | 1 | ||
| 155667 | 47386 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 400 Ellington Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2002 12:00:00 AM | Permit Number 45302 | 5998534.7421818 | 2087640.83447452 | 37.7121802187249 | -122.446903063491 | (37.7121802187249, -122.446903063491) | 9 | 7 | 6 | 28861 | 25 | |||
| 156301 | 136745 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2908 Broderick St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6000044.84961 | 2118592.59728 | 37.7972523569702 | -122.443906124388 | (37.7972523569702, -122.443906124388) | 13 | 9 | 1 | 57 | 17 | |||
| 156738 | 215412 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1407 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5991770.8881 | 2105805.69837 | 37.7616676000029 | -122.471603571552 | (37.7616676000029, -122.471603571552) | 1 | 8 | 4 | 56 | 12 | |||
| 157496 | 51920 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 45 Sheridan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/2005 12:00:00 AM | 2x3 | Permit Number 48123 | 6009316.82358159 | 2109402.74774996 | 37.7725437555109 | -122.411173135945 | (37.7725437555109, -122.411173135945) | 8 | 2 | 9 | 28853 | 34 | ||
| 161154 | 241188 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 419 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6007442.12211 | 2107229.45736 | 37.7664710984984 | -122.417503881697 | (37.7664710984984, -122.417503881697) | 8 | 4 | 7 | 28853 | 19 | |||
| 163035 | 99249 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 435 Paul Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/2012 12:00:00 AM | 3x3 | Permit Number 769233 | 6012286.9 | 2091380.6 | 37.7232249352354 | -122.399633675727 | (37.7232249352354, -122.399633675727) | 10 | 3 | 8 | 58 | 1 | ||
| 163142 | 258471 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2229 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5988796 | 2106431 | 37.7632119492313 | -122.481938191449 | (37.7632119492313, -122.481938191449) | 1 | 8 | 3 | 56 | 35 | ||||
| 164100 | 621 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 3151 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/23/1992 12:00:00 AM | 18 | 3X3 | 6007979.07595 | 2102079.24238 | 37.7523599891254 | -122.415282029241 | (37.7523599891254, -122.415282029241) | 2 | 4 | 7 | 28859 | 19 | ||
| 164294 | 123216 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 654 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5993193.61084 | 2111027.91211 | 37.7760886204879 | -122.467062678343 | (37.7760886204879, -122.467062678343) | 11 | 6 | 2 | 54 | 11 | |||
| 164560 | 62050 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 70 13th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 3x3 | Permit Number 50122 | 6008120 | 2108416 | 37.7697671862008 | -122.415243219817 | (37.7697671862008, -122.415243219817) | 8 | 2 | 9 | 28853 | 19 | ||
| 165500 | 258474 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2115 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5989132 | 2106442 | 37.7632616874488 | -122.480776898017 | (37.7632616874488, -122.480776898017) | 1 | 8 | 3 | 56 | 35 | ||||
| 168165 | 87391 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 3322 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773384 | 6002335.87278 | 2119635.99284 | 37.800247665053 | -122.436053318908 | (37.800247665053, -122.436053318908) | 13 | 9 | 1 | 57 | 17 | |
| 169340 | 255617 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 350 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006699 | 2104069 | 37.7577513796565 | -122.419849926759 | (37.7577513796565, -122.419849926759) | 2 | 4 | 7 | 28859 | 19 | ||||
| 169972 | 258424 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2050 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5989314 | 2106544 | 37.7635523285903 | -122.480154892876 | (37.7635523285903, -122.480154892876) | 1 | 8 | 3 | 56 | 35 | ||||
| 171280 | 215416 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 286 Orizaba Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 12 | 5994027.68196 | 2088444.22736 | 37.7141276262766 | -122.462538908049 | (37.7141276262766, -122.462538908049) | 9 | 8 | 6 | 28861 | 24 | ||||
| 171394 | 16201 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 500X Monterey Blvd | 1 | Median : Cutout | Tree | DPW 1 | 02/02/2003 12:00:00 AM | 12 | 5 | 5998782.1299536 | 2094714.7967047 | 37.7316178141427 | -122.446556643647 | (37.7316178141427, -122.446556643647) | 9 | 7 | 4 | 59 | 40 | ||
| 172443 | 198003 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 920x Jamestown Ave | 1 | Median : Cutout | Tree | DPW 1 | 12 | Width 5ft | 6014527.01214 | 2089285.60779 | 37.7175971171782 | -122.391743566112 | (37.7175971171782, -122.391743566112) | 10 | 3 | 8 | 58 | 1 | |||
| 174362 | 179954 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 40 Tomaso Ct | 1 | : | Tree | Private 2 | 23 | Width 2ft | 6009197.20014 | 2086405.9588 | 37.709392885454 | -122.409963207553 | (37.709392885454, -122.409963207553) | 9 | 7 | 8 | 309 | 39 | |||
| 174430 | 258415 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1815 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 5990072 | 2106474 | 37.7634041420481 | -122.477528122764 | (37.7634041420481, -122.477528122764) | 1 | 8 | 3 | 56 | 35 | ||||
| 174905 | 101273 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2324 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5988506 | 2106527 | 37.7634586690964 | -122.482948229193 | (37.7634586690964, -122.482948229193) | 1 | 8 | 3 | 56 | 35 | |||||
| 175473 | 48927 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 1362 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/2002 12:00:00 AM | Permit Number 46117 | 6009515.72884218 | 2101239.2044667 | 37.7501396750607 | -122.409908717805 | (37.7501396750607, -122.409908717805) | 2 | 4 | 7 | 28859 | 19 | ||
| 176157 | 63531 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 645 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/10/1987 12:00:00 AM | Permit Number 24143 | 6007924.14567941 | 2104175.72058203 | 37.7581133535123 | -122.415620410353 | (37.7581133535123, -122.415620410353) | 2 | 4 | 7 | 28859 | 19 | ||
| 178255 | 241205 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2389 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6008219.00846 | 2104543.89441 | 37.7591408449879 | -122.414626698671 | (37.7591408449879, -122.414626698671) | 2 | 4 | 7 | 28859 | 19 | |||
| 180712 | 241227 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 104 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003479.82073 | 2097757.75572 | 37.7402402980644 | -122.430532852122 | (37.7402402980644, -122.430532852122) | 2 | 7 | 5 | 63 | 7 | |||
| 180994 | 60926 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2000 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/1983 12:00:00 AM | 13 | 3x3 | Permit Number 20727 | 5989507.2134 | 2106536.1763 | 37.7635420716385 | -122.479486064031 | (37.7635420716385, -122.479486064031) | 1 | 8 | 3 | 56 | 35 | |
| 181035 | 215434 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 20 Lakewood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5993586.39661 | 2092891.16546 | 37.7263124219742 | -122.464386821508 | (37.7263124219742, -122.464386821508) | 9 | 8 | 4 | 59 | 40 | |||
| 181127 | 241203 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2399 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6008221.76709 | 2104500.66986 | 37.7590223152579 | -122.414614099173 | (37.7590223152579, -122.414614099173) | 2 | 4 | 7 | 28859 | 19 | |||
| 181143 | 82360 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 415-421 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/2011 12:00:00 AM | 10 | 3x3 | Permit Number 768604 | 6007434.83105048 | 2107262.94030089 | 37.766562624561 | -122.417531473498 | (37.766562624561, -122.417531473498) | 8 | 4 | 7 | 28853 | 19 |
| 181839 | 215435 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 271 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 6ft | 5999640.40097 | 2095213.212 | 37.7330353327146 | -122.443625232838 | (37.7330353327146, -122.443625232838) | 9 | 7 | 4 | 63 | 40 | |||
| 183428 | 136750 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1124 Filbert St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 5ft | 6007528.1043 | 2119564.51843 | 37.8003450211571 | -122.418081047713 | (37.8003450211571, -122.418081047713) | 5 | 1 | 1 | 28858 | 32 | |||
| 183562 | 34085 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 2851X 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/19/2011 12:00:00 AM | 6 | 3x3 | Permit Number 768574 | 6007780.97837226 | 2105869.55428135 | 37.7627561815899 | -122.41623551069 | (37.7627561815899, -122.41623551069) | 8 | 4 | 7 | 28859 | 19 |
| 187547 | 241178 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 300 Duboce Ave | 1 | Front Yard : Yard | Tree | Private 2 | 02/20/2001 12:00:00 AM | 8 | Width 3ft | Permit Number 43693 | 6004795.38967 | 2108410.10559 | 37.7695635954031 | -122.426742541533 | (37.7695635954031, -122.426742541533) | 7 | 9 | 5 | 28862 | 10 | |
| 187747 | 85241 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 4331 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/28/2019 12:00:00 AM | 3 | Permit Number 784317 | 5981367.2124 | 2104841.304 | 37.7584122600662 | -122.507513483633 | (37.7584122600662, -122.507513483633) | 1 | 8 | 3 | 56 | 35 | ||
| 188827 | 258426 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2116 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5989195 | 2106551 | 37.7635646334525 | -122.480566983887 | (37.7635646334525, -122.480566983887) | 1 | 8 | 3 | 56 | 35 | ||||
| 189294 | 69181 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1335 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1994 12:00:00 AM | 12 | Permit Number 33220 | 5982114.4178 | 2105957.0803 | 37.7615198518733 | -122.505012044902 | (37.7615198518733, -122.505012044902) | 1 | 8 | 3 | 56 | 35 | |
| 189828 | 38219 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 118 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/09/2000 12:00:00 AM | Permit Number 40340 | 6000363.19569215 | 2109305.86913973 | 37.7717715527779 | -122.44213760158 | (37.7717715527779, -122.44213760158) | 15 | 5 | 11 | 29492 | 9 | ||
| 190621 | 63542 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 2389 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/1987 12:00:00 AM | Permit Number 24157 | 6008220.8181992 | 2104530.13411616 | 37.7591031640479 | -122.414619465951 | (37.7591031640479, -122.414619465951) | 2 | 4 | 7 | 28859 | 19 | ||
| 191550 | 71944 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 1342 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/04/1995 12:00:00 AM | 3x3 | Permit Number 50253 | 6008035.06455956 | 2100432.68279191 | 37.7478420534954 | -122.414971880187 | (37.7478420534954, -122.414971880187) | 2 | 7 | 7 | 28859 | 2 | ||
| 193047 | 88286 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 240 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2008 12:00:00 AM | 3x3 | Permit Number 51287 | 6007754 | 2106536 | 37.7645845697556 | -122.416376026653 | (37.7645845697556, -122.416376026653) | 8 | 4 | 7 | 28859 | 19 | ||
| 193222 | 258429 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2206 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5988870 | 2106540 | 37.7635155369644 | -122.481690237146 | (37.7635155369644, -122.481690237146) | 1 | 8 | 3 | 56 | 35 | ||||
| 193495 | 197988 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 82 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6012221.12319 | 2107462.35445 | 37.7673783228879 | -122.40099044576 | (37.7673783228879, -122.40099044576) | 14 | 3 | 8 | 28856 | 20 | |||
| 193666 | 50830 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 621 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/2004 12:00:00 AM | 9 | Permit Number 47349 | 6000535.8217 | 2111139.1847 | 37.7768152106013 | -122.441672069607 | (37.7768152106013, -122.441672069607) | 15 | 5 | 11 | 29492 | 16 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );