Street_Tree_List

Data source: data.sfgov.org

958 rows where qSiteInfo = 9 and qSpecies = 19 sorted by YCoord

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, PlotSize

qSiteInfo

  • Sidewalk: Property side : Yard · 958
Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord ▼ Latitude Longitude Location
24631 176638 Undocumented 2 Juniperus chinensis :: Juniper 19 65 Santa Barbara Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 8ft   5993323.454919999 2086371.47099 37.7083957495352 -122.46482253315399 (37.7083957495352, -122.464822533154)
82512 176641 Undocumented 2 Juniperus chinensis :: Juniper 19 89 Belle Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 2ft   5991622.07464 2086489.1085299999 37.708620512601705 -122.47071121118 (37.7086205126017, -122.47071121118)
76107 187484 Undocumented 2 Juniperus chinensis :: Juniper 19 701 Velasco Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     18 Width 3ft   6006683.55132 2086560.9884900001 37.7096773634854 -122.418661795732 (37.7096773634854, -122.418661795732)
145739 176592 Undocumented 2 Juniperus chinensis :: Juniper 19 2249 Cayuga Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 10ft   5996118.04902 2086754.98706 37.70960952494271 -122.455191839948 (37.7096095249427, -122.455191839948)
72240 176634 Undocumented 2 Juniperus chinensis :: Juniper 19 600 Blanken Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15 Width 5ft   6013132.57563 2086873.0357 37.7108951651419 -122.396394525203 (37.7108951651419, -122.396394525203)
92201 176628 Undocumented 2 Juniperus chinensis :: Juniper 19 3067 Alemany Blvd 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 1ft   5996456.31752 2087068.2457400002 37.7104890628041 -122.454045341035 (37.7104890628041, -122.454045341035)
60393 176642 Undocumented 2 Juniperus chinensis :: Juniper 19 450 Palmetto Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 3ft   5993005.954030001 2087230.75027 37.7107368152174 -122.465982240383 (37.7107368152174, -122.465982240383)
130769 176644 Undocumented 2 Juniperus chinensis :: Juniper 19 450 Palmetto Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 3ft   5992981.09091 2087231.27267 37.7107368152211 -122.466068210177 (37.7107368152211, -122.466068210177)
153643 176643 Undocumented 2 Juniperus chinensis :: Juniper 19 450 Palmetto Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 3ft   5992994.85836 2087232.28697 37.7107403945151 -122.46602070080401 (37.7107403945151, -122.466020700804)
177708 176591 Undocumented 2 Juniperus chinensis :: Juniper 19 170 Lawrence Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 2ft   5996818.41137 2087266.2974900003 37.711053623008 -122.45280815898501 (37.711053623008, -122.452808158985)
66575 176855 Undocumented 2 Juniperus chinensis :: Juniper 19 699 Prague St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 2ft   6002700.83355 2087431.53609 37.711842660275394 -122.43248890094499 (37.7118426602754, -122.432488900945)
61753 176856 Undocumented 2 Juniperus chinensis :: Juniper 19 699 Prague St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 2ft   6002702.07598 2087433.5886 37.7118483664744 -122.43248475327499 (37.7118483664744, -122.432484753275)
157915 176857 Undocumented 2 Juniperus chinensis :: Juniper 19 699 Prague St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 2ft   6002703.472569999 2087435.53377 37.711853786683 -122.432480065122 (37.711853786683, -122.432480065122)
176436 176858 Undocumented 2 Juniperus chinensis :: Juniper 19 699 Prague St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 2ft   6002704.995180001 2087438.5155900002 37.711862060452205 -122.432475015405 (37.7118620604522, -122.432475015405)
47827 176859 Undocumented 2 Juniperus chinensis :: Juniper 19 699 Prague St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 2ft   6002706.29177 2087440.6711400002 37.7118680526473 -122.432470687896 (37.7118680526473, -122.432470687896)
52511 176860 Undocumented 2 Juniperus chinensis :: Juniper 19 699 Prague St 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 2ft   6002707.3669 2087442.2073099997 37.711872331601704 -122.432467081601 (37.7118723316017, -122.432467081601)
149485 176861 Undocumented 2 Juniperus chinensis :: Juniper 19 699 Prague St 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 2ft   6002708.23559 2087443.8519099997 37.7118768965747 -122.43246419656 (37.7118768965747, -122.43246419656)
185500 176862 Undocumented 2 Juniperus chinensis :: Juniper 19 699 Prague St 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 2ft   6002709.09569 2087445.08105 37.711880320298 -122.43246131155199 (37.711880320298, -122.432461311552)
161312 176863 Undocumented 2 Juniperus chinensis :: Juniper 19 699 Prague St 9 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 2ft   6002709.8582 2087446.62401 37.7118846001685 -122.43245878624201 (37.7118846001685, -122.432458786242)
39238 176826 Undocumented 2 Juniperus chinensis :: Juniper 19 635 Prague St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 5ft   6002712.89216 2087452.0684200001 37.711899721374 -122.432448688654 (37.711899721374, -122.432448688654)
60604 176825 Undocumented 2 Juniperus chinensis :: Juniper 19 23 Seville St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 2ft   6002184.50257 2087581.6181299998 37.7122254594191 -122.434284204968 (37.7122254594191, -122.434284204968)
149343 176640 Undocumented 2 Juniperus chinensis :: Juniper 19 47 Payson St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 3ft   5991761.59345 2087760.80597 37.7121203547524 -122.47032156819401 (37.7121203547524, -122.470321568194)
183956 176627 Undocumented 2 Juniperus chinensis :: Juniper 19 332 Ellington Ave 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 4ft   5998745.61831 2087840.43325 37.712740316791795 -122.44618856505699 (37.7127403167918, -122.446188565057)
57570 176626 Undocumented 2 Juniperus chinensis :: Juniper 19 332 Ellington Ave 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 4ft   5998755.95892 2087850.85961 37.712769535747206 -122.446153574254 (37.7127695357472, -122.446153574254)
125302 176625 Undocumented 2 Juniperus chinensis :: Juniper 19 332 Ellington Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 4ft   5998763.992880001 2087858.5335799998 37.712791065527796 -122.446126358062 (37.7127910655278, -122.446126358062)
183779 176633 Undocumented 2 Juniperus chinensis :: Juniper 19 110 Newton St 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14 Width 3ft   6000954.59421 2087879.4605599998 37.7129733823892 -122.43855644963399 (37.7129733823892, -122.438556449634)
130697 176632 Undocumented 2 Juniperus chinensis :: Juniper 19 110 Newton St 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 3ft   6000949.95305 2087893.72595 37.713012287961604 -122.43857351247499 (37.7130122879616, -122.438573512475)
25117 219340 Undocumented 2 Juniperus chinensis :: Juniper 19 217 Orizaba Ave 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 4ft   5993976.2548 2087899.9330400003 37.7126301615391 -122.462677198595 (37.7126301615391, -122.462677198595)
148159 176631 Undocumented 2 Juniperus chinensis :: Juniper 19 110 Newton St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 3ft   6000945.59643 2087907.6965599998 37.7130504003174 -122.438589570763 (37.7130504003174, -122.438589570763)
46662 219339 Undocumented 2 Juniperus chinensis :: Juniper 19 217 Orizaba Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15 Width 4ft   5993976.06053 2087910.0728799999 37.712657991947 -122.46267860514999 (37.712657991947, -122.46267860515)
130317 219338 Undocumented 2 Juniperus chinensis :: Juniper 19 217 Orizaba Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 4ft   5993976.25604 2087919.3939099999 37.7126835965453 -122.462678605151 (37.7126835965453, -122.462678605151)
52462 219337 Undocumented 2 Juniperus chinensis :: Juniper 19 217 Orizaba Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16 Width 4ft   5993976.47705 2087929.93053 37.712712540334 -122.462678605144 (37.712712540334, -122.462678605144)
167871 219336 Undocumented 2 Juniperus chinensis :: Juniper 19 217 Orizaba Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 4ft   5993977.06233 2087938.43241 37.7127359181885 -122.462677198601 (37.7127359181885, -122.462677198601)
68329 176623 Undocumented 2 Juniperus chinensis :: Juniper 19 256 Ellington Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 1ft   5999086.11922 2088154.6418400002 37.713622502239794 -122.445034263618 (37.7136225022398, -122.445034263618)
32661 176624 Undocumented 2 Juniperus chinensis :: Juniper 19 190 Foote Ave 15 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 8ft   5998633.901980001 2088379.60151 37.714214369464 -122.446613458762 (37.714214369464, -122.446613458762)
184432 219244 Undocumented 2 Juniperus chinensis :: Juniper 19 4 Farallones St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 2ft   5996960.480830001 2088401.3270400001 37.7141782922784 -122.452398988125 (37.7141782922784, -122.452398988125)
164120 176827 Undocumented 2 Juniperus chinensis :: Juniper 19 1791 Cayuga Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 5ft   5997883.80423 2088433.1189700002 37.7143184408223 -122.44920992919799 (37.7143184408223, -122.449209929198)
181201 219362 Undocumented 2 Juniperus chinensis :: Juniper 19 81 Vernon St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 5ft   5992423.9143900005 2088481.1554 37.7141365322476 -122.468084780709 (37.7141365322476, -122.468084780709)
27887 176613 Undocumented 2 Juniperus chinensis :: Juniper 19 263 Rome St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 0ft   5998491.328480001 2088788.6230099997 37.7153293039925 -122.447135664507 (37.7153293039925, -122.447135664507)
168891 176612 Undocumented 2 Juniperus chinensis :: Juniper 19 275 Rome St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 0ft   5998463.137019999 2088828.41793 37.715436960924 -122.44723596859 (37.715436960924, -122.44723596859)
162215 176611 Undocumented 2 Juniperus chinensis :: Juniper 19 275 Rome St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5998451.26815 2088839.7013700001 37.7154672644752 -122.447277804138 (37.7154672644752, -122.447277804138)
175687 176609 Undocumented 2 Juniperus chinensis :: Juniper 19 1659 Cayuga Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 8ft   5998355.24802 2088872.09815 37.7155507314505 -122.447612021886 (37.7155507314505, -122.447612021886)
161661 176610 Undocumented 2 Juniperus chinensis :: Juniper 19 1659 Cayuga Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 10ft   5998366.15646 2088880.1893799999 37.7155735715352 -122.447574899658 (37.7155735715352, -122.447574899658)
134236 176680 Undocumented 2 Juniperus chinensis :: Juniper 19 301 Rome St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 6ft   5998334.393730001 2088961.07404 37.715793846985996 -122.44769050482701 (37.715793846986, -122.447690504827)
175110 219346 Undocumented 2 Juniperus chinensis :: Juniper 19 81 Byxbee St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 10ft   5991911.85592 2089125.7971700002 37.7158769767191 -122.46990154251999 (37.7158769767191, -122.46990154252)
75947 219345 Undocumented 2 Juniperus chinensis :: Juniper 19 81 Byxbee St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 10ft   5991911.8899300005 2089150.8332900002 37.7159457217874 -122.469903246754 (37.7159457217874, -122.469903246754)
28406 219344 Undocumented 2 Juniperus chinensis :: Juniper 19 81 Byxbee St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 10ft   5991912.69269 2089165.54418 37.71598616072 -122.469901542523 (37.71598616072, -122.469901542523)
68468 219360 Undocumented 2 Juniperus chinensis :: Juniper 19 313 Bright St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 6ft   5993732.0948 2089263.8820200001 37.7163611752992 -122.46362001454901 (37.7163611752992, -122.463620014549)
180880 219359 Undocumented 2 Juniperus chinensis :: Juniper 19 313 Bright St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 6ft   5993732.18416 2089268.1403400002 37.7163728727759 -122.46362001455601 (37.7163728727759, -122.463620014556)
165769 176683 Undocumented 2 Juniperus chinensis :: Juniper 19 2328 Alemany Blvd 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 2ft   5999409.94736 2089269.75185 37.7167028187559 -122.443995073633 (37.7167028187559, -122.443995073633)
48887 219358 Undocumented 2 Juniperus chinensis :: Juniper 19 313 Bright St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 6ft   5993732.273519999 2089272.39867 37.71638457028 -122.463620014563 (37.71638457028, -122.463620014563)
36980 219357 Undocumented 2 Juniperus chinensis :: Juniper 19 313 Bright St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 6ft   5993732.37033 2089277.01188 37.7163972426289 -122.463620014561 (37.7163972426289, -122.463620014561)
181470 219356 Undocumented 2 Juniperus chinensis :: Juniper 19 313 Bright St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 6ft   5993733.55118 2089282.3121 37.7164118638057 -122.46361631744699 (37.7164118638057, -122.463616317447)
62081 176614 Undocumented 2 Juniperus chinensis :: Juniper 19 1531 Cayuga Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 0ft   5998790.48593 2089284.65203 37.7167083747673 -122.44613730731301 (37.7167083747673, -122.446137307313)
182517 190822 Undocumented 2 Juniperus chinensis :: Juniper 19 13 Jennings Ct 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 2ft   6012854.0546699995 2089293.52608 37.7175258486306 -122.397526813914 (37.7175258486306, -122.397526813914)
163530 190821 Undocumented 2 Juniperus chinensis :: Juniper 19 13 Jennings Ct 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 2ft   6012858.0659300005 2089298.3166900002 37.7175392260401 -122.39751328452499 (37.7175392260401, -122.397513284525)
61598 176615 Undocumented 2 Juniperus chinensis :: Juniper 19 73 Rome St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 0ft   5999173.59476 2089300.0418599998 37.716772502713596 -122.44481420042801 (37.7167725027136, -122.444814200428)
43812 176599 Undocumented 2 Juniperus chinensis :: Juniper 19 255 Ottawa Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     17 Width 8ft   5998280.541680001 2089346.8494799999 37.716850019794606 -122.44790439957899 (37.7168500197946, -122.447904399579)
152831 176834 Undocumented 2 Juniperus chinensis :: Juniper 19 1457 Cayuga Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 0ft   5999029.42353 2089515.22336 37.7173551132383 -122.445327990315 (37.7173551132383, -122.445327990315)
151929 219350 Undocumented 2 Juniperus chinensis :: Juniper 19 350 Victoria St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 3ft   5993263.513069999 2089526.9590200002 37.717056510421 -122.465258746617 (37.717056510421, -122.465258746617)
49144 219352 Undocumented 2 Juniperus chinensis :: Juniper 19 350 Victoria St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 3ft   5993266.488919999 2089531.0532200001 37.71706792372179 -122.465248757836 (37.7170679237218, -122.465248757836)
44302 219351 Undocumented 2 Juniperus chinensis :: Juniper 19 350 Victoria St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 3ft   5993263.35325 2089534.6361099998 37.7170775806463 -122.46525985636002 (37.7170775806463, -122.46525985636)
166819 176630 Undocumented 2 Juniperus chinensis :: Juniper 19 271 Prague St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 8ft   6004066.09018 2089571.2619999999 37.7177952090644 -122.427922568075 (37.7177952090644, -122.427922568075)
72856 219335 Undocumented 2 Juniperus chinensis :: Juniper 19 261 Thrift St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 3ft   5994423.037830001 2089616.126 37.7173681417119 -122.461257314797 (37.7173681417119, -122.461257314797)
147731 219334 Undocumented 2 Juniperus chinensis :: Juniper 19 800 Capitol Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 10ft   5995082.86973 2089689.0619599998 37.717606358621104 -122.45898187623001 (37.7176063586211, -122.45898187623)
161516 219361 Undocumented 2 Juniperus chinensis :: Juniper 19 606 Shields St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     33 Width 4ft   5992405.16075 2089868.2609299999 37.717944105311 -122.468250447523 (37.717944105311, -122.468250447523)
29711 218145 Undocumented 2 Juniperus chinensis :: Juniper 19 31 Ashton Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9     5994144.20993 2090116.67038 37.7187264660332 -122.462257368104 (37.7187264660332, -122.462257368104)
173591 219330 Undocumented 2 Juniperus chinensis :: Juniper 19 1025 Junipero Serra Blvd 19 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 3ft   5991259.76279 2090425.50198 37.7194079318084 -122.472250145444 (37.7194079318084, -122.472250145444)
65469 219343 Undocumented 2 Juniperus chinensis :: Juniper 19 295 Byxbee St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 6ft   5991924.98252 2090428.4017299998 37.7194543701096 -122.469950959395 (37.7194543701096, -122.469950959395)
166707 219342 Undocumented 2 Juniperus chinensis :: Juniper 19 295 Byxbee St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 6ft   5991925.44739 2090450.4823200002 37.719515024881794 -122.469950959366 (37.7195150248818, -122.469950959366)
40817 176682 Undocumented 2 Juniperus chinensis :: Juniper 19 1998 Alemany Blvd 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 2ft   6000630.5225599995 2090456.6587099999 37.7200313490478 -122.43986121213301 (37.7200313490478, -122.439861212133)
188529 219331 Undocumented 2 Juniperus chinensis :: Juniper 19 1025 Junipero Serra Blvd 21 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 3ft   5991262.34027 2090458.54246 37.7194988020073 -122.472243643342 (37.7194988020073, -122.472243643342)
161077 176681 Undocumented 2 Juniperus chinensis :: Juniper 19 1998 Alemany Blvd 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 2ft   6000637.29788 2090464.1729400002 37.7200523670946 -122.439838330692 (37.7200523670946, -122.439838330692)
24248 219332 Undocumented 2 Juniperus chinensis :: Juniper 19 1025 Junipero Serra Blvd 22 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 3ft   5991262.77441 2090479.13965 37.719555381949206 -122.47224364333 (37.7195553819492, -122.47224364333)
184130 219353 Undocumented 2 Juniperus chinensis :: Juniper 19 718 Head St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 8ft   5993539.38524 2090524.66713 37.7198118820929 -122.46437759357201 (37.7198118820929, -122.464377593572)
32303 219349 Undocumented 2 Juniperus chinensis :: Juniper 19 513 Ramsell St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15 Width 8ft   5992970.2206 2090529.11347 37.719791266033 -122.466345302087 (37.719791266033, -122.466345302087)
67231 219354 Undocumented 2 Juniperus chinensis :: Juniper 19 718 Head St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15 Width 8ft   5993538.524669999 2090540.93075 37.7198564884635 -122.46438174842699 (37.7198564884635, -122.464381748427)
44537 219348 Undocumented 2 Juniperus chinensis :: Juniper 19 513 Ramsell St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 8ft   5992970.49595 2090542.2168 37.7198272604875 -122.466345302117 (37.7198272604875, -122.466345302117)
187898 219347 Undocumented 2 Juniperus chinensis :: Juniper 19 513 Ramsell St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15 Width 8ft   5992971.18683 2090558.0944400001 37.7198708965006 -122.46634406733999 (37.7198708965006, -122.46634406734)
32893 176636 Undocumented 2 Juniperus chinensis :: Juniper 19 725 Olmstead St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 4ft   6009567.85058 2090563.67809 37.7208298948579 -122.40897533376301 (37.7208298948579, -122.408975333763)
57377 219355 Undocumented 2 Juniperus chinensis :: Juniper 19 718 Head St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 6ft   5993537.41459 2090564.39449 37.719920850243 -122.464387288237 (37.719920850243, -122.464387288237)
153257 176637 Undocumented 2 Juniperus chinensis :: Juniper 19 725 Olmstead St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 4ft   6009580.5453 2090567.0766099999 37.7208399376015 -122.40893169145001 (37.7208399376015, -122.40893169145)
62283 219329 Undocumented 2 Juniperus chinensis :: Juniper 19 100 Miramar Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 4ft   5995365.77553 2090599.7710099998 37.7201232084876 -122.45806987824699 (37.7201232084876, -122.458069878247)
172065 219328 Undocumented 2 Juniperus chinensis :: Juniper 19 101 Miramar Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 4ft   5995301.79244 2090610.0663299998 37.720147800462996 -122.458291789543 (37.720147800463, -122.458291789543)
171560 219327 Undocumented 2 Juniperus chinensis :: Juniper 19 101 Miramar Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 4ft   5995301.64396 2090617.7903200001 37.720169000171296 -122.458292861552 (37.7201690001713, -122.458292861552)
187057 219326 Undocumented 2 Juniperus chinensis :: Juniper 19 101 Miramar Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 4ft   5995302.40607 2090624.5686700002 37.7201876557032 -122.45829071756701 (37.7201876557032, -122.458290717567)
59824 176593 Undocumented 2 Juniperus chinensis :: Juniper 19 556 Delano Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     17 Width 2ft   5999236.66404 2090814.9322900001 37.7209356443574 -122.44470502632099 (37.7209356443574, -122.444705026321)
155443 219333 Undocumented 2 Juniperus chinensis :: Juniper 19 159 Ashton Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 6ft   5994132.08627 2090976.61214 37.721086961572496 -122.46236161210699 (37.7210869615725, -122.462361612107)
37643 219320 Undocumented 2 Juniperus chinensis :: Juniper 19 1090 Capitol Ave 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 1ft   5995079.65544 2091128.71847 37.7215591281313 -122.459097172915 (37.7215591281313, -122.459097172915)
32089 219321 Undocumented 2 Juniperus chinensis :: Juniper 19 1090 Capitol Ave 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 1ft   5995079.2109 2091143.91965 37.7216008413857 -122.45909980971201 (37.7216008413857, -122.459099809712)
32651 219322 Undocumented 2 Juniperus chinensis :: Juniper 19 1090 Capitol Ave 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 1ft   5995079.87033 2091157.1990200002 37.7216373412734 -122.459098491322 (37.7216373412734, -122.459098491322)
147745 219323 Undocumented 2 Juniperus chinensis :: Juniper 19 1090 Capitol Ave 9 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 1ft   5995079.72755 2091168.59616 37.7216686268896 -122.459099809715 (37.7216686268896, -122.459099809715)
42679 219324 Undocumented 2 Juniperus chinensis :: Juniper 19 1090 Capitol Ave 10 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 1ft   5995080.31545 2091178.4589099998 37.721695741442396 -122.459098491311 (37.7216957414424, -122.459098491311)
134794 219325 Undocumented 2 Juniperus chinensis :: Juniper 19 1090 Capitol Ave 11 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 1ft   5995080.6810800005 2091195.9220900002 37.721743712182395 -122.459098491296 (37.7217437121824, -122.459098491296)
34914 176818 Undocumented 2 Juniperus chinensis :: Juniper 19 695 Hamilton St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 3ft   6009866.42198 2091203.0617799999 37.722602230178 -122.407988325128 (37.722602230178, -122.407988325128)
60723 176819 Undocumented 2 Juniperus chinensis :: Juniper 19 691 Hamilton St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 4ft   6009861.20828 2091223.43353 37.7226578748526 -122.40800778375099 (37.7226578748526, -122.408007783751)
30656 176851 Undocumented 2 Juniperus chinensis :: Juniper 19 339 Athens St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 2ft   6004177.9913099995 2091279.54891 37.7224921207944 -122.427657419158 (37.7224921207944, -122.427657419158)
73755 187586 Undocumented 2 Juniperus chinensis :: Juniper 19 611 Holyoke St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 8ft   6010130.12486 2091286.0001700001 37.7228447224995 -122.407082601693 (37.7228447224995, -122.407082601693)
26978 176852 Undocumented 2 Juniperus chinensis :: Juniper 19 339 Athens St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 2ft   6004182.999 2091286.4234200001 37.7225112799465 -122.427640598252 (37.7225112799465, -122.427640598252)
73569 187587 Undocumented 2 Juniperus chinensis :: Juniper 19 611 Holyoke St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 8ft   6010130.636940001 2091289.3744 37.7228540160906 -122.40708106925501 (37.7228540160906, -122.407081069255)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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");
Powered by Datasette · Query took 1296.273ms · Data source: data.sfgov.org