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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
142472 | 142472 | 108226 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 240 Shotwell St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007737.2 | 2106597.0 | 37.764751116814296 | -122.41643845462299 | (37.7647511168143, -122.416438454623) | ||||
143287 | 143287 | 44011 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 405X Florida St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2015 12:00:00 AM | 3 | Permit Number 43559. Tree 2 on Florida | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.41044985886299 | (37.7642662704227, -122.410449858863) | ||
144031 | 144031 | 16312 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 758X Monterey Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 12 | 5 | 5997070.7706475 | 2094757.2260752 | 37.7316364140758 | -122.45247618016899 | (37.7316364140758, -122.452476180169) | ||
145082 | 145082 | 88286 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 240 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2008 12:00:00 AM | 3x3 | Permit Number 51287 | 6007754.0 | 2106536.0 | 37.7645845697556 | -122.416376026653 | (37.7645845697556, -122.416376026653) | ||
145218 | 145218 | 71944 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1342 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/04/1995 12:00:00 AM | 3x3 | Permit Number 50253 | 6008035.06455956 | 2100432.68279191 | 37.7478420534954 | -122.414971880187 | (37.7478420534954, -122.414971880187) | ||
145642 | 145642 | 108223 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 240 Shotwell St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007737.2 | 2106597.0 | 37.764751116814296 | -122.41643845462299 | (37.7647511168143, -122.416438454623) | ||||
146364 | 146364 | 179967 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 716 Peru Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 2ft | 6005275.29843 | 2092450.03888 | 37.7257680389529 | -122.423947466603 | (37.7257680389529, -122.423947466603) | |||
147184 | 147184 | 215439 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 217 Staples Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 5998709.4181699995 | 2093777.72882 | 37.729040692553 | -122.44674062198 | (37.729040692553, -122.44674062198) | |||
148653 | 148653 | 215421 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2085 09th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5993516.19097 | 2101401.9668400004 | 37.74967690946279 | -122.46524744032101 | (37.7496769094628, -122.465247440321) | |||
149959 | 149959 | 197978 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1100 Mariposa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6013947.00765 | 2106209.45605 | 37.764034263084504 | -122.394933045925 | (37.7640342630845, -122.394933045925) | |||
150042 | 150042 | 241222 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2800 17th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009029.52417 | 2106399.69099 | 37.7642819417697 | -122.411954681586 | (37.7642819417697, -122.411954681586) | |||
151347 | 151347 | 136741 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2900 Broderick St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 6000055.17715 | 2118534.1134099998 | 37.797092364871794 | -122.44386618458701 | (37.7970923648718, -122.443866184587) | |||
151710 | 151710 | 197982 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 601 Wisconsin St | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6012729.113 | 2104654.63686 | 37.759697277132204 | -122.39903627291001 | (37.7596972771322, -122.39903627291) | |||
152480 | 152480 | 241225 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 4049 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6001920.58101 | 2105839.72544 | 37.7623430070574 | -122.43650238277901 | (37.7623430070574, -122.436502382779) | |||
153492 | 153492 | 136750 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1124 Filbert St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 5ft | 6007528.1043 | 2119564.5184299997 | 37.8003450211571 | -122.41808104771299 | (37.8003450211571, -122.418081047713) | |||
153956 | 153956 | 241211 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2801 17th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6009079.81613 | 2106354.44033 | 37.7641605153159 | -122.411777537601 | (37.7641605153159, -122.411777537601) | |||
156645 | 156645 | 179959 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 162 Tunnel Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6011901.82986 | 2087473.4551099997 | 37.7124752317148 | -122.400690449024 | (37.7124752317148, -122.400690449024) | |||
157293 | 157293 | 60204 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1400 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/1982 12:00:00 AM | 8 | 4x4 | Permit Number 19750 | 6012229.2906 | 2107053.9352 | 37.766257350909704 | -122.400933496957 | (37.7662573509097, -122.400933496957) | |
157611 | 157611 | 136748 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 165 Marina Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 7ft | 6002698.42353 | 2121575.97678 | 37.80559494132721 | -122.43493757052299 | (37.8055949413272, -122.434937570523) | |||
157670 | 157670 | 241194 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 699 Hampshire St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6010150.13435 | 2105098.1288099997 | 37.7607709543248 | -122.4079869968 | (37.7607709543248, -122.4079869968) | |||
157728 | 157728 | 215438 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 217 Staples Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 5998696.43814 | 2093778.97623 | 37.7290433761531 | -122.44678558449101 | (37.7290433761531, -122.446785584491) | |||
158174 | 158174 | 241187 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 45 Hoff St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 6ft | 6006570.58835 | 2106391.73918 | 37.7641218444722 | -122.420458896575 | (37.7641218444722, -122.420458896575) | |||
158454 | 158454 | 250756 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2900 Lake St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5986048.1037 | 2114785.2005 | 37.7859900201618 | -122.492057248563 | (37.7859900201618, -122.492057248563) | |||
159390 | 159390 | 246465 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 220 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6005035.80445 | 2099919.28541 | 37.746263388739706 | -122.425306657892 | (37.7462633887397, -122.425306657892) | |||
159781 | 159781 | 197990 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 155 Grace St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6008384.453919999 | 2110216.9376 | 37.774726996282 | -122.414455930021 | (37.774726996282, -122.414455930021) | |||
159970 | 159970 | 124330 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 130 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5995934.0004900005 | 2113471.95009 | 37.782957097905395 | -122.457759890544 | (37.7829570979054, -122.457759890544) | |||
160016 | 160016 | 241207 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1142 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007609.4952 | 2103000.12596 | 37.754867747762795 | -122.41662533218701 | (37.7548677477628, -122.416625332187) | |||
160717 | 160717 | 197991 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 3419 Jennings St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 6013294.96544 | 2089742.68292 | 37.7187836844998 | -122.396034235213 | (37.7187836844998, -122.396034235213) | ||||
160919 | 160919 | 241224 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 44 Museum Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6000710.17183 | 2106760.2697 | 37.764801739133205 | -122.44075476054701 | (37.7648017391332, -122.440754760547) | |||
162786 | 162786 | 143059 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 440 GREENWICH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6010738.656 | 2120349.8129 | 37.8026814253217 | -122.40702659346701 | (37.8026814253217, -122.407026593467) | |||
162849 | 162849 | 241205 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2389 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6008219.00846 | 2104543.8944099997 | 37.7591408449879 | -122.414626698671 | (37.7591408449879, -122.414626698671) | |||
162886 | 162886 | 197999 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 828 Jamestown Ave | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 5ft | 6014890.34253 | 2088931.57147 | 37.7166451650195 | -122.39046296391399 | (37.7166451650195, -122.390462963914) | |||
163040 | 163040 | 82715 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1379 Quesada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2009 12:00:00 AM | 11 | 3x3 | Permit Number 52465 | 6016442.9825 | 2093699.9014 | 37.7298240779238 | -122.385428311894 | (37.7298240779238, -122.385428311894) | |
164340 | 164340 | 117703 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 4001 Clement St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 7ft | 5983084.790030001 | 2113081.26685 | 37.7811378565893 | -122.502183200126 | (37.7811378565893, -122.502183200126) | |||
164851 | 164851 | 247521 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1101 Waller St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6000007.86979 | 2108477.01107 | 37.7694754609529 | -122.443307149811 | (37.7694754609529, -122.443307149811) | ||||
164853 | 164853 | 215422 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 15 Fairfield Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5993781.00975 | 2092831.61045 | 37.7261601145848 | -122.46370973814 | (37.7261601145848, -122.46370973814) | |||
166118 | 166118 | 215413 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 423 Flood Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 6ft | 5997941.5079 | 2094069.28168 | 37.7297973308762 | -122.44941633348999 | (37.7297973308762, -122.44941633349) | |||
166430 | 166430 | 179960 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 162 Tunnel Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6011897.9450900005 | 2087458.38855 | 37.7124336452757 | -122.400702818282 | (37.7124336452757, -122.400702818282) | |||
166443 | 166443 | 241208 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2801 17th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009151.461180001 | 2106358.27771 | 37.7641750708383 | -122.41153000822901 | (37.7641750708383, -122.411530008229) | |||
166782 | 166782 | 36797 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1350 Donner Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | 8 | 3x3 | Permit Number 39527 | 6015213.5435 | 2090847.5562 | 37.721924008003604 | -122.389479539312 | (37.7219240080036, -122.389479539312) | |
167445 | 167445 | 215432 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 20 Lakewood Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5993607.07382 | 2092934.5708400002 | 37.7264327944236 | -122.464318491921 | (37.7264327944236, -122.464318491921) | |||
168300 | 168300 | 215431 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 20 Lakewood Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5993618.37614 | 2092959.3845099998 | 37.726501578172396 | -122.464281221309 | (37.7265015781724, -122.464281221309) | |||
168702 | 168702 | 241202 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 154 Highland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6005836.15299 | 2096624.2788099998 | 37.7372612281114 | -122.42230507703 | (37.7372612281114, -122.42230507703) | |||
170469 | 170469 | 197997 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 881 Jamestown Ave | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 6014474.56871 | 2089262.00767 | 37.717529404523795 | -122.391923191299 | (37.7175294045238, -122.391923191299) | |||
170472 | 170472 | 241215 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2801 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6008984.20306 | 2106349.91543 | 37.7641427267158 | -122.412107917041 | (37.7641427267158, -122.412107917041) | |||
171952 | 171952 | 241182 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1362 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009519.86871 | 2101254.76714 | 37.7501826387226 | -122.409895500292 | (37.7501826387226, -122.409895500292) | |||
172140 | 172140 | 115615 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1400 16th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 4x4 | 6012069.0366 | 2107045.8512 | 37.766226213653 | -122.40148722008699 | (37.766226213653, -122.401487220087) | |||
173453 | 173453 | 106777 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1177 De Haro St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/03/2014 12:00:00 AM | 5 | Permit Number 773142 | 6012265.00001 | 2102937.69671 | 37.7549570630325 | -122.400520812589 | (37.7549570630325, -122.400520812589) | ||
173562 | 173562 | 241186 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 45 Hoff St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 6ft | 6006573.70754 | 2106363.42565 | 37.764044277946205 | -122.42044609832399 | (37.7640442779462, -122.420446098324) | |||
173632 | 173632 | 241206 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2387 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6008217.68506 | 2104568.2265 | 37.759207580982 | -122.414632997525 | (37.759207580982, -122.414632997525) | |||
174334 | 174334 | 241198 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 106 Chattanooga St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6004702.81282 | 2102995.20065 | 37.754690319613296 | -122.426677105059 | (37.7546903196133, -122.426677105059) | |||
174371 | 174371 | 179957 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 162 Tunnel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6011927.1671400005 | 2087557.3453099998 | 37.7127069906044 | -122.40060876447599 | (37.7127069906044, -122.400608764476) | |||
174472 | 174472 | 36791 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1350 Donner Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | 9 | 3x3 | Permit Number 39527 | 6015186.7443 | 2090870.701 | 37.7219860731406 | -122.389573793771 | (37.7219860731406, -122.389573793771) | |
175277 | 175277 | 241199 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 24 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5998508.2304 | 2107266.01278 | 37.7660647371231 | -122.448407097228 | (37.7660647371231, -122.448407097228) | |||
175537 | 175537 | 136749 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1360 Jones St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6008500.72583 | 2117239.96883 | 37.794017078290295 | -122.41455079677701 | (37.7940170782903, -122.414550796777) | |||
178056 | 178056 | 136744 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2906 Broderick St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 6000047.06944 | 2118581.72583 | 37.7972226334754 | -122.44389766175101 | (37.7972226334754, -122.443897661751) | |||
178127 | 178127 | 197992 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 881 Jamestown Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6014311.92 | 2089359.19845 | 37.717787240171795 | -122.392492192366 | (37.7177872401718, -122.392492192366) | |||
178204 | 178204 | 197987 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2 Bridgeview Dr | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6014076.35565 | 2095353.09382 | 37.734232186468894 | -122.39372574026501 | (37.7342321864689, -122.393725740265) | ||||
178207 | 178207 | 198003 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 920x Jamestown Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 5ft | 6014527.01214 | 2089285.60779 | 37.7175971171782 | -122.391743566112 | (37.7175971171782, -122.391743566112) | |||
178324 | 178324 | 215437 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 217 Staples Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 5998668.44451 | 2093778.0926299999 | 37.729039350777 | -122.44688229669701 | (37.729039350777, -122.446882296697) | |||
178543 | 178543 | 197994 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 881 Jamestown Ave | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 6014370.9162 | 2089321.9827 | 37.717688329142604 | -122.392285665748 | (37.7176883291426, -122.392285665748) | |||
178574 | 178574 | 241189 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 415 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6007440.26209 | 2107242.97401 | 37.7665081073951 | -122.41751127324 | (37.7665081073951, -122.41751127324) | |||
178635 | 178635 | 182656 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2618 Ortega St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 0ft | 5985872.0635 | 2102330.847 | 37.7517835760889 | -122.491749119446 | (37.7517835760889, -122.491749119446) | |||
180078 | 180078 | 241183 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1720 Dolores St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6005264.11037 | 2098316.58265 | 37.7418756279601 | -122.424403226839 | (37.7418756279601, -122.424403226839) | |||
181600 | 181600 | 241204 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2399 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6008220.32471 | 2104519.20022 | 37.759073114347295 | -122.414620398932 | (37.7590731143473, -122.414620398932) | |||
181948 | 181948 | 215424 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 15 Fairfield Way | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5993760.13704 | 2092800.2871 | 37.7260729055276 | -122.463779620842 | (37.7260729055276, -122.463779620842) | |||
182005 | 182005 | 197998 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 881 Jamestown Ave | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6014511.88744 | 2089238.1825599999 | 37.717466057201705 | -122.391792531525 | (37.7174660572017, -122.391792531525) | |||
182308 | 182308 | 197996 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 881 Jamestown Ave | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6014434.42252 | 2089286.69966 | 37.7175949749992 | -122.392063685205 | (37.7175949749992, -122.392063685205) | |||
182516 | 182516 | 215434 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 20 Lakewood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5993586.39661 | 2092891.1654599998 | 37.7263124219742 | -122.464386821508 | (37.7263124219742, -122.464386821508) | |||
184005 | 184005 | 197977 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1301 Minnesota St | 73 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6015364.560269999 | 2102275.50149 | 37.7533111867689 | -122.389755314382 | (37.7533111867689, -122.389755314382) | ||||
184240 | 184240 | 197993 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 881 Jamestown Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6014330.76175 | 2089346.27019 | 37.7177527880479 | -122.392426160549 | (37.7177527880479, -122.392426160549) | |||
184272 | 184272 | 241184 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1720 Dolores St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6005265.18206 | 2098303.13157 | 37.7418387548635 | -122.424398564767 | (37.7418387548635, -122.424398564767) | |||
185205 | 185205 | 179966 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 716 Peru Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 2ft | 6005255.40982 | 2092462.4838400001 | 37.725801087223 | -122.424017104714 | (37.725801087223, -122.424017104714) | |||
185349 | 185349 | 179968 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 675 Silver Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 32 | Width 2ft | 6005852.39602 | 2093589.2328700002 | 37.7289285803821 | -122.422033372066 | (37.7289285803821, -122.422033372066) | |||
185878 | 185878 | 50830 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 621 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/19/2004 12:00:00 AM | 9 | Permit Number 47349 | 6000535.8217 | 2111139.1847 | 37.7768152106013 | -122.441672069607 | (37.7768152106013, -122.441672069607) | ||
186537 | 186537 | 182441 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1529 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5985572.6922 | 2104787.172 | 37.7585104674539 | -122.492965288536 | (37.7585104674539, -122.492965288536) | |||
186902 | 186902 | 197986 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 498 Mississippi St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6014051.93568 | 2104880.86729 | 37.7603920825505 | -122.394477092339 | (37.7603920825505, -122.394477092339) | |||
187402 | 187402 | 179964 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 85 South Hill Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 6002952.82685 | 2087126.8782400002 | 37.7110204227269 | -122.431596206017 | (37.7110204227269, -122.431596206017) | |||
188005 | 188005 | 215430 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 20 Lakewood Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5993628.724219999 | 2092981.5344200002 | 37.72656299287289 | -122.464247056069 | (37.7265629928729, -122.464247056069) | |||
188473 | 188473 | 215418 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 286 Orizaba Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | 5994025.68496 | 2088506.9373700002 | 37.7142996980529 | -122.462550356439 | (37.7142996980529, -122.462550356439) | ||||
188528 | 188528 | 246216 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 725 Buena Vista Ave West | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5999835.3063 | 2107870.2944 | 37.7677997276311 | -122.443860441452 | (37.7677997276311, -122.443860441452) | |||
188676 | 188676 | 241203 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2399 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6008221.76709 | 2104500.66986 | 37.759022315257894 | -122.414614099173 | (37.7590223152579, -122.414614099173) | |||
189124 | 189124 | 179961 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 299 Lathrop Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6012198.832140001 | 2086842.9214 | 37.7107604718955 | -122.399619668515 | (37.7107604718955, -122.399619668515) | |||
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) |
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) |
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) | |
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) | ||
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) | ||||
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) | |
61689 | 61689 | 42736 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 2155 Bay Shore Blvd | 2 | 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) | ||
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) | |
73423 | 73423 | 72214 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1799 Revere Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/18/1990 12:00:00 AM | 12 | 6014033.56934 | 2095149.8862 | 37.7336718422767 | -122.39385944784901 | (37.7336718422767, -122.393859447849) | ||
80956 | 80956 | 34053 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 375 Alabama St | 2 | 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) | ||
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) | ||
83463 | 83463 | 49161 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 804 Faxon Ave | 2 | 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) | ||
83681 | 83681 | 34052 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 375 Alabama St | 3 | 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) | ||
86383 | 86383 | 34081 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 240 SHOTWELL ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | 6 | 3x3 | Permit Number 37968 | 6007737.2 | 2106597.0 | 37.764751116814296 | -122.41643845462299 | (37.7647511168143, -122.416438454623) |
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) |
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");