Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3825 | 3825 | 253557 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1398 Tennessee St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 5ft | 6015583.67362 | 2102658.4010900003 | 37.7543746962452 | -122.38902430045499 | (37.7543746962452, -122.389024300455) | ||||
| 6751 | 6751 | 137889 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2034 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6002935.6901 | 2115351.8703 | 37.7885186270288 | -122.433671363006 | (37.7885186270288, -122.433671363006) | ||||
| 19725 | 19725 | 114507 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 10 LOMBARD ST | 2 | Back Yard : Cutout 16 | Tree 1 | Port 9 | 4x4 | 6011932.0 | 2120995.0 | 37.8045196580749 | -122.402942401468 | (37.8045196580749, -122.402942401468) | ||||
| 20863 | 20863 | 112866 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 750 VICENTE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990595.0 | 2097751.0 | 37.7394834085128 | -122.475082436927 | (37.7394834085128, -122.475082436927) | ||||
| 28416 | 28416 | 99761 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 4212 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 4212-4216 25th St (4214 is visible address) | 6002485.0 | 2101232.0 | 37.749723353108294 | -122.434220849449 | (37.7497233531083, -122.434220849449) | |||
| 77592 | 77592 | 120516 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 888 Brannan St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011018.0 | 2109170.0 | 37.771999940852105 | -122.40527216982201 | (37.7719999408521, -122.405272169822) | ||||
| 77757 | 77757 | 118287 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 240 IVY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2.5 | 6006177.0 | 2111293.0 | 37.777557347021606 | -122.42216843833201 | (37.7775573470216, -122.422168438332) | ||||
| 79651 | 79651 | 96102 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2780X 18th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/2011 12:00:00 AM | 3x3 | Permit Number 767752 | 6009596.8 | 2105493.6 | 37.7618258328219 | -122.40992865921999 | (37.7618258328219, -122.40992865922) | ||
| 83756 | 83756 | 120515 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 888 Brannan St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011018.0 | 2109170.0 | 37.771999940852105 | -122.40527216982201 | (37.7719999408521, -122.405272169822) | ||||
| 88077 | 88077 | 111906 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1699x WASHINGTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006657.0 | 2116952.0 | 37.7931226344993 | -122.42090983270799 | (37.7931226344993, -122.420909832708) | ||||
| 91102 | 91102 | 102673 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 616 Shrader St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997561.0 | 2108438.0 | 37.7692285123205 | -122.451767914676 | (37.7692285123205, -122.451767914676) | ||||
| 92555 | 92555 | 120872 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 16 Ford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003333.0 | 2105685.0 | 37.761998326992504 | -122.43160630843398 | (37.7619983269925, -122.431606308434) | ||||
| 93319 | 93319 | 113204 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3225 26TH ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008227.0 | 2100905.0 | 37.7491497143695 | -122.41434158844801 | (37.7491497143695, -122.414341588448) | ||||
| 93327 | 93327 | 112843 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1415 EVANS AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6016481.0 | 2097724.0 | 37.7408755487739 | -122.385577218432 | (37.7408755487739, -122.385577218432) | |||||
| 94294 | 94294 | 115222 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2252 15TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002543.0 | 2107122.0 | 37.76589916997111 | -122.434441354631 | (37.7658991699711, -122.434441354631) | ||||
| 99727 | 99727 | 112868 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 750 VICENTE ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990595.0 | 2097751.0 | 37.7394834085128 | -122.475082436927 | (37.7394834085128, -122.475082436927) | ||||
| 103743 | 103743 | 96097 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1999 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/2011 12:00:00 AM | 3x3 | Permit Number 767752 | 6009553.0 | 2105475.0 | 37.7617723065941 | -122.41007883348301 | (37.7617723065941, -122.410078833483) | ||
| 107640 | 107640 | 111908 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1699x WASHINGTON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006657.0 | 2116952.0 | 37.7931226344993 | -122.42090983270799 | (37.7931226344993, -122.420909832708) | ||||
| 108509 | 108509 | 96100 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2780X 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/2011 12:00:00 AM | 3x3 | Permit Number 767752 | 6009596.8 | 2105493.6 | 37.7618258328219 | -122.40992865921999 | (37.7618258328219, -122.40992865922) | ||
| 109062 | 109062 | 112867 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 750 VICENTE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990595.0 | 2097751.0 | 37.7394834085128 | -122.475082436927 | (37.7394834085128, -122.475082436927) | ||||
| 109983 | 109983 | 112869 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 750 VICENTE ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990595.0 | 2097751.0 | 37.7394834085128 | -122.475082436927 | (37.7394834085128, -122.475082436927) | ||||
| 111716 | 111716 | 111910 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1699x WASHINGTON ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006657.0 | 2116952.0 | 37.7931226344993 | -122.42090983270799 | (37.7931226344993, -122.420909832708) | ||||
| 114129 | 114129 | 101280 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2201 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5988947.0 | 2106461.0 | 37.7633031017087 | -122.48141813594201 | (37.7633031017087, -122.481418135942) | ||||
| 114300 | 114300 | 112865 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 750 VICENTE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990595.0 | 2097751.0 | 37.7394834085128 | -122.475082436927 | (37.7394834085128, -122.475082436927) | ||||
| 114782 | 114782 | 112164 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 701 MISSION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011822.0 | 2114512.0 | 37.7867127527861 | -122.4028668317 | (37.7867127527861, -122.4028668317) | ||||
| 116732 | 116732 | 118288 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 240 IVY ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2.5 | 6006177.0 | 2111293.0 | 37.777557347021606 | -122.42216843833201 | (37.7775573470216, -122.422168438332) | ||||
| 120937 | 120937 | 120517 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 888 Brannan St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011018.0 | 2109170.0 | 37.771999940852105 | -122.40527216982201 | (37.7719999408521, -122.405272169822) | ||||
| 123602 | 123602 | 120676 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1 Ford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003502.0 | 2105614.0 | 37.7618129556584 | -122.43101673587799 | (37.7618129556584, -122.431016735878) | ||||
| 139854 | 139854 | 111907 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1699x WASHINGTON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006657.0 | 2116952.0 | 37.7931226344993 | -122.42090983270799 | (37.7931226344993, -122.420909832708) | ||||
| 142916 | 142916 | 96107 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2780X 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/2011 12:00:00 AM | 3x3 | Permit Number 767752 | 6009596.8 | 2105493.6 | 37.7618258328219 | -122.40992865921999 | (37.7618258328219, -122.40992865922) | ||
| 145239 | 145239 | 111909 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1699x WASHINGTON ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006657.0 | 2116952.0 | 37.7931226344993 | -122.42090983270799 | (37.7931226344993, -122.420909832708) | ||||
| 3425 | 3425 | 159220 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 372 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5998655.59562 | 2087744.29121 | 37.71247119106079 | -122.446492798529 | (37.7124711910608, -122.446492798529) | |||
| 3492 | 3492 | 159213 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 300 Ellington Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5998902.8056 | 2087977.93006 | 37.7131268274265 | -122.445655159179 | (37.7131268274265, -122.445655159179) | |||
| 48328 | 48328 | 117078 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1506 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 0 | 5x5 | 6003016.0 | 2114040.0 | 37.7849211205465 | -122.433299725252 | (37.7849211205465, -122.433299725252) | |||
| 3810 | 3810 | 193325 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1398 Tennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6015584.15702 | 2102639.39931 | 37.754322548171395 | -122.389021302106 | (37.7543225481714, -122.389021302106) | |||
| 3814 | 3814 | 193324 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1398 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6015583.67362 | 2102658.4010900003 | 37.7543746962452 | -122.38902430045499 | (37.7543746962452, -122.389024300455) | |||
| 3820 | 3820 | 193326 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1398 Tennessee St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6015584.3745800005 | 2102621.5534900003 | 37.754273559383 | -122.389019303814 | (37.754273559383, -122.389019303814) | |||
| 25838 | 25838 | 75303 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 376 Utah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 1 | 6010591.15079 | 2106579.14528 | 37.7648621726769 | -122.40656607695699 | (37.7648621726769, -122.406566076957) | ||
| 28756 | 28756 | 213918 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 50 Hill Point Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5996378.4642199995 | 2106655.73366 | 37.76426707058221 | -122.455729371032 | (37.7642670705822, -122.455729371032) | |||
| 29126 | 29126 | 140884 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 642 SPRUCE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5997209.5584 | 2113437.661 | 37.782936144733 | -122.453344534721 | (37.782936144733, -122.453344534721) | |||
| 29555 | 29555 | 142821 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1760 POLK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6006596.1444 | 2116951.8546 | 37.7931188048508 | -122.421120386791 | (37.7931188048508, -122.421120386791) | |||
| 33428 | 33428 | 197157 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 106 Whitney Young Cir | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6016598.7871900005 | 2095669.6865 | 37.7352413346217 | -122.385026857123 | (37.7352413346217, -122.385026857123) | |||
| 39170 | 39170 | 75389 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 376 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 1 | 6010589.86723 | 2106590.9300700002 | 37.7648944592258 | -122.40657134700199 | (37.7648944592258, -122.406571347002) | ||
| 40781 | 40781 | 101046 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1050 Sansome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | Permit Number 774347 | 6012049.4869099995 | 2119300.00717 | 37.799872179210894 | -122.40241656909201 | (37.7998721792109, -122.402416569092) | ||
| 41586 | 41586 | 197159 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 122 Whitney Young Cir | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6016446.71962 | 2095806.9526900002 | 37.7356098273254 | -122.385562178561 | (37.7356098273254, -122.385562178561) | |||
| 42229 | 42229 | 240207 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 71 Miguel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003881.31618 | 2097271.66945 | 37.738928352668 | -122.429109992458 | (37.738928352668, -122.429109992458) | |||
| 43382 | 43382 | 246032 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 11 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5998172.7746 | 2108470.8044 | 37.7693536035765 | -122.44965419238501 | (37.7693536035765, -122.449654192385) | |||
| 47113 | 47113 | 111740 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 498x 11th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 5992531.49665 | 2112146.31797 | 37.779121219504106 | -122.46943451634199 | (37.7791212195041, -122.469434516342) | |||
| 50543 | 50543 | 239266 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 181 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6007450.5138 | 2107918.2957099997 | 37.7683629591168 | -122.417523681168 | (37.7683629591168, -122.417523681168) | |||
| 59671 | 59671 | 213985 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 431 Capitol Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5995022.34889 | 2088455.31671 | 37.714215306566 | -122.45910178282301 | (37.714215306566, -122.459101782823) | |||
| 60538 | 60538 | 75145 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 376 Utah St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 1 | 6010592.19708 | 2106537.02068 | 37.76474656661821 | -122.406559489431 | (37.7647465666182, -122.406559489431) | ||
| 61184 | 61184 | 197150 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 102 Whitney Young Cir | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6016678.04362 | 2095528.85162 | 37.7348590139212 | -122.38474302838999 | (37.7348590139212, -122.38474302839) | |||
| 64108 | 64108 | 83143 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 101X Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/17/2006 12:00:00 AM | 1 | 6016637.512159999 | 2095504.68596 | 37.7347904181313 | -122.384881478104 | (37.7347904181313, -122.384881478104) | ||
| 66294 | 66294 | 213983 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 201 Lobos St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5994955.32932 | 2088691.9508900002 | 37.7148611951615 | -122.45935055329201 | (37.7148611951615, -122.459350553292) | |||
| 71155 | 71155 | 246033 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 17 Belvedere St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5998175.5001 | 2108450.8177 | 37.769298881123 | -122.44964332461001 | (37.769298881123, -122.44964332461) | |||
| 71681 | 71681 | 197075 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 375 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010369.647419999 | 2106560.6353700003 | 37.7647989539274 | -122.40733089909901 | (37.7647989539274, -122.407330899099) | |||
| 129971 | 129971 | 138441 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1820 POST ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6003436.7333 | 2114199.9413 | 37.785384138383996 | -122.43185554851802 | (37.785384138384, -122.431855548518) | |||
| 132617 | 132617 | 240206 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 81 Miguel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6003903.54766 | 2097252.3303400003 | 37.7388765103369 | -122.429031747817 | (37.7388765103369, -122.429031747817) | |||
| 135664 | 135664 | 213984 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 201 Lobos St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5994978.50476 | 2088691.4656200001 | 37.7148611951759 | -122.459270414704 | (37.7148611951759, -122.459270414704) | |||
| 147100 | 147100 | 240138 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 470 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6003459.77034 | 2100123.18676 | 37.7467340885186 | -122.430770938652 | (37.7467340885186, -122.430770938652) | |||
| 150336 | 150336 | 213982 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 201 Lobos St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5994935.45629 | 2088691.9546700001 | 37.714860062915 | -122.459419242599 | (37.714860062915, -122.459419242599) | |||
| 153566 | 153566 | 200041 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1598 Lane St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6015290.2453 | 2094700.1942 | 37.73250683679421 | -122.389483319509 | (37.7325068367942, -122.389483319509) | |||
| 167622 | 167622 | 213919 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 48 Hill Point Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5996378.49971 | 2106675.08456 | 37.76432020522871 | -122.455730647159 | (37.7643202052287, -122.455730647159) | |||
| 169613 | 169613 | 200039 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1598 Lane St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6015308.9321 | 2094726.0259999998 | 37.7325788017835 | -122.38942051753 | (37.7325788017835, -122.38942051753) | |||
| 175286 | 175286 | 141309 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 74 PARKER AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5996869.9521 | 2114088.2769 | 37.784703091925294 | -122.454566442022 | (37.7847030919253, -122.454566442022) | |||
| 178628 | 178628 | 200040 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1598 Lane St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6015299.5887 | 2094715.0337 | 37.732548101110794 | -122.389452052823 | (37.7325481011108, -122.389452052823) | |||
| 23424 | 23424 | 197132 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 201 Newhall St | 4 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6016788.78445 | 2098277.43468 | 37.742412193171795 | -122.384551543811 | (37.7424121931718, -122.384551543811) | |||
| 23795 | 23795 | 239276 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 313 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6007404.6677 | 2107881.43658 | 37.768259172860105 | -122.41767964611 | (37.7682591728601, -122.41767964611) | |||
| 25710 | 25710 | 138447 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1820 POST ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6003269.2692 | 2114178.8859 | 37.7853168309586 | -122.432433419204 | (37.7853168309586, -122.432433419204) | |||
| 26202 | 26202 | 239326 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 26 Mullen Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009380.8265 | 2099841.0915200002 | 37.746293204883706 | -122.41027651786001 | (37.7462932048837, -122.41027651786) | |||
| 26489 | 26489 | 139379 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1409 LYON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999686.4389 | 2113792.3684 | 37.7840517388464 | -122.44480108896799 | (37.7840517388464, -122.444801088968) | |||
| 35505 | 35505 | 240160 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 4903 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5997783.51169 | 2105613.08498 | 37.7614847543311 | -122.450794550851 | (37.7614847543311, -122.450794550851) | |||
| 35976 | 35976 | 181801 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1919 Santiago St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986905.9682 | 2099586.0566 | 37.744307492185 | -122.487972126615 | (37.744307492185, -122.487972126615) | |||
| 36045 | 36045 | 213990 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 380 Kingston St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 5994010.049330001 | 2099244.86467 | 37.743782519860794 | -122.46338315652099 | (37.7437825198608, -122.463383156521) | |||
| 36909 | 36909 | 141968 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 600 FULTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004837.9618 | 2111622.5068 | 37.778386474037205 | -122.426824094864 | (37.7783864740372, -122.426824094864) | |||
| 38430 | 38430 | 197164 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 15 Reuel Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017108.5730800005 | 2096118.78323 | 37.7365026499645 | -122.383295574057 | (37.7365026499645, -122.383295574057) | |||
| 42163 | 42163 | 239262 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1515 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6007244.80682 | 2107321.6134599997 | 37.766713033200105 | -122.41819289551 | (37.7667130332001, -122.41819289551) | |||
| 42922 | 42922 | 139277 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 725 FULTON ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004315.8695 | 2111494.5451 | 37.778005589649 | -122.428621083615 | (37.778005589649, -122.428621083615) | |||
| 44502 | 44502 | 202037 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 75 Crane St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6012270.3118199995 | 2090901.9422 | 37.7219097135375 | -122.399657426574 | (37.7219097135375, -122.399657426574) | |||
| 47162 | 47162 | 239361 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1400 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6003885.736769999 | 2100085.59963 | 37.746655007529505 | -122.42929530943701 | (37.7466550075295, -122.429295309437) | |||
| 48422 | 48422 | 197116 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1015 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6011950.215340001 | 2103491.63171 | 37.75646048668521 | -122.40164836548 | (37.7564604866852, -122.40164836548) | |||
| 49202 | 49202 | 197168 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2 Baldwin Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017908.19776 | 2093591.9406 | 37.729608594643004 | -122.38035534224899 | (37.729608594643, -122.380355342249) | |||
| 49612 | 49612 | 239279 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 266 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006490.03164 | 2104559.30004 | 37.7590858550479 | -122.420607431291 | (37.7590858550479, -122.420607431291) | |||
| 53227 | 53227 | 179288 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 97 Still St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6002296.73031 | 2094454.79419 | 37.7311040332072 | -122.434387409368 | (37.7311040332072, -122.434387409368) | |||
| 54284 | 54284 | 239283 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2750 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009688.59129 | 2105501.22435 | 37.761851911552206 | -122.409611726409 | (37.7618519115522, -122.409611726409) | |||
| 54847 | 54847 | 197162 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 123 Whitney Young Cir | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6016438.8167 | 2095743.2053 | 37.735434352517 | -122.385585060917 | (37.735434352517, -122.385585060917) | |||
| 65474 | 65474 | 239267 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 174 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6007529.81177 | 2107967.97324 | 37.7685038235247 | -122.417252916882 | (37.7685038235247, -122.417252916882) | |||
| 67554 | 67554 | 240166 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 955 Clayton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 5998780.1300099995 | 2106624.27042 | 37.7643182159335 | -122.44742045909099 | (37.7643182159335, -122.447420459091) | |||
| 72832 | 72832 | 181803 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1915 Santiago St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986942.1793 | 2099588.0871 | 37.7443151796952 | -122.487847067129 | (37.7443151796952, -122.487847067129) | |||
| 75017 | 75017 | 140555 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 864 FULTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6003696.4035 | 2111458.3246 | 37.7778710601657 | -122.430761450875 | (37.7778710601657, -122.430761450875) | |||
| 129883 | 129883 | 137865 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2044 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6002933.4443 | 2115374.3282 | 37.7885801632703 | -122.43368073882401 | (37.7885801632703, -122.433680738824) | |||
| 130186 | 130186 | 142826 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1725 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 0ft | 6006566.9559 | 2116825.8136 | 37.7927710822258 | -122.421212426745 | (37.7927710822258, -122.421212426745) | |||
| 131718 | 131718 | 106807 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 167 Commonwealth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 5996526.1156 | 2113238.8382 | 37.78235103251139 | -122.45569457348499 | (37.7823510325114, -122.455694573485) | ||||
| 132038 | 132038 | 239321 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 78 Norwich St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 6008940.36814 | 2099480.93118 | 37.74527958439511 | -122.411774130991 | (37.7452795843951, -122.411774130991) | ||||
| 135095 | 135095 | 239352 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 581 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002854.305240001 | 2098872.3384700003 | 37.7432652289055 | -122.43277523341699 | (37.7432652289055, -122.432775233417) | |||
| 137452 | 137452 | 197161 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 130 Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6016392.6723 | 2096037.13258 | 37.7362388644345 | -122.38576508091299 | (37.7362388644345, -122.385765080913) | |||
| 147715 | 147715 | 138510 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1910 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6002995.9377 | 2114140.5454 | 37.785196054628294 | -122.433376321644 | (37.7851960546283, -122.433376321644) | |||
| 148185 | 148185 | 202038 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 75 Crane St | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6012275.87253 | 2090920.17769 | 37.7219600944649 | -122.39963948420099 | (37.7219600944649, -122.399639484201) | |||
| 149879 | 149879 | 197163 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 15 Reuel Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017071.14695 | 2096120.91017 | 37.7365064217414 | -122.383425121372 | (37.7365064217414, -122.383425121372) | |||
| 152812 | 152812 | 143549 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2245 UNION ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6002240.1517 | 2118427.2493 | 37.7969233328664 | -122.436297997013 | (37.7969233328664, -122.436297997013) |
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");