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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
137150 | 137150 | 124432 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 325 Cherry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5996172.9855 | 2115088.62611 | 37.787409784331295 | -122.457050084041 | (37.7874097843313, -122.457050084041) | |||
55435 | 55435 | 131324 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 400 Cherry St | 14 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 9ft | 5996252.06992 | 2114879.22587 | 37.7868393686989 | -122.456761319676 | (37.7868393686989, -122.456761319676) | |||
55682 | 55682 | 124430 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 315 Cherry St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 5ft | 5996165.292669999 | 2115148.00048 | 37.7875723686265 | -122.457080995957 | (37.7875723686265, -122.457080995957) | |||
66177 | 66177 | 131322 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 400 Cherry St | 11 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 9ft | 5996256.90517 | 2114854.47123 | 37.786771676724 | -122.45674279995501 | (37.786771676724, -122.456742799955) | |||
129709 | 129709 | 131323 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 400 Cherry St | 12 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 9ft | 5996254.50366 | 2114867.62545 | 37.7868076567964 | -122.456752060266 | (37.7868076567964, -122.456752060266) | |||
57778 | 57778 | 124704 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2x Cherry St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | 5996074.417169999 | 2115943.0366 | 37.789750104458 | -122.457452946984 | (37.789750104458, -122.457452946984) | ||||
133994 | 133994 | 132192 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2x Cherry St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | 5996086.73681 | 2115931.64437 | 37.789719532087396 | -122.457409497957 | (37.7897195320874, -122.457409497957) | ||||
44723 | 44723 | 124421 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 201 Cherry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5996117.71774 | 2115510.10225 | 37.7885638704534 | -122.457271799923 | (37.7885638704534, -122.457271799923) | |||
53571 | 53571 | 124890 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 110 Cherry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 5996111.85979 | 2115830.13955 | 37.7894422702032 | -122.45731522921801 | (37.7894422702032, -122.457315229218) | |||
172156 | 172156 | 124422 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 201 Cherry St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 5996118.09616 | 2115484.01636 | 37.7884922673554 | -122.457268602807 | (37.7884922673554, -122.457268602807) | |||
177310 | 177310 | 124889 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 342 Cherry St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5996228.817290001 | 2115003.39409 | 37.7871789661719 | -122.45685075186199 | (37.7871789661719, -122.456850751862) | |||
158723 | 158723 | 124414 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 100 Cherry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 2ft | 5996072.31903 | 2115814.16927 | 37.7893961490256 | -122.457450879091 | (37.7893961490256, -122.457450879091) | |||
26436 | 26436 | 129898 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 400 Cherry St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5996260.812469999 | 2114721.3486 | 37.7864063819923 | -122.456719650485 | (37.7864063819923, -122.456719650485) | |||
28981 | 28981 | 129894 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 400 Cherry St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5996275.0492 | 2114623.54617 | 37.7861386601261 | -122.456663319683 | (37.7861386601261, -122.456663319683) | |||
56547 | 56547 | 129893 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 400 Cherry St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 9ft | 5996283.0892 | 2114624.04425 | 37.78614048933979 | -122.45663553961701 | (37.7861404893398, -122.456635539617) | |||
65355 | 65355 | 129899 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 400 Cherry St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5996261.37885 | 2114748.4333599997 | 37.786480782009704 | -122.45671965049601 | (37.7864807820097, -122.456719650496) | |||
68952 | 68952 | 129901 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 400 Cherry St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5996245.8044 | 2114846.26346 | 37.786748502996204 | -122.45678061193001 | (37.7867485029962, -122.45678061193) | |||
71822 | 71822 | 129900 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 400 Cherry St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5996256.896319999 | 2114800.7220099997 | 37.786624095259704 | -122.45673894186301 | (37.7866240952597, -122.456738941863) | |||
129731 | 129731 | 129897 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 400 Cherry St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5996264.38909 | 2114700.39578 | 37.7863490565186 | -122.456705760474 | (37.7863490565186, -122.456705760474) | |||
137455 | 137455 | 129896 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 400 Cherry St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5996264.99029 | 2114681.22571 | 37.786296455158 | -122.456702293584 | (37.786296455158, -122.456702293584) | |||
147975 | 147975 | 129902 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 400 Cherry St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5996242.10727 | 2114872.10464 | 37.7868192436635 | -122.456795272687 | (37.7868192436635, -122.456795272687) | |||
183198 | 183198 | 129895 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 400 Cherry St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5996272.40169 | 2114646.25643 | 37.786200864412706 | -122.456674122309 | (37.7862008644127, -122.456674122309) | |||
24345 | 24345 | 124697 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 451 Cherry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5996214.788240001 | 2114760.29077 | 37.786510664059 | -122.456881699337 | (37.786510664059, -122.456881699337) | |||
24396 | 24396 | 125599 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 150 Cherry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5996146.14565 | 2115602.46834 | 37.788819115546296 | -122.457180128568 | (37.7888191155463, -122.457180128568) | |||
27848 | 27848 | 125605 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 120 Cherry St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5996123.87094 | 2115736.2480900004 | 37.78918515941611 | -122.45726687718901 | (37.7891851594161, -122.457266877189) | |||
29603 | 29603 | 124703 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 451 Cherry St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5996235.8474 | 2114621.2716599996 | 37.7861301640519 | -122.45679878212201 | (37.7861301640519, -122.456798782122) | |||
41652 | 41652 | 124699 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 451 Cherry St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5996221.57456 | 2114722.16861 | 37.786406380503294 | -122.456855462236 | (37.7864063805033, -122.456855462236) | |||
49715 | 49715 | 124700 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 451 Cherry St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5996224.4777 | 2114690.34678 | 37.7863191729833 | -122.456843115773 | (37.7863191729833, -122.456843115773) | |||
50127 | 50127 | 125601 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 150 Cherry St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5996138.93396 | 2115640.6623400003 | 37.78892357180771 | -122.45720784389098 | (37.7889235718077, -122.457207843891) | |||
51059 | 51059 | 125603 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 150 Cherry St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996132.87636 | 2115679.93599 | 37.789031058770796 | -122.45723164444901 | (37.7890310587708, -122.457231644449) | |||
57093 | 57093 | 125606 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 120 Cherry St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 5ft | 5996136.29839 | 2115745.93668 | 37.7892124754164 | -122.45722458116998 | (37.7892124754164, -122.45722458117) | |||
65148 | 65148 | 125600 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 150 Cherry St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5996141.59024 | 2115620.3582599997 | 37.7888679748267 | -122.45719718420901 | (37.7888679748267, -122.457197184209) | |||
131865 | 131865 | 124702 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 451 Cherry St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5996232.59552 | 2114639.23679 | 37.786179304766705 | -122.456811332493 | (37.7861793047667, -122.456811332493) | |||
133404 | 133404 | 125602 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 150 Cherry St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5996136.46876 | 2115656.4811 | 37.788966864280795 | -122.457217517883 | (37.7889668642808, -122.457217517883) | |||
153893 | 153893 | 101375 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 120 Cherry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/2012 12:00:00 AM | 4 | 3x3 | Permit Number 768069 | 5996130.40345 | 2115708.11083 | 37.7891082772647 | -122.457242239354 | (37.7891082772647, -122.457242239354) | |
160929 | 160929 | 124698 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 451 Cherry St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5996218.82946 | 2114740.21668 | 37.786455778040796 | -122.456866265371 | (37.7864557780408, -122.456866265371) | |||
181335 | 181335 | 124701 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 451 Cherry St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5996228.47225 | 2114668.05282 | 37.786258189109795 | -122.456827682728 | (37.7862581891098, -122.456827682728) | |||
188072 | 188072 | 125604 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 150 Cherry St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996130.82862 | 2115695.90389 | 37.789074784715204 | -122.45723988491301 | (37.7890747847152, -122.457239884913) | |||
29971 | 29971 | 124427 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300 Cherry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5996158.81228 | 2115191.7023 | 37.7876919899265 | -122.457106579099 | (37.7876919899265, -122.457106579099) | |||
40442 | 40442 | 103930 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 336 Cherry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 4x9 | 5996224.66606 | 2115025.87772 | 37.78724046181829 | -122.456866740917 | (37.7872404618183, -122.456866740917) | |||
148530 | 148530 | 133427 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 330 Cherry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5996221.0151 | 2115072.28188 | 37.7873676655448 | -122.45688272995001 | (37.7873676655448, -122.45688272995) | |||
150396 | 150396 | 124420 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 151 Cherry St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5996102.184859999 | 2115592.3429900003 | 37.788788789257495 | -122.45733149298201 | (37.7887887892575, -122.457331492982) | |||
151221 | 151221 | 124418 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 151 Cherry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5996096.43617 | 2115626.82461 | 37.7888831363176 | -122.45735387807801 | (37.7888831363176, -122.457353878078) | |||
151976 | 151976 | 103931 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 336 Cherry St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 4x6 | 5996221.56708 | 2115039.74877 | 37.7872783700507 | -122.456878466296 | (37.7872783700507, -122.456878466296) | |||
157668 | 157668 | 124419 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 151 Cherry St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5996100.01625 | 2115606.50093 | 37.7888275385921 | -122.45734002067499 | (37.7888275385921, -122.457340020675) | |||
168172 | 168172 | 124429 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300 Cherry St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5996161.90508 | 2115162.79795 | 37.787612803961395 | -122.457093787063 | (37.7876128039614, -122.457093787063) | |||
179441 | 179441 | 124428 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300 Cherry St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5996160.14683 | 2115181.85648 | 37.78766503259129 | -122.45710124936501 | (37.7876650325913, -122.457101249365) | |||
26 | 26 | 237469 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 4200 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2000 12:00:00 AM | 0 | Width 3ft | Permit Number 43111 | 6001814.64366 | 2102375.07824 | 37.75282390261339 | -122.43662077403299 | (37.7528239026134, -122.436620774033) | |
128 | 128 | 212622 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 115 Beverly St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5991392.0 | 2089980.0 | 37.718192344870296 | -122.471760605115 | (37.7181923448703, -122.471760605115) | |||
233 | 233 | 121240 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 91 Commonwealth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/2016 12:00:00 AM | 3 | 3x5 | Permit Number 778926 | 5996501.4108 | 2113948.5087 | 37.7842981813685 | -122.45583135787399 | (37.7842981813685, -122.455831357874) | |
270 | 270 | 28098 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 639 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/28/2006 12:00:00 AM | 3 | 3X3 | 6001577.9698 | 2110674.4978 | 37.7755986195101 | -122.438033679217 | (37.7755986195101, -122.438033679217) | ||
303 | 303 | 196320 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 905 Minna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008110.0 | 2110227.0 | 37.774739203286295 | -122.415406037323 | (37.7747392032863, -122.415406037323) | |||
401 | 401 | 235987 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1118 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2000 12:00:00 AM | 10 | Width 3ft | Permit Number 42064 | 6004405.04081 | 2102370.6961 | 37.7529587370629 | -122.42766238971399 | (37.7529587370629, -122.427662389714) | |
407 | 407 | 248462 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 130 Beulah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | Permit Number 779787 | 5997458.097999999 | 2107812.3026 | 37.767504613553 | -122.45207869525 | (37.767504613553, -122.45207869525) | ||
450 | 450 | 142159 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 490X Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6000657.0 | 2110488.0 | 37.7750341257837 | -122.44120614609 | (37.7750341257837, -122.44120614609) | |||
482 | 482 | 142326 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1652 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5999940.0 | 2110256.0 | 37.774356244626205 | -122.44366972691601 | (37.7743562446262, -122.443669726916) | |||
585 | 585 | 236679 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 682 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2000 12:00:00 AM | 2 | Width 3ft | Permit Number 42634 | 6000886.69016 | 2100906.56017 | 37.7487389273654 | -122.43972452598301 | (37.7487389273654, -122.439724525983) | |
678 | 678 | 237516 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1004 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/17/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779660 | 6003758.05774 | 2102389.1689299997 | 37.752972841143 | -122.429901097271 | (37.752972841143, -122.429901097271) | |
695 | 695 | 212430 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 377 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/1999 12:00:00 AM | 4 | Width 3ft | Permit Number 41586 | 5992705.098540001 | 2094089.26949 | 37.7295512799622 | -122.467520487584 | (37.7295512799622, -122.467520487584) | |
702 | 702 | 212428 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 384 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/1999 12:00:00 AM | 4 | Width 3ft | Permit Number 41587 | 5992676.41369 | 2094100.5394 | 37.7295805681871 | -122.467620472428 | (37.7295805681871, -122.467620472428) | |
711 | 711 | 212429 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 384 San Benito Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/1999 12:00:00 AM | 4 | Width 3ft | Permit Number 41587 | 5992663.86781 | 2094081.2472599999 | 37.7295268723689 | -122.467662441966 | (37.7295268723689, -122.467662441966) | |
830 | 830 | 12894 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 255X Larch St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1990 12:00:00 AM | 3 | 3X3 | 6006443.29256 | 2113021.2667 | 37.7823177635948 | -122.421370005133 | (37.7823177635948, -122.421370005133) | ||
924 | 924 | 214223 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 207 Mangels Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5999983.92895 | 2095213.9818900002 | 37.7330570333525 | -122.44243762501199 | (37.7330570333525, -122.442437625012) | |||
1001 | 1001 | 238568 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1300 Noe St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 04/27/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 779731 | 6003218.5106 | 2100626.90187 | 37.7481035005842 | -122.431641146931 | (37.7481035005842, -122.431641146931) | |
1087 | 1087 | 236728 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1616 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6002564.10416 | 2100703.66645 | 37.7482771632622 | -122.433909544687 | (37.7482771632622, -122.433909544687) | |||
1181 | 1181 | 12891 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 255X Larch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/2005 12:00:00 AM | 3 | 3X3 | 6006369.20019 | 2113010.28335 | 37.7822834283719 | -122.421625551994 | (37.7822834283719, -122.421625551994) | ||
1186 | 1186 | 244032 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 501X Shrader St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/1999 12:00:00 AM | 7 | Width 0ft | Permit Number 41876 | 5997510.0 | 2108663.0 | 37.7698433835647 | -122.45196055507601 | (37.7698433835647, -122.451960555076) | |
1190 | 1190 | 244029 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 501X Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/1999 12:00:00 AM | 7 | Width 0ft | Permit Number 41876 | 5997510.0 | 2108663.0 | 37.7698433835647 | -122.45196055507601 | (37.7698433835647, -122.451960555076) | |
1193 | 1193 | 244030 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 501X Shrader St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/1999 12:00:00 AM | 6 | Width 0ft | Permit Number 41876 | 5997510.0 | 2108663.0 | 37.7698433835647 | -122.45196055507601 | (37.7698433835647, -122.451960555076) | |
1200 | 1200 | 244033 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 501X Shrader St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/1999 12:00:00 AM | 8 | Width 0ft | Permit Number 41876 | 5997510.0 | 2108663.0 | 37.7698433835647 | -122.45196055507601 | (37.7698433835647, -122.451960555076) | |
1216 | 1216 | 244031 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 501X Shrader St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/1999 12:00:00 AM | 6 | Width 0ft | Permit Number 41876 | 5997510.0 | 2108663.0 | 37.7698433835647 | -122.45196055507601 | (37.7698433835647, -122.451960555076) | |
1264 | 1264 | 212477 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2147 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/06/1991 12:00:00 AM | 4 | Width 2ft | Permit Number 29975 | 5992562.5652 | 2100831.93832 | 37.7480567178444 | -122.468503616573 | (37.7480567178444, -122.468503616573) | |
1535 | 1535 | 28642 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1300 Webster St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | 20 | 6003705.0759 | 2113297.4854 | 37.782921429068395 | -122.430862736641 | (37.7829214290684, -122.430862736641) | |||
1658 | 1658 | 245160 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6000314.5004 | 2109304.1699 | 37.7717641118423 | -122.4423059193 | (37.7717641118423, -122.4423059193) | |||
1660 | 1660 | 245161 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000318.8213 | 2109280.9033 | 37.7717004738838 | -122.442289302515 | (37.7717004738838, -122.442289302515) | |||
1661 | 1661 | 245154 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 100 Lyon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000359.4788 | 2109307.5305 | 37.771775902629706 | -122.44215057779499 | (37.7717759026297, -122.442150577795) | |||
1663 | 1663 | 251645 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 132 Shipley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011949.0 | 2112390.0 | 37.7808933270361 | -122.40227818697599 | (37.7808933270361, -122.402278186976) | ||||
1669 | 1669 | 245155 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 100 Lyon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000354.8127 | 2109347.659 | 37.7718858194659 | -122.442169599164 | (37.7718858194659, -122.442169599164) | |||
1670 | 1670 | 251646 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 132 Shipley St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011949.0 | 2112390.0 | 37.7808933270361 | -122.40227818697599 | (37.7808933270361, -122.402278186976) | ||||
1675 | 1675 | 245153 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 100 Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6000359.9454 | 2109295.8652 | 37.7717438992436 | -122.44214812628701 | (37.7717438992436, -122.442148126287) | |||
1677 | 1677 | 251644 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 132 Shipley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011949.0 | 2112390.0 | 37.7808933270361 | -122.40227818697599 | (37.7808933270361, -122.402278186976) | ||||
1681 | 1681 | 246983 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 38 Clipper St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | Permit Number 779954 | 6004884.234759999 | 2101078.02552 | 37.7494364577399 | -122.42591323621201 | (37.7494364577399, -122.425913236212) | ||
1684 | 1684 | 236727 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1616 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | Permit Number 779934 | 6002562.04117 | 2100731.79845 | 37.7483542900352 | -122.43391868899201 | (37.7483542900352, -122.433918688992) | ||
1716 | 1716 | 236992 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 300x Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6007066.0 | 2096791.0 | 37.7377883043483 | -122.418064736265 | (37.7377883043483, -122.418064736265) | |||
1884 | 1884 | 236583 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 607 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/1994 12:00:00 AM | 5 | Width 4ft | Permit Number 779645 | 6009295.1552099995 | 2105340.17803 | 37.7613876608276 | -122.41096109620001 | (37.7613876608276, -122.4109610962) | |
1896 | 1896 | 236582 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 607 Florida St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | Permit Number 779645 | 6009292.7773400005 | 2105398.5203400003 | 37.7615477221736 | -122.410973441191 | (37.7615477221736, -122.410973441191) | ||
2020 | 2020 | 40822 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 695 05th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/1999 12:00:00 AM | 3 | 3x3 | Permit Number 41762 | 6013323.14167 | 2110435.9074 | 37.775604443222704 | -122.39738724541901 | (37.7756044432227, -122.397387245419) | |
2078 | 2078 | 12419 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1691 Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/1997 12:00:00 AM | 3 | 4X4 | 6004453.7544 | 2114557.5752 | 37.786423711867705 | -122.42836245915599 | (37.7864237118677, -122.428362459156) | ||
2113 | 2113 | 2684 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2100 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3X3 | 6003399.8502 | 2114890.5748 | 37.787278352566105 | -122.432032487909 | (37.7872783525661, -122.432032487909) | |||
2150 | 2150 | 196171 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 150 Loomis St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/27/2017 12:00:00 AM | 3 | Width 4ft | 6010696.4368900005 | 2097532.57901 | 37.7400281875625 | -122.405564708871 | (37.7400281875625, -122.405564708871) | ||
2155 | 2155 | 235936 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 900 Hampshire St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/27/2017 12:00:00 AM | 3 | Width 3ft | 6010180.29259 | 2103880.6842099996 | 37.7574298137383 | -122.40779684417 | (37.7574298137383, -122.40779684417) | ||
2160 | 2160 | 235935 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 900 Hampshire St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/27/2017 12:00:00 AM | 3 | Width 3ft | 6010177.7603400005 | 2103903.055 | 37.7574910971521 | -122.407807179156 | (37.7574910971521, -122.407807179156) | ||
2163 | 2163 | 235934 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 900 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/27/2017 12:00:00 AM | 3 | Width 3ft | 6010177.20863 | 2103930.96552 | 37.757567702297294 | -122.407811055241 | (37.7575677022973, -122.407811055241) | ||
2174 | 2174 | 113405 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2120 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6006435.39008 | 2118126.47056 | 37.796334942346 | -122.42176007795901 | (37.796334942346, -122.421760077959) | |||
2396 | 2396 | 135722 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2498X Pierce St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | Permit Number 779691 | 6001734.0 | 2116823.0 | 37.7924897105997 | -122.437934432064 | (37.7924897105997, -122.437934432064) | ||
2420 | 2420 | 135721 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2498X Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | Permit Number 779691 | 6001734.0 | 2116823.0 | 37.7924897105997 | -122.437934432064 | (37.7924897105997, -122.437934432064) | ||
2555 | 2555 | 138187 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1865 Buchanan St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/18/1998 12:00:00 AM | 6 | Width 0ft | 6003949.1621 | 2114685.5907 | 37.7867466447295 | -122.43011735683599 | (37.7867466447295, -122.430117356836) | ||
2593 | 2593 | 155952 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 35 Manor Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 07/20/2017 12:00:00 AM | 3 | 5993448.18795 | 2093194.64055 | 37.7271377226027 | -122.464886627823 | (37.7271377226027, -122.464886627823) | |||
2651 | 2651 | 253156 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 654 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2017 12:00:00 AM | 3 | 3x3 | Permit Number 40826 | 6010070.0 | 2105228.0 | 37.7611230643779 | -122.40827330718099 | (37.7611230643779, -122.408273307181) | |
2835 | 2835 | 236764 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 512 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/2005 12:00:00 AM | 7 | Width 2ft | Permit Number 48087 | 6003424.25631 | 2095995.5606900002 | 37.735398565789 | -122.43059925984801 | (37.735398565789, -122.430599259848) |
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");