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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 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) | |||
| 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) | |||
| 156017 | 156017 | 63197 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 472 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1986 12:00:00 AM | 14 | Permit Number 23738 | 5984415.8334099995 | 2112620.0121299997 | 37.7799494956437 | -122.49754445897301 | (37.7799494956437, -122.497544458973) | |
| 156645 | 156645 | 179959 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 162 Tunnel Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6011901.82986 | 2087473.4551099997 | 37.7124752317148 | -122.400690449024 | (37.7124752317148, -122.400690449024) | |||
| 157293 | 157293 | 60204 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1400 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/1982 12:00:00 AM | 8 | 4x4 | Permit Number 19750 | 6012229.2906 | 2107053.9352 | 37.766257350909704 | -122.400933496957 | (37.7662573509097, -122.400933496957) | |
| 157670 | 157670 | 241194 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 699 Hampshire St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6010150.13435 | 2105098.1288099997 | 37.7607709543248 | -122.4079869968 | (37.7607709543248, -122.4079869968) | |||
| 157728 | 157728 | 215438 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 217 Staples Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 5998696.43814 | 2093778.97623 | 37.7290433761531 | -122.44678558449101 | (37.7290433761531, -122.446785584491) | |||
| 158174 | 158174 | 241187 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 45 Hoff St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 6ft | 6006570.58835 | 2106391.73918 | 37.7641218444722 | -122.420458896575 | (37.7641218444722, -122.420458896575) | |||
| 159781 | 159781 | 197990 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 155 Grace St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6008384.453919999 | 2110216.9376 | 37.774726996282 | -122.414455930021 | (37.774726996282, -122.414455930021) | |||
| 159970 | 159970 | 124330 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 130 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5995934.0004900005 | 2113471.95009 | 37.782957097905395 | -122.457759890544 | (37.7829570979054, -122.457759890544) | |||
| 160016 | 160016 | 241207 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1142 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007609.4952 | 2103000.12596 | 37.754867747762795 | -122.41662533218701 | (37.7548677477628, -122.416625332187) | |||
| 160212 | 160212 | 63573 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1500@Polk Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 6 | Permit Number 49344 | 6006306.38676 | 2118003.57118 | 37.795990216032294 | -122.422197721351 | (37.7959902160323, -122.422197721351) | |
| 160919 | 160919 | 241224 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 44 Museum Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6000710.17183 | 2106760.2697 | 37.764801739133205 | -122.44075476054701 | (37.7648017391332, -122.440754760547) | |||
| 162786 | 162786 | 143059 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 440 GREENWICH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6010738.656 | 2120349.8129 | 37.8026814253217 | -122.40702659346701 | (37.8026814253217, -122.407026593467) | |||
| 162849 | 162849 | 241205 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2389 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6008219.00846 | 2104543.8944099997 | 37.7591408449879 | -122.414626698671 | (37.7591408449879, -122.414626698671) | |||
| 163040 | 163040 | 82715 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1379 Quesada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2009 12:00:00 AM | 11 | 3x3 | Permit Number 52465 | 6016442.9825 | 2093699.9014 | 37.7298240779238 | -122.385428311894 | (37.7298240779238, -122.385428311894) | |
| 164545 | 164545 | 82366 | Significant Tree 6 | Trachycarpus fortunei :: Windmill Palm 31 | 51 Princeton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/28/2005 12:00:00 AM | 9 | 6007564.92616 | 2093725.05049 | 37.7293979446509 | -122.416122630059 | (37.7293979446509, -122.416122630059) | ||
| 164853 | 164853 | 215422 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 15 Fairfield Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5993781.00975 | 2092831.61045 | 37.7261601145848 | -122.46370973814 | (37.7261601145848, -122.46370973814) | |||
| 166430 | 166430 | 179960 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 162 Tunnel Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6011897.9450900005 | 2087458.38855 | 37.7124336452757 | -122.400702818282 | (37.7124336452757, -122.400702818282) | |||
| 166443 | 166443 | 241208 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2801 17th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009151.461180001 | 2106358.27771 | 37.7641750708383 | -122.41153000822901 | (37.7641750708383, -122.411530008229) | |||
| 166782 | 166782 | 36797 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1350 Donner Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | 8 | 3x3 | Permit Number 39527 | 6015213.5435 | 2090847.5562 | 37.721924008003604 | -122.389479539312 | (37.7219240080036, -122.389479539312) | |
| 167445 | 167445 | 215432 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 20 Lakewood Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5993607.07382 | 2092934.5708400002 | 37.7264327944236 | -122.464318491921 | (37.7264327944236, -122.464318491921) | |||
| 168300 | 168300 | 215431 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 20 Lakewood Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5993618.37614 | 2092959.3845099998 | 37.726501578172396 | -122.464281221309 | (37.7265015781724, -122.464281221309) | |||
| 168702 | 168702 | 241202 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 154 Highland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6005836.15299 | 2096624.2788099998 | 37.7372612281114 | -122.42230507703 | (37.7372612281114, -122.42230507703) | |||
| 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) | |||
| 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) | |
| 171952 | 171952 | 241182 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1362 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009519.86871 | 2101254.76714 | 37.7501826387226 | -122.409895500292 | (37.7501826387226, -122.409895500292) | |||
| 172140 | 172140 | 115615 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1400 16th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 4x4 | 6012069.0366 | 2107045.8512 | 37.766226213653 | -122.40148722008699 | (37.766226213653, -122.401487220087) | |||
| 173562 | 173562 | 241186 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 45 Hoff St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 6ft | 6006573.70754 | 2106363.42565 | 37.764044277946205 | -122.42044609832399 | (37.7640442779462, -122.420446098324) | |||
| 173632 | 173632 | 241206 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2387 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6008217.68506 | 2104568.2265 | 37.759207580982 | -122.414632997525 | (37.759207580982, -122.414632997525) | |||
| 174371 | 174371 | 179957 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 162 Tunnel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6011927.1671400005 | 2087557.3453099998 | 37.7127069906044 | -122.40060876447599 | (37.7127069906044, -122.400608764476) | |||
| 174472 | 174472 | 36791 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1350 Donner Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | 9 | 3x3 | Permit Number 39527 | 6015186.7443 | 2090870.701 | 37.7219860731406 | -122.389573793771 | (37.7219860731406, -122.389573793771) | |
| 175277 | 175277 | 241199 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 24 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5998508.2304 | 2107266.01278 | 37.7660647371231 | -122.448407097228 | (37.7660647371231, -122.448407097228) | |||
| 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) | |||
| 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) | |||
| 179138 | 179138 | 36792 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1350 Donner Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | 9 | 3x3 | Permit Number 39527 | 6015166.6448 | 2090882.8824 | 37.7220184063671 | -122.38964412365499 | (37.7220184063671, -122.389644123655) |
| 181600 | 181600 | 241204 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2399 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6008220.32471 | 2104519.20022 | 37.759073114347295 | -122.414620398932 | (37.7590731143473, -122.414620398932) | |||
| 181948 | 181948 | 215424 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 15 Fairfield Way | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5993760.13704 | 2092800.2871 | 37.7260729055276 | -122.463779620842 | (37.7260729055276, -122.463779620842) | |||
| 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) | |||
| 183227 | 183227 | 43754 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 367 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 14 | Permit Number 43390 | 5991197.85001 | 2112958.02747 | 37.781272787853 | -122.474107339564 | (37.781272787853, -122.474107339564) | |
| 185878 | 185878 | 50830 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 621 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/19/2004 12:00:00 AM | 9 | Permit Number 47349 | 6000535.8217 | 2111139.1847 | 37.7768152106013 | -122.441672069607 | (37.7768152106013, -122.441672069607) | ||
| 186537 | 186537 | 182441 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1529 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5985572.6922 | 2104787.172 | 37.7585104674539 | -122.492965288536 | (37.7585104674539, -122.492965288536) | |||
| 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) | |||
| 188342 | 188342 | 70057 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1799 Revere Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/18/1990 12:00:00 AM | 12 | 6014037.2583099995 | 2095146.8497099997 | 37.7336637097057 | -122.393846481427 | (37.7336637097057, -122.393846481427) | ||
| 188528 | 188528 | 246216 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 725 Buena Vista Ave West | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5999835.3063 | 2107870.2944 | 37.7677997276311 | -122.443860441452 | (37.7677997276311, -122.443860441452) | |||
| 188676 | 188676 | 241203 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2399 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6008221.76709 | 2104500.66986 | 37.759022315257894 | -122.414614099173 | (37.7590223152579, -122.414614099173) | |||
| 189124 | 189124 | 179961 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 299 Lathrop Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6012198.832140001 | 2086842.9214 | 37.7107604718955 | -122.399619668515 | (37.7107604718955, -122.399619668515) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 50962 | 50962 | 179971 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 160 Baltimore Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 6ft | 6002384.15556 | 2086207.4195700001 | 37.708463540423104 | -122.43349600315001 | (37.7084635404231, -122.43349600315) | |||
| 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) | |||
| 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) | |||
| 65216 | 65216 | 136751 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1142 Filbert St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 6007453.51921 | 2119553.70533 | 37.8003111329029 | -122.41833837521999 | (37.8003111329029, -122.41833837522) | |||
| 70744 | 70744 | 179963 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 85 South Hill Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 6002963.44574 | 2087110.53022 | 37.7109761365014 | -122.431558338255 | (37.7109761365014, -122.431558338255) | |||
| 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) | |||
| 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) | |||
| 153492 | 153492 | 136750 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1124 Filbert St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 5ft | 6007528.1043 | 2119564.5184299997 | 37.8003450211571 | -122.41808104771299 | (37.8003450211571, -122.418081047713) | |||
| 160717 | 160717 | 197991 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 3419 Jennings St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 6013294.96544 | 2089742.68292 | 37.7187836844998 | -122.396034235213 | (37.7187836844998, -122.396034235213) | ||||
| 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) | |||
| 187402 | 187402 | 179964 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 85 South Hill Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 6002952.82685 | 2087126.8782400002 | 37.7110204227269 | -122.431596206017 | (37.7110204227269, -122.431596206017) | |||
| 30518 | 30518 | 179954 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 40 Tomaso Ct | 1 | : 4 | Tree 1 | Private 1 | 23 | Width 2ft | 6009197.20014 | 2086405.9588 | 37.709392885454 | -122.409963207553 | (37.709392885454, -122.409963207553) | |||
| 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) | |||
| 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) | |||
| 158454 | 158454 | 250756 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2900 Lake St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5986048.1037 | 2114785.2005 | 37.7859900201618 | -122.492057248563 | (37.7859900201618, -122.492057248563) | |||
| 159390 | 159390 | 246465 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 220 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6005035.80445 | 2099919.28541 | 37.746263388739706 | -122.425306657892 | (37.7462633887397, -122.425306657892) | |||
| 162886 | 162886 | 197999 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 828 Jamestown Ave | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 5ft | 6014890.34253 | 2088931.57147 | 37.7166451650195 | -122.39046296391399 | (37.7166451650195, -122.390462963914) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 140792 | 140792 | 94868 | Significant Tree 6 | Trachycarpus fortunei :: Windmill Palm 31 | 51 Princeton St | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 6007547.0 | 2093670.0 | 37.729245779959 | -122.416180705349 | (37.729245779959, -122.416180705349) | |||||
| 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) | ||
| 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) | |
| 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) | |
| 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) | |
| 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) | ||||
| 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) | ||||
| 24481 | 24481 | 117708 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 4001 Clement St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 7ft | 5983029.04687 | 2113077.7485700003 | 37.7811249212832 | -122.50237578006501 | (37.7811249212832, -122.502375780065) | |||
| 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) | |||
| 27769 | 27769 | 215436 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 670 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 5996989.65534 | 2095298.72051 | 37.7331185802561 | -122.452795679095 | (37.7331185802561, -122.452795679095) | |||
| 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) | |||
| 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) | |||
| 35762 | 35762 | 241219 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 4130 Cesar Chavez St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 6003095.93223 | 2100399.3712299997 | 37.7474718059861 | -122.432048772745 | (37.7474718059861, -122.432048772745) | |||
| 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) | |||
| 40655 | 40655 | 197995 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 881 Jamestown Ave | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6014417.48937 | 2089293.51791 | 37.717612756412 | -122.392122692435 | (37.717612756412, -122.392122692435) | |||
| 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) | |||
| 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) | |||
| 59497 | 59497 | 215415 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 484 Faxon Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 5994798.18805 | 2091784.9127099998 | 37.7233446951982 | -122.460117638125 | (37.7233446951982, -122.460117638125) | |||
| 59883 | 59883 | 179956 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 78 Sala Ter | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 6ft | 5998852.5351599995 | 2088480.84158 | 37.7145048379104 | -122.44586505733999 | (37.7145048379104, -122.44586505734) | |||
| 64095 | 64095 | 179955 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 78 Sala Ter | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 6ft | 5998862.1125 | 2088471.1679599998 | 37.7144788232093 | -122.445831259031 | (37.7144788232093, -122.445831259031) | |||
| 64723 | 64723 | 215414 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 423 Flood Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 6ft | 5997954.5929 | 2094069.3346400002 | 37.7297982247933 | -122.449371101191 | (37.7297982247933, -122.449371101191) | |||
| 66969 | 66969 | 241217 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 4130 Cesar Chavez St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 6003092.5802 | 2100398.11558 | 37.7474681682247 | -122.432060274186 | (37.7474681682247, -122.432060274186) | |||
| 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) | |||
| 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) |
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");