Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantDate, PlotSize, PermitNotes
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15847 | 15847 | 11469 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 39X Hawkins Ln | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/1992 12:00:00 AM | 9 | 3X3 | 6016835.012019999 | 2095606.77415 | 37.735081653692 | -122.38420575361401 | (37.735081653692, -122.384205753614) | ||
23298 | 23298 | 16667 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 224 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 3x3 | 6002859.4217 | 2106954.1416 | 37.7654562279366 | -122.433334922887 | (37.7654562279366, -122.433334922887) | |||
26335 | 26335 | 239363 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3995 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6003937.45795 | 2100690.36733 | 37.748318487114894 | -122.429159577477 | (37.7483184871149, -122.429159577477) | |||
26848 | 26848 | 239353 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 333 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6003763.4516900005 | 2098632.19433 | 37.7426573690441 | -122.429614519315 | (37.7426573690441, -122.429614519315) | |||
26988 | 26988 | 248441 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 739 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5998553.128 | 2108007.4759 | 37.7681031739849 | -122.44830520423099 | (37.7681031739849, -122.448305204231) | |||
27334 | 27334 | 240136 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 277 27th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6004700.17371 | 2100146.19558 | 37.7468674642611 | -122.426483383002 | (37.7468674642611, -122.426483383002) | |||
28850 | 28850 | 110361 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1155 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 6008381.52689 | 2115877.48528 | 37.790269335318996 | -122.41486676369699 | (37.790269335319, -122.414866763697) | ||||
30474 | 30474 | 138425 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1901 SUTTER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6003355.5073 | 2114484.6624 | 37.786161305767706 | -122.432156906104 | (37.7861613057677, -122.432156906104) | |||
34193 | 34193 | 122096 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 515 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5990911.764769999 | 2111862.01127 | 37.778246853274105 | -122.475017013162 | (37.7782468532741, -122.475017013162) | |||
36006 | 36006 | 246059 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 602 Shrader St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5997560.3028 | 2108454.9059 | 37.76927489165771 | -122.451771545977 | (37.7692748916577, -122.451771545977) | |||
37187 | 37187 | 179321 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 6 Merrill St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009462.15792 | 2094931.0044 | 37.732815729946 | -122.409648778469 | (37.732815729946, -122.409648778469) | |||
37471 | 37471 | 137830 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2000 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6002959.8323 | 2115200.8411 | 37.7881053091283 | -122.433577037034 | (37.7881053091283, -122.433577037034) | |||
37696 | 37696 | 32199 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1516 Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/1995 12:00:00 AM | 9 | Permit Number 35524 | 6009302.4465 | 2100450.1305 | 37.7479610974423 | -122.410590548539 | (37.7479610974423, -122.410590548539) | ||
40711 | 40711 | 179300 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 318 Avalon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6003594.26211 | 2092734.45611 | 37.7264539365874 | -122.42977895945499 | (37.7264539365874, -122.429778959455) | |||
40842 | 40842 | 197113 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2030 23rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6012295.98887 | 2102846.65042 | 37.7547087979762 | -122.40040724889299 | (37.7547087979762, -122.400407248893) | |||
40908 | 40908 | 197109 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 600 De Haro St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6012049.36164 | 2105557.39202 | 37.7621381396801 | -122.401450654931 | (37.7621381396801, -122.401450654931) | ||||
46947 | 46947 | 117046 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2205x Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6002022.6426 | 2114300.8047 | 37.785580820217206 | -122.436755092227 | (37.7855808202172, -122.436755092227) | |||
47645 | 47645 | 142218 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 401 CENTRAL AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5999746.1848 | 2109905.9886 | 37.773384146155 | -122.44431500945 | (37.773384146155, -122.44431500945) | |||
49709 | 49709 | 120248 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 164 24th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 6ft | 5988365.09621 | 2114861.46484 | 37.786334585774604 | -122.484046777757 | (37.7863345857746, -122.484046777757) | |||
49804 | 49804 | 239345 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3869 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6004701.96435 | 2101317.0101799998 | 37.7500823517234 | -122.42656054755399 | (37.7500823517234, -122.426560547554) | |||
51742 | 51742 | 141888 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1355 EDDY ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6004065.2695 | 2112854.1643 | 37.78172458138 | -122.42958498914801 | (37.78172458138, -122.429584989148) | |||
58478 | 58478 | 240187 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 84 Chenery St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6004879.89291 | 2097658.89878 | 37.7400480733545 | -122.425684927129 | (37.7400480733545, -122.425684927129) | |||
59397 | 59397 | 31336 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 745 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/1995 12:00:00 AM | 9 | Permit Number 34951 | 6004456.33645 | 2111073.11505 | 37.776856394839 | -122.42810511786001 | (37.776856394839, -122.42810511786) | ||
60127 | 60127 | 30620 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1645 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 9 | Permit Number 34580 | 6008131.7874 | 2108606.0519 | 37.7702896865902 | -122.415215902671 | (37.7702896865902, -122.415215902671) | |
60462 | 60462 | 136252 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 802 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006854.74284 | 2121556.7809200003 | 37.8057773454026 | -122.420552649091 | (37.8057773454026, -122.420552649091) | |||
61577 | 61577 | 240199 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 48 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6002587.38275 | 2096084.8942099998 | 37.7355964094447 | -122.433499023086 | (37.7355964094447, -122.433499023086) | |||
62420 | 62420 | 32198 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1516 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/2002 12:00:00 AM | 9 | Permit Number 45854 | 6009303.2136699995 | 2100469.6159099997 | 37.748014643075706 | -122.410589271476 | (37.7480146430757, -122.410589271476) | |
62974 | 62974 | 66344 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 628 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/1990 12:00:00 AM | 9 | Permit Number 29465 | 6000112.1176 | 2111075.8999 | 37.7766172965815 | -122.44313323876601 | (37.7766172965815, -122.443133238766) | ||
63345 | 63345 | 120250 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 164 24th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 6ft | 5988365.5517 | 2114845.05893 | 37.7862895663335 | -122.484043998391 | (37.7862895663335, -122.484043998391) | |||
64317 | 64317 | 141943 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1101 GOLDEN GATE AVE | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6004162.7275 | 2112162.4936 | 37.77983094307 | -122.42919849613199 | (37.77983094307, -122.429198496132) | |||
64583 | 64583 | 136197 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2101 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6000062.25305 | 2120901.6465 | 37.8035933822804 | -122.444011899049 | (37.8035933822804, -122.444011899049) | |||
65185 | 65185 | 141941 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1101 GOLDEN GATE AVE | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6004098.4852 | 2112152.8429 | 37.779800807673794 | -122.42942005016 | (37.7798008076738, -122.42942005016) | |||
65412 | 65412 | 136219 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2901 Steiner St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6002007.17609 | 2118176.89143 | 37.79622267548079 | -122.437086212761 | (37.7962226754808, -122.437086212761) | |||
67011 | 67011 | 239372 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3531 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6004798.380530001 | 2103661.55417 | 37.756525372754 | -122.426394047952 | (37.756525372754, -122.426394047952) | |||
68363 | 68363 | 213939 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2526 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5992077.721369999 | 2098220.5392 | 37.7408584659515 | -122.469990060101 | (37.7408584659515, -122.469990060101) | |||
68727 | 68727 | 200945 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1620 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6008108.7332 | 2108716.8122 | 37.7705925126951 | -122.415303489324 | (37.7705925126951, -122.415303489324) | |||
69936 | 69936 | 213969 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1061 Capitol Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5995027.18674 | 2091165.82123 | 37.7216579869959 | -122.459281227274 | (37.7216579869959, -122.459281227274) | |||
70424 | 70424 | 124324 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 109 Jordan Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 5996182.48161 | 2113700.3553299997 | 37.7835985094544 | -122.45691677945 | (37.7835985094544, -122.45691677945) | |||
70999 | 70999 | 179320 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 6 Merrill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009455.67793 | 2094945.80172 | 37.7328559971016 | -122.409672225595 | (37.7328559971016, -122.409672225595) | |||
71447 | 71447 | 136229 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1695 North Point St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6002733.14719 | 2120927.81311 | 37.8038172262563 | -122.434771025084 | (37.8038172262563, -122.434771025084) | |||
72007 | 72007 | 179292 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 180 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6004024.15435 | 2092667.6547299998 | 37.7262948492128 | -122.428288081343 | (37.7262948492128, -122.428288081343) | |||
74416 | 74416 | 246027 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2 Belvedere St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5998205.4802 | 2108541.9693 | 37.76955087528 | -122.449546194352 | (37.76955087528, -122.449546194352) | |||
74659 | 74659 | 240186 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 76 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6004876.9244 | 2097755.23098 | 37.740312411980206 | -122.425702045734 | (37.7403124119802, -122.425702045734) | |||
75038 | 75038 | 246064 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 601 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5997522.9034 | 2108415.3867 | 37.7691642400439 | -122.45189805652399 | (37.7691642400439, -122.451898056524) | |||
77012 | 77012 | 73715 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2012 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/1984 12:00:00 AM | 9 | 6012416.66148 | 2102853.00124 | 37.7547329645749 | -122.399990373555 | (37.7547329645749, -122.399990373555) | ||
105462 | 105462 | 43565 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 527 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2000 12:00:00 AM | 9 | 3x3 | Permit Number 43226 | 6003161.6606046 | 2098886.62601348 | 37.743321886148 | -122.431713499297 | (37.743321886148, -122.431713499297) |
124403 | 124403 | 4618 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 354 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 3x3 | 6010598.00994 | 2118821.5860200003 | 37.7984774173787 | -122.407405500457 | (37.7984774173787, -122.407405500457) | |||
131009 | 131009 | 240202 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3006 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6002850.86093 | 2096098.0434 | 37.7356474594489 | -122.43258901797701 | (37.7356474594489, -122.432589017977) | |||
131520 | 131520 | 137831 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2000 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6002949.7262 | 2115248.5641 | 37.7882357709282 | -122.43361541433501 | (37.7882357709282, -122.433615414335) | |||
133936 | 133936 | 240197 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 44 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6002619.5193 | 2096053.2786 | 37.7355114234985 | -122.43338565634599 | (37.7355114234985, -122.433385656346) | |||
135716 | 135716 | 213942 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 15 Westgate Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5993008.95688 | 2093342.09181 | 37.72751725271729 | -122.466415744194 | (37.7275172527173, -122.466415744194) | |||
135724 | 135724 | 56157 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 474 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/1973 12:00:00 AM | 9 | Permit Number 12265 | 5990948.43736 | 2112161.09667 | 37.7790701847482 | -122.474911987504 | (37.7790701847482, -122.474911987504) | ||
135920 | 135920 | 239291 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 876 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6009903.2471199995 | 2104137.06349 | 37.7581182600559 | -122.408773069018 | (37.7581182600559, -122.408773069018) | |||
135932 | 135932 | 240188 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 73 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6004313.76435 | 2097764.66953 | 37.74030648905929 | -122.42764990171499 | (37.7403064890593, -122.427649901715) | |||
138897 | 138897 | 110940 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1944X FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 3X3 | 6003020.0 | 2115096.0 | 37.7878208557656 | -122.433361372735 | (37.7878208557656, -122.433361372735) | |||
144529 | 144529 | 4 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1101X Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 3X3 | 5992046.40751 | 2114771.53879 | 37.7863013087655 | -122.471303948198 | (37.7863013087655, -122.471303948198) | |||
147037 | 147037 | 136227 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3630 Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6002616.6752 | 2121115.11425 | 37.804324892641 | -122.435187487615 | (37.804324892641, -122.435187487615) | |||
147505 | 147505 | 247402 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 944 Page St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 0ft | 6002027.7583 | 2109490.1505 | 37.7723722659737 | -122.436392970615 | (37.7723722659737, -122.436392970615) | |||
148769 | 148769 | 50669 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3130 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2004 12:00:00 AM | 9 | Permit Number 47247 | 6002419.67533 | 2119034.32922 | 37.798600414646295 | -122.435720259485 | (37.7986004146463, -122.435720259485) | ||
149660 | 149660 | 179303 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 204 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6003684.6928 | 2092628.55261 | 37.726168269630996 | -122.42945879538901 | (37.726168269631, -122.429458795389) | |||
149720 | 149720 | 239370 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3545 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6004734.2478 | 2103657.77197 | 37.7565113622207 | -122.426615572568 | (37.7565113622207, -122.426615572568) | |||
150546 | 150546 | 213943 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 98 Westwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5995156.25779 | 2093258.2613099997 | 37.727410745106 | -122.45898649333799 | (37.727410745106, -122.458986493338) | |||
150579 | 150579 | 61560 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2117 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/1984 12:00:00 AM | 9 | Permit Number 21520 | 6012109.3133 | 2102790.6962200003 | 37.7545447481545 | -122.401048896306 | (37.7545447481545, -122.401048896306) | |
151661 | 151661 | 239264 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 160 Julian Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006412.02807 | 2106950.6326599997 | 37.7656474975546 | -122.42104699741999 | (37.7656474975546, -122.42104699742) | |||
152868 | 152868 | 179319 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2 Merrill St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009450.87811 | 2094957.47714 | 37.7328877863362 | -122.409689643667 | (37.7328877863362, -122.409689643667) | |||
154173 | 154173 | 213963 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 621 Holloway Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5994830.12755 | 2091215.05246 | 37.7217818326369 | -122.45996596837 | (37.7217818326369, -122.45996596837) | |||
156207 | 156207 | 136214 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3601 Jackson St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5996953.554930001 | 2115974.46386 | 37.7898868527455 | -122.45441350368999 | (37.7898868527455, -122.45441350369) | |||
156526 | 156526 | 179322 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 6 Merrill St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009466.72074 | 2094917.2114400002 | 37.732778113112296 | -122.409632030398 | (37.7327781131123, -122.409632030398) | |||
157228 | 157228 | 39955 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 273 Teddy Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1999 12:00:00 AM | 9 | Permit Number 41217 | 6009804.77414 | 2088411.3721599998 | 37.7149333756547 | -122.408004652316 | (37.7149333756547, -122.408004652316) | |
159656 | 159656 | 42168 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 525 05th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2000 12:00:00 AM | 9 | Permit Number 42460 | 6012645.95751 | 2111148.5484599997 | 37.7775234660795 | -122.399779856677 | (37.7775234660795, -122.399779856677) | ||
161198 | 161198 | 32200 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1548 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/1995 12:00:00 AM | 9 | Permit Number 35525 | 6009311.87257 | 2100296.5048 | 37.7475398037183 | -122.410547106778 | (37.7475398037183, -122.410547106778) | |
161525 | 161525 | 136220 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2901 Steiner St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6002011.27576 | 2118147.89877 | 37.7961433022242 | -122.43706995031201 | (37.7961433022242, -122.437069950312) | |||
161550 | 161550 | 199972 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1200 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6017032.2494 | 2092637.585 | 37.7269397498685 | -122.38331721142401 | (37.7269397498685, -122.383317211424) | |||
161956 | 161956 | 65112 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 367 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | 9 | Permit Number 27081 | 5989323.93516 | 2112879.29731 | 37.78094788727989 | -122.48058432391001 | (37.7809478872799, -122.48058432391) | |
162115 | 162115 | 138075 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1900 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6002996.0585 | 2114912.5257 | 37.7873157236915 | -122.433431089473 | (37.7873157236915, -122.433431089473) | |||
166708 | 166708 | 137981 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1940 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6002965.4976 | 2115097.1921 | 37.7878210367847 | -122.433550025903 | (37.7878210367847, -122.433550025903) | |||
167380 | 167380 | 138444 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1820 POST ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6003354.9599 | 2114191.1274 | 37.785355301736004 | -122.43213783008999 | (37.785355301736, -122.43213783009) | |||
168024 | 168024 | 179299 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 326 Peru Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6004388.44448 | 2093015.96904 | 37.7272718493156 | -122.427053545987 | (37.7272718493156, -122.427053545987) | |||
169270 | 169270 | 73714 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2110 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/1984 12:00:00 AM | 9 | 6012133.53509 | 2102840.64813 | 37.75468325634171 | -122.400968639917 | (37.7546832563417, -122.400968639917) | ||
169277 | 169277 | 30566 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2245 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1995 12:00:00 AM | 9 | Permit Number 34543 | 6002231.0779 | 2118426.8867900004 | 37.796921821948 | -122.436329368507 | (37.796921821948, -122.436329368507) | ||
169427 | 169427 | 248000 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 402 Franconia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009971.140819999 | 2098682.22782 | 37.7431442907726 | -122.408153555751 | (37.7431442907726, -122.408153555751) | |||
169460 | 169460 | 56218 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 475 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/1973 12:00:00 AM | 9 | Permit Number 12339 | 5990899.771790001 | 2112161.89837 | 37.779069565646 | -122.475080398267 | (37.779069565646, -122.475080398267) | ||
170174 | 170174 | 138832 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 745 BUCHANAN ST | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 0ft | 6004455.5234 | 2111072.8991 | 37.7768557558926 | -122.428107915053 | (37.7768557558926, -122.428107915053) | |||
173304 | 173304 | 65517 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2028 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/1990 12:00:00 AM | 9 | Permit Number 28403 | 6003226.452219999 | 2118960.15524 | 37.7984425449573 | -122.43292325730499 | (37.7984425449573, -122.432923257305) | ||
174429 | 174429 | 35739 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 378 Hale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/15/1998 12:00:00 AM | 9 | Permit Number 39013 | 6008634.39829 | 2094282.55173 | 37.7309887985962 | -122.41246474286999 | (37.7309887985962, -122.41246474287) | |
175096 | 175096 | 239364 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3995 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6003953.0649 | 2100692.52563 | 37.7483252967888 | -122.429105762915 | (37.7483252967888, -122.429105762915) | |||
178696 | 178696 | 136211 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 101 Spruce St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5997026.34564 | 2115964.00812 | 37.7898623183414 | -122.454160900321 | (37.7898623183414, -122.454160900321) | |||
179770 | 179770 | 71586 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 121 Goethe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 9 | 5994945.16185 | 2086428.98532 | 37.7086470380903 | -122.459221923276 | (37.7086470380903, -122.459221923276) | ||
181131 | 181131 | 179318 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2 Merrill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009445.77773 | 2094973.4037900001 | 37.7329312316932 | -122.409708400835 | (37.7329312316932, -122.409708400835) | |||
183463 | 183463 | 239287 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 719 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009892.49651 | 2104739.8354599997 | 37.7597727338352 | -122.40885277595899 | (37.7597727338352, -122.408852775959) | |||
185384 | 185384 | 42169 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 525 05th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | 9 | Permit Number 42460 | 6012658.26755 | 2111134.8999400004 | 37.777486676607204 | -122.399736313291 | (37.7774866766072, -122.399736313291) | |
188713 | 188713 | 138427 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1901 SUTTER ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6003418.1055 | 2114492.1548 | 37.786185426920795 | -122.431940868192 | (37.7861854269208, -122.431940868192) |
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");