Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo ▲ | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 33040 | 33040 | 185413 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 2300 Sunset Blvd | 29 | unknown : Yard 19 | Tree 1 | Private 1 | 4 | Width 0ft | 5985092.6382 | 2099208.8841 | 37.7431659316065 | -122.49421435006501 | (37.7431659316065, -122.494214350065) | |||
| 162943 | 162943 | 185411 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 2300 Sunset Blvd | 26 | unknown : Yard 19 | Tree 1 | Private 1 | 10 | Width 0ft | 5985100.1361 | 2099184.3909 | 37.7430991186582 | -122.49418661978599 | (37.7430991186582, -122.494186619786) | |||
| 63782 | 63782 | 197353 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1750 22nd St | 13 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6012786.799 | 2103803.61301 | 37.7573637666391 | -122.398777038841 | (37.7573637666391, -122.398777038841) | ||||
| 151712 | 151712 | 248239 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 298 Esmeralda Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6006759.33465 | 2099019.31967 | 37.7438895076886 | -122.419283056374 | (37.7438895076886, -122.419283056374) | ||||
| 178929 | 178929 | 247983 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 497 Peralta Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6009757.51939 | 2099637.18115 | 37.74575442014729 | -122.408959568646 | (37.7457544201473, -122.408959568646) | ||||
| 187182 | 187182 | 247984 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 497 Peralta Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6009751.76686 | 2099644.8640900003 | 37.745775193576705 | -122.408980002136 | (37.7457751935767, -122.408980002136) | ||||
| 29920 | 29920 | 240423 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 5 Penny Ln | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | Width 2ft | 6002449.92079 | 2096381.9214299999 | 37.7364041778047 | -122.433995506402 | (37.7364041778047, -122.433995506402) | |||
| 35387 | 35387 | 240421 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 5 Penny Ln | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | Width 2ft | 6002440.8921300005 | 2096392.57557 | 37.736432919229706 | -122.43402748359101 | (37.7364329192297, -122.434027483591) | |||
| 71286 | 71286 | 240425 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 5 Penny Ln | 7 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | Width 2ft | 6002456.8751300005 | 2096374.3168900001 | 37.736383692152295 | -122.433970918943 | (37.7363836921523, -122.433970918943) | |||
| 73730 | 73730 | 240424 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 5 Penny Ln | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 2ft | 6002452.23233 | 2096379.1355 | 37.7363966594644 | -122.43398731536502 | (37.7363966594644, -122.433987315365) | |||
| 188488 | 188488 | 240422 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 5 Penny Ln | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 2ft | 6002442.71855 | 2096389.33655 | 37.7364241292793 | -122.43402093743201 | (37.7364241292793, -122.434020937432) | |||
| 95726 | 95726 | 23598 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 200X Vasquez Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 60 | 5994426.954874 | 2098963.765109 | 37.7430347013579 | -122.46192122709499 | (37.7430347013579, -122.461921227095) | |||
| 116556 | 116556 | 23599 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 200X Vasquez Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 60 | 5994426.954874 | 2098963.765109 | 37.7430347013579 | -122.46192122709499 | (37.7430347013579, -122.461921227095) | |||
| 143705 | 143705 | 13408 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 364 Marietta Dr | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 45 | 5 | 5999660.108164 | 2097381.7238333 | 37.738990678772396 | -122.443712833155 | (37.7389906787724, -122.443712833155) | |||
| 169354 | 169354 | 117837 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 660x 39th Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 6ft | 5983820.01458 | 2111273.2343900003 | 37.776216692790705 | -122.49950607144899 | (37.7762166927907, -122.499506071449) | |||
| 43641 | 43641 | 179373 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 670 Brunswick St | 17 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | 5998557.70629 | 2086647.36142 | 37.709453678716706 | -122.446752254708 | (37.7094536787167, -122.446752254708) | ||||
| 48149 | 48149 | 240393 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 35 Hill St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6006109.51353 | 2103440.5803799997 | 37.7559926584484 | -122.421843980221 | (37.7559926584484, -122.421843980221) | |||
| 61274 | 61274 | 197334 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1098 Mississippi St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 5ft | 6014199.99182 | 2102083.0983599997 | 37.7527182412529 | -122.39376919728501 | (37.7527182412529, -122.393769197285) | |||
| 30089 | 30089 | 122281 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1750 Balboa St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5990111.6262 | 2111320.57885 | 37.7767138255075 | -122.477745368245 | (37.7767138255075, -122.477745368245) | |||
| 36460 | 36460 | 122283 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1750 Balboa St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5990098.96698 | 2111321.01529 | 37.7767142891731 | -122.477789191669 | (37.7767142891731, -122.477789191669) | |||
| 36999 | 36999 | 122289 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1750 Balboa St | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5990067.41245 | 2111319.5030799997 | 37.7767083057233 | -122.477898236364 | (37.7767083057233, -122.477898236364) | |||
| 37930 | 37930 | 186236 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1701 Sunset Blvd | 47 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984809.6691 | 2103350.7929 | 37.75452191688171 | -122.495498186629 | (37.7545219168817, -122.495498186629) | |||
| 39998 | 39998 | 122277 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1750 Balboa St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5990139.99053 | 2111321.69927 | 37.7767185479371 | -122.477647330613 | (37.7767185479371, -122.477647330613) | |||
| 44795 | 44795 | 122290 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1750 Balboa St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5990062.61204 | 2111318.0216900003 | 37.7767039596239 | -122.47791473389799 | (37.7767039596239, -122.477914733898) | |||
| 46494 | 46494 | 122286 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1750 Balboa St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5990082.62166 | 2111319.5038 | 37.7767091904138 | -122.477845623834 | (37.7767091904138, -122.477845623834) | |||
| 47685 | 47685 | 214042 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 22 Gennessee St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 10ft | 5997465.40478 | 2093699.4723200002 | 37.728754675784394 | -122.451035610522 | (37.7287546757844, -122.451035610522) | |||
| 48717 | 48717 | 214026 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 124 Baden St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6000776.43659 | 2094502.29985 | 37.7311480595383 | -122.43964672023199 | (37.7311480595383, -122.439646720232) | |||
| 50462 | 50462 | 122282 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1750 Balboa St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5990106.33926 | 2111321.3026900003 | 37.7767155061466 | -122.477763710061 | (37.7767155061466, -122.477763710061) | |||
| 56127 | 56127 | 136318 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 2431 Jones St | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 6007955.59027 | 2120758.45752 | 37.803647329033105 | -122.416686400679 | (37.8036473290331, -122.416686400679) | |||
| 58619 | 58619 | 122287 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1750 Balboa St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5990077.48759 | 2111319.8179099998 | 37.776709754904104 | -122.477863406875 | (37.7767097549041, -122.477863406875) | |||
| 64497 | 64497 | 214035 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 142 Staples Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 5999120.59989 | 2093807.09624 | 37.72914480888021 | -122.445321250796 | (37.7291448088802, -122.445321250796) | ||||
| 65759 | 65759 | 122284 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1750 Balboa St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5990094.44484 | 2111319.9709799998 | 37.776711159339705 | -122.47780475856199 | (37.7767111593397, -122.477804758562) | |||
| 66165 | 66165 | 186237 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1701 Sunset Blvd | 48 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984808.8655 | 2103347.0431 | 37.7545115739121 | -122.495500689099 | (37.7545115739121, -122.495500689099) | |||
| 72433 | 72433 | 122278 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1750 Balboa St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5990134.53204 | 2111321.8992 | 37.776718780123794 | -122.477666227559 | (37.7767187801238, -122.477666227559) | |||
| 97449 | 97449 | 102592 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 124 Baden St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | FUF 1 | 04/17/2010 12:00:00 AM | 3 | 6x6 | 6000765.0 | 2094428.0 | 37.7309433983829 | -122.439680933747 | (37.7309433983829, -122.439680933747) | |
| 129693 | 129693 | 122288 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1750 Balboa St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5990072.179690001 | 2111319.40231 | 37.776708305720796 | -122.477881737882 | (37.7767083057208, -122.477881737882) | |||
| 131206 | 131206 | 179380 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 77 Santa Cruz Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 5993077.06779 | 2086425.7469099998 | 37.7085305695939 | -122.46567800964199 | (37.7085305695939, -122.465678009642) | |||
| 135749 | 135749 | 122280 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1750 Balboa St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5990124.518680001 | 2111321.36168 | 37.776716723141206 | -122.477700827061 | (37.7767167231412, -122.477700827061) | |||
| 135936 | 135936 | 214037 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 510 Ramsell St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 5993017.248790001 | 2090566.81293 | 37.719897493047704 | -122.466185481793 | (37.7198974930477, -122.466185481793) | |||
| 137254 | 137254 | 124092 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 601 Funston Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 5991890.07496 | 2111196.5227799998 | 37.776476251963295 | -122.47158420369101 | (37.7764762519633, -122.471584203691) | ||||
| 137258 | 137258 | 122279 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1750 Balboa St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5990130.41151 | 2111322.13937 | 37.7767192004406 | -122.477680499098 | (37.7767192004406, -122.477680499098) | |||
| 137888 | 137888 | 214039 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 57 Nordhoff St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6000414.26094 | 2095519.5651200002 | 37.7339206127394 | -122.440971772322 | (37.7339206127394, -122.440971772322) | |||
| 145225 | 145225 | 186232 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1701 Sunset Blvd | 43 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984802.7052 | 2103358.5602 | 37.754542835963505 | -122.49552284211201 | (37.7545428359635, -122.495522842112) | |||
| 149725 | 149725 | 136320 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 99 North Point St | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6010568.43745 | 2122006.8054400003 | 37.8072215900736 | -122.40773254351801 | (37.8072215900736, -122.407732543518) | |||
| 158949 | 158949 | 197336 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 651 Missouri St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6013643.57223 | 2103811.4939599996 | 37.757433106182 | -122.39581450923201 | (37.757433106182, -122.395814509232) | ||||
| 165341 | 165341 | 136319 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 99 North Point St | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6010537.589980001 | 2122003.14861 | 37.8072098224406 | -122.40783904035901 | (37.8072098224406, -122.407839040359) | |||
| 167275 | 167275 | 136317 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 954 Vallejo St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6008931.36114 | 2118725.70113 | 37.798120717152294 | -122.413165857925 | (37.7981207171523, -122.413165857925) | |||
| 168253 | 168253 | 240399 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1636 Diamond St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6002005.77197 | 2099212.90242 | 37.7441521762959 | -122.43573359642201 | (37.7441521762959, -122.435733596422) | |||
| 175014 | 175014 | 240397 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1636 Diamond St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6001997.9354 | 2099211.95257 | 37.744149123094104 | -122.43576062557301 | (37.7441491230941, -122.435760625573) | |||
| 175663 | 175663 | 186234 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1701 Sunset Blvd | 45 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984803.2409 | 2103355.3462 | 37.7545340425765 | -122.495520752512 | (37.7545340425765, -122.495520752512) | |||
| 182820 | 182820 | 240398 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1636 Diamond St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6002001.74432 | 2099212.54095 | 37.74415095500439 | -122.43574749727301 | (37.7441509550044, -122.435747497273) | |||
| 187748 | 187748 | 122285 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1750 Balboa St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5990089.24883 | 2111319.7381700003 | 37.7767102185501 | -122.477822715879 | (37.7767102185501, -122.477822715879) | |||
| 106143 | 106143 | 87075 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 395 Byxbee St | 6 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947.0 | 2091188.0 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | |||
| 111937 | 111937 | 87074 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 395 Byxbee St | 5 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947.0 | 2091188.0 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | |||
| 31206 | 31206 | 246759 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 70 Waltham St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6009196.74806 | 2098886.80636 | 37.7436626276403 | -122.410845655606 | (37.7436626276403, -122.410845655606) | ||||
| 38193 | 38193 | 246761 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 70 Waltham St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6009235.422669999 | 2098888.8268 | 37.7436703438078 | -122.410712070303 | (37.7436703438078, -122.410712070303) | ||||
| 38403 | 38403 | 197339 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 696 Amador St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6016827.1128 | 2099574.92506 | 37.745976956489294 | -122.384509368331 | (37.7459769564893, -122.384509368331) | ||||
| 43322 | 43322 | 246767 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 70 Waltham St | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6009322.267109999 | 2098890.11567 | 37.743678751571295 | -122.410411873024 | (37.7436787515713, -122.410411873024) | ||||
| 132831 | 132831 | 201725 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1915 Quesada Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6013561.8417 | 2095888.78027 | 37.735674466103795 | -122.39554210998199 | (37.7356744661038, -122.395542109982) | ||||
| 149552 | 149552 | 246638 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 3320 Harrison St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 6009023.34848 | 2099240.7850900004 | 37.7446248509555 | -122.411470234758 | (37.7446248509555, -122.411470234758) | ||||
| 157777 | 157777 | 197340 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 696 Amador St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6016813.36643 | 2099575.53369 | 37.745977867490204 | -122.384556944272 | (37.7459778674902, -122.384556944272) | ||||
| 166990 | 166990 | 136321 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 150 Francisco St | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6010437.78302 | 2121369.6786 | 37.8054648831642 | -122.408139740375 | (37.8054648831642, -122.408139740375) | ||||
| 172123 | 172123 | 240382 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 200 Kingston St | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6006224.51109 | 2098080.7337 | 37.7412822264814 | -122.4210657258 | (37.7412822264814, -122.4210657258) | ||||
| 185231 | 185231 | 197341 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 696 Amador St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | 6016796.90554 | 2099573.89089 | 37.745972446388 | -122.384613749949 | (37.745972446388, -122.384613749949) | ||||
| 576 | 576 | 240412 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 3420 Market St | 1 | : 4 | Tree 1 | DPW 2 | 04/19/1996 12:00:00 AM | 7 | Width 3ft | 6000095.059769999 | 2103920.2632400002 | 37.7569687331323 | -122.442678332141 | (37.7569687331323, -122.442678332141) | ||
| 596 | 596 | 240413 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 3420 Market St | 2 | : 4 | Tree 1 | DPW 2 | 04/19/1996 12:00:00 AM | 8 | Width 3ft | 6000107.95046 | 2103900.11575 | 37.756914147893795 | -122.442632304847 | (37.7569141478938, -122.442632304847) | ||
| 59339 | 59339 | 197337 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 501 Amador St | 8 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6017571.01278 | 2099537.71438 | 37.7459158925037 | -122.381934448315 | (37.7459158925037, -122.381934448315) | |||
| 146955 | 146955 | 197338 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 501 Amador St | 9 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6017587.31479 | 2099538.4559 | 37.745918828809295 | -122.381878129198 | (37.7459188288093, -122.381878129198) | |||
| 171047 | 171047 | 214038 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 638 Head St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5993525.3619099995 | 2090091.0611400001 | 37.718620496206796 | -122.46439460152901 | (37.7186204962068, -122.464394601529) | |||
| 177864 | 177864 | 214036 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 262 Ralston St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5992219.26388 | 2089623.39625 | 37.7172610279406 | -122.46887519663 | (37.7172610279406, -122.46887519663) | |||
| 181218 | 181218 | 247182 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 21 Buena Vista Ave East | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6001135.9574 | 2108807.3946 | 37.770446875354295 | -122.439428836098 | (37.7704468753543, -122.439428836098) | |||
| 22821 | 22821 | 197331 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1501 25th St | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6014124.123369999 | 2101967.77095 | 37.752397360459 | -122.39402349321199 | (37.752397360459, -122.394023493212) | ||||
| 26432 | 26432 | 141346 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 463 BRODERICK ST | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 6001145.1037 | 2110334.7664 | 37.774641176317104 | -122.439506706044 | (37.7746411763171, -122.439506706044) | |||
| 35367 | 35367 | 197333 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1501 25th St | 22 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6014202.148440001 | 2101967.42619 | 37.7524007500093 | -122.39375364352301 | (37.7524007500093, -122.393753643523) | ||||
| 40074 | 40074 | 181349 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 2254 29th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5987333.026000001 | 2099936.24 | 37.745293905616705 | -122.48652117681601 | (37.7452939056167, -122.486521176816) | |||
| 130949 | 130949 | 181350 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 2270 25th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5988575.9018 | 2099879.6972 | 37.745211025577895 | -122.48221942866999 | (37.7452110255779, -122.48221942867) | |||
| 147113 | 147113 | 184465 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 2182 45th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5982354.8718 | 2100269.3302 | 37.745917034436296 | -122.503759179813 | (37.7459170344363, -122.503759179813) | |||
| 179103 | 179103 | 197332 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1501 25th St | 19 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6014163.86905 | 2101969.79141 | 37.752405117125896 | -122.393886186499 | (37.7524051171259, -122.393886186499) | ||||
| 122 | 122 | 183689 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1341 42nd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5983043.6112 | 2105976.497 | 37.761627789464704 | -122.501799836383 | (37.7616277894647, -122.501799836383) | |||
| 1152 | 1152 | 240384 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 65 Hermann St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2017 12:00:00 AM | 3 | Width 2ft | Permit Number 779910 | 6004983.769180001 | 2108813.08838 | 37.7706807377627 | -122.426119636009 | (37.7706807377627, -122.426119636009) | |
| 1553 | 1553 | 207056 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 340 Vicente St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5991811.94775 | 2097766.11202 | 37.7395953573424 | -122.470875903123 | (37.7395953573424, -122.470875903123) | |||
| 1559 | 1559 | 207057 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 340 Vicente St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5991827.84816 | 2097768.2699700003 | 37.7396022020835 | -122.47082108403099 | (37.7396022020835, -122.470821084031) | |||
| 1984 | 1984 | 252847 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1500 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008908.0 | 2108725.0 | 37.7706598827985 | -122.412539385599 | (37.7706598827985, -122.412539385599) | ||||
| 1993 | 1993 | 252846 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1500 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008908.0 | 2108725.0 | 37.7706598827985 | -122.412539385599 | (37.7706598827985, -122.412539385599) | ||||
| 2099 | 2099 | 200057 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1898x Lane St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6014825.8229 | 2094079.4071 | 37.7307765200208 | -122.39104557773999 | (37.7307765200208, -122.39104557774) | |||
| 2370 | 2370 | 112542 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 438 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/24/2016 12:00:00 AM | 3 | 3x3 | 6011405.06525 | 2118709.9257400003 | 37.7982159634572 | -122.40460495956002 | (37.7982159634572, -122.40460495956) | ||
| 5190 | 5190 | 253817 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 159 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6001018.0 | 2098627.0 | 37.742487269754704 | -122.43910710368601 | (37.7424872697547, -122.439107103686) | ||||
| 6247 | 6247 | 112539 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 426 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/12/2016 11:10:00 AM | 3 | 3x3 | 6011460.82325 | 2118719.23159 | 37.7982446311281 | -122.404412674615 | (37.7982446311281, -122.404412674615) | ||
| 6998 | 6998 | 112530 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 435 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/24/2016 07:26:00 AM | 3 | 3x3 | 6011409.86951 | 2118646.99301 | 37.7980434339179 | -122.40458390283199 | (37.7980434339179, -122.404583902832) | ||
| 7100 | 7100 | 106210 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 585X Bush St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774310 | 6010773.37918 | 2115862.1930299997 | 37.7903614528559 | -122.406590009715 | (37.7903614528559, -122.406590009715) | |
| 9846 | 9846 | 41266 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2929 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2016 12:00:00 AM | 3 | Permit Number 779089 | 6002905.04785 | 2118704.6759200003 | 37.7977228301084 | -122.434017142274 | (37.7977228301084, -122.434017142274) | ||
| 10245 | 10245 | 43062 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 490 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2017 12:00:00 AM | 3 | 3x3 | Permit Number 51464 | 5985348.18764 | 2112571.6735099996 | 37.779871377757296 | -122.49431551232401 | (37.7798713777573, -122.494315512324) | |
| 10851 | 10851 | 52794 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1277TEHAMA Houston St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2006 12:00:00 AM | Permit Number 48833 | ||||||||
| 10944 | 10944 | 35742 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/1998 12:00:00 AM | Permit Number 39016 | |||||||||
| 10980 | 10980 | 52793 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1277TEHAMA Houston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2006 12:00:00 AM | Permit Number 48833 | ||||||||
| 11876 | 11876 | 38200 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 514 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 12 | 3x3 | Permit Number 45184 | 6010449.69037 | 2092207.2371 | 37.7253921259422 | -122.406042793857 | (37.7253921259422, -122.406042793857) |
| 13065 | 13065 | 52792 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1277TEHAMA Houston St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2006 12:00:00 AM | Permit Number 48833 | ||||||||
| 13295 | 13295 | 187666 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 107 Bernard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 2ft | 6008318.73536 | 2118064.92593 | 37.796271980829 | -122.415238929252 | (37.796271980829, -122.415238929252) | ||||
| 14122 | 14122 | 35743 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/1998 12:00:00 AM | Permit Number 39016 | |||||||||
| 14808 | 14808 | 106045 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 2201X 20th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2014 12:00:00 AM | 14 | 4x14 | Permit Number 772230 | 6011471.492269999 | 2104620.16703 | 37.7595324691706 | -122.403383358282 | (37.7595324691706, -122.403383358282) |
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");