sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1830 251757 2 73 233 Winding Way 1 1 1 1       3x3   6001887.0 2086528.0 37.7093155646434 -122.43523714505 (37.7093155646434, -122.43523714505)
1839 251756 2 73 233 Winding Way 2 1 1 1       3x3   6001887.0 2086528.0 37.7093155646434 -122.43523714505 (37.7093155646434, -122.43523714505)
3405 180669 2 73 171 Winding Way 3 2 1 1     0 Width 6ft   6002170.184219999 2086635.71157 37.70962739445179 -122.434266111507 (37.7096273944518, -122.434266111507)
3413 180646 2 73 451 Rolph St 1 2 1 1     0 Width 6ft   6002230.18825 2087673.61332 37.7124806510226 -122.434132874236 (37.7124806510226, -122.434132874236)
3430 180648 2 73 120 Seville St 1 2 1 1     0 Width 6ft   6001751.26715 2087361.8508 37.7115974268507 -122.435765878508 (37.7115974268507, -122.435765878508)
4838 243005 2 73 301 Dolores St 3 1 1 1     0 Width 6ft   6004912.59389 2106510.6516400003 37.7643547760633 -122.42620188801001 (37.7643547760633, -122.42620188801)
18743 18381 3 73 768 Potrero Ave 1 1 1 2     40 3x3   6010390.09454 2104720.536 37.7597476013854 -122.40713046091801 (37.7597476013854, -122.407130460918)
25091 230419 2 73 1301 San Jose Ave 5 1 1 1     2 Width 3ft   6003538.9746900005 2095464.77113 37.733947636477396 -122.430164781185 (37.7339476364774, -122.430164781185)
26296 193431 2 73 568 Missouri St 1 4 1 1     6 Width 3ft   6013531.88693 2104447.0848 37.7591720865425 -122.39624530967801 (37.7591720865425, -122.396245309678)
26639 117155 2 73 701 Pennsylvania Ave 3 1 1 1     8 3x3   6014460.76675 2103748.99279 37.757306918684 -122.392983929988 (37.757306918684, -122.392983929988)
26689 193419 2 73 610 Illinois St 2 1 1 1     7 Width 3ft   6015956.40459 2106139.49843 37.763953701820604 -122.387978189259 (37.7639537018206, -122.387978189259)
30004 193411 2 73 681 San Bruno Ave 1 1 1 1     5 Width 3ft   6011009.79725 2105127.16685 37.7608987794618 -122.40501583552 (37.7608987794618, -122.40501583552)
31110 101612 1 73 681 San Bruno Ave 3 1 1 1     8 7x5   6011003.086019999 2105162.84205 37.7609963604006 -122.40504155884399 (37.7609963604006, -122.405041558844)
31334 230397 2 73 635 Potrero Ave 1 1 1 1     1 Width 3ft   6010452.60466 2105203.30463 37.7610766734566 -122.406948295125 (37.7610766734566, -122.406948295125)
31798 193424 2 73 501 18th St 5 1 1 1     8 Width 3ft   6015930.41591 2105802.18595 37.7630260745267 -122.38804453674801 (37.7630260745267, -122.388044536748)
34840 230415 2 73 1301 San Jose Ave 1 1 1 1     3 Width 3ft   6003663.13723 2095538.7313 37.7341577459882 -122.429740786804 (37.7341577459882, -122.429740786804)
35864 202028 2 73 1330 Fitzgerald Ave 10 4 1 1     3 Width 3ft   6013610.79633 2091351.15014 37.723217781063205 -122.395055126189 (37.7232177810632, -122.395055126189)
36283 193430 2 73 560 Missouri St 4 4 1 1     5 Width 3ft   6013531.28257 2104470.6669900003 37.7592368044652 -122.396249052661 (37.7592368044652, -122.396249052661)
36526 101613 1 73 681 San Bruno Ave 4 1 1 1     8 9x7   6011003.32363 2105183.63205 37.7610534583629 -122.405042200948 (37.7610534583629, -122.405042200948)
36596 117159 2 73 701 Pennsylvania Ave 7 1 1 1     8 3x3   6014455.7871900005 2103822.04979 37.7575072408736 -122.39300626284799 (37.7575072408736, -122.393006262848)
37325 193426 2 73 807 22nd St 1 1 1 1     2 Width 3ft   6015414.46793 2103902.8500099997 37.7577823075377 -122.389696374594 (37.7577823075377, -122.389696374594)
37611 230424 2 73 387 Shotwell St 3 1 1 1     3 Width 3ft   6007831.12637 2105698.0394200003 37.76228806116921 -122.41604991899099 (37.7622880611692, -122.416049918991)
39159 208859 2 73 157 Thrift St 1 1 1 1     1 Width 3ft   5995398.10832 2089609.6071400002 37.7174063107347 -122.45788650015699 (37.7174063107347, -122.457886500157)
40746 193433 2 73 588 Missouri St 1 4 1 1     7 Width 3ft   6013536.39974 2104342.74788 37.758885851209 -122.396222389564 (37.758885851209, -122.396222389564)
41687 230410 2 73 701 Potrero Ave 9 1 1 1     5 Width 4ft   6010454.77139 2105010.4435799997 37.7605472416892 -122.406927207828 (37.7605472416892, -122.406927207828)
43230 81651 2 73 1100@ 12th Ave Cabrillo St 1 1 1 1 1   6   Permit Number 767881 5992197.33713 2110704.35062 37.7751426520596 -122.470485452724 (37.7751426520596, -122.470485452724)
44441 230406 2 73 701 Potrero Ave 3 1 1 1     7 Width 3ft   6010469.85138 2104738.84531 37.7598023377254 -122.406855910494 (37.7598023377254, -122.406855910494)
44609 193420 2 73 501 18th St 1 1 1 1     3 Width 3ft   6015798.54633 2105794.6845 37.76299817034379 -122.38850010901001 (37.7629981703438, -122.38850010901)
45892 230421 2 73 2851 19th St 1 1 1 1     1 Width 4ft   6009338.5093 2104971.08738 37.76037665287679 -122.41078508446002 (37.7603766528768, -122.41078508446)
46903 193418 2 73 610 Illinois St 1 1 1 1     7 Width 3ft   6015955.040580001 2106161.7939400002 37.7640148449206 -122.387984462917 (37.7640148449206, -122.387984462917)
47570 117158 2 73 701 Pennsylvania Ave 6 1 1 1     7 3x3   6014455.94065 2103803.2979900003 37.7574557609929 -122.393004420141 (37.7574557609929, -122.393004420141)
48188 117156 2 73 701 Pennsylvania Ave 4 1 1 1     4 3x3   6014458.776219999 2103767.54398 37.7573577456892 -122.392992112005 (37.7573577456892, -122.392992112005)
49040 230420 2 73 143 Fair Oaks St 1 1 1 1     2 Width 3ft   6005428.8647300005 2102882.34915 37.7544214771723 -122.424158193041 (37.7544214771723, -122.424158193041)
50998 202024 2 73 1330 Fitzgerald Ave 6 4 1 1     3 Width 3ft   6013681.0358 2091298.8599 37.7230781082384 -122.394808659817 (37.7230781082384, -122.394808659817)
53201 230399 2 73 635 Potrero Ave 3 1 1 1     2 Width 5ft   6010446.039030001 2105294.43136 37.761326519519 -122.406977425991 (37.761326519519, -122.406977425991)
54038 202020 2 73 1330 Fitzgerald Ave 2 4 1 1     3 Width 3ft   6013858.20959 2091166.1399 37.7227235352339 -122.39418691350599 (37.7227235352339, -122.394186913506)
54459 193427 2 73 1151 22nd St 1 1 1 1     6 Width 3ft   6014474.19771 2103855.91322 37.75760124521779 -122.39294496056499 (37.7576012452178, -122.392944960565)
55809 123781 2 73 1100 Cabrillo St 3 1 1 1     5 Width 3ft   5992148.272480001 2110704.3151 37.775139717422704 -122.47065517411998 (37.7751397174227, -122.47065517412)
57863 230414 2 73 1295 San Jose Ave 1 1 1 1     3 Width 3ft   6003749.35106 2095592.3419599999 37.7343098303216 -122.429446540326 (37.7343098303216, -122.429446540326)
57871 193417 2 73 1425 Indiana St 4 1 1 1     6 Width 4ft   6015126.28801 2101884.04231 37.7522231069197 -122.39055196440201 (37.7522231069197, -122.390551964402)
58037 193432 2 73 572 Missouri St 2 4 1 1     6 Width 3ft   6013532.897999999 2104416.8953299997 37.759089249099105 -122.39623969701401 (37.7590892490991, -122.396239697014)
58293 193413 2 73 2200 18th St 2 1 1 1     5 Width 3ft   6011171.17043 2105584.0111700003 37.7621621911485 -122.404489872412 (37.7621621911485, -122.404489872412)
58655 202021 2 73 1330 Fitzgerald Ave 3 4 1 1     4 Width 3ft   6013834.37055 2091185.2446599999 37.722774667999 -122.39427065747101 (37.722774667999, -122.394270657471)
60282 193428 2 73 1151 22nd St 2 1 1 1     5 Width 3ft   6014491.22334 2103857.32403 37.7576060646987 -122.392886177259 (37.7576060646987, -122.392886177259)
61175 117154 2 73 701 Pennsylvania Ave 2 1 1 1     7 3x3   6014461.75742 2103731.13458 37.757257938912 -122.3929792544 (37.757257938912, -122.3929792544)
61392 230407 2 73 701 Potrero Ave 4 1 1 1     6 Width 3ft   6010466.98 2104784.69833 37.75992807914729 -122.406869072951 (37.7599280791473, -122.406869072951)
61446 230417 2 73 1301 San Jose Ave 3 1 1 1     3 Width 3ft   6003609.08364 2095506.47935 37.7340661284367 -122.42992536726801 (37.7340661284367, -122.429925367268)
61485 230422 2 73 387 Shotwell St 1 1 1 1     2 Width 3ft   6007833.76172 2105654.7259299997 37.7621692805159 -122.41603773676901 (37.7621692805159, -122.416037736769)
63056 193414 2 73 563 Vermont St 1 1 1 1     9 Width 3ft   6011255.16087 2105737.93689 37.762589530116 -122.40421021383999 (37.762589530116, -122.40421021384)
63152 177453 2 73 1651 San Jose Ave 1 1 1 1     4 Width 2ft   6001481.52618 2094146.78927 37.7302120154671 -122.437183661494 (37.7302120154671, -122.437183661494)
63489 177454 2 73 1651 San Jose Ave 2 1 1 1     4 Width 2ft   6001501.639719999 2094151.35591 37.730225697742796 -122.43711445328998 (37.7302256977428, -122.43711445329)
67572 123782 2 73 1100 Cabrillo St 2 1 1 1     5 Width 3ft   5992174.172809999 2110703.76964 37.7751397174253 -122.470565540203 (37.7751397174253, -122.470565540203)
67791 230398 2 73 625 Potrero Ave 1 1 1 1     1 Width 5ft   6010441.3524 2105364.41642 37.761518420453896 -122.40699856812901 (37.7615184204539, -122.406998568129)
68017 208858 2 73 438 Capitol Ave 1 1 1 1     1 Width 3ft   5995058.10493 2088636.3102900002 37.7147143277695 -122.458991293911 (37.7147143277695, -122.458991293911)
69513 202022 2 73 1330 Fitzgerald Ave 4 4 1 1     3 Width 3ft   6013717.54523 2091271.8320400002 37.723005925068605 -122.39468056126199 (37.7230059250686, -122.394680561262)
70356 193410 2 73 551 Utah St 3 1 1 1     3 Width 3ft   6010705.60274 2105553.4377099997 37.762052213957794 -122.40609794748501 (37.7620522139578, -122.406097947485)
70771 193438 2 73 170 Scotia Ave 1 4 1 1     1 Width 3ft   6012250.26105 2094642.5839099998 37.7321796295918 -122.39998929257601 (37.7321796295918, -122.399989292576)
71026 230404 2 73 995 Potrero Ave 14 1 1 1     4 Width 3ft   6010493.00859 2104414.71875 37.7589136546545 -122.406752977672 (37.7589136546545, -122.406752977672)
74087 230423 2 73 387 Shotwell St 2 1 1 1     2 Width 3ft   6007832.95914 2105672.86461 37.7622190400112 -122.416041797198 (37.7622190400112, -122.416041797198)
74732 117153 2 73 701 Pennsylvania Ave 1 1 1 1     5 3x3   6014462.23102 2103712.78244 37.757207574192 -122.392976332502 (37.757207574192, -122.392976332502)
75391 230416 2 73 1301 San Jose Ave 2 1 1 1     3 Width 3ft   6003629.87373 2095518.0627099997 37.734099111076496 -122.429854315422 (37.7340991110765, -122.429854315422)
76703 230409 2 73 701 Potrero Ave 8 1 1 1     5 Width 4ft   6010459.52552 2104963.6053 37.7604189003367 -122.406907464126 (37.7604189003367, -122.406907464126)
77661 94252 2 73 2125 BRYANT ST 10 1 1 1     9 3x3   6009652.0 2104721.0 37.7597075419954 -122.40968320892 (37.7597075419954, -122.40968320892)
80296 94248 2 73 2125 BRYANT ST 5 1 1 1     9 3x3   6009652.0 2104721.0 37.7597075419954 -122.40968320892 (37.7597075419954, -122.40968320892)
80407 94251 2 73 2125 BRYANT ST 9 1 1 1     9 3x3   6009652.0 2104721.0 37.7597075419954 -122.40968320892 (37.7597075419954, -122.40968320892)
83236 94249 2 73 2125 BRYANT ST 6 1 1 1     9 3x3   6009652.0 2104721.0 37.7597075419954 -122.40968320892 (37.7597075419954, -122.40968320892)
93824 117589 2 73 2698 VALLEJO ST 1 1 1 1       3x3   6000707.0 2117582.0 37.7945152706116 -122.44154236468901 (37.7945152706116, -122.441542364689)
96459 94253 2 73 2125 BRYANT ST 12 1 1 1     9 3x3   6009652.0 2104721.0 37.7597075419954 -122.40968320892 (37.7597075419954, -122.40968320892)
112590 104967 2 73 143-147 FAIR OAKS ST 1 1 1 1     17 3x3 Permit Number 770854 6005451.2 2102876.8 37.7544075015735 -122.424080557223 (37.7544075015735, -122.424080557223)
116382 94250 2 73 2125 BRYANT ST 8 1 1 1     9 3x3   6009652.0 2104721.0 37.7597075419954 -122.40968320892 (37.7597075419954, -122.40968320892)
116397 94257 2 73 2777X 19th St 2 1 1 1     6 3x3   6009684.4 2104752.7 37.7597963985886 -122.40957339028499 (37.7597963985886, -122.409573390285)
119799 94256 2 73 2777X 19th St 3 1 1 1     9 3x3   6009684.4 2104752.7 37.7597963985886 -122.40957339028499 (37.7597963985886, -122.409573390285)
130484 193429 2 73 1151 22nd St 3 1 1 1     6 Width 3ft   6014506.85634 2103858.18885 37.7576093076281 -122.39283217206699 (37.7576093076281, -122.392832172067)
135447 193437 2 73 420 Bay Shore Blvd 1 4 1 1     4 Width 3ft   6010286.5563 2097785.62722 37.7407000755616 -122.40699974536501 (37.7407000755616, -122.406999745365)
136176 117160 2 73 701 Pennsylvania Ave 8 1 1 1     7 3x3   6014455.03317 2103837.45298 37.7575494928317 -122.393009948265 (37.7575494928317, -122.393009948265)
137569 177457 2 73 1651 San Jose Ave 5 1 1 1     2 Width 2ft   6001558.284440001 2094165.3004599998 37.730267205960295 -122.436919623235 (37.7302672059603, -122.436919623235)
138541 230402 2 73 995 Potrero Ave 3 4 1 1     7 Width 4ft   6010527.0507 2103856.48907 37.7573827855076 -122.406595905697 (37.7573827855076, -122.406595905697)
146792 101611 1 73 681 San Bruno Ave 2 1 1 1     6 3x6   6011008.341990001 2105144.37638 37.7609459516243 -122.40502208042 (37.7609459516243, -122.40502208042)
147472 230408 2 73 701 Potrero Ave 6 1 1 1     1 Width 4ft   6010466.90309 2104889.86859 37.7602168487345 -122.40687675138001 (37.7602168487345, -122.40687675138)
150182 193425 2 73 501 18th St 6 1 1 1     8 Width 3ft   6015950.63788 2105804.61367 37.7630338608554 -122.38797476464799 (37.7630338608554, -122.387974764648)
151479 193416 2 73 1425 Indiana St 3 1 1 1     5 Width 4ft   6015128.54714 2101843.94886 37.75211314410829 -122.390541350608 (37.7521131441083, -122.390541350608)
154620 202023 2 73 1330 Fitzgerald Ave 5 4 1 1     3 Width 3ft   6013701.15269 2091283.23076 37.723036312264796 -122.394738025239 (37.7230363122648, -122.394738025239)
154854 177455 2 73 1651 San Jose Ave 3 1 1 1     4 Width 2ft   6001518.96973 2094154.72477 37.7302359329302 -122.43705478235701 (37.7302359329302, -122.437054782357)
155237 131012 2 73 1661 Sacramento St 1 1 1 1     1 Width 4ft   6006845.959840001 2116366.0433 37.7915243922801 -122.420214413174 (37.7915243922801, -122.420214413174)
159837 193415 2 73 1425 Indiana St 2 1 1 1     5 Width 4ft   6015129.4675 2101818.79874 37.75204413825129 -122.390536410622 (37.7520441382513, -122.390536410622)
160052 230400 2 73 898 Potrero Ave 1 1 1 1     2 Width 4ft   6010432.2870000005 2104046.5208099997 37.7578992679501 -122.406937031143 (37.7578992679501, -122.406937031143)
161322 202025 2 73 1330 Fitzgerald Ave 7 4 1 1     3 Width 3ft   6013662.901769999 2091312.2744599998 37.723113933631204 -122.394872285044 (37.7231139336312, -122.394872285044)
162305 230396 2 73 675 Potrero Ave 2 1 1 1     1 Width 3ft   6010452.66825 2105159.82839 37.7609573010551 -122.406945010817 (37.7609573010551, -122.406945010817)
163256 193435 2 73 600 Missouri St 1 4 1 1     7 Width 3ft   6013537.44197 2104295.86136 37.7587571690323 -122.39621549896299 (37.7587571690323, -122.396215498963)
165780 193423 2 73 501 18th St 4 1 1 1     7 Width 3ft   6015877.90137 2105798.99134 37.7630143932264 -122.388225945268 (37.7630143932264, -122.388225945268)
167491 230403 2 73 995 Potrero Ave 10 4 1 1     4 Width 2ft   6010508.06667 2104211.71419 37.758357092123106 -122.406686593337 (37.7583570921231, -122.406686593337)
170064 202026 2 73 1330 Fitzgerald Ave 8 4 1 1     3 Width 3ft   6013645.7458 2091325.32173 37.723148804870206 -122.394932503635 (37.7231488048702, -122.394932503635)
171216 177456 2 73 1651 San Jose Ave 4 1 1 1     3 Width 2ft   6001539.4565 2094159.8919400002 37.7302512852618 -122.436984326781 (37.7302512852618, -122.436984326781)
172396 193422 2 73 501 18th St 3 1 1 1     7 Width 3ft   6015855.7958 2105797.31045 37.763008553013 -122.388302284235 (37.763008553013, -122.388302284235)
173435 230401 2 73 1140 Potrero Ave 1 1 1 1     3 Width 3ft   6010508.63913 2102581.4092 37.753880669869794 -122.406569730021 (37.7538806698698, -122.406569730021)
174486 230411 2 73 2901 Cesar Chavez St 1 2 1 1     7     6010009.797780001 2100525.6899 37.7482081987543 -122.408149874844 (37.7482081987543, -122.408149874844)
175041 193421 2 73 501 18th St 2 1 1 1     7 Width 3ft   6015817.08868 2105796.2011 37.763003362128 -122.38843608266899 (37.763003362128, -122.388436082669)
175470 202027 2 73 1330 Fitzgerald Ave 9 4 1 1     3 Width 3ft   6013629.1875599995 2091337.20695 37.72318051856 -122.39499057468001 (37.72318051856, -122.39499057468)
175478 230405 2 73 701 Potrero Ave 2 1 1 1     6 Width 3ft   6010473.72719 2104680.02328 37.7596410425128 -122.406838360202 (37.7596410425128, -122.406838360202)
176083 117157 2 73 701 Pennsylvania Ave 5 1 1 1     9 3x3   6014459.2864 2103784.30474 37.7574037954676 -122.39299152024999 (37.7574037954676, -122.39299152025)
179529 230395 2 73 675 Potrero Ave 1 1 1 1     1 Width 3ft   6010455.482030001 2105111.38251 37.760824437031395 -122.40693186450899 (37.7608244370314, -122.406931864509)
Powered by Datasette · Query took 3.093ms · Data source: data.sfgov.org