sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
19658 103913 1 197 6025 03rd St 14 9 1 1   06/19/2013 12:00:00 AM     Permit Number 770276 6013653.2 2091451.0 37.7234943066524 -122.394915533675 (37.7234943066524, -122.394915533675)
20296 103912 1 197 6025 03rd St 13 9 1 1   06/19/2013 12:00:00 AM     Permit Number 770276 6013653.2 2091451.0 37.7234943066524 -122.394915533675 (37.7234943066524, -122.394915533675)
24737 207467 2 197 555 Flood Ave 5 9 1 1     1 Width 10ft   5997138.67547 2094084.4213299998 37.7297929430915 -122.452192893201 (37.7297929430915, -122.452192893201)
25855 176183 2 197 500 Geneva Ave 1 9 1 1     8 Width 5ft   5998729.89326 2090676.55478 37.7205267594696 -122.446446824275 (37.7205267594696, -122.446446824275)
26100 201969 2 197 1651 Carroll Ave 22 9 1 1     3 Width 10ft   6013782.624009999 2092181.31295 37.725506794893896 -122.394519248986 (37.7255067948939, -122.394519248986)
26369 201988 2 197 1651 Carroll Ave 3 9 1 1     4     6013586.6338 2092298.57883 37.7258178856713 -122.39520498563 (37.7258178856713, -122.39520498563)
26383 207515 2 197 71 Melrose Ave 1 9 1 1     1     5999632.40668 2095469.97761 37.7337398948819 -122.443671310503 (37.7337398948819, -122.443671310503)
26765 207471 2 197 555 Flood Ave 8 9 1 1     1 Width 10ft   5997138.11204 2094076.47997 37.7297711057327 -122.45219426825399 (37.7297711057327, -122.452194268254)
27379 207465 2 197 555 Flood Ave 2 9 1 1     1 Width 10ft   5997138.25418 2094089.75184 37.729807555268295 -122.452194734107 (37.7298075552683, -122.452194734107)
28382 207524 2 197 266 Judson Ave 2 9 1 1     6     5998309.1596 2093573.15338 37.728456103557896 -122.448109616788 (37.7284561035579, -122.448109616788)
29667 176185 2 197 500 Geneva Ave 6 9 1 1     7 Width 5ft   5998832.19664 2090623.5038299998 37.7203869364761 -122.446089381522 (37.7203869364761, -122.446089381522)
30038 207511 2 197 300 Mangels Ave 9 9 1 1     1     5999356.36789 2095270.9974099998 37.733177794305 -122.44461135834601 (37.733177794305, -122.444611358346)
30834 222515 2 197 1445 Douglass St 3 9 1 1     6 Width 4ft   6001418.004509999 2099470.26771 37.7448254366625 -122.43778439245001 (37.7448254366625, -122.43778439245)
31618 222513 2 197 1445 Douglass St 1 9 1 1     8 Width 4ft   6001419.9831 2099436.11309 37.7447317686527 -122.43777510514 (37.7447317686527, -122.43777510514)
31908 207496 2 197 426 Bright St 1 9 1 1     3     5993791.26805 2090028.04623 37.7184627965046 -122.46347090877899 (37.7184627965046, -122.463470908779)
34556 176189 2 197 500 Geneva Ave 11 9 1 1     4 Width 5ft   5998893.49045 2090593.19981 37.7203072286757 -122.445875331189 (37.7203072286757, -122.445875331189)
35272 223291 2 197 271 Bemis St 1 9 1 1     3 Width 4ft   6002969.0531 2096218.7937599998 37.7359857142716 -122.432189003136 (37.7359857142716, -122.432189003136)
35988 222510 2 197 123 Marsily St 3 9 1 1     6 Width 2ft   6004279.53355 2095213.5865099998 37.7332998565836 -122.427586552585 (37.7332998565836, -122.427586552585)
36540 207466 2 197 555 Flood Ave 3 9 1 1     1 Width 10ft   5997138.05021 2094086.70842 37.7297991870776 -122.452195219742 (37.7297991870776, -122.452195219742)
38347 103902 1 197 6025 03rd St 3 9 1 1   06/19/2013 12:00:00 AM     Permit Number 770276 6013653.2 2091451.0 37.7234943066524 -122.394915533675 (37.7234943066524, -122.394915533675)
39053 201987 2 197 1651 Carroll Ave 5 9 1 1     3 Width 5ft   6013596.70102 2092297.48635 37.7258154458067 -122.39517010723301 (37.7258154458067, -122.395170107233)
39353 176191 2 197 500 Geneva Ave 14 9 1 1     12 Width 5ft   5998925.79803 2090576.3375099998 37.7202627733854 -122.44576244287799 (37.7202627733854, -122.445762442878)
39981 207473 2 197 549 Flood Ave 2 9 1 1     1 Width 10ft   5997163.92167 2094087.8656099997 37.729803846463795 -122.45210586311 (37.7298038464638, -122.45210586311)
41608 207494 2 197 589 Arch St 4 9 1 1     7 Width 10ft   5992718.62693 2091039.53667 37.7211782436554 -122.467252058845 (37.7211782436554, -122.467252058845)
42194 207483 2 197 209 Flood Ave 6 9 1 1     6     5999342.799240001 2094043.6842 37.729807105610206 -122.444570089355 (37.7298071056102, -122.444570089355)
43694 176202 2 197 746 Olmstead St 2 9 1 1     18 Width 4ft   6009489.79963 2090597.2729099998 37.7209177667302 -122.40924750276501 (37.7209177667302, -122.409247502765)
44338 207495 2 197 218 Arch St 1 9 1 1     3 Width 10ft   5992735.18915 2088665.77704 37.7146614305504 -122.467022318922 (37.7146614305504, -122.467022318922)
45553 207517 2 197 215 Stillings Ave 1 9 1 1     2 Width 6ft   5999350.95651 2095746.5877599998 37.73448334463821 -122.444664238484 (37.7344833446382, -122.444664238484)
47406 207469 2 197 555 Flood Ave 6 9 1 1     1 Width 10ft   5997138.98786 2094080.7785599998 37.7297829588082 -122.452191550501 (37.7297829588082, -122.452191550501)
47611 207519 2 197 906 Teresita Blvd 3 9 1 1     3 Width 10ft   5998840.32295 2095592.3894200001 37.7340308003734 -122.446418571155 (37.7340308003734, -122.446418571155)
48055 176194 2 197 500 Geneva Ave 18 9 1 1     14 Width 5ft   5998956.61434 2090559.37492 37.720217957471704 -122.44565470229799 (37.7202179574717, -122.445654702298)
49292 207513 2 197 454 Mangels Ave 2 9 1 1     9 Width 6ft   5998419.395690001 2095283.7253 37.73315923141121 -122.447851626453 (37.7331592314112, -122.447851626453)
51461 223294 2 197 779 Andover St 1 9 1 1     6 Width 3ft   6007381.1978 2095205.1537400002 37.7334516540573 -122.416862619235 (37.7334516540573, -122.416862619235)
52978 176187 2 197 500 Geneva Ave 8 9 1 1     3 Width 5ft   5998858.2339699995 2090609.3161099998 37.7203494671212 -122.44599835935301 (37.7203494671212, -122.445998359353)
54391 207512 2 197 300 Mangels Ave 11 9 1 1     1     5999349.275230001 2095271.40684 37.733178513774796 -122.44463590891701 (37.7331785137748, -122.444635908917)
54481 222526 2 197 4302 Cesar Chavez St 4 9 1 1     10 Width 3ft   6001855.92203 2100330.2514 37.7472116402063 -122.436331694157 (37.7472116402063, -122.436331694157)
54589 222509 2 197 123 Marsily St 2 9 1 1     5 Width 2ft   6004280.34409 2095211.59088 37.733294422879 -122.427583608195 (37.733294422879, -122.427583608195)
54985 126463 2 197 845 Marina Blvd 3 9 1 1     9 Width 6ft   5998902.34401 2121345.9026 37.8047469543639 -122.44805780953199 (37.8047469543639, -122.448057809532)
55215 207480 2 197 209 Flood Ave 3 9 1 1     3     5999342.45977 2094050.8697400002 37.729826816053794 -122.444571779177 (37.7298268160538, -122.444571779177)
55553 201990 2 197 1651 Carroll Ave 1 9 1 1     5     6013571.200540001 2092301.5748400001 37.7258252538048 -122.395258547459 (37.7258252538048, -122.395258547459)
56363 207470 2 197 555 Flood Ave 7 9 1 1     1 Width 10ft   5997138.5742 2094079.0064 37.7297780691825 -122.452192852745 (37.7297780691825, -122.452192852745)
56735 207486 2 197 112 Marston Ave 7 9 1 1     2     5998687.36534 2093224.2464299998 37.7275196997744 -122.44677705081499 (37.7275196997744, -122.446777050815)
57554 207472 2 197 549 Flood Ave 1 9 1 1     1 Width 10ft   5997163.972030001 2094090.1048700002 37.729809997823104 -122.45210585051201 (37.7298099978231, -122.452105850512)
58247 222508 2 197 123 Marsily St 1 9 1 1     4 Width 2ft   6004280.8593 2095209.0357 37.7332874360711 -122.427581644992 (37.7332874360711, -122.427581644992)
59100 207479 2 197 209 Flood Ave 2 9 1 1     5     5999342.510319999 2094053.30224 37.729833498015 -122.444571779181 (37.729833498015, -122.444571779181)
59304 176184 2 197 500 Geneva Ave 2 9 1 1     4 Width 5ft   5998735.57322 2090674.4246200002 37.720521234959996 -122.446427037372 (37.72052123496, -122.446427037372)
59457 207492 2 197 589 Arch St 2 9 1 1     1 Width 10ft   5992718.40075 2091048.7391700002 37.721203498421396 -122.467253509457 (37.7212034984214, -122.467253509457)
59840 207507 2 197 131 Mangels Ave 1 9 1 1     5     6000533.96633 2095190.65838 37.7330243285976 -122.44053433311501 (37.7330243285976, -122.440534333115)
59913 222517 2 197 714 Duncan St 3 9 1 1     14 Width 4ft   6001862.10862 2099746.95983 37.7456104108039 -122.436268564438 (37.7456104108039, -122.436268564438)
60278 176208 2 197 328 Santa Rosa Ave 1 9 1 1     24     6000504.57511 2093791.5155099998 37.729180932853296 -122.44053562992701 (37.7291809328533, -122.440535629927)
62213 176195 2 197 500 Geneva Ave 19 9 1 1     12 Width 5ft   5998964.86489 2090556.5222099999 37.720210595634605 -122.445625977963 (37.7202105956346, -122.445625977963)
62238 176207 2 197 178 Cotter St 1 9 1 1     4 Width 6ft   6001859.62036 2093660.3477 37.7288978433404 -122.435841750723 (37.7288978433404, -122.435841750723)
63542 176204 2 197 538 Cayuga Ave 1 9 1 1     3 Width 10ft   6001908.14836 2093650.44447 37.7288734078601 -122.43567327801901 (37.7288734078601, -122.435673278019)
63942 176182 2 197 200 Rome St 2 9 1 1     7 Width 0ft   5998635.4334 2088884.2911 37.7156002193629 -122.44664445567301 (37.7156002193629, -122.446644455673)
64887 124159 2 197 970 Anza St 5 9 1 1     8 Width 4ft   5995776.57441 2112223.28537 37.7795195518878 -122.45821411290599 (37.7795195518878, -122.458214112906)
65841 223335 2 197 147 Beacon St 6 9 1 1     1 Width 6ft   6003368.46906 2097136.1116900002 37.7385270976507 -122.43087350809999 (37.7385270976507, -122.4308735081)
67050 176188 2 197 500 Geneva Ave 10 9 1 1     13 Width 5ft   5998880.863480001 2090599.2128400002 37.7203230180654 -122.44591941055401 (37.7203230180654, -122.445919410554)
68020 207491 2 197 589 Arch St 1 9 1 1     5 Width 10ft   5992718.20945 2091059.61299 37.72123334423829 -122.46725496096201 (37.7212333442383, -122.467254960962)
68201 207468 2 197 555 Flood Ave 5 9 1 1     1 Width 10ft   5997138.68437 2094082.5659999999 37.7297878493071 -122.452192728615 (37.7297878493071, -122.452192728615)
68291 201986 2 197 1651 Carroll Ave 6 9 1 1     3 Width 5ft   6013604.03863 2092295.5009700002 37.725810402411796 -122.395144602456 (37.7258104024118, -122.395144602456)
70216 207499 2 197 2225 09th Ave 1 9 1 1     6 Width 3ft   5993421.6511 2100648.01596 37.747601300271604 -122.46551959497101 (37.7476013002716, -122.465519594971)
70587 207478 2 197 549 Flood Ave 7 9 1 1     1 Width 10ft   5997163.33701 2094077.0358799999 37.7297740771139 -122.452107103267 (37.7297740771139, -122.452107103267)
73507 207506 2 197 155 Mangels Ave 1 9 1 1     3     6000387.096390001 2095198.9294 37.7330386745754 -122.44104269288401 (37.7330386745754, -122.441042692884)
73782 207487 2 197 484 Faxon Ave 7 9 1 1     3 Width 3ft   5994797.52832 2091773.8490900001 37.723314279209205 -122.46011911753 (37.7233142792092, -122.46011911753)
74228 207484 2 197 117 Judson Ave 1 9 1 1     2     5999294.91677 2093456.39313 37.728191808994495 -122.444693427765 (37.7281918089945, -122.444693427765)
74349 207520 2 197 910 Teresita Blvd 1 9 1 1     8 Width 10ft   5998827.615259999 2095598.2840200001 37.734046259733404 -122.44646292933001 (37.7340462597334, -122.44646292933)
77171 201981 2 197 1651 Carroll Ave 10 9 1 1     5 Width 6ft   6013639.52945 2092282.8618599998 37.725777671598294 -122.395021027505 (37.7257776715983, -122.395021027505)
86086 103907 1 197 6025 03rd St 8 9 1 1   06/19/2013 12:00:00 AM     Permit Number 770276 6013653.2 2091451.0 37.7234943066524 -122.394915533675 (37.7234943066524, -122.394915533675)
94145 103911 1 197 6025 03rd St 12 9 1 1   06/19/2013 12:00:00 AM     Permit Number 770276 6013653.2 2091451.0 37.7234943066524 -122.394915533675 (37.7234943066524, -122.394915533675)
100077 103909 1 197 6025 03rd St 10 9 1 1   06/19/2013 12:00:00 AM     Permit Number 770276 6013653.2 2091451.0 37.7234943066524 -122.394915533675 (37.7234943066524, -122.394915533675)
107558 103901 1 197 6025 03rd St 2 9 1 1   06/19/2013 12:00:00 AM     Permit Number 770276 6013653.2 2091451.0 37.7234943066524 -122.394915533675 (37.7234943066524, -122.394915533675)
109731 103908 1 197 6025 03rd St 9 9 1 1   06/19/2013 12:00:00 AM     Permit Number 770276 6013653.2 2091451.0 37.7234943066524 -122.394915533675 (37.7234943066524, -122.394915533675)
118191 103906 1 197 6025 03rd St 7 9 1 1   06/19/2013 12:00:00 AM     Permit Number 770276 6013653.2 2091451.0 37.7234943066524 -122.394915533675 (37.7234943066524, -122.394915533675)
120276 103903 1 197 6025 03rd St 4 9 1 1   06/19/2013 12:00:00 AM     Permit Number 770276 6013653.2 2091451.0 37.7234943066524 -122.394915533675 (37.7234943066524, -122.394915533675)
124611 103905 1 197 6025 03rd St 6 9 1 1   06/19/2013 12:00:00 AM     Permit Number 770276 6013653.2 2091451.0 37.7234943066524 -122.394915533675 (37.7234943066524, -122.394915533675)
125294 176198 2 197 500 Geneva Ave 23 9 1 1     5 Width 5ft   5998989.57955 2090542.3676900002 37.720173141569 -122.445539530639 (37.720173141569, -122.445539530639)
128312 103900 1 197 6025 03rd St 1 9 1 1   06/19/2013 12:00:00 AM     Permit Number 770276 6013653.2 2091451.0 37.7234943066524 -122.394915533675 (37.7234943066524, -122.394915533675)
130891 207453 2 197 730 Ulloa St 2 9 1 1     7 Width 10ft   5993922.42412 2098155.36186 37.7407859697846 -122.463607085923 (37.7407859697846, -122.463607085923)
134437 207449 2 197 36 Brentwood Ave 1 9 1 1     11 Width 10ft   5996496.77472 2095409.8676 37.7333955075962 -122.454507715774 (37.7333955075962, -122.454507715774)
135986 207463 2 197 698 Hearst Ave 6 9 1 1     11 Width 6ft   5996886.4017900005 2094438.11032 37.7307496337669 -122.453090548796 (37.7307496337669, -122.453090548796)
136266 207464 2 197 118 Ridgewood Ave 2 9 1 1     1 Width 10ft   5996817.27631 2094530.75495 37.731000051814206 -122.453336211192 (37.7310000518142, -122.453336211192)
136456 207503 2 197 745 Ulloa St 1 9 1 1     12 Width 3ft   5993822.08464 2098107.46233 37.7406486676059 -122.463950543278 (37.7406486676059, -122.463950543278)
136862 207482 2 197 209 Flood Ave 5 9 1 1     6     5999342.84979 2094046.1167 37.729813787571395 -122.444570089359 (37.7298137875714, -122.444570089359)
137035 207474 2 197 549 Flood Ave 3 9 1 1     1 Width 10ft   5997163.276190001 2094085.18087 37.7297964378325 -122.452107900965 (37.7297964378325, -122.452107900965)
137134 207510 2 197 300 Mangels Ave 8 9 1 1     1     5999358.72288 2095270.42475 37.733176356297 -122.44460317539301 (37.733176356297, -122.444603175393)
137385 207493 2 197 589 Arch St 3 9 1 1     6 Width 10ft   5992717.93715 2091043.75308 37.7211897810709 -122.467254749618 (37.7211897810709, -122.467254749618)
137962 207454 2 197 730 Ulloa St 3 9 1 1     9 Width 10ft   5993920.85369 2098154.62053 37.7407838437897 -122.46361246204701 (37.7407838437897, -122.463612462047)
138857 103904 1 197 6025 03rd St 5 9 1 1   06/19/2013 12:00:00 AM     Permit Number 770276 6013653.2 2091451.0 37.7234943066524 -122.394915533675 (37.7234943066524, -122.394915533675)
139784 222525 2 197 739 27th St 10 9 1 1     1 Width 8ft   6001732.374 2099973.3898099996 37.7462247619684 -122.43673337185601 (37.7462247619684, -122.436733371856)
144807 103910 1 197 6025 03rd St 11 9 1 1   06/19/2013 12:00:00 AM     Permit Number 770276 6013653.2 2091451.0 37.7234943066524 -122.394915533675 (37.7234943066524, -122.394915533675)
146556 207516 2 197 132 Melrose Ave 2 9 1 1     5 Width 10ft   5999170.9063099995 2095539.25965 37.7339037945108 -122.445271827652 (37.7339037945108, -122.445271827652)
147870 124158 2 197 970 Anza St 4 9 1 1     4 Width 4ft   5995788.03534 2112225.31952 37.7795257956775 -122.458174612179 (37.7795257956775, -122.458174612179)
148790 176193 2 197 500 Geneva Ave 17 9 1 1     5 Width 5ft   5998949.70909 2090563.2644599997 37.7202282430074 -122.445678850924 (37.7202282430074, -122.445678850924)
148799 176192 2 197 500 Geneva Ave 15 9 1 1     5 Width 5ft   5998935.8928 2090570.77641 37.7202480802556 -122.445727149009 (37.7202480802556, -122.445727149009)
150727 176205 2 197 538 Cayuga Ave 2 9 1 1     3 Width 10ft   6001907.20593 2093652.1324099998 37.7288779890283 -122.435676656773 (37.7288779890283, -122.435676656773)
151239 176197 2 197 500 Geneva Ave 21 9 1 1     6 Width 5ft   5998975.73013 2090548.27475 37.720188570324204 -122.445587827823 (37.7201885703242, -122.445587827823)
152621 207477 2 197 549 Flood Ave 6 9 1 1     1 Width 10ft   5997163.54471 2094079.1487 37.729779890312 -122.45210653761002 (37.729779890312, -122.45210653761)
152734 223289 2 197 2230 Castro St 1 9 1 1     3 Width 4ft   6002654.982580001 2098989.6554 37.743576047195795 -122.43347282043699 (37.7435760471958, -122.433472820437)
153343 201989 2 197 1651 Carroll Ave 2 9 1 1     6     6013578.50346 2092296.28411 37.725811132676704 -122.395232931161 (37.7258111326767, -122.395232931161)
154279 207509 2 197 300 Mangels Ave 6 9 1 1     2     5999366.08904 2095270.5336900002 37.7331770757488 -122.444577716507 (37.7331770757488, -122.444577716507)
154975 176186 2 197 500 Geneva Ave 7 9 1 1     5 Width 5ft   5998840.97625 2090619.3076900002 37.7203759162079 -122.44605873171899 (37.7203759162079, -122.446058731719)
Powered by Datasette · Query took 30.376ms · Data source: data.sfgov.org