Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▲ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 39187 | 39187 | 178946 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 25 Madison St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 9ft | 6005433.25 | 2093389.63985 | 37.7283568930528 | -122.42346820799 | (37.7283568930528, -122.42346820799) | |||
| 146780 | 146780 | 214408 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 100x Idora Ave | 20 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 9ft | 5995751.653580001 | 2099314.25679 | 37.7440732391823 | -122.457366158726 | (37.7440732391823, -122.457366158726) | |||
| 167759 | 167759 | 196407 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 301 Pennsylvania Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 9ft | 6014364.2295 | 2105674.4780599996 | 37.7625885210619 | -122.393452545091 | (37.7625885210619, -122.393452545091) | |||
| 68703 | 68703 | 178875 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 190 Foote Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5998646.9675199995 | 2088361.56482 | 37.7141655911394 | -122.446567002474 | (37.7141655911394, -122.446567002474) | |||
| 135125 | 135125 | 178874 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 190 Foote Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5998666.63351 | 2088343.6345099998 | 37.7141174818994 | -122.446497740299 | (37.7141174818994, -122.446497740299) | |||
| 169862 | 169862 | 214472 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 249 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 8ft | 6000443.47619 | 2094924.07855 | 37.732287209190396 | -122.44082806428499 | (37.7322872091904, -122.440828064285) | |||
| 185796 | 185796 | 214455 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 449 Baden St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | Width 8ft | 6000738.084840001 | 2095503.40232 | 37.733894671806 | -122.439851058803 | (37.733894671806, -122.439851058803) | |||
| 74939 | 74939 | 135892 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 323 Marina Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 7ft | 6001823.0897 | 2121828.5954400003 | 37.8062388262166 | -122.437984887306 | (37.8062388262166, -122.437984887306) | |||
| 176610 | 176610 | 135908 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 405 Vallejo St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 7ft | 6011535.18315 | 2119025.39151 | 37.7990894272815 | -122.40417692455 | (37.7990894272815, -122.40417692455) | |||
| 179436 | 179436 | 135891 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2398 North Point St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 7ft | 5999308.28669 | 2120504.72693 | 37.802460509893606 | -122.44659245147301 | (37.8024605098936, -122.446592451473) | |||
| 53380 | 53380 | 214420 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 466 Victoria St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 6ft | 5993273.262130001 | 2090266.31835 | 37.7190871751261 | -122.465278724129 | (37.7190871751261, -122.465278724129) | |||
| 65928 | 65928 | 238009 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1269 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 6ft | 5997476.9069 | 2105200.1672799997 | 37.7603334305535 | -122.45182517571199 | (37.7603334305535, -122.451825175712) | |||
| 165452 | 165452 | 214381 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1862 17th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 5990969.19969 | 2102754.50273 | 37.75324341026371 | -122.47415361899401 | (37.7532434102637, -122.474153618994) | |||
| 182223 | 182223 | 214385 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1955 10th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 6ft | 5993134.95065 | 2102190.16883 | 37.7518191170825 | -122.46662305770501 | (37.7518191170825, -122.466623057705) | |||
| 24062 | 24062 | 237974 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 250 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6005423.51837 | 2102260.48733 | 37.752713687090896 | -122.424132459851 | (37.7527136870909, -122.424132459851) | |||
| 27579 | 27579 | 237973 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 47 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6005397.275719999 | 2103411.57149 | 37.7558728147995 | -122.42430507393601 | (37.7558728147995, -122.424305073936) | |||
| 29658 | 29658 | 214395 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 191 Granville Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 5994322.3379999995 | 2098681.3180299997 | 37.7422531489715 | -122.462262480723 | (37.7422531489715, -122.462262480723) | |||
| 43582 | 43582 | 214394 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 191 Granville Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 5994343.40984 | 2098666.78046 | 37.742214445742896 | -122.46218856725201 | (37.7422144457429, -122.462188567252) | |||
| 56855 | 56855 | 238020 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 20 Ashbury Ter | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 5ft | 5999596.30607 | 2106935.78713 | 37.7652201693967 | -122.44461993696501 | (37.7652201693967, -122.444619936965) | |||
| 60164 | 60164 | 214397 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 195 Granville Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 5994296.9529800005 | 2098696.80879 | 37.7422942210096 | -122.462351376935 | (37.7422942210096, -122.462351376935) | |||
| 131720 | 131720 | 238018 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 50 Ashbury Ter | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 5ft | 5999581.71277 | 2106854.10087 | 37.7649950466081 | -122.444664539759 | (37.7649950466081, -122.444664539759) | |||
| 136127 | 136127 | 238019 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 50 Ashbury Ter | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 5ft | 5999588.96153 | 2106868.76746 | 37.765035731038104 | -122.444640522441 | (37.7650357310381, -122.444640522441) | |||
| 146988 | 146988 | 238017 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 50 Ashbury Ter | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 5ft | 5999577.21744 | 2106844.6450900002 | 37.7649688268778 | -122.444679408227 | (37.7649688268778, -122.444679408227) | |||
| 149154 | 149154 | 214396 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 195 Granville Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 5994309.483109999 | 2098688.20376 | 37.742271315265 | -122.462307427938 | (37.742271315265, -122.462307427938) | |||
| 152855 | 152855 | 214399 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 280 Granville Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 5993979.945780001 | 2098920.29255 | 37.7428895919817 | -122.46346369708799 | (37.7428895919817, -122.463463697088) | |||
| 154849 | 154849 | 135905 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2843 Larkin St | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 6006460.32075 | 2121020.9303099997 | 37.804283800830795 | -122.42187952052099 | (37.8042838008308, -122.421879520521) | |||
| 156102 | 156102 | 214382 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1935 16th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 5991235.497140001 | 2102232.23855 | 37.751824832267395 | -122.473194631436 | (37.7518248322674, -122.473194631436) | |||
| 171254 | 171254 | 214398 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 201 Granville Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 5994265.55246 | 2098714.72698 | 37.742341611687294 | -122.46246124889 | (37.7423416116873, -122.46246124889) | |||
| 175247 | 175247 | 238016 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 50 Ashbury Ter | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 5ft | 5999571.744519999 | 2106835.86862 | 37.7649444165749 | -122.44469770674 | (37.7649444165749, -122.44469770674) | |||
| 2000 | 2000 | 237999 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 4302 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2012 12:00:00 AM | 2 | Width 4ft | Permit Number 769743 | 6001218.46057 | 2101752.36044 | 37.7510801711245 | -122.438637864349 | (37.7510801711245, -122.438637864349) | |
| 23893 | 23893 | 238011 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 170 Upper Ter | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5999678.6983900005 | 2106620.27376 | 37.7643585496334 | -122.444312287003 | (37.7643585496334, -122.444312287003) | |||
| 28949 | 28949 | 238015 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 77 Ashbury Ter | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5999599.38464 | 2106733.87641 | 37.76466594869029 | -122.44459477575501 | (37.7646659486903, -122.444594775755) | |||
| 34860 | 34860 | 237993 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 480 Jersey St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6001987.72906 | 2101502.95079 | 37.7504390831161 | -122.43595981461701 | (37.7504390831161, -122.435959814617) | |||
| 40894 | 40894 | 237979 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 823 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5999103.16972 | 2107519.69828 | 37.7667952905854 | -122.44636758050501 | (37.7667952905854, -122.446367580505) | |||
| 41303 | 41303 | 118024 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 455 37th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5984366.776430001 | 2112718.2833 | 37.7802164441611 | -122.497721424423 | (37.7802164441611, -122.497721424423) | |||
| 43146 | 43146 | 118427 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 5400 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 5981873.51616 | 2111696.39703 | 37.7772641742522 | -122.506270809551 | (37.7772641742522, -122.506270809551) | |||
| 44205 | 44205 | 178924 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 88 San Gabriel Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6000939.255030001 | 2093544.2007900001 | 37.7285266059143 | -122.43901519111 | (37.7285266059143, -122.43901519111) | |||
| 54244 | 54244 | 196406 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1021 Minnesota St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 6015301.01099 | 2103753.62638 | 37.7573662793475 | -122.390078334671 | (37.7573662793475, -122.390078334671) | |||
| 55304 | 55304 | 214412 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 441 Ulloa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5995385.60147 | 2098278.36305 | 37.7412079002216 | -122.458556904286 | (37.7412079002216, -122.458556904286) | |||
| 61372 | 61372 | 214427 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 55 Cranleigh Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 5991235.53196 | 2095666.85517 | 37.7337979784868 | -122.47271585846799 | (37.7337979784868, -122.472715858468) | |||
| 63435 | 63435 | 214440 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1746 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5992520.380580001 | 2103558.15623 | 37.7555397706536 | -122.468847844656 | (37.7555397706536, -122.468847844656) | |||
| 63909 | 63909 | 238012 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 170 Upper Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 5999727.58165 | 2106665.35693 | 37.7644851256196 | -122.444146453789 | (37.7644851256196, -122.444146453789) | |||
| 67278 | 67278 | 237997 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 4160 23rd St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 6002093.96349 | 2102384.7886200002 | 37.752866434239394 | -122.435655530791 | (37.7528664342394, -122.435655530791) | |||
| 68693 | 68693 | 118431 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 5400 Anza St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5981816.64658 | 2111695.18358 | 37.7772574943259 | -122.506467446284 | (37.7772574943259, -122.506467446284) | |||
| 69155 | 69155 | 214404 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 66 Sotelo Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993883.93649 | 2101380.3383299997 | 37.7496387233569 | -122.46397420265801 | (37.7496387233569, -122.463974202658) | |||
| 70069 | 70069 | 118023 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 455 37th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5984366.09559 | 2112727.46699 | 37.780241619998 | -122.49772445801202 | (37.780241619998, -122.497724458012) | |||
| 70625 | 70625 | 178891 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 579 Madrid St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 6002452.87445 | 2090566.89512 | 37.720437599790394 | -122.43356984466999 | (37.7204375997904, -122.43356984467) | |||
| 72044 | 72044 | 178922 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 88 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6000972.29348 | 2093568.3517900002 | 37.7285947987994 | -122.438902705697 | (37.7285947987994, -122.438902705697) | |||
| 75002 | 75002 | 237978 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 25 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 5998568.181969999 | 2106878.54944 | 37.7650042880525 | -122.44817183545901 | (37.7650042880525, -122.448171835459) | |||
| 130597 | 130597 | 214411 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 451 Ulloa St | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5995342.99314 | 2098250.4042599997 | 37.74112868343371 | -122.45870220413799 | (37.7411286834337, -122.458702204138) | |||
| 131822 | 131822 | 178888 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 451 Athens St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6003758.58722 | 2090633.91893 | 37.7206956305865 | -122.42906119342501 | (37.7206956305865, -122.429061193425) | |||
| 133064 | 133064 | 178900 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1128 Bowdoin St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 6009581.67769 | 2090926.3916900002 | 37.721826605402 | -122.40895311598699 | (37.721826605402, -122.408953115987) | |||
| 146623 | 146623 | 178923 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 88 San Gabriel Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6000952.168380001 | 2093553.63725 | 37.7285532510089 | -122.43897122505899 | (37.7285532510089, -122.438971225059) | |||
| 149250 | 149250 | 214410 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 319 Kensington Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5994311.31652 | 2098976.3234200003 | 37.7430625253047 | -122.462321980781 | (37.7430625253047, -122.462321980781) | |||
| 153169 | 153169 | 214417 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 182 Jules Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 5994480.563080001 | 2091128.3543599998 | 37.7215236696771 | -122.461168031889 | (37.7215236696771, -122.461168031889) | |||
| 157140 | 157140 | 214435 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 320 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 5993233.77766 | 2104623.70866 | 37.758506690737 | -122.46645815892201 | (37.758506690737, -122.466458158922) | |||
| 157232 | 157232 | 238013 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 77 Ashbury Ter | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 4ft | 5999618.479619999 | 2106729.8577400004 | 37.764656004003 | -122.44452844265899 | (37.764656004003, -122.444528442659) | |||
| 158401 | 158401 | 118027 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 51 Shore View Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5984327.56097 | 2112791.45591 | 37.780415056002205 | -122.49786249135201 | (37.7804150560022, -122.497862491352) | |||
| 160642 | 160642 | 214409 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 319 Kensington Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5994299.528 | 2098982.87958 | 37.7430798480616 | -122.462363217409 | (37.7430798480616, -122.462363217409) | |||
| 162160 | 162160 | 238014 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 77 Ashbury Ter | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5999606.96605 | 2106732.73135 | 37.7646632372481 | -122.444568471453 | (37.7646632372481, -122.444568471453) | |||
| 164677 | 164677 | 237975 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 132 Rivoli St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5998055.3096900005 | 2105976.44068 | 37.7624979926238 | -122.44988070562401 | (37.7624979926238, -122.449880705624) | |||
| 165895 | 165895 | 238010 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1231 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5997428.72694 | 2105545.13928 | 37.76127787699421 | -122.452016696208 | (37.7612778769942, -122.452016696208) | |||
| 167008 | 167008 | 238002 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1471 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6003322.028609999 | 2099674.87097 | 37.7454953128593 | -122.43121524060801 | (37.7454953128593, -122.431215240608) | |||
| 170362 | 170362 | 118429 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 5400 Anza St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5981844.98436 | 2111695.06236 | 37.7772588298958 | -122.50636940951 | (37.7772588298958, -122.50636940951) | |||
| 173041 | 173041 | 238003 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 860 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6000870.32995 | 2102023.8969900003 | 37.7518059348134 | -122.439861199541 | (37.7518059348134, -122.439861199541) | |||
| 177236 | 177236 | 178894 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 38 Curtis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6000524.98993 | 2088394.3572900002 | 37.714362726143 | -122.44007819877 | (37.714362726143, -122.44007819877) | |||
| 178144 | 178144 | 178886 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 451 Athens St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6003733.07859 | 2090591.8271 | 37.7205786116989 | -122.42914636912501 | (37.7205786116989, -122.429146369125) | |||
| 182222 | 182222 | 178965 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 748 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6002497.1974599995 | 2087222.1001 | 37.7112560450962 | -122.433177768149 | (37.7112560450962, -122.433177768149) | |||
| 184613 | 184613 | 178887 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 451 Athens St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6003747.16271 | 2090614.46015 | 37.720641554351296 | -122.429099297695 | (37.7206415543513, -122.429099297695) | |||
| 1012 | 1012 | 246499 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 311 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779776 | 6004393.833380001 | 2099835.13521 | 37.7459960419019 | -122.427520522551 | (37.7459960419019, -122.427520522551) | |
| 1259 | 1259 | 238460 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 52 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/08/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779768 | 6002902.99046 | 2108581.89909 | 37.7699281239255 | -122.433300551682 | (37.7699281239255, -122.433300551682) | |
| 24204 | 24204 | 238028 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 251 Alma St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997698.52987 | 2106146.63858 | 37.7629448927014 | -122.45112694477699 | (37.7629448927014, -122.451126944777) | |||
| 24369 | 24369 | 237998 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 338 Hoffman Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6000611.91644 | 2101788.98208 | 37.7511462020375 | -122.440737977395 | (37.7511462020375, -122.440737977395) | |||
| 24998 | 24998 | 238025 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 251 Alma St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5997578.60338 | 2106127.58066 | 37.762885697531296 | -122.451540352327 | (37.7628856975313, -122.451540352327) | |||
| 25315 | 25315 | 214430 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1449 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5994564.92824 | 2105667.42419 | 37.7614491861622 | -122.461930160573 | (37.7614491861622, -122.461930160573) | |||
| 25621 | 25621 | 178933 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 249 Ocean Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6000047.59686 | 2091609.71589 | 37.723164181455004 | -122.441958899679 | (37.723164181455, -122.441958899679) | |||
| 26502 | 26502 | 196418 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 74 Langton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6010052.79507 | 2110841.7577299997 | 37.7765361885308 | -122.408728861943 | (37.7765361885308, -122.408728861943) | |||
| 27000 | 27000 | 214389 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 265 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992333.20147 | 2097526.08875 | 37.7389664461405 | -122.469056185189 | (37.7389664461405, -122.469056185189) | |||
| 28974 | 28974 | 214439 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1569 Willard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5996912.71569 | 2105759.04962 | 37.7618356500092 | -122.453816799006 | (37.7618356500092, -122.453816799006) | |||
| 30319 | 30319 | 237984 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 124 Marsily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004243.12433 | 2095170.9025700002 | 37.733180596596206 | -122.42770938917101 | (37.7331805965962, -122.427709389171) | |||
| 32181 | 32181 | 214447 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 265 Dorantes Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5993364.21414 | 2099688.46118 | 37.7449632937192 | -122.465648504685 | (37.7449632937192, -122.465648504685) | |||
| 32814 | 32814 | 214424 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 732 Shields St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5992045.199469999 | 2089870.8873400001 | 37.7179305201634 | -122.469494855606 | (37.7179305201634, -122.469494855606) | |||
| 32988 | 32988 | 196389 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 93 Stillman St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6013924.26567 | 2112893.70041 | 37.7823864349182 | -122.395480022606 | (37.7823864349182, -122.395480022606) | |||
| 33576 | 33576 | 196395 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 260 Clara St | 3 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6011460.59942 | 2111454.8789 | 37.7782984271806 | -122.40390199009501 | (37.7782984271806, -122.403901990095) | |||
| 35955 | 35955 | 214400 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 225 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992660.56821 | 2095241.10617 | 37.7327113663366 | -122.467758171225 | (37.7327113663366, -122.467758171225) | |||
| 37603 | 37603 | 196415 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 74 Langton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6010031.16155 | 2110864.86545 | 37.776598425219206 | -122.408805329496 | (37.7765984252192, -122.408805329496) | |||
| 37685 | 37685 | 178897 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 250 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6012667.83856 | 2087309.2144 | 37.7120669530014 | -122.39803135517599 | (37.7120669530014, -122.398031355176) | |||
| 38266 | 38266 | 214432 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1493 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5994264.26348 | 2105375.95517 | 37.7606315737945 | -122.462948880198 | (37.7606315737945, -122.462948880198) | |||
| 38480 | 38480 | 214433 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1530 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5993395.62301 | 2105048.89443 | 37.759683477928704 | -122.465929324277 | (37.7596834779287, -122.465929324277) | |||
| 38600 | 38600 | 237996 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 741 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001915.60449 | 2101837.36295 | 37.7513532016953 | -122.436233155455 | (37.7513532016953, -122.436233155455) | |||
| 38789 | 38789 | 214431 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1417 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5994558.263669999 | 2105844.83617 | 37.7619359298261 | -122.461966075892 | (37.7619359298261, -122.461966075892) | |||
| 40942 | 40942 | 178925 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1699 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001853.21575 | 2094253.6838200002 | 37.73052664507 | -122.435906329212 | (37.73052664507, -122.435906329212) | |||
| 41728 | 41728 | 247994 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 270 Peralta Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 6009740.549319999 | 2099529.50478 | 37.7454578138309 | -122.409010652834 | (37.7454578138309, -122.409010652834) | |||
| 42734 | 42734 | 178927 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 169 Otsego Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6000613.31177 | 2092308.08767 | 37.7251139719271 | -122.440053391844 | (37.7251139719271, -122.440053391844) | |||
| 42943 | 42943 | 178899 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 250 Tocoloma Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6012660.08669 | 2087284.72268 | 37.7119992718279 | -122.39805643095801 | (37.7119992718279, -122.398056430958) | |||
| 43246 | 43246 | 247776 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 228 30th St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6005091.07435 | 2098463.74529 | 37.7422699303121 | -122.425011997728 | (37.7422699303121, -122.425011997728) | |||
| 44073 | 44073 | 237980 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 163 Delmar St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5999394.39801 | 2107237.60683 | 37.7660373671625 | -122.445339989042 | (37.7660373671625, -122.445339989042) | |||
| 44877 | 44877 | 238005 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 118 Sussex St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002126.98293 | 2096665.47856 | 37.7371644277915 | -122.435132311514 | (37.7371644277915, -122.435132311514) | |||
| 45806 | 45806 | 238022 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1430 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5999608.40723 | 2107632.1113400003 | 37.7671327917617 | -122.44462813427401 | (37.7671327917617, -122.444628134274) | |||
| 46101 | 46101 | 237994 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 4120 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6002361.65324 | 2101818.0737099997 | 37.751325570939706 | -122.434689290178 | (37.7513255709397, -122.434689290178) |
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");