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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | |||
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) | |||
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) | |||
173991 | 173991 | 179297 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 326 Peru Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6004358.252069999 | 2093034.47753 | 37.7273209621682 | -122.427159238819 | (37.7273209621682, -122.427159238819) | |||
156747 | 156747 | 179296 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 326 Peru Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6004346.75764 | 2093042.32572 | 37.7273418615316 | -122.42719953383998 | (37.7273418615316, -122.42719953384) | |||
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) | |||
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) | |||
72873 | 72873 | 213944 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 98 Westwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5995156.984180001 | 2093277.67362 | 37.7274640883802 | -122.458985387177 | (37.7274640883802, -122.458985387177) | |||
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) | |||
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) | |||
15797 | 15797 | 101777 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1700 Yosemite Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6014038.07825 | 2093123.5904299999 | 37.72810829704029 | -122.39370208181101 | (37.7281082970403, -122.393702081811) | |||
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) | |||
71297 | 71297 | 199665 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1901 Keith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6015244.0778 | 2093456.6965 | 37.729089882168395 | -122.389556118834 | (37.7290898821684, -122.389556118834) | |||
119496 | 119496 | 199666 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1901 Keith St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6015268.2608 | 2093490.7724 | 37.72918478862329 | -122.389474894337 | (37.7291847886233, -122.389474894337) | |||
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) | |||
164981 | 164981 | 197167 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 15 Baldwin Ct | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6017931.28632 | 2093542.2184 | 37.729473341113895 | -122.380272067717 | (37.7294733411139, -122.380272067717) | |||
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) | |||
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) | |||
35501 | 35501 | 197166 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 15 Baldwin Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6017812.186480001 | 2093598.1535200002 | 37.729620355985205 | -122.380687698389 | (37.7296203559852, -122.380687698389) | |||
30856 | 30856 | 197169 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2 Baldwin Ct | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 6017690.0216 | 2093651.3665 | 37.7297597257339 | -122.38111373781 | (37.7297597257339, -122.38111373781) | |||
38610 | 38610 | 213996 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 146 Flood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5999758.63525 | 2094089.70358 | 37.7299571835696 | -122.44313580558399 | (37.7299571835696, -122.443135805584) | |||
59609 | 59609 | 213995 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 146 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5999776.55649 | 2094090.41195 | 37.729960150431 | -122.44307390075399 | (37.729960150431, -122.443073900754) | |||
70907 | 70907 | 197139 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 139 Venus St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6012870.02823 | 2094155.1374099997 | 37.730875736712704 | -122.39781242511101 | (37.7308757367127, -122.397812425111) | |||
182525 | 182525 | 179291 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 65 Badger St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6002393.53271 | 2094418.30005 | 37.731009322903 | -122.434050139316 | (37.731009322903, -122.434050139316) | |||
174223 | 174223 | 179286 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 97 Still St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6002271.23579 | 2094443.82332 | 37.7310724625286 | -122.43447476411801 | (37.7310724625286, -122.434474764118) | |||
183076 | 183076 | 179287 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 97 Still St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6002285.23223 | 2094449.03286 | 37.7310875612396 | -122.43442674840799 | (37.7310875612396, -122.434426748408) | |||
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) | |||
137886 | 137886 | 179289 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 97 Still St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002308.41253 | 2094461.38463 | 37.7311227921608 | -122.43434749296101 | (37.7311227921608, -122.434347492961) | |||
157489 | 157489 | 179290 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 97 Still St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6002318.3672 | 2094465.3447 | 37.7311342306478 | -122.43431336098601 | (37.7311342306478, -122.434313360986) | |||
181073 | 181073 | 78383 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1490 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/14/2004 12:00:00 AM | 5 | 6015869.5519 | 2094203.8416 | 37.7311760546893 | -122.387445886397 | (37.7311760546893, -122.387445886397) | ||
68861 | 68861 | 197140 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 53 Pomona St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 5ft | 6014151.58684 | 2094423.9633799999 | 37.7316851643341 | -122.39340063984 | (37.7316851643341, -122.39340063984) | |||
48741 | 48741 | 71411 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1556 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/1983 12:00:00 AM | 5 | 6015495.2506 | 2094478.7004 | 37.7319100238031 | -122.388759104128 | (37.7319100238031, -122.388759104128) | ||
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) | |||
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) | |||
185244 | 185244 | 179316 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 209 Sweeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009472.2037 | 2094777.58995 | 37.7323950495839 | -122.40960322331199 | (37.7323950495839, -122.409603223312) | |||
175783 | 175783 | 200043 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1598 Lane St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6015271.0088 | 2094675.4616 | 37.732437859472796 | -122.38954809856399 | (37.7324378594728, -122.389548098564) | |||
157622 | 157622 | 200042 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1598 Lane St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6015283.1003 | 2094689.2019 | 37.7324762579969 | -122.389507254289 | (37.7324762579969, -122.389507254289) | |||
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) | |||
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) | |||
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) | |||
68096 | 68096 | 200038 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1598 Lane St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6015316.6267 | 2094740.3159 | 37.7326184655785 | -122.38939491276501 | (37.7326184655785, -122.389394912765) | |||
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) | |||
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) | |||
76235 | 76235 | 179325 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 139 Sweeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009883.98076 | 2094924.5226900002 | 37.7328215611604 | -122.408189966611 | (37.7328215611604, -122.408189966611) | |||
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) | |||
34771 | 34771 | 200748 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1667 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6014912.0282 | 2094835.2906 | 37.73285680655879 | -122.39080035501699 | (37.7328568065588, -122.390800355017) | |||
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) | |||
163220 | 163220 | 200741 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1667 Quesada Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6014891.7516 | 2094855.5671 | 37.7329113566731 | -122.39087187355699 | (37.7329113566731, -122.390871873557) | |||
168559 | 168559 | 179317 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 213 Gaven St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009388.38978 | 2094971.87362 | 37.7329238140651 | -122.40990669864999 | (37.7329238140651, -122.40990669865) | |||
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) | |||
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) | |||
158433 | 158433 | 200739 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1667 Quesada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6014860.3556 | 2094879.7682 | 37.7329760658991 | -122.39098210937901 | (37.7329760658991, -122.390982109379) | |||
137365 | 137365 | 200738 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1667 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6014840.7331 | 2094895.4662 | 37.7330180805666 | -122.39105104685301 | (37.7330180805666, -122.391051046853) | |||
168763 | 168763 | 213992 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 20 Mangels Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 6001188.39506 | 2095218.69175 | 37.733138545197704 | -122.43827381338801 | (37.7331385451977, -122.438273813388) | |||
152226 | 152226 | 197145 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 65 Whitney Young Cir | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6016890.6542 | 2094912.19179 | 37.7331775451961 | -122.38396502668199 | (37.7331775451961, -122.383965026682) | |||
180761 | 180761 | 200726 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1660 Quesada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6014855.123 | 2094958.2582 | 37.7331912931628 | -122.39100568396299 | (37.7331912931628, -122.391005683963) | |||
171836 | 171836 | 197146 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 65 Whitney Young Cir | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017111.39408 | 2094922.05635 | 37.733216832081396 | -122.383202548153 | (37.7332168320814, -122.383202548153) | |||
33109 | 33109 | 197147 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 65 Whitney Young Cir | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017204.67342 | 2094944.70699 | 37.7332841805136 | -122.38288162868099 | (37.7332841805136, -122.382881628681) | |||
169823 | 169823 | 197148 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 65 Whitney Young Cir | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017233.106869999 | 2094952.3109 | 37.7333066302946 | -122.382783854412 | (37.7333066302946, -122.382783854412) | |||
183412 | 183412 | 197149 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 58 Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6017152.11734 | 2094978.18509 | 37.7333732007951 | -122.38306566055401 | (37.7333732007951, -122.383065660554) | |||
54424 | 54424 | 197151 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 99 Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6016637.91847 | 2095129.63156 | 37.7337606161438 | -122.384853953468 | (37.7337606161438, -122.384853953468) | |||
172109 | 172109 | 213994 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 132 Melrose Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5999171.152980001 | 2095530.50421 | 37.7338797682181 | -122.445270345553 | (37.7338797682181, -122.445270345553) | |||
40754 | 40754 | 247569 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 326 Alemany Blvd | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6008658.24946 | 2095385.97007 | 37.7340198862064 | -122.41246025166299 | (37.7340198862064, -122.412460251663) | |||
69161 | 69161 | 247568 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 322 Alemany Blvd | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6008688.67784 | 2095404.14208 | 37.734071490194296 | -122.41235633497101 | (37.7340714901943, -122.412356334971) | |||
60831 | 60831 | 247567 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 320 Alemany Blvd | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 4ft | 6008730.40268 | 2095427.8255 | 37.7341388611064 | -122.412213751984 | (37.7341388611064, -122.412213751984) | |||
160606 | 160606 | 247566 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 318 Alemany Blvd | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6008741.21767 | 2095435.4350400001 | 37.7341603621059 | -122.41217689865101 | (37.7341603621059, -122.412176898651) | |||
44172 | 44172 | 247564 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 316 Alemany Blvd | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 4ft | 6008777.64172 | 2095456.26862 | 37.7342196103425 | -122.412052440585 | (37.7342196103425, -122.412052440585) | |||
44291 | 44291 | 247563 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 316 Alemany Blvd | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6008788.9631 | 2095462.99791 | 37.734238722726495 | -122.41201377422199 | (37.7342387227265, -122.412013774222) | |||
60939 | 60939 | 197154 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 18 Hawkins Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6017001.63224 | 2095478.16332 | 37.734737725070204 | -122.383620731122 | (37.7347377250702, -122.383620731122) | |||
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) | |||
36489 | 36489 | 213993 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 95 Martha Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6000354.21561 | 2095866.7572 | 37.7348705009689 | -122.441204268679 | (37.7348705009689, -122.441204268679) | |||
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) | |||
164209 | 164209 | 197155 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 36 Hawkins Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6016950.769830001 | 2095599.6717299998 | 37.73506855147429 | -122.38380503909401 | (37.7350685514743, -122.383805039094) | |||
168340 | 168340 | 197156 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 70 Hawkins Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6016728.211 | 2095612.50382 | 37.73509148057529 | -122.38457540555001 | (37.7350914805753, -122.38457540555) | |||
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) | |||
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) | |||
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) | |||
154667 | 154667 | 240198 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 46 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002599.46299 | 2096074.44073 | 37.735568391971604 | -122.433456510332 | (37.7355683919716, -122.433456510332) | |||
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) | |||
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) | |||
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) | |||
175081 | 175081 | 240201 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3004 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002850.8471 | 2096117.4239599998 | 37.735700673245 | -122.432590449705 | (37.735700673245, -122.432590449705) | |||
74866 | 74866 | 240196 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 406 Arlington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6004000.46579 | 2096134.03404 | 37.735811408553296 | -122.42861695621 | (37.7358114085533, -122.42861695621) | |||
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) | |||
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) | |||
135819 | 135819 | 197165 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 15 Reuel Ct | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6017366.51517 | 2096051.5594799998 | 37.7363323183867 | -122.382399074074 | (37.7363323183867, -122.382399074074) | |||
133737 | 133737 | 240172 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 553 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008195.53017 | 2096250.8800700002 | 37.73636876251379 | -122.414121189761 | (37.7363687625138, -122.414121189761) | |||
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) | |||
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) | |||
44193 | 44193 | 240203 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 50 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002560.6439 | 2096455.85562 | 37.736613467133004 | -122.433617972817 | (37.736613467133, -122.433617972817) | |||
36074 | 36074 | 240200 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 57 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002464.85342 | 2096514.646 | 37.736769456354 | -122.43395336236401 | (37.736769456354, -122.433953362364) | |||
160304 | 160304 | 247591 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 800 Tompkins Ave | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6008974.65943 | 2096434.5209700002 | 37.736916732029705 | -122.411440373668 | (37.7369167320297, -122.411440373668) | ||||
172651 | 172651 | 71391 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1531 Kirkwood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1988 12:00:00 AM | 4 | 6015562.7322 | 2096452.7948 | 37.737334227876396 | -122.388663558077 | (37.7373342278764, -122.388663558077) | ||
165779 | 165779 | 240173 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 479 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008226.13214 | 2096616.22603 | 37.737373641567395 | -122.414041223846 | (37.7373736415674, -122.414041223846) | |||
58670 | 58670 | 240174 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 455 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008235.53885 | 2096703.3498099998 | 37.7376133927535 | -122.414014861994 | (37.7376133927535, -122.414014861994) | |||
62846 | 62846 | 240171 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 457 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007878.36492 | 2096720.03268 | 37.7376391331344 | -122.415250966654 | (37.7376391331344, -122.415250966654) | |||
173878 | 173878 | 240175 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 449 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008238.06241 | 2096739.7432799998 | 37.7377134629997 | -122.414008710659 | (37.7377134629997, -122.414008710659) |
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");