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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |
| 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) | |||
| 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) | ||||
| 76250 | 76250 | 215428 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 20 Lakewood Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5993651.19736 | 2093024.90181 | 37.7266833644367 | -122.464172514845 | (37.7266833644367, -122.464172514845) | |||
| 128240 | 128240 | 215433 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 20 Lakewood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5993594.89235 | 2092910.6701200001 | 37.726366466724 | -122.464358867875 | (37.726366466724, -122.464358867875) | |||
| 136653 | 136653 | 215429 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 20 Lakewood Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5993645.021930001 | 2093008.9273599999 | 37.726639146565 | -122.46419270373801 | (37.726639146565, -122.464192703738) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |
| 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) | |||
| 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) | |||
| 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) | ||
| 101582 | 101582 | 42735 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 2155 Bay Shore Blvd | 4 | 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) | ||
| 109593 | 109593 | 42738 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 2155 Bay Shore Blvd | 3 | 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) | ||
| 112114 | 112114 | 42733 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 2155 Bay Shore Blvd | 5 | 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) | ||
| 117817 | 117817 | 42739 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 2155 Bay Shore Blvd | 7 | 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 146236 | 146236 | 63542 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 2389 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1987 12:00:00 AM | Permit Number 24157 | 6008220.818199201 | 2104530.13411616 | 37.7591031640479 | -122.414619465951 | (37.7591031640479, -122.414619465951) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) |
| 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) |
| 86898 | 86898 | 34083 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 240 Shotwell St | 6 | 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) |
| 98468 | 98468 | 34082 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 240 Shotwell St | 5 | 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) |
| 98537 | 98537 | 34079 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 240 Shotwell St | 2 | 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) |
| 100434 | 100434 | 108225 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 240 Shotwell St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007737.2 | 2106597.0 | 37.764751116814296 | -122.41643845462299 | (37.7647511168143, -122.416438454623) | ||||
| 105965 | 105965 | 108221 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 240 Shotwell St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007737.2 | 2106597.0 | 37.764751116814296 | -122.41643845462299 | (37.7647511168143, -122.416438454623) | ||||
| 118122 | 118122 | 108224 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 240 Shotwell St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007737.2 | 2106597.0 | 37.764751116814296 | -122.41643845462299 | (37.7647511168143, -122.416438454623) | ||||
| 118194 | 118194 | 108227 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 240 Shotwell St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007737.2 | 2106597.0 | 37.764751116814296 | -122.41643845462299 | (37.7647511168143, -122.416438454623) | ||||
| 120475 | 120475 | 108220 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 240 Shotwell St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007737.2 | 2106597.0 | 37.764751116814296 | -122.41643845462299 | (37.7647511168143, -122.416438454623) | ||||
| 126801 | 126801 | 34084 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 240 Shotwell St | 7 | 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) |
| 129363 | 129363 | 108222 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 240 Shotwell St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007737.2 | 2106597.0 | 37.764751116814296 | -122.41643845462299 | (37.7647511168143, -122.416438454623) | ||||
| 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) | ||||
| 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) | ||
| 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) | ||||
| 94918 | 94918 | 42310 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 249 Edna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2000 12:00:00 AM | Permit Number 42531 | 5998732.34943109 | 2093642.59637242 | 37.7286709604577 | -122.446651628377 | (37.7286709604577, -122.446651628377) | |||
| 105310 | 105310 | 42309 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 249 Edna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2000 12:00:00 AM | Permit Number 42531 | 5998732.34943109 | 2093642.59637242 | 37.7286709604577 | -122.446651628377 | (37.7286709604577, -122.446651628377) | |||
| 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) | ||
| 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) | ||
| 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) | |||
| 73993 | 73993 | 241200 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 26 Carl St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5998502.5017 | 2107263.12139 | 37.7660564705643 | -122.448426703328 | (37.7660564705643, -122.448426703328) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 81608 | 81608 | 44006 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 2701X 17th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2015 12:00:00 AM | 3 | Permit Number 43559. Tree 4 on 17th St | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.41044985886299 | (37.7642662704227, -122.410449858863) | ||
| 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) | ||
| 108893 | 108893 | 44008 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 2701X 17th 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 17th St | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.41044985886299 | (37.7642662704227, -122.410449858863) | ||
| 128783 | 128783 | 44007 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 2701X 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2015 12:00:00 AM | 3 | Permit Number 43559. Tree 3 on 17th St | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.41044985886299 | (37.7642662704227, -122.410449858863) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 131633 | 131633 | 241213 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2801 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6009032.16938 | 2106352.76347 | 37.76415323799171 | -122.411942216073 | (37.7641532379917, -122.411942216073) | |||
| 132120 | 132120 | 241214 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2801 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009008.65245 | 2106350.93983 | 37.764146911276704 | -122.41202342575899 | (37.7641469112767, -122.412023425759) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 74241 | 74241 | 241197 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 285 Mullen Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010385.48006 | 2100017.65971 | 37.7468342873856 | -122.406814971529 | (37.7468342873856, -122.406814971529) | |||
| 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) | |||
| 106308 | 106308 | 34076 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 2851X 16th St | 2 | 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) |
| 120751 | 120751 | 34077 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 2851X 16th St | 3 | 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) |
| 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) |
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | |||
| 109031 | 109031 | 136743 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2900 Broderick St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 6000050.877859999 | 2118557.23395 | 37.7971556025074 | -122.44388272313 | (37.7971556025074, -122.44388272313) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) |
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");