sf-trees

Data source: data.sfgov.org

Custom SQL query returning 58 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
185681 222617 2 123 100 Alemany Blvd 15 1 1 1     16 Width 3ft   6009476.82637 2095975.18511 37.7356836481774 -122.409671740872 (37.7356836481774, -122.409671740872)
183889 188396 2 123 760 De Haro St 3 10 1 1     8 Width 9ft   6012087.53124 2104906.41164 37.760352821738 -122.401272892241 (37.760352821738, -122.401272892241)
182586 72595 2 123 1342 24th Ave 2 1 1 1 1 02/22/1997 12:00:00 AM 8     5988674.2474 2106188.616 37.7625393471524 -122.482341528113 (37.7625393471524, -122.482341528113)
178171 126440 2 123 3700 Webster St 3 9 1 1     6 Width 2ft   6002594.85565 2121336.78528 37.8049323037346 -122.435278861456 (37.8049323037346, -122.435278861456)
175205 126439 2 123 3700 Webster St 1 9 1 1     6 Width 2ft   6002595.71169 2121316.79455 37.804877463081205 -122.43527446824 (37.8048774630812, -122.43527446824)
174707 222616 2 123 100 Alemany Blvd 2 1 1 1     9 Width 3ft   6009648.8071099995 2096248.24649 37.7364430518981 -122.409096395993 (37.7364430518981, -122.409096395993)
174575 126449 2 123 2401 Broadway 13 9 1 1     8 Width 4ft   6002081.41043 2117344.80364 37.7939421980234 -122.436769753035 (37.7939421980234, -122.436769753035)
173981 204703 2 123 1701 Irving St 5 1 1 1     7 Width 4ft   5990335.67224 2106502.91932 37.7634988436072 -122.476618288403 (37.7634988436072, -122.476618288403)
171772 222620 2 123 2080 Folsom St 3 1 1 1     11 Width 3ft   6008061.85014 2106305.07413 37.763967807681496 -122.41529490396002 (37.7639678076815, -122.41529490396)
170963 200141 2 123 700 Jamestown Ave 3 1 1 1     6 Width 0ft   6015336.2607 2088334.3204 37.7150299562444 -122.388879960947 (37.7150299562444, -122.388879960947)
170706 222622 2 123 1403 Douglass St 24 9 1 1     9 Width 5ft   6001405.60814 2099658.97548 37.7453428786853 -122.437840770053 (37.7453428786853, -122.437840770053)
168529 187347 2 123 2200 Sunset Blvd 32 9 1 1     2 Width 0ft   5985050.239 2099735.2948 37.7446088316551 -122.49439974859 (37.7446088316551, -122.49439974859)
164988 82707 1 123 728 Jamestown Ave 1 1 1 1   07/08/2009 12:00:00 AM 10 3x3 Permit Number 52492 6015289.4977 2088419.4291 37.715261056172 -122.389047534015 (37.715261056172, -122.389047534015)
164740 222619 2 123 2070 Folsom St 3 1 1 1     12 Width 2ft   6008053.49701 2106456.27126 37.7643824904803 -122.415334499301 (37.7643824904803, -122.415334499301)
162738 200798 2 123 700 Jamestown Ave 7 1 1 1     5 Width 0ft   6015296.9798 2088405.4002 37.71522295028 -122.389020693471 (37.71522295028, -122.389020693471)
159266 222618 2 123 100 Alemany Blvd 24 1 1 1     13 Width 3ft   6009365.793430001 2095894.2189 37.7354551097631 -122.41004991207599 (37.7354551097631, -122.410049912076)
155827 187359 2 123 2200 Sunset Blvd 44 9 1 1     1 Width 0ft   5985046.8536 2099804.0196 37.744797333195294 -122.49441651949199 (37.7447973331953, -122.494416519492)
151915 222621 2 123 275 Shotwell St 1 1 1 1     9 Width 3ft   6007804.561840001 2106235.52037 37.763762365669606 -122.41617986380501 (37.7637623656696, -122.416179863805)
150521 185561 2 123 2201 Sunset Blvd 45 9 1 1     1 Width 0ft   5984873.8699 2099777.8321 37.744715304246604 -122.495012724857 (37.7447153042466, -122.495012724857)
131592 204701 2 123 1708 Irving St 2 1 1 1     13 Width 3ft   5990405.41807 2106567.82065 37.7636810903261 -122.476381803596 (37.7636810903261, -122.476381803596)
130070 73785 2 123 1342 24th Ave 1 1 1 1 1 02/22/1997 12:00:00 AM 15     5988676.4118 2106176.1706 37.7625053013705 -122.48233313043801 (37.7625053013705, -122.482333130438)
76970 126445 2 123 2601 Vallejo St 9 9 1 1     4 Width 4ft   6001071.40482 2117563.77475 37.7944859829844 -122.44028017389499 (37.7944859829844, -122.440280173895)
76797 184436 2 123 3832 Quintara St 1 1 1 1     7 Width 0ft   5981489.6965 2100816.3891 37.7473681966369 -122.506791353844 (37.7473681966369, -122.506791353844)
76116 204702 2 123 1701 Irving St 3 1 1 1     10 Width 4ft   5990288.33301 2106501.46876 37.763492114902206 -122.47678191195 (37.7634921149022, -122.47678191195)
75695 126441 2 123 1601 Beach St 6 9 1 1     4 Width 3ft   6002491.85461 2121233.39773 37.8046425790601 -122.435627906308 (37.8046425790601, -122.435627906308)
74309 248017 2 123 525 Franconia St 8 2 1 1     16 Width 6ft   6009948.88401 2098163.6400900004 37.7417191153415 -122.408193947005 (37.7417191153415, -122.408193947005)
74060 223873 2 123 310 Liberty St 53 2 1 1     3 Width 3ft   6003827.49895 2103926.48833 37.757197889383 -122.429770597528 (37.757197889383, -122.429770597528)
69650 204699 2 123 1325 18th Ave 3 1 1 1     14 Width 6ft   5990483.27142 2106360.56489 37.7631165364244 -122.476097397488 (37.7631165364244, -122.476097397488)
68751 184077 2 123 1600 Sunset Blvd 78 9 1 1     1 Width 0ft   5984949.117000001 2104038.1203 37.7564172922771 -122.495066625722 (37.7564172922771, -122.495066625722)
67538 248010 2 123 525 Franconia St 1 9 1 1     15 Width 6ft   6009913.14391 2098013.75729 37.741305568398104 -122.408306955813 (37.7413055683981, -122.408306955813)
66545 126444 2 123 2601 Vallejo St 8 9 1 1     5 Width 4ft   6001059.38792 2117563.4406 37.7944843813066 -122.440321729778 (37.7944843813066, -122.440321729778)
62347 126446 2 123 2656 Broderick St 4 9 1 1     4 Width 4ft   6000160.0682 2117773.16546 37.795008985534395 -122.443448549322 (37.7950089855344, -122.443448549322)
62269 126450 2 123 2401 Broadway 14 9 1 1     8 Width 4ft   6002086.73219 2117346.5512599996 37.793947298979504 -122.436751464412 (37.7939472989795, -122.436751464412)
62162 248012 2 123 525 Franconia St 3 1 1 1     13 Width 4ft   6009917.55831 2098055.52867 37.7414205107404 -122.40829463781401 (37.7414205107404, -122.408294637814)
59768 187346 2 123 2200 Sunset Blvd 31 9 1 1     2 Width 0ft   5985099.3282 2099721.0758 37.7445726628756 -122.494228962515 (37.7445726628756, -122.494228962515)
57337 204700 2 123 1708 Irving St 1 1 1 1     14 Width 3ft   5990418.27546 2106568.79929 37.763684523058 -122.47633740584101 (37.763684523058, -122.476337405841)
52982 223871 2 123 310 Liberty St 17 2 1 1     3 Width 3ft   6004161.87105 2103941.4208299997 37.7572578193179 -122.42861527358299 (37.7572578193179, -122.428615273583)
49987 223870 2 123 310 Liberty St 16 2 1 1     6 Width 3ft   6004165.7339 2103945.48087 37.757269185837295 -122.428602203741 (37.7572691858373, -122.428602203741)
49290 78320 2 123 830 Olmstead St 1 1 1 1 1 08/05/2000 12:00:00 AM 14     6009222.3521300005 2090505.2073099997 37.7206499863841 -122.41016549563999 (37.7206499863841, -122.41016549564)
48770 200139 2 123 700 Jamestown Ave 1 1 1 1     6 Width 0ft   6015356.8365 2088295.9747 37.7149258068198 -122.388806166206 (37.7149258068198, -122.388806166206)
47680 184086 2 123 1600 Sunset Blvd 87 9 1 1     2 Width 0ft   5984957.3486 2104087.5098 37.7565533840583 -122.495041800117 (37.7565533840583, -122.495041800117)
47389 40047 1 123 1748 Quesada Ave 1 1 1 1 1 02/10/1999 12:00:00 AM 15   Permit Number 41284 6014490.89885 2095235.14935 37.733931362340705 -122.392284274492 (37.7339313623407, -122.392284274492)
43228 200140 2 123 700 Jamestown Ave 2 1 1 1     4 Width 0ft   6015344.6781 2088315.6151 37.714979061664295 -122.388849561469 (37.7149790616643, -122.388849561469)
42613 191031 2 123 601 Wisconsin St 10 9 1 1     4 Width 6ft   6012727.00633 2104624.78835 37.7596152022936 -122.399041463801 (37.7596152022936, -122.399041463801)
39395 223872 2 123 310 Liberty St 18 2 1 1     5 Width 3ft   6004160.81529 2103945.20592 37.7572681525309 -122.428619194619 (37.7572681525309, -122.428619194619)
39390 200797 2 123 700 Jamestown Ave 6 1 1 1     5 Width 0ft   6015309.1382 2088387.6302 37.715174831256704 -122.388977428453 (37.7151748312567, -122.388977428453)
38528 185435 2 123 2300 Sunset Blvd 51 9 1 1     2 Width 0ft   5985116.6315 2099415.327 37.7437341719949 -122.49414660134899 (37.7437341719949, -122.494146601349)
36122 248019 2 123 525 Franconia St 10 2 1 1     10 Width 6ft   6009962.41848 2098212.02892 37.741852738408 -122.408150561002 (37.741852738408, -122.408150561002)
35889 185557 2 123 2201 Sunset Blvd 41 9 1 1     1 Width 0ft   5984925.3425 2099814.4466 37.744818850863794 -122.494837444262 (37.7448188508638, -122.494837444262)
33603 126442 2 123 1601 Beach St 7 9 1 1     5 Width 3ft   6002503.29983 2121235.66202 37.8046494462659 -122.435588461158 (37.8046494462659, -122.435588461158)
33543 126448 2 123 2401 Broadway 5 9 1 1     9 Width 4ft   6002040.59654 2117340.69483 37.7939285966777 -122.43691067858299 (37.7939285966777, -122.436910678583)
30428 204704 2 123 1701 Irving St 7 1 1 1     7 Width 3ft   5990371.2577599995 2106504.61857 37.7635055732383 -122.47649533489701 (37.7635055732383, -122.476495334897)
27783 126443 2 123 2601 Vallejo St 7 9 1 1     6 Width 4ft   6001049.1036 2117561.90352 37.7944795753318 -122.440357204422 (37.7944795753318, -122.440357204422)
23780 126447 2 123 2656 Broderick St 5 9 1 1     4 Width 4ft   6000161.293869999 2117775.76551 37.795016194482706 -122.44344449519 (37.7950161944827, -122.44344449519)
9444 173598 6 123 1771 11th Ave 1 5 1 1     12 3x3   5992768.0 2103420.0 37.7551747322674 -122.467981458634 (37.7551747322674, -122.467981458634)
3495 82708 1 123 728 Jamestown Ave 1 1 1 1   07/08/2009 12:00:00 AM 14 3x3 Permit Number 52492 6015291.25471 2088404.66417 37.7152206119305 -122.38904043068399 (37.7152206119305, -122.389040430684)
1789 251698 2 123 700 Jamestown Ave 9 1 1 1       Width 0ft   6015296.9798 2088405.4002 37.71522295028 -122.389020693471 (37.71522295028, -122.389020693471)
951 248015 3 123 525 Franconia St 6 1 1 2     13 Width 4ft   6009932.57505 2098116.0025400002 37.741587399748894 -122.408246979117 (37.7415873997489, -122.408246979117)
Powered by Datasette · Query took 2.341ms · Data source: data.sfgov.org