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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
49521 | 49521 | 240131 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 0 Chattanooga St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6004671.7789900005 | 2103561.17999 | 37.7562426115098 | -122.426824733295 | (37.7562426115098, -122.426824733295) | |||
75125 | 75125 | 240132 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 0 Chattanooga St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6004672.38894 | 2103545.66672 | 37.7562000502026 | -122.42682151911801 | (37.7562000502026, -122.426821519118) | |||
154817 | 154817 | 240133 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 0 Chattanooga St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6004672.52486 | 2103529.70008 | 37.756156217245604 | -122.426819912015 | (37.7561562172456, -122.426819912015) | |||
87818 | 87818 | 102145 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 0X Ford St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6003601.0 | 2105679.0 | 37.7619970392507 | -122.430678972901 | (37.7619970392507, -122.430678972901) | |||
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) | |||
114315 | 114315 | 102144 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 0X Ford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003601.0 | 2105679.0 | 37.7619970392507 | -122.430678972901 | (37.7619970392507, -122.430678972901) | |||
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) | ||||
63119 | 63119 | 213926 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1 Hill Point Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5996340.85636 | 2106804.33971 | 37.764672946334294 | -122.45587018867501 | (37.7646729463343, -122.455870188675) | |||
131145 | 131145 | 213991 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1 Merced Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5995344.90173 | 2100199.2685 | 37.7464798897511 | -122.458836668093 | (37.7464798897511, -122.458836668093) | |||
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) | ||||
70153 | 70153 | 179314 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 100 Hamilton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009038.30764 | 2093734.4569599999 | 37.7295065063148 | -122.411029655989 | (37.7295065063148, -122.411029655989) | |||
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) | |||
69300 | 69300 | 179323 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 100 Merrill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009520.85663 | 2094768.8785700002 | 37.7323738561678 | -122.409434403484 | (37.7323738561678, -122.409434403484) | |||
179013 | 179013 | 179324 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 100 Merrill St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009528.37304 | 2094747.8855599998 | 37.7323166349901 | -122.409406936389 | (37.7323166349901, -122.409406936389) | |||
178446 | 178446 | 179313 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 100 Yale St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006918.398519999 | 2093488.03593 | 37.728710780776 | -122.418340943684 | (37.728710780776, -122.418340943684) | |||
50254 | 50254 | 213950 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1006 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5995061.44128 | 2090626.04133 | 37.720177849497794 | -122.459123753274 | (37.7201778494978, -122.459123753274) | |||
67006 | 67006 | 240153 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1008 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5998136.29263 | 2106764.45676 | 37.764666319205205 | -122.449657403985 | (37.7646663192052, -122.449657403985) | |||
25564 | 25564 | 197127 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 101 Newhall St | 13 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6017303.080490001 | 2098110.9339400004 | 37.7419834431736 | -122.382761660942 | (37.7419834431736, -122.382761660942) | |||
152901 | 152901 | 239239 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 101 Scott St | 1 | : 4 | Tree 1 | Private 1 | 20 | Width 6ft | 6002329.06188 | 2108869.34471 | 37.7706848027038 | -122.435306320439 | (37.7706848027038, -122.435306320439) | |||
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) | |||
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) | |||
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) | |||
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) | ||
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) | |||
181078 | 181078 | 239315 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1024 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010214.49456 | 2103222.56761 | 37.7556246873555 | -122.40763215850599 | (37.7556246873555, -122.407632158506) | |||
38315 | 38315 | 179295 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 103 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004297.98606 | 2093012.3139099998 | 37.727256697520204 | -122.42736600014 | (37.7272566975202, -122.42736600014) | |||
170019 | 170019 | 141931 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1050 MCALLISTER ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004116.6344 | 2111867.0624 | 37.7790171527246 | -122.42933687953999 | (37.7790171527246, -122.42933687954) | |||
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) | |||
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) | ||
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) | |||
173068 | 173068 | 197158 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 106 Whitney Young Cir | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6016583.16711 | 2095682.22839 | 37.7352749081106 | -122.385081735533 | (37.7352749081106, -122.385081735533) | |||
29544 | 29544 | 213971 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1061 Capitol Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5995026.07265 | 2091112.6142099998 | 37.7215118291791 | -122.459281227253 | (37.7215118291791, -122.459281227253) | |||
33788 | 33788 | 213974 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1061 Capitol Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5995026.3935 | 2091022.299 | 37.7212638636298 | -122.459273581222 | (37.7212638636298, -122.459273581222) | |||
36604 | 36604 | 213973 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1061 Capitol Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5995027.24606 | 2091045.4090900002 | 37.721327367434604 | -122.459272306869 | (37.7213273674346, -122.459272306869) | |||
59382 | 59382 | 213975 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1061 Capitol Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5995024.51997 | 2091003.2487299999 | 37.7212114484221 | -122.45927867859501 | (37.7212114484221, -122.459278678595) | |||
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) | |||
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) | |||
124104 | 124104 | 213976 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1061 Capitol Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5995023.46765 | 2090970.5982400002 | 37.7211217374705 | -122.459279952923 | (37.7211217374705, -122.459279952923) | |||
172877 | 172877 | 213968 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1061 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5995026.496169999 | 2091185.65951 | 37.7217124184688 | -122.459285050266 | (37.7217124184688, -122.459285050266) | |||
177551 | 177551 | 213972 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1061 Capitol Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5995029.65711 | 2091072.52436 | 37.721401958108295 | -122.459265935174 | (37.7214019581083, -122.459265935174) | |||
30190 | 30190 | 136213 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 107 Spruce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5997027.70911 | 2115921.73522 | 37.78974632646779 | -122.45415312837099 | (37.7897463264678, -122.454153128371) | |||
41318 | 41318 | 240143 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 109 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5998171.35185 | 2106192.58759 | 37.763098116497204 | -122.449494935145 | (37.7630981164972, -122.449494935145) | |||
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) | |||
27161 | 27161 | 197088 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6014473.69906 | 2102184.6927400003 | 37.753012404101 | -122.39282976818998 | (37.753012404101, -122.39282976819) | |||
36178 | 36178 | 197095 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 6014479.30677 | 2102077.89395 | 37.7527194688438 | -122.39280290452601 | (37.7527194688438, -122.392802904526) | |||
41596 | 41596 | 197086 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6014471.44073 | 2102209.38753 | 37.7530800852958 | -122.39283930551599 | (37.7530800852958, -122.392839305516) | |||
45418 | 45418 | 197094 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6014478.47867 | 2102089.9100099998 | 37.7527524163908 | -122.392806608832 | (37.7527524163908, -122.392806608832) | |||
62833 | 62833 | 197084 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6014468.76337 | 2102245.03022 | 37.753177803814 | -122.39285105782801 | (37.753177803814, -122.392851057828) | |||
134469 | 134469 | 197089 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 6014473.51573 | 2102162.27258 | 37.7529508329366 | -122.39282883379101 | (37.7529508329366, -122.392828833791) | |||
149097 | 149097 | 197092 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6014476.97343 | 2102121.40509 | 37.752838811567 | -122.392814017467 | (37.752838811567, -122.392814017467) | |||
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) | |||
160169 | 160169 | 197087 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6014472.10243 | 2102198.29911 | 37.753049675611 | -122.39283624152 | (37.753049675611, -122.39283624152) | |||
170402 | 170402 | 197083 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6014468.24915 | 2102256.69833 | 37.7532098133945 | -122.392853652369 | (37.7532098133945, -122.392853652369) | |||
171068 | 171068 | 197090 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 6014474.311480001 | 2102148.65752 | 37.752913493081294 | -122.39282512948 | (37.7529134930813, -122.39282512948) | |||
181135 | 181135 | 197093 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6014477.98301 | 2102105.11898 | 37.7527941494528 | -122.392809386851 | (37.7527941494528, -122.392809386851) | |||
181973 | 181973 | 197091 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 6014475.63706 | 2102134.7648099996 | 37.7528754202862 | -122.39281957348601 | (37.7528754202862, -122.392819573486) | |||
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) | |||
36414 | 36414 | 136262 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 11 Filbert St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6012539.8548099995 | 2120210.2855 | 37.8023989459081 | -122.400783688018 | (37.8023989459081, -122.400783688018) | ||||
77015 | 77015 | 197152 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 11 Jakey Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6016707.19345 | 2095564.5930700002 | 37.734958764918396 | -122.384644735176 | (37.7349587649184, -122.384644735176) | |||
175020 | 175020 | 197153 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 11 Jakey Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6016721.84036 | 2095568.4819 | 37.734970252878796 | -122.384594365947 | (37.7349702528788, -122.384594365947) | |||
45950 | 45950 | 197160 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 11 Mabrey Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6016488.26571 | 2095902.24457 | 37.7358737783612 | -122.385425174944 | (37.7358737783612, -122.385425174944) | |||
39213 | 39213 | 239316 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1100 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 6ft | 6010239.40016 | 2102763.26328 | 37.7543649341213 | -122.407513645861 | (37.7543649341213, -122.407513645861) | |||
185144 | 185144 | 239317 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1100 Hampshire St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 6ft | 6010240.72628 | 2102744.15996 | 37.7543125548829 | -122.407507713025 | (37.7543125548829, -122.407507713025) | |||
25009 | 25009 | 197076 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1101 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6014915.77906 | 2102946.7050400004 | 37.7551292724085 | -122.39135422264098 | (37.7551292724085, -122.391354222641) | |||
64389 | 64389 | 197077 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1101 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6014934.55258 | 2102947.77391 | 37.7551332492083 | -122.391289372524 | (37.7551332492083, -122.391289372524) | |||
115937 | 115937 | 197078 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1101 23rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6014978.14287 | 2102950.87924 | 37.75514419486029 | -122.391138840404 | (37.7551441948603, -122.391138840404) | |||
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) | |||
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) | |||
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) | |||
161134 | 161134 | 199943 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1101 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6017830.3585 | 2092664.2977 | 37.7270571724447 | -122.380559991407 | (37.7270571724447, -122.380559991407) | |||
72140 | 72140 | 239356 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 111 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6005135.00311 | 2098711.3374 | 37.7429522432585 | -122.42487771633101 | (37.7429522432585, -122.424877716331) | |||
31491 | 31491 | 239296 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1114 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6009989.84018 | 2102603.83852 | 37.753913217229 | -122.408365447707 | (37.753913217229, -122.408365447707) | |||
165666 | 165666 | 179334 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1119 Athens St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 6001947.96661 | 2087712.00011 | 37.7125700310481 | -122.43511106143801 | (37.7125700310481, -122.435111061438) | |||
171035 | 171035 | 179335 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1119 Athens St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 6ft | 6001959.57443 | 2087726.76645 | 37.7126112352992 | -122.435071996701 | (37.7126112352992, -122.435071996701) | |||
65822 | 65822 | 74096 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1133 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/1994 12:00:00 AM | 10 | 6001902.78384 | 2087667.7277099998 | 37.712445903022704 | -122.435264062185 | (37.7124459030227, -122.435264062185) | ||
8596 | 8596 | 115210 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 115 Spruce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5997031.37665 | 2115893.5791 | 37.789669227607604 | -122.45413840466298 | (37.7896692276076, -122.454138404663) | |||
129542 | 129542 | 199942 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1151 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6017725.4053 | 2092742.7421 | 37.7272667732913 | -122.38092826799401 | (37.7272667732913, -122.380928267994) | |||
167097 | 167097 | 240168 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 116 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5998899.29279 | 2107504.14215 | 37.766740931067204 | -122.447071634562 | (37.7667409310672, -122.447071634562) | |||
138771 | 138771 | 199941 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1161 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6017637.7639999995 | 2092806.0386 | 37.7274357354826 | -122.38123564590401 | (37.7274357354826, -122.381235645904) | |||
166740 | 166740 | 239355 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 117 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 2ft | 6005097.05649 | 2098708.2685700003 | 37.7429416735155 | -122.425008707103 | (37.7429416735155, -122.425008707103) | |||
136478 | 136478 | 199940 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1177 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6017562.0246 | 2092865.5482 | 37.7275949559017 | -122.381501616556 | (37.7275949559017, -122.381501616556) | |||
4111 | 4111 | 159295 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 118 Whipple Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 02:16:00 PM | 3 | Width 0ft | 5998136.03876 | 2087321.1199900003 | 37.7112795695727 | -122.448258085851 | (37.7112795695727, -122.448258085851) | ||
39057 | 39057 | 120310 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 120 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5988691.601840001 | 2114529.40052 | 37.7854418348342 | -122.482892819932 | (37.7854418348342, -122.482892819932) | |||
4050 | 4050 | 159297 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 120 Whipple Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 01:53:00 PM | 3 | Width 0ft | 5998096.339240001 | 2087362.0634299999 | 37.711389721237104 | -122.448398243388 | (37.7113897212371, -122.448398243388) | ||
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) | |||
54800 | 54800 | 213913 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1205 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 5994820.88687 | 2107315.71116 | 37.7659896869053 | -122.46116439324899 | (37.7659896869053, -122.461164393249) | |||
160675 | 160675 | 213914 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1205 04th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 5994821.63869 | 2107263.01718 | 37.7658450462296 | -122.46115797296999 | (37.7658450462296, -122.46115797297) | |||
56189 | 56189 | 240144 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1207 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5998176.37667 | 2106172.1274099997 | 37.7630422254456 | -122.449476081756 | (37.7630422254456, -122.449476081756) | |||
160986 | 160986 | 240145 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1209 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5998178.05243 | 2106154.45126 | 37.7629937870534 | -122.44946901220301 | (37.7629937870534, -122.449469012203) | |||
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) | ||
170342 | 170342 | 240170 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1210 Shrader St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997763.42944 | 2106350.69035 | 37.763508882764796 | -122.45091719498699 | (37.7635088827648, -122.450917194987) | |||
70320 | 70320 | 181741 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1215 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5985810.6327 | 2106942.082 | 37.7644411641486 | -122.492301073815 | (37.7644411641486, -122.492301073815) | |||
171759 | 171759 | 240146 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1217 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5998179.2817400005 | 2106131.69521 | 37.7629313749956 | -122.449463120725 | (37.7629313749956, -122.449463120725) | |||
4003 | 4003 | 159298 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 122 Whipple Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 02:11:00 PM | 3 | Width 0ft | 5998090.67137 | 2087368.5047400002 | 37.711407083550704 | -122.448418296488 | (37.7114070835507, -122.448418296488) | ||
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) | |||
25023 | 25023 | 213915 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1221 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5993897.03256 | 2107168.07527 | 37.7655311082052 | -122.464349072465 | (37.7655311082052, -122.464349072465) | |||
62773 | 62773 | 213916 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1221 07th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5993897.35256 | 2107155.07888 | 37.7654954419723 | -122.46434702200199 | (37.7654954419723, -122.464347022002) | |||
61276 | 61276 | 240147 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1225 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5998185.557080001 | 2106089.4961900003 | 37.762815866092794 | -122.44943837589399 | (37.7628158660928, -122.449438375894) | |||
75524 | 75524 | 120438 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 123 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5988956.31634 | 2114501.1697400003 | 37.7853797200377 | -122.48197492857099 | (37.7853797200377, -122.481974928571) | |||
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) |
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");