sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
27341 206556 2 66 32 Sotelo Ave 1 2 1 1     1 Width 4ft   5993935.86279 2101082.16601 37.7488230103837 -122.463773001819 (37.7488230103837, -122.463773001819)
28309 206505 2 66 1965 10th Ave 1 2 1 1     1 Width 6ft   5993138.76599 2102124.2403700002 37.7516383146611 -122.46660507218701 (37.7516383146611, -122.466605072187)
29530 218122 2 66 45 Lopez Ave 3 2 1 1     1 Width 0ft   5994032.10421 2100668.86964 37.7476937487685 -122.463410213512 (37.7476937487685, -122.463410213512)
43524 206628 2 66 20 Ventura Ave 1 2 1 1     1 Width 3ft   5994037.30563 2101977.91794 37.7512883623694 -122.463487212563 (37.7512883623694, -122.463487212563)
150435 206545 2 66 265 Pacheco St 1 2 1 1     1 Width 4ft   5994446.422040001 2100465.35227 37.747158803252 -122.461962779858 (37.747158803252, -122.461962779858)
51397 206539 2 66 393 Pacheco St 1 2 1 1     2 Width 3ft   5994118.07071 2101419.5251 37.749759810788 -122.46316740736499 (37.749759810788, -122.463167407365)
66445 206538 2 66 399 Pacheco St 2 2 1 1     2 Width 3ft   5994103.277319999 2101446.93652 37.749834223367294 -122.463220551898 (37.7498342233673, -122.463220551898)
185968 206624 2 66 80 Ventura Ave 2 2 1 1     2 Width 3ft   5994298.51296 2101800.2527099997 37.7508155851791 -122.46257104893 (37.7508155851791, -122.46257104893)
29329 206551 2 66 308 Pacheco St 3 2 1 1     3 Width 6ft   5994320.14066 2100781.15308 37.74801864146029 -122.462422349606 (37.7480186414603, -122.462422349606)
35264 206544 2 66 337 Pacheco St 1 2 1 1     3 Width 3ft   5994178.74316 2101030.22278 37.7486943803622 -122.462929360401 (37.7486943803622, -122.462929360401)
44246 206584 2 66 180 Dorantes Ave 1 2 1 1     3 Width 3ft   5993659.8453 2099783.1011200002 37.745240198571295 -122.464633144905 (37.7452401985713, -122.464633144905)
49506 206607 2 66 2 Sola Ave 2 2 1 1     3 Width 4ft   5994975.69537 2100714.97086 37.7478746501056 -122.460150689128 (37.7478746501056, -122.460150689128)
52949 206549 2 66 308 Pacheco St 1 2 1 1     3 Width 6ft   5994338.43004 2100748.81738 37.7479309089808 -122.462356761175 (37.7479309089808, -122.462356761175)
69850 206611 2 66 49 Sola Ave 4 2 1 1     3 Width 4ft   5994869.30829 2100730.97603 37.7479124764813 -122.460519727717 (37.7479124764813, -122.460519727717)
76722 206547 2 66 120 Dorantes Ave 1 2 1 1     3 Width 4ft   5993889.308780001 2099967.60077 37.7457600139093 -122.463853094571 (37.7457600139093, -122.463853094571)
148911 206583 2 66 180 Dorantes Ave 2 2 1 1     3 Width 3ft   5993643.85712 2099778.24608 37.7452259461282 -122.464688076401 (37.7452259461282, -122.464688076401)
152678 206603 2 66 160 Magellan Ave 4 2 1 1     3 Width 4ft   5995045.25769 2100752.48094 37.7479816442318 -122.459912864313 (37.7479816442318, -122.459912864313)
171736 206609 2 66 44 Sola Ave 1 2 1 1     3 Width 4ft   5994867.729069999 2100768.79557 37.7480162285692 -122.46052792862601 (37.7480162285692, -122.460527928626)
174439 206625 2 66 80 Ventura Ave 1 2 1 1     3 Width 3ft   5994283.13326 2101793.571 37.7507963531822 -122.46262374828999 (37.7507963531822, -122.46262374829)
175120 206659 2 66 41 Alton Ave 3 2 1 1     3 Width 3ft   5994198.61036 2101541.1054 37.750098278721 -122.462897719553 (37.750098278721, -122.462897719553)
24031 206557 2 66 517 Laguna Honda Blvd 2 2 1 1     4 Width 4ft   5995503.23656 2100160.4413400004 37.7463823798599 -122.458286357642 (37.7463823798599, -122.458286357642)
25120 206614 2 66 432 Dewey Blvd 1 2 1 1     4 Width 3ft   5995034.15561 2100336.79731 37.7468396428317 -122.45992114704399 (37.7468396428317, -122.459921147044)
40559 206571 2 66 51 Cortes Ave 5 2 1 1     4 Width 3ft   5993219.180819999 2099666.63445 37.7448949964991 -122.466148413523 (37.7448949964991, -122.466148413523)
41542 206581 2 66 190 Dorantes Ave 2 2 1 1     4 Width 3ft   5993591.13879 2099773.66773 37.745210335700605 -122.46487003355301 (37.7452103357006, -122.464870033553)
45428 206576 2 66 100 Montalvo Ave 2 2 1 1     4 Width 3ft   5993684.51151 2099645.64672 37.744864205510204 -122.46453787523501 (37.7448642055102, -122.464537875235)
46146 206555 2 66 47 Sotelo Ave 2 2 1 1     4 Width 4ft   5993893.29504 2101174.89341 37.74907516320621 -122.463926929805 (37.7490751632062, -122.463926929805)
55162 206635 2 66 145 Castenada Ave 1 2 1 1     4 Width 3ft   5994551.94388 2100907.9053700003 37.7483800169362 -122.461629977657 (37.7483800169362, -122.461629977657)
56091 206541 2 66 375 Pacheco St 1 2 1 1     4 Width 3ft   5994147.31458 2101302.53521 37.7494402708691 -122.463057794403 (37.7494402708691, -122.463057794403)
56263 206670 2 66 15 Sotelo Ave 5 2 1 1     4 Width 3ft   5994011.71818 2100897.82655 37.7483212318599 -122.463497320046 (37.7483212318599, -122.463497320046)
58009 206641 2 66 196 Castenada Ave 1 2 1 1     4 Width 3ft   5994436.73351 2100801.00946 37.748079875384796 -122.462020618849 (37.7480798753848, -122.462020618849)
63202 206604 2 66 160 Magellan Ave 5 2 1 1     4 Width 4ft   5995043.01031 2100739.53906 37.747945979831 -122.45991969824 (37.747945979831, -122.45991969824)
66581 206606 2 66 160 Magellan Ave 7 2 1 1     4 Width 4ft   5995035.92285 2100721.97488 37.747897345392 -122.459942934033 (37.747897345392, -122.459942934033)
67067 206660 2 66 41 Alton Ave 4 2 1 1     4 Width 3ft   5994227.712619999 2101539.78712 37.750096335277796 -122.462796987411 (37.7500963352778, -122.462796987411)
68099 206662 2 66 390 Pacheco St 2 2 1 1     4 Width 3ft   5994173.63187 2101468.0491400003 37.749896246027106 -122.462978796147 (37.7498962460271, -122.462978796147)
69565 206610 2 66 49 Sola Ave 3 2 1 1     4 Width 4ft   5994851.290519999 2100738.8321 37.7479330107067 -122.46058260112 (37.7479330107067, -122.46058260112)
74950 206661 2 66 390 Pacheco St 3 2 1 1     4 Width 3ft   5994161.93741 2101486.33597 37.7499457833913 -122.463020562465 (37.7499457833913, -122.463020562465)
114401 206552 2 66 308 Pacheco St 4 2 1 1     4 Width 6ft   5994313.1172 2100803.87721 37.7480806317257 -122.462448284279 (37.7480806317257, -122.462448284279)
164232 206634 2 66 145 Castenada Ave 2 2 1 1     4 Width 3ft   5994552.462069999 2100915.6770099998 37.748401385725 -122.461628749166 (37.748401385725, -122.461628749166)
167733 206503 2 66 1957 10th Ave 1 2 1 1     4 Width 6ft   5993135.46016 2102179.05998 37.751788644440495 -122.46662048837 (37.7517886444405, -122.46662048837)
172567 206643 2 66 196 Castenada Ave 3 2 1 1     4 Width 3ft   5994392.211730001 2100761.6142700003 37.74796914278121 -122.462171715751 (37.7479691427812, -122.462171715751)
177772 206633 2 66 145 Castenada Ave 3 2 1 1     4 Width 3ft   5994552.3071099995 2100925.23177 37.7484276117632 -122.461629977659 (37.7484276117632, -122.461629977659)
182763 206550 2 66 308 Pacheco St 2 2 1 1     4 Width 6ft   5994328.73662 2100761.78102 37.7479659456765 -122.46239122047199 (37.7479659456765, -122.462391220472)
553 206616 2 66 198 Vasquez Ave 2 2 1 1     5 Width 3ft Permit Number 779324 5994742.56026 2099334.6803900003 37.7440713065495 -122.460856833195 (37.7440713065495, -122.460856833195)
27743 206657 2 66 41 Alton Ave 1 2 1 1     5 Width 3ft   5994149.03126 2101531.53277 37.7500691388799 -122.463068471138 (37.7500691388799, -122.463068471138)
33279 206578 2 66 275 Dorantes Ave 3 2 1 1     5 Width 3ft   5993312.03833 2099686.0969 37.7449537923783 -122.46582874591199 (37.7449537923783, -122.465828745912)
34016 206586 2 66 360 Magellan Ave 1 2 1 1     5 Width 3ft   5993997.55659 2099722.78299 37.745094043463396 -122.46346102880699 (37.7450940434634, -122.463461028807)
39199 206623 2 66 1964 08th Ave 2 2 1 1     5 Width 3ft   5993824.3832 2102096.20379 37.7516008749812 -122.464232103026 (37.7516008749812, -122.464232103026)
39280 206536 2 66 401 Pacheco St 1 2 1 1     5 Width 3ft   5994052.44062 2101520.15999 37.7500323476354 -122.463401659183 (37.7500323476354, -122.463401659183)
44510 218322 2 66 420 Castenada Ave 1 2 1 1     5 Width 0ft   5993190.15092 2099959.3697 37.745697098249394 -122.466270063011 (37.7456970982494, -122.466270063011)
56319 206573 2 66 51 Cortes Ave 3 2 1 1     5 Width 3ft   5993216.90415 2099626.41246 37.7447844257663 -122.466153363383 (37.7447844257663, -122.466153363383)
57787 206540 2 66 387 Pacheco St 2 2 1 1     5 Width 3ft   5994134.95664 2101369.7507 37.7496241156629 -122.46310540451401 (37.7496241156629, -122.463105404514)
59046 206654 2 66 45 Alton Ave 1 2 1 1     5 Width 3ft   5994247.90783 2101537.24109 37.7500905076701 -122.46272696707399 (37.7500905076701, -122.462726967074)
61321 206667 2 66 15 Sotelo Ave 2 2 1 1     5 Width 3ft   5993986.73582 2100929.3593 37.74840637335971 -122.46358599590499 (37.7484063733597, -122.463585995905)
64527 206668 2 66 15 Sotelo Ave 3 2 1 1     5 Width 3ft   5993998.36893 2100916.3469700003 37.7483713150869 -122.46354482495501 (37.7483713150869, -122.463544824955)
66424 206580 2 66 275 Dorantes Ave 1 2 1 1     5 Width 3ft   5993286.92729 2099684.15258 37.7449470052046 -122.46591543334401 (37.7449470052046, -122.465915433344)
68999 206663 2 66 390 Pacheco St 1 2 1 1     5 Width 3ft   5994181.82756 2101452.31219 37.7498535084399 -122.46294931367399 (37.7498535084399, -122.462949313674)
74247 206636 2 66 159 Castenada Ave 1 2 1 1     5 Width 3ft   5994544.936980001 2100878.69027 37.7482993963164 -122.461652089281 (37.7482993963164, -122.461652089281)
75436 206640 2 66 175 Castenada Ave 2 2 1 1     5 Width 3ft   5994518.44354 2100835.0258299997 37.7481779797266 -122.46174053670201 (37.7481779797266, -122.461740536702)
126753 206613 2 66 432 Dewey Blvd 2 2 1 1     5 Width 3ft   5995024.84981 2100327.10403 37.746812492318604 -122.459952623323 (37.7468124923186, -122.459952623323)
130265 206637 2 66 159 Castenada Ave 2 2 1 1     5 Width 3ft   5994549.87925 2100894.15199 37.7483421347836 -122.461636120028 (37.7483421347836, -122.461636120028)
133199 206579 2 66 275 Dorantes Ave 2 2 1 1     5 Width 3ft   5993299.1056 2099684.88554 37.744949720257004 -122.46587337656601 (37.744949720257, -122.465873376566)
148350 206542 2 66 351 Pacheco St 2 2 1 1     5 Width 3ft   5994154.36407 2101104.3868400003 37.748896611800106 -122.46301904261999 (37.7488966118001, -122.46301904262)
151567 206554 2 66 47 Sotelo Ave 3 2 1 1     5 Width 4ft   5993895.61602 2101166.1129900003 37.749051188161296 -122.46391826663401 (37.7490511881613, -122.463918266634)
153873 206585 2 66 368 Magellan Ave 2 2 1 1     5 Width 3ft   5993961.3420400005 2099692.54098 37.745008919941 -122.463584056983 (37.745008919941, -122.463584056983)
154984 206629 2 66 81 Ventura Ave 2 2 1 1     5 Width 3ft   5994298.95446 2101835.26425 37.7509117433916 -122.46257206157101 (37.7509117433916, -122.462572061571)
157129 206655 2 66 45 Alton Ave 2 2 1 1     5 Width 3ft   5994255.40167 2101538.8525799997 37.7500953640099 -122.462701170033 (37.7500953640099, -122.462701170033)
165454 206630 2 66 81 Ventura Ave 1 2 1 1     5 Width 3ft   5994323.8061 2101846.4166200003 37.7509437961254 -122.46248693172701 (37.7509437961254, -122.462486931727)
170563 206605 2 66 160 Magellan Ave 6 2 1 1     5 Width 4ft   5995038.86988 2100730.57279 37.7479211225827 -122.459933366148 (37.7479211225827, -122.459933366148)
170709 206644 2 66 180 Castenada Ave 1 2 1 1     5 Width 3ft   5994467.924 2100831.48615 37.748165352368105 -122.46191497372 (37.7481653523681, -122.46191497372)
174659 206543 2 66 347 Pacheco St 1 2 1 1     5 Width 3ft   5994159.12368 2101087.0695700003 37.7488493371331 -122.463001327749 (37.7488493371331, -122.463001327749)
176273 206546 2 66 265 Pacheco St 2 2 1 1     5 Width 4ft   5994442.894180001 2100449.8026 37.747115904674004 -122.46197385141399 (37.747115904674, -122.461973851414)
181807 206656 2 66 45 Alton Ave 3 2 1 1     5 Width 3ft   5994277.8238699995 2101540.85875 37.75010216378529 -122.46262377888 (37.7501021637853, -122.46262377888)
186378 206627 2 66 40 Ventura Ave 1 2 1 1     5 Width 3ft   5994076.75455 2101874.6545700002 37.751007100296604 -122.463343302157 (37.7510071002966, -122.463343302157)
539 206615 2 66 198 Vasquez Ave 1 2 1 1     6 Width 3ft Permit Number 779324 5994758.52704 2099346.29484 37.7441041156281 -122.460802465585 (37.7441041156281, -122.460802465585)
26518 206504 2 66 1959 10th Ave 1 2 1 1     6 Width 6ft   5993136.05327 2102151.01657 37.7517116786758 -122.46661639913602 (37.7517116786758, -122.466616399136)
29674 206651 2 66 160 Castenada Ave 1 2 1 1     6 Width 3ft   5994510.63767 2100971.03236 37.7485509699531 -122.461777389118 (37.7485509699531, -122.461777389118)
33381 206506 2 66 1985 10th Ave 1 2 1 1     6 Width 6ft   5993143.71774 2101970.98373 37.7512177970674 -122.46657681008301 (37.7512177970674, -122.466576810083)
34122 206658 2 66 41 Alton Ave 2 2 1 1     6 Width 3ft   5994157.02115 2101539.85513 37.7500924502117 -122.463041445619 (37.7500924502117, -122.463041445619)
39798 206669 2 66 15 Sotelo Ave 4 2 1 1     6 Width 3ft   5994007.62455 2100906.4247 37.74834460433671 -122.463512099503 (37.7483446043367, -122.463512099503)
40135 206582 2 66 190 Dorantes Ave 1 2 1 1     6 Width 3ft   5993610.53275 2099775.23813 37.745215765798996 -122.464803087101 (37.745215765799, -122.464803087101)
47868 206574 2 66 120 Montalvo Ave 2 2 1 1     6 Width 3ft   5993698.095930001 2099619.5133 37.744793232835605 -122.464489006068 (37.7447932328356, -122.464489006068)
49358 206666 2 66 15 Sotelo Ave 1 2 1 1     6 Width 3ft   5993976.53914 2100938.08553 37.74842974584271 -122.46362188875901 (37.7484297458427, -122.463621888759)
54773 206638 2 66 167 Castenada Ave 1 2 1 1     6 Width 3ft   5994538.83302 2100858.6540099997 37.7482440304446 -122.46167174395 (37.7482440304446, -122.46167174395)
58785 206665 2 66 11 Santa Rita Ave 1 2 1 1     6 Width 3ft   5993870.76921 2100887.71242 37.748285339014295 -122.463983980089 (37.7482853390143, -122.463983980089)
62866 206570 2 66 4 Dorantes Ave 1 2 1 1     6 Width 3ft   5993230.1067699995 2099675.67045 37.7449204374235 -122.46611129043 (37.7449204374235, -122.46611129043)
72564 206631 2 66 89 Ventura Ave 1 2 1 1     6 Width 3ft   5994365.2652199995 2101880.85976 37.7510407556506 -122.462346061026 (37.7510407556506, -122.462346061026)
74465 206646 2 66 180 Castenada Ave 3 2 1 1     6 Width 3ft   5994489.718859999 2100854.37735 37.7482294605322 -122.46184126797701 (37.7482294605322, -122.461841267977)
133979 206590 2 66 340 Magellan Ave 1 2 1 1     6 Width 3ft   5994099.18491 2099823.6206900002 37.745376773231 -122.463116933812 (37.745376773231, -122.463116933812)
134479 206645 2 66 180 Castenada Ave 2 2 1 1     6 Width 3ft   5994475.58114 2100840.87711 37.748191578392294 -122.461889176638 (37.7481915783923, -122.461889176638)
134876 206558 2 66 517 Laguna Honda Blvd 1 2 1 1     6 Width 4ft   5995506.851369999 2100151.8642599997 37.7463590370584 -122.458273237436 (37.7463590370584, -122.458273237436)
137122 206507 2 66 1985 10th Ave 2 2 1 1     6 Width 6ft   5993144.62205 2101960.97627 37.751190371338 -122.46657295558599 (37.751190371338, -122.466572955586)
151744 218121 2 66 45 Lopez Ave 2 2 1 1     6 Width 0ft   5994024.91011 2100655.57636 37.7476568343048 -122.463434125583 (37.7476568343048, -122.463434125583)
156496 206639 2 66 175 Castenada Ave 1 2 1 1     6 Width 3ft   5994510.39425 2100823.8744099997 37.748146897381794 -122.461767562235 (37.7481468973818, -122.461767562235)
158121 206588 2 66 348 Magellan Ave 1 2 1 1     6 Width 3ft   5994058.29292 2099782.40477 37.7452612490171 -122.463255340382 (37.7452612490171, -122.463255340382)
162090 206642 2 66 196 Castenada Ave 2 2 1 1     6 Width 3ft   5994408.53923 2100777.89876 37.7480147959636 -122.46211643714899 (37.7480147959636, -122.462116437149)
164769 206602 2 66 160 Magellan Ave 3 2 1 1     6 Width 4ft   5995047.859019999 2100763.4476 37.7480119055303 -122.45990466338101 (37.7480119055303, -122.459904663381)
168564 206601 2 66 160 Magellan Ave 1 2 1 1     6 Width 4ft   5995052.26314 2100785.00395 37.7480713471357 -122.45989099549601 (37.7480713471357, -122.459890995496)
179119 206587 2 66 348 Magellan Ave 2 2 1 1     6 Width 3ft   5994044.71238 2099771.06427 37.745229328484704 -122.46330147648099 (37.7452293284847, -122.463301476481)
184549 206626 2 66 40 Ventura Ave 2 2 1 1     6 Width 3ft   5994084.99265 2101862.2244599997 37.750973444992205 -122.46331391231199 (37.7509734449922, -122.463313912312)
187736 206608 2 66 2 Sola Ave 3 2 1 1     6 Width 4ft   5994960.813709999 2100721.5804 37.7478919422595 -122.460202627649 (37.7478919422595, -122.460202627649)
188058 206537 2 66 401 Pacheco St 2 2 1 1     6 Width 3ft   5994067.3294 2101503.80633 37.7499883024325 -122.46334898679 (37.7499883024325, -122.46334898679)
Powered by Datasette · Query took 40.037ms · Data source: data.sfgov.org