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 ▲ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 102992 | 102992 | 34050 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 375 Alabama St | 5 | 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) | ||
| 110283 | 110283 | 34049 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 375 Alabama St | 7 | 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) | ||
| 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) | ||
| 114146 | 114146 | 34047 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 375 Alabama St | 6 | 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) | ||
| 123243 | 123243 | 34051 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 375 Alabama St | 4 | 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) | ||
| 142033 | 142033 | 34048 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 375 Alabama St | 9 | 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 171456 | 171456 | 35380 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 528 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/14/2015 12:00:00 AM | 4 | Permit Number 775347 | 6011191.999009999 | 2105854.03053 | 37.7629047676749 | -122.40443684118799 | (37.7629047676749, -122.404436841188) | |
| 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) |
| 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) |
| 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) |
| 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) |
| 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) | |||
| 98438 | 98438 | 117606 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 420 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002292.2454566 | 2105806.2278627 | 37.7622721434766 | -122.43521453981701 | (37.7622721434766, -122.435214539817) | |||
| 128524 | 128524 | 117607 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 420 Castro St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002292.2454566 | 2105806.2278627 | 37.7622721434766 | -122.43521453981701 | (37.7622721434766, -122.435214539817) | |||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |
| 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) |
| 49851 | 49851 | 197983 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1809 19th St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6012297.3164 | 2105130.82765 | 37.760980720296295 | -122.400563103211 | (37.7609807202963, -122.400563103211) | |||
| 47759 | 47759 | 241195 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 699 Hampshire St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6010149.3192300005 | 2105113.8429400004 | 37.7608140561404 | -122.407990924146 | (37.7608140561404, -122.407990924146) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 37345 | 37345 | 197979 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 601 Wisconsin St | 21 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 6012714.266419999 | 2104668.82572 | 37.759735409279706 | -122.39908861614599 | (37.7597354092797, -122.399088616146) | |||
| 42049 | 42049 | 197980 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 601 Wisconsin St | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 6ft | 6012727.8948800005 | 2104659.33214 | 37.759710101458204 | -122.399040815374 | (37.7597101014582, -122.399040815374) | |||
| 44751 | 44751 | 197981 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 601 Wisconsin St | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 6012726.35291 | 2104657.30852 | 37.759704459115795 | -122.39904600628 | (37.7597044591158, -122.39904600628) | |||
| 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) | |||
| 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) | |
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 28815 | 28815 | 182351 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1501 35th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 0ft | 5985257.4301 | 2104935.3862 | 37.758898980602005 | -122.49406651392 | (37.758898980602, -122.49406651392) | |||
| 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) | ||||
| 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) | |
| 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) | |||
| 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) | |||
| 60023 | 60023 | 241192 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 3630 20th St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 6006049.00576 | 2104357.91631 | 37.7585080370469 | -122.42211840383499 | (37.7585080370469, -122.422118403835) | |||
| 113940 | 113940 | 107411 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 3634 20th St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6006068.0 | 2104353.0 | 37.7584956093101 | -122.422052363883 | (37.7584956093101, -122.422052363883) | ||||
| 50744 | 50744 | 197985 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 669 Mississippi St | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6014155.897999999 | 2104063.80675 | 37.758154390328 | -122.394060332116 | (37.758154390328, -122.394060332116) | |||
| 142933 | 142933 | 63531 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 645 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/10/1987 12:00:00 AM | Permit Number 24143 | 6007924.14567941 | 2104175.72058203 | 37.7581133535123 | -122.41562041035299 | (37.7581133535123, -122.415620410353) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 101783 | 101783 | 47561 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 580 Capp St | 2 | 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) | ||
| 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) | ||
| 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) | ||
| 118491 | 118491 | 106781 | 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 | Permit Number 773142 | 6012276.4 | 2102941.5 | 37.7549681417933 | -122.400481655091 | (37.7549681417933, -122.400481655091) | |||
| 67671 | 67671 | 197984 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1177 De Haro St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6012264.79545 | 2102939.83963 | 37.754962935614294 | -122.40052167053999 | (37.7549629356143, -122.40052167054) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 111471 | 111471 | 52313 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 4400HOFFMAN 24th St | 3 | 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) |
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");