Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize
qLegalStatus ✖
| Link | rowid | TreeID ▲ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | |||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 36052 | 36052 | 240426 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 60 Brady St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006672.38997 | 2109529.27096 | 37.772742500096705 | -122.42032950031499 | (37.7727425000967, -122.420329500315) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 58739 | 58739 | 240420 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 150 Conrad St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6001790.0985900005 | 2096478.24715 | 37.7366311981596 | -122.436283676644 | (37.7366311981596, -122.436283676644) | |||
| 75414 | 75414 | 240419 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 150 Conrad St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001783.7465 | 2096493.5262099998 | 37.7366727900018 | -122.436306731665 | (37.7366727900018, -122.436306731665) | |||
| 75456 | 75456 | 240418 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 150 Conrad St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6001776.14511 | 2096508.8311299998 | 37.73671438186 | -122.436334107928 | (37.73671438186, -122.436334107928) | |||
| 73938 | 73938 | 240417 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 150 Conrad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6001765.76464 | 2096530.8335799999 | 37.736774205667295 | -122.436371571893 | (37.7367742056673, -122.436371571893) | |||
| 23461 | 23461 | 240416 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 12 Harper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003644.58951 | 2098299.35585 | 37.7417367402568 | -122.43000177276899 | (37.7417367402568, -122.430001772769) | |||
| 50859 | 50859 | 240415 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 751 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6003800.46059 | 2107711.4253 | 37.7675888874331 | -122.43013411340901 | (37.7675888874331, -122.430134113409) | |||
| 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) | ||
| 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) | ||
| 130150 | 130150 | 240411 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 235 Surrey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6001924.04211 | 2096180.04982 | 37.7358200267578 | -122.435799247861 | (37.7358200267578, -122.435799247861) | |||
| 25257 | 25257 | 240410 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 235 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6001912.29637 | 2096185.45895 | 37.735834211766 | -122.43584024433599 | (37.735834211766, -122.435840244336) | |||
| 74383 | 74383 | 240409 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1 Arbor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6002196.797259999 | 2096967.0919299999 | 37.7379965524899 | -122.434912495609 | (37.7379965524899, -122.434912495609) | |||
| 177305 | 177305 | 240408 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 180 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001780.1737 | 2096439.35558 | 37.7365238469964 | -122.436315208675 | (37.7365238469964, -122.436315208675) | |||
| 30553 | 30553 | 240407 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 489 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6003411.63679 | 2096255.36709 | 37.7361112200507 | -122.430661423705 | (37.7361112200507, -122.430661423705) | |||
| 56315 | 56315 | 240406 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 101 Roanoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003419.55137 | 2096211.39701 | 37.7359909366181 | -122.430630923178 | (37.7359909366181, -122.430630923178) | |||
| 188261 | 188261 | 240405 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 130 Roanoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6003457.25772 | 2096114.18055 | 37.735726138447795 | -122.43049362280199 | (37.7357261384478, -122.430493622802) | |||
| 26763 | 26763 | 240404 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 4362 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6000898.63467 | 2103311.26449 | 37.7553423460847 | -122.439855611169 | (37.7553423460847, -122.439855611169) | |||
| 56835 | 56835 | 240403 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 557 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002931.13898 | 2099759.29881 | 37.7457049727185 | -122.43257290392799 | (37.7457049727185, -122.432572903928) | |||
| 70628 | 70628 | 240402 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 4440 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6000362.39575 | 2102290.8235 | 37.7525099241126 | -122.441636854259 | (37.7525099241126, -122.441636854259) | |||
| 54599 | 54599 | 240401 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 499 Hoffman Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000694.66286 | 2101176.32982 | 37.749468718214004 | -122.440407898332 | (37.749468718214, -122.440407898332) | |||
| 179090 | 179090 | 240400 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 499 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000695.68287 | 2101155.78818 | 37.74941237387971 | -122.440402898093 | (37.7494123738797, -122.440402898093) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 125050 | 125050 | 240396 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 122 Highland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6005552.307130001 | 2096648.4643 | 37.737311620735895 | -122.42328818262301 | (37.7373116207359, -122.423288182623) | |||
| 62196 | 62196 | 240395 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 37 Highland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6005177.74113 | 2096695.2803099998 | 37.7374190204687 | -122.42458656083201 | (37.7374190204687, -122.424586560832) | |||
| 172426 | 172426 | 240394 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 27 Topaz Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001499.24152 | 2098615.40839 | 37.742482813337 | -122.43744228675301 | (37.742482813337, -122.437442286753) | |||
| 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) | |||
| 40291 | 40291 | 240392 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1803 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6008038.16649 | 2107910.1392200002 | 37.768373611578205 | -122.415490461517 | (37.7683736115782, -122.415490461517) | |||
| 27641 | 27641 | 240391 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 346 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006743.91028 | 2097051.2853599999 | 37.7384848564878 | -122.41919681678199 | (37.7384848564878, -122.419196816782) | |||
| 76501 | 76501 | 240390 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 48 Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6005917.96775 | 2097681.76661 | 37.740169467433894 | -122.42209730935801 | (37.7401694674339, -122.422097309358) | |||
| 157900 | 157900 | 240389 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 457 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6008913.61949 | 2096192.37009 | 37.7362484143157 | -122.41163431247601 | (37.7362484143157, -122.411634312476) | |||
| 71181 | 71181 | 240388 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 65 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008348.72479 | 2098315.88712 | 37.742047422761296 | -122.413737549756 | (37.7420474227613, -122.413737549756) | |||
| 164927 | 164927 | 240387 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 310 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008249.57192 | 2097137.15027 | 37.7388053020181 | -122.41399702216002 | (37.7388053020181, -122.41399702216) | |||
| 169762 | 169762 | 240386 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 310 Gates St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008247.18934 | 2097121.53396 | 37.738762289236895 | -122.41400415558998 | (37.7387622892369, -122.41400415559) | |||
| 180367 | 180367 | 240385 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 310 Gates St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008245.55924 | 2097104.87481 | 37.738716455307795 | -122.41400861353 | (37.7387164553078, -122.41400861353) | |||
| 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) | |
| 33363 | 33363 | 240383 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 65 Hermann St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6004954.4402 | 2108809.15318 | 37.770668274943205 | -122.426220805247 | (37.7706682749432, -122.426220805247) | |||
| 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) | ||||
| 174144 | 174144 | 240381 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 98 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008070.808569999 | 2107998.41684 | 37.7686178359612 | -122.415383805538 | (37.7686178359612, -122.415383805538) | |||
| 23996 | 23996 | 240380 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 87 14th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008113.4152 | 2107953.3802 | 37.768496570485794 | -122.41523324373199 | (37.7684965704858, -122.415233243732) | |||
| 68004 | 68004 | 240379 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 87 14th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008087.13667 | 2107952.681 | 37.7684931737476 | -122.41532408966002 | (37.7684931737476, -122.41532408966) | |||
| 67968 | 67968 | 240378 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 87 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008072.764690001 | 2107952.79864 | 37.768492689 | -122.41537380956899 | (37.768492689, -122.415373809569) | |||
| 180886 | 180886 | 240377 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 87 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008059.81094 | 2107952.1886400003 | 37.768490286015 | -122.415418572409 | (37.768490286015, -122.415418572409) | |||
| 28437 | 28437 | 240376 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1367 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6007185.77161 | 2107529.7326700003 | 37.76728115653079 | -122.41841184713499 | (37.7672811565308, -122.418411847135) | |||
| 46279 | 46279 | 240375 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 99 Ramona Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6005227.26292 | 2107315.18034 | 37.7665816008793 | -122.425170785627 | (37.7665816008793, -122.425170785627) | |||
| 74323 | 74323 | 240374 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 99 Ramona Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6005228.2825 | 2107285.15785 | 37.7664992238917 | -122.425165122599 | (37.7664992238917, -122.425165122599) | |||
| 71077 | 71077 | 240373 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1373 Utah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6010904.97586 | 2101974.91384 | 37.7522375329589 | -122.405156394162 | (37.7522375329589, -122.405156394162) | |||
| 148073 | 148073 | 240372 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1373 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6010906.21016 | 2101953.93145 | 37.752179988937 | -122.40515064838199 | (37.752179988937, -122.405150648382) | |||
| 188758 | 188758 | 217581 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 500 Randolph St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5992611.7697 | 2088555.8456 | 37.714352460703104 | -122.467440914144 | (37.7143524607031, -122.467440914144) | |||
| 53292 | 53292 | 217579 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 636 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5992273.5996 | 2088560.7555 | 37.714346412845295 | -122.46861011007299 | (37.7143464128453, -122.468610110073) | |||
| 74280 | 74280 | 217578 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 308 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5993138.4427 | 2088550.8537 | 37.7143691463099 | -122.46562017697799 | (37.7143691463099, -122.465620176978) | |||
| 185216 | 185216 | 214045 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 115 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5999297.76132 | 2093768.33781 | 37.7290484986852 | -122.444706006572 | (37.7290484986852, -122.444706006572) | |||
| 31386 | 31386 | 214044 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 119 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5999274.87025 | 2093768.2240099998 | 37.729046879900295 | -122.444785134325 | (37.7290468799003, -122.444785134325) | |||
| 159513 | 159513 | 214043 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 212 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5998768.52981 | 2093586.90837 | 37.7285201208974 | -122.446522546303 | (37.7285201208974, -122.446522546303) | |||
| 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) | |||
| 46883 | 46883 | 214041 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 431 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5997281.4748599995 | 2093791.4004 | 37.7289965565343 | -122.451678093372 | (37.7289965565343, -122.451678093372) | |||
| 134723 | 134723 | 214040 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 111 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5999932.25708 | 2094051.5429 | 37.729862301496 | -122.442532837136 | (37.729862301496, -122.442532837136) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 69594 | 69594 | 214034 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 218 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 1ft | 5998609.02608 | 2093807.55818 | 37.729116861544206 | -122.447089829625 | (37.7291168615442, -122.447089829625) | |||
| 73887 | 73887 | 214033 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 342 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5997821.19553 | 2093821.6931599998 | 37.7291106283447 | -122.449814429211 | (37.7291106283447, -122.449814429211) | |||
| 27695 | 27695 | 214032 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 342 Staples Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5997805.133780001 | 2093821.6600400002 | 37.729109618413 | -122.449869953332 | (37.729109618413, -122.449869953332) | |||
| 31525 | 31525 | 214031 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 119 Gennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5997420.89454 | 2093944.4368 | 37.7294247417474 | -122.45120714359501 | (37.7294247417474, -122.451207143595) | |||
| 116622 | 116622 | 214030 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 133 Baden St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 1ft | 6000729.565880001 | 2094512.14983 | 37.7311724374522 | -122.439809466051 | (37.7311724374522, -122.439809466051) | |||
| 31765 | 31765 | 214029 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 133 Baden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 1ft | 6000729.59206 | 2094530.6160900001 | 37.7312231430208 | -122.43981069901301 | (37.7312231430208, -122.439810699013) | |||
| 30486 | 30486 | 214028 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 130 Baden St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6000768.83365 | 2094531.22311 | 37.7312270433827 | -122.43967507764201 | (37.7312270433827, -122.439675077642) | |||
| 24847 | 24847 | 214027 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 130 Baden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6000768.47308 | 2094513.82924 | 37.7311792633149 | -122.439675077667 | (37.7311792633149, -122.439675077667) | |||
| 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) | |||
| 72907 | 72907 | 214025 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 118 Baden St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6000768.8435 | 2094480.0839900002 | 37.7310866277439 | -122.439671378725 | (37.7310866277439, -122.439671378725) | |||
| 33748 | 33748 | 214024 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 118 Baden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6000768.15588 | 2094464.1173900003 | 37.7310427480136 | -122.43967261170201 | (37.7310427480136, -122.439672611702) | |||
| 36061 | 36061 | 214023 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 111 Hearst Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6000598.84895 | 2094335.4471599997 | 37.7306798113107 | -122.44024870933599 | (37.7306798113107, -122.440248709336) | |||
| 134645 | 134645 | 214022 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 659 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5997050.53703 | 2094389.3323099997 | 37.7306251064676 | -122.45251959171101 | (37.7306251064676, -122.452519591711) | |||
| 40581 | 40581 | 214021 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 75 Fairfield Way | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5993799.03412 | 2093427.92907 | 37.727798498601295 | -122.463690690492 | (37.7277984986013, -122.463690690492) | |||
| 188052 | 188052 | 214020 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 75 Fairfield Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5993790.82197 | 2093445.17793 | 37.727845386546605 | -122.46372033123501 | (37.7278453865466, -122.463720331235) | |||
| 171501 | 171501 | 214019 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 112 Dorado Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5994645.417119999 | 2093146.00663 | 37.7270731423102 | -122.460744326189 | (37.7270731423102, -122.460744326189) | |||
| 66574 | 66574 | 214018 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 2464 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5991736.67899 | 2098669.28572 | 37.742070888761894 | -122.47120193253001 | (37.7420708887619, -122.47120193253) | |||
| 129548 | 129548 | 214017 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1438 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5993685.58433 | 2105688.82171 | 37.761457274651605 | -122.464972976223 | (37.7614572746516, -122.464972976223) | |||
| 32460 | 32460 | 214016 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1310 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992104.55451 | 2106488.0935299997 | 37.7635605748926 | -122.47049926614099 | (37.7635605748926, -122.470499266141) | |||
| 172827 | 172827 | 214015 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1326 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5992108.78084 | 2106403.01661 | 37.763327220596 | -122.470478452218 | (37.763327220596, -122.470478452218) | |||
| 174298 | 174298 | 214014 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1462 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992138.117459999 | 2105483.85764 | 37.7608051492715 | -122.47031004699 | (37.7608051492715, -122.47031004699) |
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");