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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 423 | 423 | 109554 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300x Van Ness Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6006839.87541 | 2111919.81075 | 37.7793157843461 | -122.41991981597201 | (37.7793157843461, -122.419919815972) | |||
| 476 | 476 | 174954 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400x Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4xt | Permit Number 779898 | 6007316.0 | 2110809.0 | 37.776292577113104 | -122.418193923043 | (37.7762925771131, -122.418193923043) | |||
| 537 | 537 | 195070 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1532 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008830.0 | 2108632.0 | 37.7704001487298 | -122.41280261366998 | (37.7704001487298, -122.41280261367) | |||
| 567 | 567 | 195068 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1532 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008830.0 | 2108632.0 | 37.7704001487298 | -122.41280261366998 | (37.7704001487298, -122.41280261367) | |||
| 761 | 761 | 195041 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 402 06th St | 1 | : 4 | Tree 1 | DPW 2 | 28 | Width 3ft | 6011480.36813 | 2111044.01847 | 37.777171403968296 | -122.40380468436199 | (37.7771714039683, -122.403804684362) | |||
| 777 | 777 | 234744 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2455 15th St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12 | Width 3ft | 6001486.4222099995 | 2107220.2274599997 | 37.766108846174795 | -122.438102867577 | (37.7661088461748, -122.438102867577) | |||
| 861 | 861 | 109545 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300x Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6006870.4118800005 | 2111707.44564 | 37.778734401395205 | -122.419799104459 | (37.7787344013952, -122.419799104459) | |||
| 1284 | 1284 | 235428 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2869 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/09/2016 12:00:00 AM | 3 | 3x3 | 6010306.81938 | 2100635.6894799997 | 37.74852686004171 | -122.40713053105101 | (37.7485268600417, -122.407130531051) | ||
| 1285 | 1285 | 234575 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2990 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/09/2016 12:00:00 AM | 3 | Width 3ft | 6009677.1610900005 | 2100624.0529099996 | 37.7484596510092 | -122.409307067568 | (37.7484596510092, -122.409307067568) | ||
| 1291 | 1291 | 234571 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2892 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/09/2017 12:00:00 AM | 3 | 3x4 | 6010196.53099 | 2100680.54575 | 37.7486438528311 | -122.407515070373 | (37.7486438528311, -122.407515070373) | ||
| 1318 | 1318 | 100805 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2429 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6002563.2899400005 | 2116751.5140400003 | 37.79234055221529 | -122.43505995207899 | (37.7923405522153, -122.435059952079) | |||
| 1429 | 1429 | 102682 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2100 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 4x4 | 6001423.65551 | 2115717.83054 | 37.7894375487454 | -122.438928994703 | (37.7894375487454, -122.438928994703) | |||
| 1733 | 1733 | 200858 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1133 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6008786.0 | 2112009.0 | 37.7796701249263 | -122.413193644333 | (37.7796701249263, -122.413193644333) | |||
| 1740 | 1740 | 200859 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1133 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6008786.0 | 2112009.0 | 37.7796701249263 | -122.413193644333 | (37.7796701249263, -122.413193644333) | |||
| 1753 | 1753 | 134350 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 838 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6010747.0 | 2114018.0 | 37.7852962621335 | -122.40655126994301 | (37.7852962621335, -122.406551269943) | |||
| 1888 | 1888 | 100797 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2471 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002362.24857 | 2116725.90576 | 37.7922588209311 | -122.435753725979 | (37.7922588209311, -122.435753725979) | |||
| 1964 | 1964 | 238618 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 4302 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 14 | Width 4ft | 6001078.53558 | 2101746.02342 | 37.751054810249 | -122.439121284114 | (37.751054810249, -122.439121284114) | |||
| 1974 | 1974 | 238616 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 4302 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 23 | Width 4ft | 6001186.94921 | 2101750.3744 | 37.7510729252903 | -122.43874669133301 | (37.7510729252903, -122.438746691333) | |||
| 1975 | 1975 | 238619 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 4302 24th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 23 | Width 4ft | 6001066.93276 | 2101745.60422 | 37.7510529990026 | -122.43916137771099 | (37.7510529990026, -122.439161377711) | |||
| 2070 | 2070 | 109552 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300x Van Ness Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6006854.31545 | 2111807.2543900004 | 37.7790075453087 | -122.419861872643 | (37.7790075453087, -122.419861872643) | |||
| 2096 | 2096 | 200850 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1411 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6007584.0 | 2110630.0 | 37.77581616716321 | -122.417254147161 | (37.7758161671632, -122.417254147161) | |||
| 2108 | 2108 | 98580 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 370 Drumm St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2017 12:00:00 AM | 3 | 3x3 | 6013585.68076 | 2118314.1263900003 | 37.7972508218322 | -122.397031561762 | (37.7972508218322, -122.397031561762) | ||
| 2299 | 2299 | 253020 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 760 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004216.0 | 2110862.0 | 37.7762631241711 | -122.42892145951299 | (37.7762631241711, -122.428921459513) | ||||
| 2303 | 2303 | 122440 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 599X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | Permit Number 778941 | 6013669.1059 | 2114077.4124 | 37.785622440131 | -122.39644576664499 | (37.785622440131, -122.396445766645) | ||
| 2305 | 2305 | 201174 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 599X Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | Permit Number 778941 | 6013723.602999999 | 2114126.7683 | 37.785760992593296 | -122.396260681537 | (37.7857609925933, -122.396260681537) | ||
| 2306 | 2306 | 195019 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X 02nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6013637.791730001 | 2113971.74755 | 37.785330566207705 | -122.396546695873 | (37.7853305662077, -122.396546695873) | |||
| 2307 | 2307 | 122432 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 598X Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | Permit Number 778941 | 6013714.3488 | 2114207.9998 | 37.7859835205848 | -122.396298394128 | (37.7859835205848, -122.396298394128) | ||
| 2309 | 2309 | 122433 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 598X Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 4x4 | Permit Number 778941 | 6013698.925 | 2114193.6044 | 37.785943135879 | -122.396350747311 | (37.785943135879, -122.396350747311) | ||
| 2313 | 2313 | 201193 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 611 Folsom St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | Permit Number 778941 | 6013579.6483 | 2113996.1808 | 37.7853944182999 | -122.39674956946399 | (37.7853944182999, -122.396749569464) | ||
| 2315 | 2315 | 195022 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X 02nd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6013709.75083 | 2113894.09551 | 37.785121356022394 | -122.39629229296001 | (37.7851213560224, -122.39629229296) | |||
| 2319 | 2319 | 201172 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 599X Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | Permit Number 778941 | 6013687.6143 | 2114096.9491 | 37.785677113353294 | -122.396383102325 | (37.7856771133533, -122.396383102325) | ||
| 2323 | 2323 | 201173 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 599X Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | Permit Number 778941 | 6013705.0945 | 2114111.3445 | 37.7857176125048 | -122.39632363473801 | (37.7857176125048, -122.396323634738) | ||
| 2324 | 2324 | 195018 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X 02nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | Permit Number 778941 | 6013610.320719999 | 2113989.12597 | 37.7853767544813 | -122.39664295660499 | (37.7853767544813, -122.396642956605) | ||
| 2331 | 2331 | 122431 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 598X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 4x4 | Permit Number 778941 | 6013729.7725 | 2114223.4236 | 37.786026729010295 | -122.396246113338 | (37.7860267290103, -122.396246113338) | ||
| 2332 | 2332 | 122438 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 598X Folsom St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 4x4 | Permit Number 778941 | 6013622.8347 | 2114119.5705 | 37.785735621476 | -122.396608809095 | (37.785735621476, -122.396608809095) | ||
| 2334 | 2334 | 122437 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 598X Folsom St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 4x4 | Permit Number 778941 | 6013638.2584 | 2114134.9942 | 37.7857788297664 | -122.396556528653 | (37.7857788297664, -122.396556528653) | ||
| 2335 | 2335 | 195021 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X 02nd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6013679.6407 | 2113928.34961 | 37.7852137343684 | -122.396398867136 | (37.7852137343684, -122.396398867136) | |||
| 2336 | 2336 | 195020 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X 02nd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6013662.142659999 | 2113947.50545 | 37.785265358143896 | -122.39646074858601 | (37.7852653581439, -122.396460748586) | |||
| 2337 | 2337 | 122436 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 598X Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4x4 | Permit Number 778941 | 6013651.6256 | 2114147.3332 | 37.7858134537143 | -122.39651114681001 | (37.7858134537143, -122.39651114681) | ||
| 2343 | 2343 | 195028 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X 02nd St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6013774.91802 | 2113824.49769 | 37.7849338824287 | -122.396061954106 | (37.7849338824287, -122.396061954106) | |||
| 2344 | 2344 | 122435 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 598X Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 4x4 | Permit Number 778941 | 6013667.0494 | 2114164.8134 | 37.785862308640105 | -122.396459010111 | (37.7858623086401, -122.396459010111) | ||
| 2347 | 2347 | 195023 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X 02nd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6013717.57682 | 2113887.99977 | 37.785105053996396 | -122.396264789902 | (37.7851050539964, -122.396264789902) | |||
| 2350 | 2350 | 122434 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 598X Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 4x4 | Permit Number 778941 | 6013681.4448 | 2114180.2371 | 37.7859054596404 | -122.39641028715201 | (37.7859054596404, -122.396410287152) | ||
| 2351 | 2351 | 201241 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 598 Folsom St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | Permit Number 778941 | 6013597.1285 | 2114096.9491 | 37.78567207766061 | -122.396696159476 | (37.7856720776606, -122.396696159476) | ||
| 2352 | 2352 | 195026 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X 02nd St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6013748.5801800005 | 2113848.78027 | 37.7849990913834 | -122.39615477762301 | (37.7849990913834, -122.396154777623) | |||
| 2355 | 2355 | 195025 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X 02nd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6013739.901380001 | 2113861.81988 | 37.7850344122501 | -122.396185717917 | (37.7850344122501, -122.396185717917) | |||
| 2358 | 2358 | 195024 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X 02nd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6013723.336209999 | 2113877.98804 | 37.785077884566604 | -122.39624416214 | (37.7850778845666, -122.39624416214) | |||
| 2359 | 2359 | 195027 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X 02nd St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6013762.26581 | 2113837.6181400004 | 37.784969204212295 | -122.396106646824 | (37.7849692042123, -122.396106646824) | |||
| 2360 | 2360 | 122439 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 598X Folsom St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 4x4 | Permit Number 778941 | 6013610.4957 | 2114107.2315 | 37.7857010547146 | -122.39665063354099 | (37.7857010547146, -122.396650633541) | ||
| 2622 | 2622 | 238126 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3388 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2017 02:38:00 PM | 3 | Width 3ft | 6006363.87344 | 2106134.73006 | 37.7634045065344 | -122.421155613935 | (37.7634045065344, -122.421155613935) | ||
| 2686 | 2686 | 234760 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 252 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6004468.902369999 | 2109137.1444099997 | 37.77154140335671 | -122.427923663451 | (37.7715414033567, -122.427923663451) | |||
| 2690 | 2690 | 126183 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1451 Bay St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003793.92894 | 2120715.46368 | 37.803294337014606 | -122.431084963893 | (37.8032943370146, -122.431084963893) | |||
| 2733 | 2733 | 253189 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99x The Embarcadero | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014645.0 | 2117171.0 | 37.794170975650296 | -122.393285986986 | (37.7941709756503, -122.393285986986) | ||||
| 2735 | 2735 | 253188 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99x The Embarcadero | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014645.0 | 2117171.0 | 37.794170975650296 | -122.393285986986 | (37.7941709756503, -122.393285986986) | ||||
| 2737 | 2737 | 253186 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99x The Embarcadero | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014645.0 | 2117171.0 | 37.794170975650296 | -122.393285986986 | (37.7941709756503, -122.393285986986) | ||||
| 2738 | 2738 | 253184 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99x The Embarcadero | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014645.0 | 2117171.0 | 37.794170975650296 | -122.393285986986 | (37.7941709756503, -122.393285986986) | ||||
| 2739 | 2739 | 253185 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99x The Embarcadero | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014645.0 | 2117171.0 | 37.794170975650296 | -122.393285986986 | (37.7941709756503, -122.393285986986) | ||||
| 2741 | 2741 | 253190 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99x The Embarcadero | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014645.0 | 2117171.0 | 37.794170975650296 | -122.393285986986 | (37.7941709756503, -122.393285986986) | ||||
| 2744 | 2744 | 253187 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99x The Embarcadero | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014645.0 | 2117171.0 | 37.794170975650296 | -122.393285986986 | (37.7941709756503, -122.393285986986) | ||||
| 2767 | 2767 | 252950 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 261x Winding Way | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | Permit Number 780594 | 6001774.0 | 2086449.0 | 37.7090922302752 | -122.435622042553 | (37.7090922302752, -122.435622042553) | |||
| 2772 | 2772 | 252949 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 261x Winding Way | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | Permit Number 780594 | 6001774.0 | 2086449.0 | 37.7090922302752 | -122.435622042553 | (37.7090922302752, -122.435622042553) | |||
| 3632 | 3632 | 122539 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3443 Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Permit Number 779060 | 5998247.97366 | 2115501.74936 | 37.788663053514 | -122.44990087023001 | (37.788663053514, -122.44990087023) | ||
| 4013 | 4013 | 253610 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1075 Mission St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 4ft | 6009725.02676 | 2112060.52163 | 37.7798642637711 | -122.40994876804 | (37.7798642637711, -122.40994876804) | ||||
| 4471 | 4471 | 100799 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2455 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6002438.67863 | 2116735.02721 | 37.7922882071812 | -122.435489929626 | (37.7922882071812, -122.435489929626) | |||
| 4567 | 4567 | 109546 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300x Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6006868.4272 | 2111721.79621 | 37.778773692788 | -122.419806988803 | (37.778773692788, -122.419806988803) | |||
| 4621 | 4621 | 122573 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2014 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 6003898.8446 | 2115409.2515 | 37.7887307847056 | -122.430343093484 | (37.7887307847056, -122.430343093484) | |||
| 4639 | 4639 | 102681 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2100 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 4x4 | 6001426.627069999 | 2115693.54787 | 37.7893710438761 | -122.43891697256399 | (37.7893710438761, -122.438916972564) | |||
| 4715 | 4715 | 103364 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1171X Sacramento St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Rec/Park 7 | 3 | 3x3 | 6009173.30525 | 2116699.27717 | 37.79257023366971 | -122.412185363057 | (37.7925702336697, -122.412185363057) | ||
| 4730 | 4730 | 234655 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 437 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 6x12 | 6002991.56268 | 2105705.90685 | 37.762036373292 | -122.432788699846 | (37.762036373292, -122.432788699846) | |||
| 5139 | 5139 | 235614 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 573 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006249.0 | 2106283.0 | 37.7638051443341 | -122.421563455709 | (37.7638051443341, -122.421563455709) | |||
| 5166 | 5166 | 235615 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 573 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006249.0 | 2106283.0 | 37.7638051443341 | -122.421563455709 | (37.7638051443341, -122.421563455709) | |||
| 5330 | 5330 | 103513 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1859 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6004155.22179 | 2118342.1254 | 37.7967982290065 | -122.429665326519 | (37.7967982290065, -122.429665326519) | |||
| 5346 | 5346 | 109550 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300x Van Ness Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6006859.56746 | 2111778.81942 | 37.778929765630295 | -122.41984168553999 | (37.7789297656303, -122.41984168554) | |||
| 5354 | 5354 | 109556 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300x Van Ness Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6006837.67499 | 2111950.4922 | 37.7793999042174 | -122.41992960596501 | (37.7793999042174, -122.419929605965) | |||
| 5376 | 5376 | 112253 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3401 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5998472.27762 | 2115859.72352 | 37.789658787381796 | -122.449150614422 | (37.7896587873818, -122.449150614422) | |||
| 5398 | 5398 | 98494 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2820 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 5999556.928169999 | 2118555.98315 | 37.79712398054429 | -122.44559181541099 | (37.7971239805443, -122.445591815411) | |||
| 5470 | 5470 | 100796 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2477 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6002339.98716 | 2116721.3494700002 | 37.79224504601171 | -122.43583042464199 | (37.7922450460117, -122.435830424642) | |||
| 5609 | 5609 | 105280 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3017 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6002863.14914 | 2118997.09169 | 37.7985233499191 | -122.43418303843399 | (37.7985233499191, -122.434183038434) | |||
| 5610 | 5610 | 109560 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300x Van Ness Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6006827.8052900005 | 2112008.26753 | 37.7795579852454 | -122.41996785053101 | (37.7795579852454, -122.419967850531) | |||
| 5640 | 5640 | 79352 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2909 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2001 12:00:00 AM | 8 | 3x3 | 5999487.033 | 2114286.0485 | 37.785395874336 | -122.445526470028 | (37.785395874336, -122.445526470028) | |
| 5817 | 5817 | 103362 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1171X Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Rec/Park 7 | 12 | 3x3 | 6009111.87446 | 2116690.2667799997 | 37.7925420462198 | -122.41239727931601 | (37.7925420462198, -122.412397279316) | ||
| 5857 | 5857 | 99700 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1412 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 4x4 | 6007375.87378 | 2117463.43004 | 37.794567388720296 | -122.41845876116301 | (37.7945673887203, -122.418458761163) | |||
| 5882 | 5882 | 109553 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300x Van Ness Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6006853.14044 | 2111821.07903 | 37.7790454382325 | -122.41986691873801 | (37.7790454382325, -122.419866918738) | |||
| 6038 | 6038 | 103363 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1171X Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Rec/Park 7 | 12 | 3x3 | 6009142.2805 | 2116694.47646 | 37.79255531122121 | -122.412292370693 | (37.7925553112212, -122.412292370693) | ||
| 6077 | 6077 | 100804 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2429 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6002544.40656 | 2116747.89129 | 37.7923295328255 | -122.435125029709 | (37.7923295328255, -122.435125029709) | |||
| 6124 | 6124 | 100807 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2401 Jackson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002634.35526 | 2116761.0817299997 | 37.7923708575934 | -122.4348147492 | (37.7923708575934, -122.4348147492) | |||
| 6227 | 6227 | 113069 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3108 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6002430.41421 | 2118968.02976 | 37.7984189836099 | -122.43567835378 | (37.7984189836099, -122.43567835378) | |||
| 6245 | 6245 | 100808 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2401 Jackson St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002651.17595 | 2116762.40631 | 37.7923754495237 | -122.43475664402399 | (37.7923754495237, -122.434756644024) | |||
| 6438 | 6438 | 113068 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3108 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6002431.85216 | 2118952.17162 | 37.7983755229712 | -122.43567224288799 | (37.7983755229712, -122.435672242888) | |||
| 6502 | 6502 | 110596 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 624 Taylor St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/12/2015 12:00:00 AM | 3 | 2x2 | 6009279.98912 | 2115129.5633 | 37.7882661656083 | -122.411705268989 | (37.7882661656083, -122.411705268989) | ||
| 6622 | 6622 | 103365 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1171X Sacramento St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Rec/Park 7 | 12 | 3x3 | 6009208.54849 | 2116702.7837799997 | 37.7925818394263 | -122.412063667702 | (37.7925818394263, -122.412063667702) | ||
| 6629 | 6629 | 100806 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2401 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6002616.18496 | 2116759.45065 | 37.7923653474383 | -122.434877502118 | (37.7923653474383, -122.434877502118) | |||
| 6677 | 6677 | 121686 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1653 Grant Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6010468.2399 | 2120204.652 | 37.8022677132519 | -122.4079521316 | (37.8022677132519, -122.4079521316) | |||
| 6798 | 6798 | 109547 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300x Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6006862.63225 | 2111739.40495 | 37.7788217156763 | -122.419828285662 | (37.7788217156763, -122.419828285662) | |||
| 6831 | 6831 | 101231 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3575 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | 3x3 | Permit Number 779254 | 5997777.0237 | 2115106.06857 | 37.7875496613457 | -122.451501728247 | (37.7875496613457, -122.451501728247) | ||
| 6848 | 6848 | 100798 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2469 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6002394.5470900005 | 2116728.58205 | 37.7922680039076 | -122.435642164168 | (37.7922680039076, -122.435642164168) | |||
| 6916 | 6916 | 102685 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2138 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 4x4 | 6001402.82307 | 2115865.31916 | 37.7898413290661 | -122.43901164686399 | (37.7898413290661, -122.439011646864) | |||
| 7073 | 7073 | 112426 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2811 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6000627.2120900005 | 2116484.87099 | 37.7914982957465 | -122.441739663868 | (37.7914982957465, -122.441739663868) | |||
| 7147 | 7147 | 102684 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2100 Scott St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 4x4 | 6001417.230930001 | 2115753.64679 | 37.78953552537921 | -122.438953790804 | (37.7895355253792, -122.438953790804) | |||
| 7337 | 7337 | 106720 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1447 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5999672.1743 | 2113882.1261 | 37.7842973761464 | -122.44485689337401 | (37.7842973761464, -122.444856893374) |
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");