Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, DBH, PlotSize
Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
188071 | 188071 | 182790 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1791 26th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5988113.3036 | 2103133.9629 | 37.754119452236 | -122.48405759118499 | (37.754119452236, -122.484057591185) | |||
185979 | 185979 | 141928 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1050 MCALLISTER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6004234.8996 | 2111882.5726 | 37.779066434664294 | -122.428928858602 | (37.7790664346643, -122.428928858602) | |||
181712 | 181712 | 138466 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1961 SUTTER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6003221.6099 | 2114462.9101 | 37.7860939869982 | -122.43261860104299 | (37.7860939869982, -122.432618601043) | |||
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) | |||
178466 | 178466 | 197104 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1468 25th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6014428.85484 | 2102039.8538900004 | 37.752612216591004 | -122.392974716426 | (37.752612216591, -122.392974716426) | |||
177196 | 177196 | 213954 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 360 Faxon Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5994772.0848 | 2091005.96515 | 37.721204390545104 | -122.460151465241 | (37.7212043905451, -122.460151465241) | |||
176037 | 176037 | 213935 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 19 Forest Side Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5992714.0636 | 2098999.44218 | 37.74303390080429 | -122.46784648283001 | (37.7430339008043, -122.46784648283) | |||
175148 | 175148 | 136110 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1725 Pacific Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6005929.66848 | 2117544.18385 | 37.7947075984216 | -122.423468565942 | (37.7947075984216, -122.423468565942) | |||
173902 | 173902 | 239309 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 8 Fair Oaks St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6005351.1495900005 | 2103566.74632 | 37.7562962839536 | -122.42447563036801 | (37.7562962839536, -122.424475630368) | |||
172017 | 172017 | 179332 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 21 Drake St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001443.39306 | 2086909.8506099998 | 37.7103388409345 | -122.43679763560301 | (37.7103388409345, -122.436797635603) | |||
171603 | 171603 | 213948 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 300 Holloway Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5995862.50546 | 2091234.8214599998 | 37.7218954350104 | -122.456398757109 | (37.7218954350104, -122.456398757109) | |||
170390 | 170390 | 240184 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3371 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6004431.11432 | 2106566.00014 | 37.764479523721704 | -122.427871135859 | (37.7644795237217, -122.427871135859) | |||
167341 | 167341 | 138453 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1901 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6002943.8549 | 2114900.2728 | 37.7872791184788 | -122.433610826756 | (37.7872791184788, -122.433610826756) | |||
167332 | 167332 | 136212 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 101 Spruce St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5997026.477630001 | 2115953.7993900003 | 37.7898342954728 | -122.454159706 | (37.7898342954728, -122.454159706) | |||
166872 | 166872 | 239249 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3750 26th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6005421.44735 | 2100814.19078 | 37.748742373565 | -122.424036779171 | (37.748742373565, -122.424036779171) | |||
166527 | 166527 | 197112 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2051 23rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6012308.80023 | 2102801.3144400003 | 37.754585029698504 | -122.400359759302 | (37.7545850296985, -122.400359759302) | |||
166469 | 166469 | 239248 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 16 Tiffany Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 6ft | 6006371.4941 | 2099835.91554 | 37.746109844791704 | -122.420682079532 | (37.7461098447917, -122.420682079532) | |||
164728 | 164728 | 240141 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 401 27th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003855.31232 | 2100097.24015 | 37.7466852472244 | -122.429401344003 | (37.7466852472244, -122.429401344003) | |||
163550 | 163550 | 113166 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3902 Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5996084.69058 | 2115243.98919 | 37.7878312986742 | -122.457366808459 | (37.7878312986742, -122.457366808459) | |||
162611 | 162611 | 136256 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1422 Vallejo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6006727.18618 | 2118403.8407799997 | 37.7971129818473 | -122.42077010155701 | (37.7971129818473, -122.420770101557) | |||
162116 | 162116 | 136199 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2101 Beach St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000108.92159 | 2120908.29838 | 37.8036143086235 | -122.443850879042 | (37.8036143086235, -122.443850879042) | |||
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) | |||
158473 | 158473 | 34253 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 945 Bay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | 7 | Permit Number 38731 | 6006242.74242 | 2121059.25353 | 37.8043767538414 | -122.42263519386199 | (37.8043767538414, -122.422635193862) | |
157723 | 157723 | 136241 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1679 Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006661.2210800005 | 2116996.6606900003 | 37.7932454995431 | -122.42089839975 | (37.7932454995431, -122.42089839975) | |||
157085 | 157085 | 197085 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 6014468.858580001 | 2102236.49554 | 37.7531543746906 | -122.392850131521 | (37.7531543746906, -122.392850131521) | |||
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) | |||
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) | |||
156143 | 156143 | 136234 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 928 Leavenworth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008238.09244 | 2115632.75649 | 37.7895893093397 | -122.41534570573299 | (37.7895893093397, -122.415345705733) | |||
155091 | 155091 | 138511 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1910 Post St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6002975.4335 | 2114139.0808 | 37.785190869930794 | -122.433447155072 | (37.7851908699308, -122.433447155072) | |||
153317 | 153317 | 179315 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 100 Hamilton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009040.95061 | 2093717.83367 | 37.729461010514605 | -122.411019345266 | (37.7294610105146, -122.411019345266) | |||
152567 | 152567 | 249824 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 285 Kearny St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 0ft | 6010866.76079 | 2120642.6759099998 | 37.8034927229673 | -122.40660393393999 | (37.8034927229673, -122.40660393394) | |||
151589 | 151589 | 48815 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | 5 | Permit Number 46042 | 6014467.97393 | 2102326.82142 | 37.7534023411579 | -122.392859509671 | (37.7534023411579, -122.392859509671) | ||
149063 | 149063 | 239273 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 400 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6007374.78459 | 2107260.9108700003 | 37.7665536733524 | -122.417739020247 | (37.7665536733524, -122.417739020247) | |||
148148 | 148148 | 239334 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3206 Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6008990.25346 | 2099948.20272 | 37.7465654071644 | -122.411634644342 | (37.7465654071644, -122.411634644342) | |||
147968 | 147968 | 200740 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1667 Quesada Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6014877.3618 | 2094866.6866 | 37.732941090123404 | -122.390922400079 | (37.7329410901234, -122.390922400079) | |||
147739 | 147739 | 42170 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 525 05th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2000 12:00:00 AM | 12 | Permit Number 42460 | 6012634.74531 | 2111162.8232 | 37.7775620361946 | -122.399819646269 | (37.7775620361946, -122.399819646269) | ||
147690 | 147690 | 136247 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1723 Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6006549.579919999 | 2116650.11937 | 37.7922876900734 | -122.421260066609 | (37.7922876900734, -122.421260066609) | |||
144769 | 144769 | 689 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1299X Potrero Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6010664.761195901 | 2101498.8811325002 | 37.7509170198962 | -122.40595356703501 | (37.7509170198962, -122.405953567035) | |||
143528 | 143528 | 96049 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1653 Alabama St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767679 | 6009324.0 | 2099841.0 | 37.7462897680072 | -122.410473011409 | (37.7462897680072, -122.410473011409) | |
142130 | 142130 | 30656 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 35 Lafayette St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 10 | 3x3 | Permit Number 34590 | 6007536.63957853 | 2109665.02696878 | 37.773163916329295 | -122.41734957960699 | (37.7731639163293, -122.417349579607) |
141722 | 141722 | 9550 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1195X Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Office of Mayor 21 | 6 | 3X3 | 6003912.3472435 | 2112132.7194564 | 37.7797350134544 | -122.43006254712499 | (37.7797350134544, -122.430062547125) | |||
138813 | 138813 | 69224 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 345 Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1994 12:00:00 AM | 3 | 3x3 | Permit Number 33276 | 6005935.60239934 | 2110883.16438759 | 37.7764184191765 | -122.42297437860701 | (37.7764184191765, -122.422974378607) |
134201 | 134201 | 239246 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1300 Hampshire St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010306.7199800005 | 2101561.6603599996 | 37.7510693666623 | -122.40719613841298 | (37.7510693666623, -122.407196138413) | |||
134067 | 134067 | 197110 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 600 De Haro St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6012050.80748 | 2105527.2247200003 | 37.7620553876595 | -122.40144353408701 | (37.7620553876595, -122.401443534087) | ||||
133236 | 133236 | 197121 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2 Napoleon St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6014057.88074 | 2100147.5071099997 | 37.747395620823 | -122.39412515077 | (37.747395620823, -122.39412515077) | |||
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) | |||
129350 | 129350 | 47638 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 301 Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/2002 12:00:00 AM | Permit Number 45452 | 5998206.68830303 | 2112594.29479697 | 37.7806775849758 | -122.44983409577299 | (37.7806775849758, -122.449834095773) | |||
129195 | 129195 | 16492 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 305X Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1992 12:00:00 AM | 3 | 3X3 | 6016524.668196499 | 2098330.497802 | 37.7425432844059 | -122.385468484111 | (37.7425432844059, -122.385468484111) | ||
128875 | 128875 | 95303 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 701 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2011 12:00:00 AM | 3x3 | Permit Number 767203 | 6006127.5 | 2112421.2 | 37.780652317617005 | -122.422419858646 | (37.780652317617, -122.422419858646) | ||
128120 | 128120 | 43506 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 161 Newman St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2000 12:00:00 AM | Permit Number 43184 | 6007338.4828929 | 2096787.18196624 | 37.7377931534639 | -122.41712235805201 | (37.7377931534639, -122.417122358052) | |||
125862 | 125862 | 87680 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2998 Larkin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/2008 12:00:00 AM | 3x3 | Permit Number 50399 | 6006514.3 | 2121415.1 | 37.805369133986794 | -122.42172073484699 | (37.8053691339868, -122.421720734847) | ||
125389 | 125389 | 18655 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 85 Reuel Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/1999 12:00:00 AM | 3 | 3X4 | 6017364.7700717 | 2096131.8258237 | 37.7365526173752 | -122.382410690517 | (37.7365526173752, -122.382410690517) | ||
124982 | 124982 | 111868 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3399x 16TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004303.0 | 2106535.0 | 37.7643871563547 | -122.428312038708 | (37.7643871563547, -122.428312038708) | ||||
124505 | 124505 | 39115 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 501 Bartlett St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50596 | 6006834.26665835 | 2100862.7419909 | 37.7489553490953 | -122.419154691519 | (37.7489553490953, -122.419154691519) | ||
122413 | 122413 | 87848 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2480 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50600 | 6006948.0 | 2103912.0 | 37.757334318408 | -122.41897764469499 | (37.757334318408, -122.418977644695) | ||
121840 | 121840 | 93814 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 178 Bluxome St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426001 | (37.7744697656056, -122.40000821426) | ||
119903 | 119903 | 95814 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 691 Tennessee St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767553 | 6015464.0 | 2105840.0 | 37.763104051991604 | -122.38966036521799 | (37.7631040519916, -122.389660365218) | |
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) | ||||
116608 | 116608 | 16680 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 248 Noe St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002873.990875499 | 2106855.8321643 | 37.765187120656705 | -122.433277506161 | (37.7651871206567, -122.433277506161) | |||
115346 | 115346 | 34241 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 9 Chattanooga St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/1997 12:00:00 AM | Permit Number 38051 | 6004714.42221556 | 2103615.95230322 | 37.7563954143949 | -122.426681158586 | (37.7563954143949, -122.426681158586) | |||
114370 | 114370 | 100412 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 201x Linden St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/2012 12:00:00 AM | Permit Number 767727 | 6006435.0 | 2110776.0 | 37.7761523386864 | -122.421239206856 | (37.7761523386864, -122.421239206856) | |||
113290 | 113290 | 98121 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 900 York St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | Permit Number 774687 | 6009897.0 | 2103882.5 | 37.7574189360449 | -122.40877671518999 | (37.7574189360449, -122.40877671519) | ||
112997 | 112997 | 106644 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3294 26th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/2014 12:00:00 AM | 3X3 | Permit Number 772448 | 6007856.1 | 2100992.4 | 37.7493688530402 | -122.415630356523 | (37.7493688530402, -122.415630356523) | ||
112178 | 112178 | 8108 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 785 Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/14/1998 12:00:00 AM | 4 | 3X3 | 6004054.06089 | 2111452.3407900003 | 37.777874887005 | -122.429523762111 | (37.777874887005, -122.429523762111) | ||
111046 | 111046 | 52906 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 295 Gaven St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2006 12:00:00 AM | 3x3 | Permit Number 48898 | 6009070.24444642 | 2094849.33610342 | 37.732569516932294 | -122.41099796146001 | (37.7325695169323, -122.41099796146) | ||
110241 | 110241 | 87072 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 395 Byxbee St | 3 | 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) | |||
108702 | 108702 | 116920 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1390x TENNESSEE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015390.0 | 2102613.0 | 37.754239296938295 | -122.389690908339 | (37.7542392969383, -122.389690908339) | ||
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) | ||||
106029 | 106029 | 9979 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 810X Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2011 12:00:00 AM | 12 | 3X3 | Permit Number 54081 | 6003050.1396073 | 2111037.6486225 | 37.7766793527515 | -122.432967039601 | (37.7766793527515, -122.432967039601) | |
105009 | 105009 | 85087 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Chestnut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49476 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | ||||
103857 | 103857 | 7248 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1880X Post St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/04/2015 12:00:00 AM | 6 | 4X4 | 6003177.7471647 | 2114161.423532 | 37.7852636935379 | -122.43274880955 | (37.7852636935379, -122.43274880955) | ||
103400 | 103400 | 102146 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 0X Ford St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003601.0 | 2105679.0 | 37.7619970392507 | -122.430678972901 | (37.7619970392507, -122.430678972901) | |||
102660 | 102660 | 85090 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Chestnut St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | |||||
101671 | 101671 | 114903 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3261 23rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6007278.07200017 | 2102623.89370267 | 37.7538160547365 | -122.41774482262699 | (37.7538160547365, -122.417744822627) | |||
100117 | 100117 | 8939 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 4649X Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 5992577.29346 | 2112701.40564 | 37.7806479856044 | -122.469316501972 | (37.7806479856044, -122.469316501972) | |||
97129 | 97129 | 52059 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3165 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2005 12:00:00 AM | Permit Number 48256 | 6006783.78749917 | 2099933.06553583 | 37.746399825173 | -122.419263309296 | (37.746399825173, -122.419263309296) | |||
96588 | 96588 | 49613 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1626 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/2003 12:00:00 AM | Permit Number 46477 | 6008114.57908688 | 2108709.83276472 | 37.7705736773564 | -122.415282774124 | (37.7705736773564, -122.415282774124) | |||
94770 | 94770 | 8084 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 755X Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/2007 12:00:00 AM | 3 | 3X3 | 6004115.11785 | 2111289.80956 | 37.7774320731857 | -122.429300951982 | (37.7774320731857, -122.429300951982) | ||
94685 | 94685 | 31311 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 709 Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/1995 12:00:00 AM | Permit Number 34949 | 6004473.77987727 | 2110903.29372292 | 37.77639109406471 | -122.428032671161 | (37.7763910940647, -122.428032671161) | |||
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) | ||||
94048 | 94048 | 121095 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1691 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6001097.0 | 2111345.0 | 37.7774122850927 | -122.439745549 | (37.7774122850927, -122.439745549) | |||
91044 | 91044 | 111484 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1745 FOLSOM ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008026.0 | 2108277.0 | 37.7693802414943 | -122.41555852152901 | (37.7693802414943, -122.415558521529) | ||||
88644 | 88644 | 111861 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 201x LOBOS ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x3 | 5994528.0 | 2088713.0 | 37.714894412350205 | -122.460829096166 | (37.7148944123502, -122.460829096166) | ||||
87317 | 87317 | 8192 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1280 Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/16/1991 12:00:00 AM | 6 | 3X3 | 6001602.3460099995 | 2111171.39622 | 37.776964363900596 | -122.437984956441 | (37.7769643639006, -122.437984956441) | ||
87043 | 87043 | 96121 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 234 Bennington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767773 | 6007093.0 | 2096944.0 | 37.7382099281297 | -122.417982227017 | (37.7382099281297, -122.417982227017) | |
86817 | 86817 | 5934 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1355 Eddy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004029.334559999 | 2112693.29822 | 37.781280848415 | -122.42969783017901 | (37.781280848415, -122.429697830179) | |||
85689 | 85689 | 41239 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 270 Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1999 12:00:00 AM | Permit Number 41940 | 5999013.40299918 | 2112000.64122659 | 37.7790936893244 | -122.447000559943 | (37.7790936893244, -122.447000559943) | |||
84924 | 84924 | 88489 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Quesada Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51434 | 6015245.7 | 2094684.2 | 37.732460450023495 | -122.38963620788401 | (37.7324604500235, -122.389636207884) | ||
79081 | 79081 | 85656 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1699X Quesada Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6014788.408146 | 2094944.7735630001 | 37.7331505648623 | -122.39123539488199 | (37.7331505648623, -122.391235394882) | ||
78191 | 78191 | 18254 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1830 Post St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/1998 12:00:00 AM | 12 | 4X4 | 6003416.3649635 | 2114195.205569 | 37.785369980601395 | -122.431925678527 | (37.7853699806014, -122.431925678527) | ||
74086 | 74086 | 239242 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1301 Potrero Ave | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6010651.99768 | 2101656.70763 | 37.751349662874105 | -122.406008821959 | (37.7513496628741, -122.406008821959) | |||
73312 | 73312 | 120776 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 57 21st Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5989252.7771 | 2114825.68271 | 37.7862879782034 | -122.48097304382 | (37.7862879782034, -122.48097304382) | |||
72557 | 72557 | 138536 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1840 Post St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/04/2015 12:00:00 AM | 5 | Width 0ft | 6003152.9747 | 2114161.9926 | 37.7852638510753 | -122.432834555298 | (37.7852638510753, -122.432834555298) | ||
71421 | 71421 | 213970 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1061 Capitol Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995027.09423 | 2091143.79671 | 37.721597507607996 | -122.45927995292699 | (37.721597507608, -122.459279952927) | |||
70539 | 70539 | 52633 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1725@ POLK Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2006 12:00:00 AM | 3 | Permit Number 48716 | 6006431.88211 | 2116964.74466 | 37.79314493643 | -122.42168966107 | (37.79314493643, -122.42168966107) | ||
68616 | 68616 | 137867 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2044 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6002928.9527 | 2115414.1909 | 37.7886893612244 | -122.43369912921301 | (37.7886893612244, -122.433699129213) | |||
66976 | 66976 | 141938 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1101 GOLDEN GATE AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6004007.1195 | 2112144.3973 | 37.779772444920894 | -122.42973552170099 | (37.7797724449209, -122.429735521701) | |||
63717 | 63717 | 240167 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 955 Clayton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 5998784.85204 | 2106603.32437 | 37.764260973182395 | -122.44740261924 | (37.7642609731824, -122.44740261924) | |||
63414 | 63414 | 49886 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 59@ WILDWOOD Eastwood Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2003 12:00:00 AM | Permit Number 46658 | 5995617.4906105995 | 2092991.57857678 | 37.726705001321996 | -122.457372735726 | (37.726705001322, -122.457372735726) | |||
59666 | 59666 | 179298 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 326 Peru Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004373.55102 | 2093025.79015 | 37.7272979737044 | -122.427105731855 | (37.7272979737044, -122.427105731855) |
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");