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 ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) |
| 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) | |
| 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) | |||
| 93469 | 93469 | 69068 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1407 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1994 12:00:00 AM | Permit Number 33076 | 5991768.06854816 | 2105844.04694914 | 37.76177273191679 | -122.471616117782 | (37.7617727319168, -122.471616117782) | ||
| 94065 | 94065 | 41897 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 2500 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42262 | 6001987.05760353 | 2105790.14936536 | 37.762210660505 | -122.436268917311 | (37.762210660505, -122.436268917311) | ||
| 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) | |||
| 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) | |||
| 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) |
| 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) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) |
| 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) | ||||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |
| 107827 | 107827 | 115617 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1400 16th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6012270.55026102 | 2107054.03832976 | 37.7662599354936 | -122.400790794031 | (37.7662599354936, -122.400790794031) | ||||
| 110007 | 110007 | 115616 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1400 16th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6012270.55026102 | 2107054.03832976 | 37.7662599354936 | -122.400790794031 | (37.7662599354936, -122.400790794031) | ||||
| 59569 | 59569 | 115612 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1400 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 4x4 | 6012209.3182 | 2107055.3618 | 37.7662601539356 | -122.401002678345 | (37.7662601539356, -122.401002678345) | |||
| 42490 | 42490 | 241188 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 419 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6007442.12211 | 2107229.45736 | 37.7664710984984 | -122.417503881697 | (37.7664710984984, -122.417503881697) | |||
| 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) | |||
| 141713 | 141713 | 82360 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 415-421 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2011 12:00:00 AM | 10 | 3x3 | Permit Number 768604 | 6007434.83105048 | 2107262.94030089 | 37.766562624561 | -122.417531473498 | (37.766562624561, -122.417531473498) |
| 145835 | 145835 | 80165 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 415-421 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2011 12:00:00 AM | 10 | 3x3 | Permit Number 768604 | 6007434.83105048 | 2107262.94030089 | 37.766562624561 | -122.417531473498 | (37.766562624561, -122.417531473498) |
| 51881 | 51881 | 197988 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 82 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6012221.12319 | 2107462.35445 | 37.7673783228879 | -122.40099044576 | (37.7673783228879, -122.40099044576) | |||
| 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) | |||
| 110112 | 110112 | 115632 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 55x 15TH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6012114.0 | 2107494.0 | 37.7674592382642 | -122.40136319642001 | (37.7674592382642, -122.40136319642) | ||||
| 42264 | 42264 | 246217 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 725 Buena Vista Ave West | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5999828.0384 | 2107849.3991 | 37.7677419398126 | -122.443884078726 | (37.7677419398126, -122.443884078726) | |||
| 81701 | 81701 | 52306 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 715 Buena Vista Ave West | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/2016 12:00:00 AM | 3 | Permit Number 48465 | 5999876.8 | 2107852.1 | 37.7677521370965 | -122.443715612896 | (37.7677521370965, -122.443715612896) | ||
| 128411 | 128411 | 52305 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 715 Buena Vista Ave West | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/2016 12:00:00 AM | 3 | Permit Number 48465 | 5999876.8 | 2107852.1 | 37.7677521370965 | -122.443715612896 | (37.7677521370965, -122.443715612896) | ||
| 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) | |||
| 72724 | 72724 | 247212 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 800 Duboce Ave | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 6001824.5154099995 | 2108284.91798 | 37.7690514458872 | -122.437009703838 | (37.7690514458872, -122.437009703838) | |||
| 56645 | 56645 | 247209 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 800 Duboce Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 6001860.515269999 | 2108286.6653 | 37.7690582897368 | -122.436885307832 | (37.7690582897368, -122.436885307832) | |||
| 96207 | 96207 | 108286 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1 HENRY ADAMS ST | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6011517.4 | 2108140.5 | 37.769201076268395 | -122.40347225564399 | (37.7692010762684, -122.403472255644) | ||||
| 106980 | 106980 | 108282 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1 HENRY ADAMS ST | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 3x3 | 6011517.4 | 2108140.5 | 37.769201076268395 | -122.40347225564399 | (37.7692010762684, -122.403472255644) | |||
| 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) | ||||
| 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) | |
| 91 | 91 | 241181 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 300 Duboce Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/20/2001 12:00:00 AM | 8 | Width 3ft | Permit Number 43693 | 6004757.3052900005 | 2108409.26199 | 37.7695591257908 | -122.42687421397 | (37.7695591257908, -122.42687421397) | |
| 90 | 90 | 241179 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 300 Duboce Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/20/2001 12:00:00 AM | 7 | Width 3ft | Permit Number 43693 | 6004783.47466 | 2108409.88584 | 37.769562318364 | -122.426783739481 | (37.769562318364, -122.426783739481) | |
| 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) | |
| 101513 | 101513 | 83941 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 60 13th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/2008 12:00:00 AM | 3X3 | Permit Number 50121 | 6008302.41836553 | 2108360.42350377 | 37.7696248364946 | -122.41460830425899 | (37.7696248364946, -122.414608304259) | ||
| 94982 | 94982 | 39859 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 70 13th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/2008 12:00:00 AM | 3x3 | Permit Number 50122 | 6008235.62773227 | 2108364.64558499 | 37.7696326766808 | -122.41483963035499 | (37.7696326766808, -122.414839630355) | ||
| 107863 | 107863 | 39860 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 70 13th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/2008 12:00:00 AM | 3x3 | Permit Number 50122 | 6008235.62773227 | 2108364.64558499 | 37.7696326766808 | -122.41483963035499 | (37.7696326766808, -122.414839630355) | ||
| 118249 | 118249 | 39861 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 70 13th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/2008 12:00:00 AM | 3x3 | Permit Number 50122 | 6008235.62773227 | 2108364.64558499 | 37.7696326766808 | -122.41483963035499 | (37.7696326766808, -122.414839630355) | ||
| 98175 | 98175 | 44261 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 300 Duboce Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2001 12:00:00 AM | Permit Number 43693 | 6004891.25445895 | 2108442.06671817 | 37.769656772496795 | -122.426413224583 | (37.7696567724968, -122.426413224583) | |||
| 109165 | 109165 | 44264 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 300 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2001 12:00:00 AM | Permit Number 43693 | 6004891.25445895 | 2108442.06671817 | 37.769656772496795 | -122.426413224583 | (37.7696567724968, -122.426413224583) | |||
| 116223 | 116223 | 44262 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 300 Duboce Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2001 12:00:00 AM | Permit Number 43693 | 6004891.25445895 | 2108442.06671817 | 37.769656772496795 | -122.426413224583 | (37.7696567724968, -122.426413224583) | |||
| 122492 | 122492 | 44263 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 300 Duboce Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2001 12:00:00 AM | Permit Number 43693 | 6004891.25445895 | 2108442.06671817 | 37.769656772496795 | -122.426413224583 | (37.7696567724968, -122.426413224583) | |||
| 117733 | 117733 | 62050 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 70 13th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/2008 12:00:00 AM | 3x3 | Permit Number 50122 | 6008120.0 | 2108416.0 | 37.769767186200795 | -122.41524321981701 | (37.7697671862008, -122.415243219817) |
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");