Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qCaretaker, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3007 | 3007 | 253279 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 201X Laguna Honda Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 10x10 | ROW IS 10' tree is street tree | ||||||||
24120 | 24120 | 179207 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1750 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 6006573.63704 | 2087691.58982 | 37.7127755684169 | -122.41912182232402 | (37.7127755684169, -122.419121822324) | |||
26179 | 26179 | 179193 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 170 Brookdale Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 6005644.83636 | 2087196.5165400002 | 37.7113638531203 | -122.422296907583 | (37.7113638531203, -122.422296907583) | |||
26875 | 26875 | 179199 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 65 Blythdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6006710.21835 | 2086918.77417 | 37.710661269476 | -122.41859498419 | (37.710661269476, -122.41859498419) | |||
26907 | 26907 | 179220 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1851 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 6006068.28025 | 2087832.3093700001 | 37.7131334823856 | -122.420878485149 | (37.7131334823856, -122.420878485149) | |||
28202 | 28202 | 179238 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 700 Delano Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 10ft | 5999059.277319999 | 2090470.23045 | 37.7199790480791 | -122.44529342577499 | (37.7199790480791, -122.445293425775) | |||
28265 | 28265 | 179185 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1500 Sunnydale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 6007214.91098 | 2087479.51248 | 37.7122293408956 | -122.41689035163401 | (37.7122293408956, -122.416890351634) | |||
28483 | 28483 | 179209 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1772 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 6006471.88428 | 2087727.6982 | 37.712868983682604 | -122.419476073376 | (37.7128689836826, -122.419476073376) | |||
29074 | 29074 | 213845 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 73 Sequoia Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5998199.26355 | 2097275.97243 | 37.7386168814741 | -122.44875612502199 | (37.7386168814741, -122.448756125022) | |||
30562 | 30562 | 179219 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1901 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 6005910.8454 | 2087904.7300099998 | 37.7133234587798 | -122.42142777398399 | (37.7133234587798, -122.421427773984) | |||
31551 | 31551 | 179200 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 65 Blythdale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 6006727.82618 | 2086918.41314 | 37.7106612694605 | -122.418534101884 | (37.7106612694605, -122.418534101884) | |||
36922 | 36922 | 179240 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 728 Delano Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 10ft | 5998999.67835 | 2090356.64376 | 37.719663762863796 | -122.445491274825 | (37.7196637628638, -122.445491274825) | |||
39093 | 39093 | 179201 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 50 Santos St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6006633.11275 | 2086991.19455 | 37.7108557793466 | -122.418866611803 | (37.7108557793466, -122.418866611803) | |||
40967 | 40967 | 179215 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1900 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 10ft | 6005901.26281 | 2087961.5006799998 | 37.7134787986892 | -122.421464924083 | (37.7134787986892, -122.421464924083) | |||
41514 | 41514 | 240089 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 4725 18th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5999807.85553 | 2105040.70574 | 37.7600288158025 | -122.44375208219 | (37.7600288158025, -122.44375208219) | |||
42567 | 42567 | 179214 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1900 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 10ft | 6005943.70452 | 2087934.63592 | 37.7134074266914 | -122.421316323695 | (37.7134074266914, -122.421316323695) | |||
44475 | 44475 | 179208 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1750 Sunnydale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 6006534.036859999 | 2087707.31011 | 37.712816502856796 | -122.419259808007 | (37.7128165028568, -122.419259808007) | |||
44669 | 44669 | 179195 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 178 Brookdale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6005631.155180001 | 2087152.0442 | 37.7112409697606 | -122.422341035527 | (37.7112409697606, -122.422341035527) | |||
44818 | 44818 | 241264 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 32 Harry St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 6003140.40772 | 2097623.29696 | 37.739851871854704 | -122.43169680777399 | (37.7398518718547, -122.431696807774) | |||
47532 | 47532 | 213788 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 409 Edna St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 5998741.333869999 | 2094177.6114700001 | 37.73014049957229 | -122.44665904717199 | (37.7301404995723, -122.446659047172) | ||||
48309 | 48309 | 179212 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1800 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 10ft | 6006336.27941 | 2087779.02675 | 37.713002282110295 | -122.419948408995 | (37.7130022821103, -122.419948408995) | |||
49167 | 49167 | 179194 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 178 Brookdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6005636.53153 | 2087165.1563799998 | 37.7112772763038 | -122.422323384518 | (37.7112772763038, -122.422323384518) | |||
50936 | 50936 | 179196 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 178 Brookdale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6005626.77881 | 2087137.8945099998 | 37.7112018708407 | -122.42235515666599 | (37.7112018708407, -122.422355156666) | |||
51449 | 51449 | 179241 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 736 Delano Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 8ft | 5998977.898569999 | 2090313.82891 | 37.7195449597169 | -122.44556348228599 | (37.7195449597169, -122.445563482286) | |||
51456 | 51456 | 179205 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1700 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 6006698.43617 | 2087637.4256 | 37.7126338721354 | -122.418686636782 | (37.7126338721354, -122.418686636782) | |||
54048 | 54048 | 179198 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 122 Santos St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 6006476.020330001 | 2086698.2398299999 | 37.7100425404106 | -122.41938879147 | (37.7100425404106, -122.41938879147) | |||
54258 | 54258 | 179206 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1700 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 6006680.55061 | 2087645.0552700001 | 37.712653814591 | -122.418748995784 | (37.712653814591, -122.418748995784) | |||
55470 | 55470 | 179197 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 165 Blythdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6005726.28272 | 2087133.8162 | 37.7111962851662 | -122.42201095643499 | (37.7111962851662, -122.422010956435) | |||
57344 | 57344 | 179191 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 170 Brookdale Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6005654.25627 | 2087232.43068 | 37.711462997092205 | -122.42226689991999 | (37.7114629970922, -122.42226689992) | |||
62592 | 62592 | 248217 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 68 Fair Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 6007016.13375 | 2099427.55153 | 37.7450248801967 | -122.418424042861 | (37.7450248801967, -122.418424042861) | |||
63599 | 63599 | 179204 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 145 Blythdale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 51 | Width 6ft | 6005707.03107 | 2087192.3586400002 | 37.711355944501 | -122.422081651264 | (37.711355944501, -122.422081651264) | |||
63898 | 63898 | 179230 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1725 Sunnydale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 6006577.9120000005 | 2087637.98608 | 37.712628624579395 | -122.41910324683998 | (37.7126286245794, -122.41910324684) | |||
65999 | 65999 | 179218 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1901 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 10ft | 6005890.39204 | 2087918.14698 | 37.713359145694795 | -122.42149942028401 | (37.7133591456948, -122.421499420284) | |||
66491 | 66491 | 213793 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 71 Ashton Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5994122.05349 | 2090285.4565599998 | 37.7191886366294 | -122.46234618875098 | (37.7191886366294, -122.462346188751) | |||
69086 | 69086 | 179225 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1801 Sunnydale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 6006308.59662 | 2087739.45788 | 37.71289207468671 | -122.420041283778 | (37.7128920746867, -122.420041283778) | |||
69779 | 69779 | 179228 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1725 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 6006500.20711 | 2087667.48458 | 37.7127052450291 | -122.419373911274 | (37.7127052450291, -122.419373911274) | |||
70709 | 70709 | 238999 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 237 Murray St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6005666.19134 | 2095362.15963 | 37.733786141604796 | -122.42280304333 | (37.7337861416048, -122.42280304333) | |||
73849 | 73849 | 179210 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1772 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 6006450.99959 | 2087738.82958 | 37.7128983717435 | -122.41954904706499 | (37.7128983717435, -122.419549047065) | |||
73852 | 73852 | 179223 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1801 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 10ft | 6006254.517659999 | 2087760.44493 | 37.7129466536263 | -122.42022968726299 | (37.7129466536263, -122.420229687263) | |||
74045 | 74045 | 136101 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2785 Vallejo St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6000252.61767 | 2117448.04234 | 37.794121560605504 | -122.443104954337 | (37.7941215606055, -122.443104954337) | |||
74136 | 74136 | 179188 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1500 Sunnydale Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6007144.00968 | 2087503.96893 | 37.7122925047707 | -122.41713713998199 | (37.7122925047707, -122.417137139982) | |||
74262 | 74262 | 248215 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 68 Fair Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 8ft | 6006947.08034 | 2099459.96671 | 37.7451099974421 | -122.418665116019 | (37.7451099974421, -122.418665116019) | |||
74934 | 74934 | 240056 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 311 Collingwood St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6002114.60301 | 2103990.27974 | 37.7572759001919 | -122.43569901030199 | (37.7572759001919, -122.435699010302) | |||
75489 | 75489 | 179213 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1800 Sunnydale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 10ft | 6006300.8377 | 2087791.60426 | 37.7130348204719 | -122.420071799571 | (37.7130348204719, -122.420071799571) | |||
76697 | 76697 | 213781 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 312 Hearst Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 5999334.253740001 | 2094401.5427299999 | 37.73078921383029 | -122.44462534279499 | (37.7307892138303, -122.444625342795) | |||
117034 | 117034 | 179222 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1825 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 10ft | 6006153.59555 | 2087799.59528 | 37.7130484649775 | -122.420581285317 | (37.7130484649775, -122.420581285317) | |||
120602 | 120602 | 115341 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1514 SUNNYDALE AVE | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Housing Authority 20 | Private 3 | 3x3 | 6006572.0 | 2087815.0 | 37.7131143345755 | -122.41913622882099 | (37.7131143345755, -122.419136228821) | |||
120882 | 120882 | 213822 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 15 Beachmont Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5990817.07176 | 2095787.79901 | 37.73410582720761 | -122.47417140758999 | (37.7341058272076, -122.47417140759) | |||
130537 | 130537 | 185054 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2779 34th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5985836.7248 | 2096507.7341 | 37.735792809146204 | -122.49144275752501 | (37.7357928091462, -122.491442757525) | |||
133095 | 133095 | 179190 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1600 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6006848.67689 | 2087568.72125 | 37.71245368215921 | -122.418162488524 | (37.7124536821592, -122.418162488524) | |||
134719 | 134719 | 248218 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 68 Fair Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 8ft | 6007026.57203 | 2099414.74402 | 37.744990301261 | -122.418387041131 | (37.744990301261, -122.418387041131) | |||
134919 | 134919 | 179187 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1500 Sunnydale Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6007159.282430001 | 2087497.73072 | 37.712276235134794 | -122.41708391091998 | (37.7122762351348, -122.41708391092) | |||
137241 | 137241 | 136102 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2785 Vallejo St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6000265.24445 | 2117449.5304799997 | 37.794126366590206 | -122.443061371388 | (37.7941263665902, -122.443061371388) | |||
137277 | 137277 | 179221 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1851 Sunnydale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 6006089.55617 | 2087821.5515700001 | 37.713105142972296 | -122.420804184985 | (37.7131051429723, -122.420804184985) | |||
147630 | 147630 | 248216 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 68 Fair Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 8ft | 6006985.57917 | 2099439.80265 | 37.7450567989249 | -122.41853056393299 | (37.7450567989249, -122.418530563933) | |||
147788 | 147788 | 179226 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1751 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 6006357.33519 | 2087720.1094 | 37.7128416937526 | -122.419871454925 | (37.7128416937526, -122.419871454925) | |||
147878 | 147878 | 239001 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 237 Murray St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6005658.56243 | 2095360.74 | 37.7337818131688 | -122.422829317924 | (37.7337818131688, -122.422829317924) | |||
148480 | 148480 | 179186 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1500 Sunnydale Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6007201.69456 | 2087483.6172599997 | 37.712239868336894 | -122.416936322255 | (37.7122398683369, -122.416936322255) | |||
153094 | 153094 | 179242 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 750 Delano Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 10ft | 5998956.14465 | 2090272.2611 | 37.7194295820854 | -122.445635689757 | (37.7194295820854, -122.445635689757) | |||
153537 | 153537 | 213846 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 102 Omar Way | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5998179.98905 | 2097537.07234 | 37.7393326968565 | -122.448841568688 | (37.7393326968565, -122.448841568688) | |||
154768 | 154768 | 179224 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1801 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 6006288.05669 | 2087748.6711799998 | 37.7129162151802 | -122.420112930068 | (37.7129162151802, -122.420112930068) | |||
155573 | 155573 | 179227 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1751 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 10ft | 6006428.508719999 | 2087690.36193 | 37.7127640229211 | -122.419623346348 | (37.7127640229211, -122.419623346348) | |||
157167 | 157167 | 179260 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 498 Capistrano Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6000796.69928 | 2092081.07254 | 37.7245010785535 | -122.439403176636 | (37.7245010785535, -122.439403176636) | |||
159864 | 159864 | 136107 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2844 Fillmore St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6002576.03515 | 2117998.39641 | 37.7957648926996 | -122.43510507374701 | (37.7957648926996, -122.435105073747) | |||
160335 | 160335 | 179202 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 50 Santos St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6006615.933569999 | 2086979.4031 | 37.710822435165205 | -122.41892515139799 | (37.7108224351652, -122.418925151398) | |||
165777 | 165777 | 179211 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1800 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 6006359.89696 | 2087770.1325599998 | 37.7129791911096 | -122.419866148013 | (37.7129791911096, -122.419866148013) | |||
169409 | 169409 | 136104 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2749 Pierce St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6001552.22851 | 2117904.90821 | 37.795450010374296 | -122.43864092293501 | (37.7954500103743, -122.438640922935) | |||
169903 | 169903 | 179261 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 498 Capistrano Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6000794.18444 | 2092068.4744799999 | 37.7244663440343 | -122.43941096744899 | (37.7244663440343, -122.439410967449) | |||
170574 | 170574 | 179216 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1924 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 10ft | 6005874.75653 | 2087979.24642 | 37.7135260301628 | -122.42155779887699 | (37.7135260301628, -122.421557798877) | |||
171933 | 171933 | 239000 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 237 Murray St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6005662.05721 | 2095361.29868 | 37.7337835443673 | -122.422817275103 | (37.7337835443673, -122.422817275103) | |||
172028 | 172028 | 238997 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 237 Murray St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 6005677.01751 | 2095365.0906200001 | 37.7337948002892 | -122.422765822208 | (37.7337948002892, -122.422765822208) | |||
172769 | 172769 | 240055 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 335 Collingwood St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 3ft | 6002120.8328 | 2103881.11635 | 37.7569765176616 | -122.435669655535 | (37.7569765176616, -122.435669655535) | |||
174987 | 174987 | 179243 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 760 Delano Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 2ft | 5998936.4786 | 2090234.74893 | 37.7193254594704 | -122.445700971549 | (37.7193254594704, -122.445700971549) | |||
175658 | 175658 | 213787 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 432 Flood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5997880.54567 | 2094122.1094099998 | 37.7299388958658 | -122.449630891054 | (37.7299388958658, -122.449630891054) | ||||
176469 | 176469 | 179239 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 710 Delano Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 5999034.4965699995 | 2090423.73362 | 37.719849963877394 | -122.44537574252199 | (37.7198499638774, -122.445375742522) | |||
178308 | 178308 | 124091 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 601 Funston Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 5991889.66003 | 2111174.78436 | 37.7764165401705 | -122.47158405457199 | (37.7764165401705, -122.471584054572) | ||||
184195 | 184195 | 179192 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 170 Brookdale Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 6005649.34848 | 2087217.2749299998 | 37.711421105778996 | -122.422282786434 | (37.711421105779, -122.422282786434) | |||
184252 | 184252 | 136097 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2240 Lyon St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 5999362.2119 | 2116523.51189 | 37.791532235263 | -122.44611930918 | (37.791532235263, -122.44611930918) | |||
185850 | 185850 | 179229 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1725 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 6006523.82481 | 2087658.59053 | 37.712682154019 | -122.41929165028999 | (37.712682154019, -122.41929165029) | |||
185866 | 185866 | 179189 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1600 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6007006.17756 | 2087541.64708 | 37.712388206122 | -122.417616198935 | (37.712388206122, -122.417616198935) | |||
188069 | 188069 | 238998 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 237 Murray St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6005671.29421 | 2095363.94691 | 37.7337913369956 | -122.42278552813801 | (37.7337913369956, -122.422785528138) | |||
188341 | 188341 | 179203 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 145 Blythdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6005739.90981 | 2087176.84104 | 37.711315190823996 | -122.42196691216101 | (37.711315190824, -122.421966912161) |
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");