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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 127059 | 127059 | 105484 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 833 Jamestown Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2014 12:00:00 AM | 3x3 | Permit Number 772170 | 6014874.7 | 2088927.9 | 37.7166342161119 | -122.390516776389 | (37.7166342161119, -122.390516776389) | ||
| 139072 | 139072 | 105478 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 833 Jamestown Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2014 12:00:00 AM | 3x3 | Permit Number 772170 | 6014874.7 | 2088927.9 | 37.7166342161119 | -122.390516776389 | (37.7166342161119, -122.390516776389) | ||
| 184470 | 184470 | 195879 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 881 Jamestown Ave | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6014843.010980001 | 2088936.2451799999 | 37.7166553723252 | -122.390626893234 | (37.7166553723252, -122.390626893234) | |||
| 52775 | 52775 | 195878 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 881 Jamestown Ave | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6014756.78586 | 2089043.98437 | 37.716946419018 | -122.39093245857799 | (37.716946419018, -122.390932458578) | |||
| 31864 | 31864 | 195877 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 881 Jamestown Ave | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6014742.2889 | 2089063.14086 | 37.7169982145749 | -122.390983906081 | (37.7169982145749, -122.390983906081) | |||
| 41659 | 41659 | 178541 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 383 Wilde Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6010763.14033 | 2089167.46002 | 37.7170630503084 | -122.404745314969 | (37.7170630503084, -122.404745314969) | |||
| 40118 | 40118 | 195876 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 881 Jamestown Ave | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6014722.93243 | 2089087.3362900002 | 37.7170635763921 | -122.391052502784 | (37.7170635763921, -122.391052502784) | |||
| 131661 | 131661 | 195875 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 881 Jamestown Ave | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6014702.6108099995 | 2089108.4073299998 | 37.717120305646 | -122.39112421743401 | (37.717120305646, -122.391124217434) | |||
| 33749 | 33749 | 71323 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 542 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 14 | 3x3 | 6003533.1657 | 2089339.03151 | 37.7171273913949 | -122.429748095618 | (37.7171273913949, -122.429748095618) | |
| 156168 | 156168 | 195874 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 881 Jamestown Ave | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6014684.01117 | 2089125.40125 | 37.717165935444996 | -122.39118969524799 | (37.717165935445, -122.391189695248) | |||
| 65912 | 65912 | 178540 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 386 Wilde Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6010727.65839 | 2089224.49237 | 37.7172176662453 | -122.40487197278 | (37.7172176662453, -122.40487197278) | |||
| 179725 | 179725 | 195873 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 881 Jamestown Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6014659.9545 | 2089146.17672 | 37.7172216457504 | -122.391274299863 | (37.7172216457504, -122.391274299863) | |||
| 158118 | 158118 | 195872 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 881 Jamestown Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6014642.0829300005 | 2089159.24693 | 37.7172565421344 | -122.391336987109 | (37.7172565421344, -122.391336987109) | |||
| 105029 | 105029 | 105483 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 833 Jamestown Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2014 12:00:00 AM | 3x3 | Permit Number 772170 | 6014353.8 | 2089169.6 | 37.7172689657855 | -122.39233417718201 | (37.7172689657855, -122.392334177182) | ||
| 109271 | 109271 | 105488 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 833 Jamestown Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 772170 | 6014353.8 | 2089169.6 | 37.7172689657855 | -122.39233417718201 | (37.7172689657855, -122.392334177182) | |||
| 122296 | 122296 | 105473 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 833 Jamestown Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2014 12:00:00 AM | 3x3 | Permit Number 772170 | 6014353.8 | 2089169.6 | 37.7172689657855 | -122.39233417718201 | (37.7172689657855, -122.392334177182) | ||
| 152026 | 152026 | 195871 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 881 Jamestown Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6014626.21861 | 2089171.94185 | 37.7172905194175 | -122.391392710014 | (37.7172905194175, -122.391392710014) | |||
| 30709 | 30709 | 195870 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 881 Jamestown Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6014596.38264 | 2089191.2735400002 | 37.7173419444641 | -122.39149719055 | (37.7173419444641, -122.39149719055) | |||
| 139222 | 139222 | 111092 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 801 GONZALEZ DR | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 06/04/2015 12:00:00 AM | 2 | Permit Number 775593 | 5988333.0 | 2089769.0 | 37.717435525652704 | -122.48231868452 | (37.7174355256527, -122.48231868452) | |||
| 111271 | 111271 | 111095 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 841x GONZALEZ DR | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 06/04/2015 12:00:00 AM | 3 | Permit Number 775593 | 5988358.0 | 2089771.0 | 37.7174424713469 | -122.48223241855301 | (37.7174424713469, -122.482232418553) | ||
| 146394 | 146394 | 178605 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 0 Gonzalez Dr | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5988508.8443599995 | 2089780.72483 | 37.71747794624039 | -122.48171173733299 | (37.7174779462404, -122.481711737333) | ||||
| 148106 | 148106 | 178604 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5988124.07873 | 2089803.3530000001 | 37.7175176953569 | -122.48304333649999 | (37.7175176953569, -122.4830433365) | ||||
| 38675 | 38675 | 54001 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 19 Rutland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/1972 12:00:00 AM | 12 | Permit Number 9719 | 6010666.13404 | 2089379.87515 | 37.717640876409604 | -122.405095569414 | (37.7176408764096, -122.405095569414) | ||
| 184602 | 184602 | 54000 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 15 Rutland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/1972 12:00:00 AM | 19 | Permit Number 9718 | 6010673.62628 | 2089402.8086700002 | 37.71770426600779 | -122.40507128591001 | (37.7177042660078, -122.40507128591) | ||
| 163021 | 163021 | 195869 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 881 Jamestown Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6014230.67939 | 2089421.95835 | 37.7179550545644 | -122.392777395286 | (37.7179550545644, -122.392777395286) | |||
| 162229 | 162229 | 195868 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 881 Jamestown Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6014208.61168 | 2089436.1660799999 | 37.7179928404794 | -122.392854667732 | (37.7179928404794, -122.392854667732) | |||
| 135722 | 135722 | 195867 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 881 Jamestown Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6014190.80973 | 2089445.9953 | 37.7180188407662 | -122.392916889096 | (37.7180188407662, -122.392916889096) | |||
| 10510 | 10510 | 1087 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2174 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 5999920.01803 | 2089753.43888 | 37.718059997362396 | -122.442266720544 | (37.7180599973624, -122.442266720544) | |||
| 24035 | 24035 | 178607 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5990327.66617 | 2089955.55198 | 37.7180635775375 | -122.47543773036101 | (37.7180635775375, -122.475437730361) | ||||
| 172969 | 172969 | 195866 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 881 Jamestown Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6014162.83531 | 2089463.80547 | 37.7180661900688 | -122.393014830689 | (37.7180661900688, -122.393014830689) | |||
| 177432 | 177432 | 195865 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 881 Jamestown Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6014137.22595 | 2089483.7511200001 | 37.718119534279296 | -122.39310474668801 | (37.7181195342793, -122.393104746688) | |||
| 181760 | 181760 | 195864 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 881 Jamestown Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6014122.19061 | 2089493.97182 | 37.7181467630545 | -122.393157432565 | (37.7181467630545, -122.393157432565) | |||
| 180107 | 180107 | 195863 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 881 Jamestown Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6014108.38675 | 2089504.7741900003 | 37.7181756573713 | -122.393205902428 | (37.7181756573713, -122.393205902428) | |||
| 10459 | 10459 | 1079 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2133 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 6000101.3096199995 | 2089802.83807 | 37.718205967213 | -122.441643618974 | (37.718205967213, -122.441643618974) | |||
| 44439 | 44439 | 178537 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 641 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6002884.33955 | 2089748.61217 | 37.7182152473007 | -122.43202000794201 | (37.7182152473007, -122.432020007942) | |||
| 38092 | 38092 | 195862 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 881 Jamestown Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6014091.2192400005 | 2089520.09734 | 37.718216777965296 | -122.393266315296 | (37.7182167779653, -122.393266315296) | |||
| 12800 | 12800 | 1083 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2150 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3x3 | 5999998.5130900005 | 2089822.2609599999 | 37.718253440618504 | -122.44200033506901 | (37.7182534406185, -122.442000335069) | |||
| 182581 | 182581 | 195861 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 881 Jamestown Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6014062.44151 | 2089544.1547299998 | 37.718281235976 | -122.39336747103901 | (37.718281235976, -122.393367471039) | |||
| 10491 | 10491 | 1075 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2119 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 6000135.00359 | 2089836.3366200002 | 37.7182998663217 | -122.44152955615299 | (37.7182998663217, -122.441529556153) | ||||
| 165879 | 165879 | 195860 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 881 Jamestown Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6014042.40973 | 2089558.52381 | 37.7183195776565 | -122.393437718003 | (37.7183195776565, -122.393437718003) | |||
| 13175 | 13175 | 1076 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2124 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | 6000057.48494 | 2089881.91046 | 37.7184205850222 | -122.441800773687 | (37.7184205850222, -122.441800773687) | |||
| 50055 | 50055 | 178539 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 490 Harkness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010199.09845 | 2089695.50908 | 37.7184814223664 | -122.406732139473 | (37.7184814223664, -122.406732139473) | |||
| 10562 | 10562 | 1073 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2118 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | 6000085.1139 | 2089908.73955 | 37.7184958258874 | -122.44170719653201 | (37.7184958258874, -122.441707196532) | |||
| 92233 | 92233 | 111089 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 10x HIGUERA AVE | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 08/30/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777485 | 5988057.0 | 2090190.0 | 37.7185754269376 | -122.483303520979 | (37.7185754269376, -122.483303520979) | |
| 21948 | 21948 | 413 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3854 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/25/1994 12:00:00 AM | 8 | 2X3 | 5990824.06176 | 2090161.99601 | 37.7186591841634 | -122.47373697479401 | (37.7186591841634, -122.473736974794) | ||
| 116026 | 116026 | 1065 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2071X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6000361.32249 | 2090050.85473 | 37.7189017758401 | -122.440762648624 | (37.7189017758401, -122.440762648624) | |||
| 172380 | 172380 | 178532 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2077 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6000360.4691699995 | 2090050.99345 | 37.7189021081373 | -122.440765608152 | (37.7189021081373, -122.440765608152) | |||
| 109545 | 109545 | 111090 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 28x HIGUERA AVE | 1 | Median : Yard 3 | Tree 1 | Private 1 | 06/04/2015 12:00:00 AM | 3 | Permit Number 777485 | 5987903.0 | 2090420.0 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | ||
| 12553 | 12553 | 1045 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2003X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6000641.86431 | 2090326.5948 | 37.719674868584704 | -122.43981268741999 | (37.7196748685847, -122.43981268742) | |||
| 125203 | 125203 | 114389 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 345x ARBALLO DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 5988176.0 | 2090635.0 | 37.7198042094326 | -122.48292478788 | (37.7198042094326, -122.48292478788) | ||||
| 172686 | 172686 | 200224 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3098 Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6014365.7136 | 2090125.8044 | 37.719895176072605 | -122.392359839359 | (37.7198951760726, -122.392359839359) | |||
| 30367 | 30367 | 200223 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3098 Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6014379.7223 | 2090145.2948 | 37.7199494707461 | -122.392312778235 | (37.7199494707461, -122.392312778235) | |||
| 70067 | 70067 | 178621 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2000 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6000618.20182 | 2090428.8464900001 | 37.7199542816414 | -122.439901807531 | (37.7199542816414, -122.439901807531) | |||
| 142119 | 142119 | 1043 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2000 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X5 | 6000617.15273 | 2090448.0855 | 37.7200070478885 | -122.43990681257799 | (37.7200070478885, -122.439906812578) | |||
| 147050 | 147050 | 200222 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3098 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6014396.7763 | 2090173.3121 | 37.7200273476772 | -122.39225578645299 | (37.7200273476772, -122.392255786453) | |||
| 152316 | 152316 | 200221 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3098 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6014405.3033 | 2090186.1027 | 37.7200629416077 | -122.392227205373 | (37.7200629416077, -122.392227205373) | |||
| 13520 | 13520 | 29553 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3000X Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6014413.8304 | 2090200.1114 | 37.7201018801983 | -122.39219870906601 | (37.7201018801983, -122.392198709066) | |||
| 14160 | 14160 | 29552 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3000X Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6014430.2753 | 2090217.7745 | 37.720151292667495 | -122.392143098776 | (37.7201512926675, -122.392143098776) | |||
| 103182 | 103182 | 29554 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3030 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6014438.8118347 | 2090233.7051406002 | 37.7201955090298 | -122.39211470411699 | (37.7201955090298, -122.392114704117) | |||
| 114413 | 114413 | 29555 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3030 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6014438.8118347 | 2090233.7051406002 | 37.7201955090298 | -122.39211470411699 | (37.7201955090298, -122.392114704117) | |||
| 120833 | 120833 | 29558 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3030 Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6014438.8118347 | 2090233.7051406002 | 37.7201955090298 | -122.39211470411699 | (37.7201955090298, -122.392114704117) | |||
| 15135 | 15135 | 29551 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3000X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6014443.0659 | 2090235.4376 | 37.720200502216294 | -122.39210012020901 | (37.7202005022163, -122.392100120209) | |||
| 149833 | 149833 | 200203 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3000 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6014458.9018 | 2090257.3642 | 37.720261587554205 | -122.392046912905 | (37.7202615875542, -122.392046912905) | |||
| 102131 | 102131 | 29550 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3000X Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6014485.674235599 | 2090296.5698245 | 37.7203707248314 | -122.391957108854 | (37.7203707248314, -122.391957108854) | |||
| 87417 | 87417 | 94437 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3711@533 Gonzalez 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2010 12:00:00 AM | 32 | Permit Number 53664 | 5990297.3 | 2090806.0 | 37.7203969366505 | -122.475604756889 | (37.7203969366505, -122.475604756889) | ||
| 80722 | 80722 | 1026 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1955X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6000855.2579 | 2090665.6856099998 | 37.7206180798117 | -122.439099353738 | (37.7206180798117, -122.439099353738) | |||
| 10666 | 10666 | 108381 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 204 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773815 | 6001936.176109999 | 2090655.40431 | 37.7206512958141 | -122.435362229505 | (37.7206512958141, -122.435362229505) |
| 84041 | 84041 | 114392 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 104x TAPIA DR | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 10 | 5988688.0 | 2090939.0 | 37.72066869526729 | -122.481177253578 | (37.7206686952673, -122.481177253578) | ||||
| 166073 | 166073 | 211987 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 951 Junipero Serra Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5991283.96245 | 2090948.88613 | 37.7208464163014 | -122.472204628055 | (37.7208464163014, -122.472204628055) | |||
| 70308 | 70308 | 178533 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1971 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 2ft | 6000911.61584 | 2090780.99233 | 37.7209378926573 | -122.438912801483 | (37.7209378926573, -122.438912801483) | |||
| 62159 | 62159 | 178536 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2134 San Jose Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 3ft | 5998755.19209 | 2090916.21978 | 37.7211862692206 | -122.44637660699499 | (37.7211862692206, -122.446376606995) | |||
| 34933 | 34933 | 178535 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2134 San Jose Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5998787.03696 | 2090942.1024 | 37.7212591556762 | -122.446268389794 | (37.7212591556762, -122.446268389794) | |||
| 59357 | 59357 | 178534 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2134 San Jose Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5998794.56221 | 2090951.4910799998 | 37.721285364599204 | -122.446243052271 | (37.7212853645992, -122.446243052271) | |||
| 41219 | 41219 | 211988 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 951 Junipero Serra Blvd | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5991299.375030001 | 2091144.62881 | 37.7213847693696 | -122.47216561275299 | (37.7213847693696, -122.472165612753) | |||
| 44181 | 44181 | 11759 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 901X Junipero Serra Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x5 | 5991288.1161497 | 2091224.4470027 | 37.7216032788517 | -122.472210346501 | (37.7216032788517, -122.472210346501) | |||
| 126341 | 126341 | 11756 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 901X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X5 | 5991288.1161497 | 2091224.4470027 | 37.7216032788517 | -122.472210346501 | (37.7216032788517, -122.472210346501) | |||
| 96525 | 96525 | 96881 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2200X San Jose Ave | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5998886.2 | 2091075.7 | 37.7216316467069 | -122.445935216513 | (37.7216316467069, -122.445935216513) | |||||
| 102506 | 102506 | 96880 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2200X San Jose Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2011 12:00:00 AM | 5998886.2 | 2091075.7 | 37.7216316467069 | -122.445935216513 | (37.7216316467069, -122.445935216513) | ||||
| 81509 | 81509 | 106258 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 205 GRANADA AVE | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | 4x4 | 5995602.7 | 2091290.9 | 37.722034494846895 | -122.457300887551 | (37.7220344948469, -122.457300887551) | |||
| 119445 | 119445 | 88345 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 347 Vienna St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51330 | 6003917.0 | 2091407.0 | 37.7228273068445 | -122.428568687279 | (37.7228273068445, -122.428568687279) | |||
| 157618 | 157618 | 178636 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 371 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6003616.32219 | 2091419.98171 | 37.7228459311798 | -122.42960899208401 | (37.7228459311798, -122.429608992084) | |||
| 168194 | 168194 | 178635 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 347 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6003933.72351 | 2091415.2294700001 | 37.72285084955671 | -122.42851146394199 | (37.7228508495567, -122.428511463942) | |||
| 158417 | 158417 | 201998 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 200 Paul Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6012853.60662 | 2091263.9911900002 | 37.7229363247465 | -122.397666492108 | (37.7229363247465, -122.397666492108) | |||
| 32371 | 32371 | 201999 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 200 Paul Ave | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6012837.45496 | 2091269.25359 | 37.7229498748073 | -122.397722694373 | (37.7229498748073, -122.397722694373) | |||
| 24869 | 24869 | 202000 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 200 Paul Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6012773.51606 | 2091290.0244900002 | 37.7230033467173 | -122.397945175839 | (37.7230033467173, -122.397945175839) | |||
| 73247 | 73247 | 202001 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 200 Paul Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6012749.41946 | 2091296.9164 | 37.7230209284511 | -122.398028956696 | (37.7230209284511, -122.398028956696) | |||
| 156709 | 156709 | 202002 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 200 Paul Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6012728.61586 | 2091304.05924 | 37.7230393825427 | -122.398101371875 | (37.7230393825427, -122.398101371875) | |||
| 51340 | 51340 | 202003 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 200 Paul Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6012704.69846 | 2091311.94783 | 37.7230597108282 | -122.398184603239 | (37.7230597108282, -122.398184603239) | |||
| 24634 | 24634 | 202004 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 200 Paul Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6012681.9088 | 2091316.93525 | 37.7230721358484 | -122.398263732799 | (37.7230721358484, -122.398263732799) | |||
| 47821 | 47821 | 211986 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 De Montfort Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5995007.309090001 | 2091908.61395 | 37.7236963750783 | -122.459403705022 | (37.7236963750783, -122.459403705022) | |||
| 154247 | 154247 | 211985 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 De Montfort Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5995023.16483 | 2091909.8583400003 | 37.7237007035157 | -122.45934898488701 | (37.7237007035157, -122.459348984887) | |||
| 109280 | 109280 | 11700 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 799X Junipero Serra Blvd | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | |||
| 52778 | 52778 | 178631 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 661 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6010974.0949800005 | 2091668.9858400002 | 37.723943515975 | -122.404192100612 | (37.723943515975, -122.404192100612) | |||
| 175474 | 175474 | 211984 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1215 Capitol Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5995042.93975 | 2091999.53532 | 37.7239480719295 | -122.459287117821 | (37.7239480719295, -122.459287117821) | |||
| 163248 | 163248 | 178632 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 649 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6010957.7594800005 | 2091720.88481 | 37.724085107030604 | -122.404252221185 | (37.7240851070306, -122.404252221185) | |||
| 77145 | 77145 | 178633 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 649 Brussels St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6010954.35314 | 2091735.9375200002 | 37.72412624831829 | -122.404265055401 | (37.7241262483183, -122.404265055401) | |||
| 10868 | 10868 | 1003 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1750 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6001350.47669 | 2091970.9547 | 37.7242302198351 | -122.43748096390101 | (37.7242302198351, -122.437480963901) | |||
| 78239 | 78239 | 1002 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1731 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 27 | 3X3 | 6001471.07065 | 2092002.59485 | 37.724323951976 | -122.437066353202 | (37.724323951976, -122.437066353202) | |||
| 73781 | 73781 | 178634 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 619 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6010918.94664 | 2091849.32517 | 37.724435608804896 | -122.404395428331 | (37.7244356088049, -122.404395428331) | |||
| 110324 | 110324 | 999 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1725 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | 6001467.99656 | 2092045.3572200001 | 37.724441193017796 | -122.43708004004499 | (37.7244411930178, -122.437080040045) |
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");