sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
838 19815 3 116 100 STAIRWAY24 6 1 1 2     6 100ST            
4452 19593 3 116 100 STAIRWAY4 16 1 1 2     3 60            
5737 20074 3 116 100 STAIRWAY55 7 1 1 2     24 27X            
6387 19592 3 116 100 STAIRWAY4 15 1 1 2     3 60            
7219 20014 3 116 100 STAIRWAY47 2 1 1 2     12 100ST            
7290 19816 3 116 100 STAIRWAY24 7 1 1 2     6 100ST            
10060 19578 3 116 100 STAIRWAY4 1 1 1 2     36 8            
12451 20015 3 116 100 STAIRWAY47 3 1 1 2     12 100ST            
13822 20456 3 116 495X Sunset Blvd 21 1 1 2     36 60            
14101 96173 1 116     20 1 1   04/04/2011 12:00:00 AM   3x3 Permit Number 767806          
15735 19811 3 116 100 STAIRWAY24 2 1 1 2     24 100ST            
86068 121227 3 116 4299x 17th St 3 7 1 2                    
11264 117179 3 116 350x Winding Way 1 11 1 2     30 3x3   6001167.67306 2086580.24641 37.7094181465037 -122.43772698870701 (37.7094181465037, -122.437726988707)
167020 179495 3 116 350x Winding Way 3 11 1 2     13 Width 0ft   6001141.4285699995 2086583.09342 37.7094244714452 -122.43781789759 (37.7094244714452, -122.43781789759)
85994 104510 5 116 254 ALLISON ST 1 13 1 1     40     6000052.0 2087408.0 37.7116274717654 -122.441642291463 (37.7116274717654, -122.441642291463)
183468 187562 2 116 136 Alpha St 4 1 1 1     5 Width 2ft   6010924.81275 2088138.49847 37.714246765754105 -122.40411411319401 (37.7142467657541, -122.404114113194)
159093 179494 2 116 861 Lisbon St 2 2 1 1     2 Width 6ft   6001008.19959 2088780.1734200001 37.715449588312104 -122.43843566438998 (37.7154495883121, -122.43843566439)
106519 105769 2 116 1 Gonzalez Dr 1 7 1 1   02/24/2014 12:00:00 AM     Permit Number 772589 5990111.8 2090190.8 37.718696994740704 -122.476201051717 (37.7186969947407, -122.476201051717)
38099 200496 2 116 3239 Jennings St 3 1 1 1     7 Width 0ft   6013542.8885 2090062.874 37.7196766561509 -122.39519967454399 (37.7196766561509, -122.395199674544)
36809 215040 2 116 88 Ashton Ave 1 9 1 1     13     5994178.77111 2090487.7098599998 37.71974724151371 -122.46216479907 (37.7197472415137, -122.46216479907)
86905 88838 1 116 3711 19th Ave 14 1 1 1   09/11/2008 12:00:00 AM   3x3 Permit Number 51718 5990297.3 2090806.0 37.7203969366505 -122.475604756889 (37.7203969366505, -122.475604756889)
115004 88839 1 116 3711 19th Ave 15 1 1 1   09/11/2008 12:00:00 AM   3x3 Permit Number 51718 5990297.3 2090806.0 37.7203969366505 -122.475604756889 (37.7203969366505, -122.475604756889)
50092 372 1 116 3711X 19th Ave 3 1 1 1   09/11/2008 12:00:00 AM 6 3x3 Permit Number 51718 5990365.2788562 2091006.8640877 37.720952400174 -122.475384436189 (37.720952400174, -122.475384436189)
88885 370 1 116 3711X 19th Ave 1 1 1 1   09/11/2008 12:00:00 AM 3 3x3 Permit Number 51718 5990365.2788562 2091006.8640877 37.720952400174 -122.475384436189 (37.720952400174, -122.475384436189)
92695 375 1 116 3711X 19th Ave 5 1 1 1   09/11/2008 12:00:00 AM 3 3x3 Permit Number 51718 5990365.2788562 2091006.8640877 37.720952400174 -122.475384436189 (37.720952400174, -122.475384436189)
96847 376 1 116 3711X 19th Ave 8 1 1 1   09/11/2008 12:00:00 AM 3 3x3 Permit Number 51718 5990365.2788562 2091006.8640877 37.720952400174 -122.475384436189 (37.720952400174, -122.475384436189)
101507 381 1 116 3711X 19th Ave 13 1 1 1   09/11/2008 12:00:00 AM 16 3x3 Permit Number 51718 5990365.2788562 2091006.8640877 37.720952400174 -122.475384436189 (37.720952400174, -122.475384436189)
102899 373 1 116 3711X 19th Ave 4 1 1 1   09/11/2008 12:00:00 AM 3 3x3 Permit Number 51718 5990365.2788562 2091006.8640877 37.720952400174 -122.475384436189 (37.720952400174, -122.475384436189)
105060 380 1 116 3711X 19th Ave 12 1 1 1   09/11/2008 12:00:00 AM 16 3x3 Permit Number 51718 5990365.2788562 2091006.8640877 37.720952400174 -122.475384436189 (37.720952400174, -122.475384436189)
116977 371 1 116 3711X 19th Ave 2 1 1 1   09/11/2008 12:00:00 AM 6 3x3 Permit Number 51718 5990365.2788562 2091006.8640877 37.720952400174 -122.475384436189 (37.720952400174, -122.475384436189)
117801 27532 1 116 3711X 19th Ave 7 1 1 1   09/11/2008 12:00:00 AM 3 3x3 Permit Number 51718 5990365.2788562 2091006.8640877 37.720952400174 -122.475384436189 (37.720952400174, -122.475384436189)
122391 374 1 116 3711X 19th Ave 6 1 1 1   09/11/2008 12:00:00 AM 3 3x3 Permit Number 51718 5990365.2788562 2091006.8640877 37.720952400174 -122.475384436189 (37.720952400174, -122.475384436189)
124243 378 1 116 3711X 19th Ave 10 1 1 1   09/11/2008 12:00:00 AM 3 3x3 Permit Number 51718 5990365.2788562 2091006.8640877 37.720952400174 -122.475384436189 (37.720952400174, -122.475384436189)
125133 377 1 116 3711X 19th Ave 9 1 1 1   09/11/2008 12:00:00 AM 12 3x3 Permit Number 51718 5990365.2788562 2091006.8640877 37.720952400174 -122.475384436189 (37.720952400174, -122.475384436189)
129416 379 1 116 3711X 19th Ave 11 1 1 1   09/11/2008 12:00:00 AM 3 3x3 Permit Number 51718 5990365.2788562 2091006.8640877 37.720952400174 -122.475384436189 (37.720952400174, -122.475384436189)
38662 215039 2 116 179 Ashton Ave 1 9 1 1     32     5994134.23715 2091156.84385 37.721581958319504 -122.462367242757 (37.7215819583195, -122.462367242757)
123320 109532   116 818 Goettingen St 1 13 1 1           6010847.3 2090865.3 37.7217296747854 -122.404573864697 (37.7217296747854, -122.404573864697)
12707 107222 2 116 327 Vienna St 1 1 1 1   09/29/2014 12:00:00 AM 3 6x5 Permit Number 773943 6003989.6035400005 2091508.12122 37.7231090719178 -122.42832491578301 (37.7231090719178, -122.428324915783)
73308 187590 2 116 700 Goettingen St 1 7 1 1     4     6010709.76883 2091388.9815099998 37.7231599087791 -122.40508613194599 (37.7231599087791, -122.405086131946)
72190 179498 2 116 892 Peru Ave 1 9 1 1     35     6005545.45161 2091807.84398 37.7240199601485 -122.422967943043 (37.7240199601485, -122.422967943043)
119676 6389 3 116 40 Entrada Ct 3 1 1 2     3 60M   5992282.41809 2092443.27672 37.725007378570105 -122.468861992007 (37.7250073785701, -122.468861992007)
21212 11673 3 116 700X Junipero Serra Blvd 10 11 1 2   03/30/2006 12:00:00 AM 3 3X3   5991295.1451900005 2092921.61878 37.7262636985024 -122.47230970662399 (37.7262636985024, -122.472309706624)
63075 179496 2 116 653 Peru Ave 8 17 1 1     6     6005058.40423 2092646.41058 37.726294985004294 -122.424711217658 (37.7262949850043, -122.424711217658)
131189 179497 2 116 653 Peru Ave 9 17 1 1     8     6005046.66321 2092646.92983 37.7262957476241 -122.424751842734 (37.7262957476241, -122.424751842734)
153412 179499 2 116 1151 Felton St 3 9 1 1     6 Width 2ft   6007548.787880001 2092831.16716 37.7269426263769 -122.416115141404 (37.7269426263769, -122.416115141404)
154917 215038 2 116 314 Staples Ave 6 9 1 1     13     5997989.53732 2093829.39983 37.7291414193406 -122.449233015693 (37.7291414193406, -122.449233015693)
38278 215037 2 116 314 Staples Ave 7 9 1 1     13     5997982.72892 2093830.4607099998 37.7291439428352 -122.449256629186 (37.7291439428352, -122.449256629186)
45602 109669 2 116 200X GELLERT DR 33 11 1 2   02/26/2015 01:37:00 PM 3 30x200   5985380.0 2094516.3 37.730298158604995 -122.492875173009 (37.730298158605, -122.492875173009)
187882 215035 2 116 639 Hearst Ave 1 9 1 1     22     5997171.50868 2094376.6234 37.7305971411271 -122.452100459987 (37.7305971411271, -122.452100459987)
134490 215036 2 116 694 Hearst Ave 5 9 1 1     16     5996922.84392 2094438.19015 37.7307519414457 -122.45296456906901 (37.7307519414457, -122.452964569069)
143568 96273 6 116 55@ Alemany Trumbull St 1 13 1 1           6004020.1 2094407.4 37.7310715719205 -122.428426044208 (37.7310715719205, -122.428426044208)
35152 215041 2 116 497 Joost Ave 1 9 1 1     3 Width 10ft   5998794.49638 2094951.64479 37.732268849509104 -122.44653092436701 (37.7322688495091, -122.446530924367)
147246 215043 2 116 798 Joost Ave 1 9 1 1     14     5996915.73734 2095029.5626400001 37.732375301382 -122.453031809567 (37.732375301382, -122.453031809567)
171498 215042 2 116 689 Mangels Ave 3 9 1 1     34 Width 10ft   5996876.31142 2095244.7341099998 37.732963851 -122.453183641224 (37.732963851, -122.453183641224)
124987 98548 7 116 132 Hamerton Ave 1 7 1 1           6001332.8 2095440.7 37.7337563407686 -122.437790462907 (37.7337563407686, -122.437790462907)
42971 111268 3 116 700X BOSWORTH ST 6 7 1 2     3     6002150.0 2095428.0 37.73376790368221 -122.434964255854 (37.7337679036822, -122.434964255854)
85054 111269 3 116 700X BOSWORTH ST 7 7 1 2     3     6002150.0 2095428.0 37.73376790368221 -122.434964255854 (37.7337679036822, -122.434964255854)
172592 240600 2 116 237 Murray St 3 9 1 1     10 Width 10ft   6005707.57123 2095372.66085 37.7338173103055 -122.422660726511 (37.7338173103055, -122.422660726511)
81067 113358 6 116 702 Foerster St 1 5 1 1           5998153.40008835 2095558.62470631 37.733898832504295 -122.448791034412 (37.7338988325043, -122.448791034412)
100317 113359 6 116 702 Foerster St 2 5 1 1           5998153.40008835 2095558.62470631 37.733898832504295 -122.448791034412 (37.7338988325043, -122.448791034412)
20974 109568 6 116 95 Nordhoff St 1 13 1 1         Permit Number 777169 6000348.8 2095645.6 37.734262946491704 -122.44120712981501 (37.7342629464917, -122.441207129815)
65956 185096 2 116 2801 Sunset Blvd 24 9 1 1     2 Width 0ft   5985018.6615 2095986.0271 37.7343125019956 -122.494232639372 (37.7343125019956, -122.494232639372)
154758 185095 2 116 2801 Sunset Blvd 23 9 1 1     2 Width 0ft   5985029.9671 2095999.845 37.7343511038502 -122.494194570965 (37.7343511038502, -122.494194570965)
164278 185092 2 116 2801 Sunset Blvd 20 9 1 1     2 Width 0ft   5985016.1492 2096009.4757 37.7343767385902 -122.494243052853 (37.7343767385902, -122.494243052853)
139589 109576 6 116 21X STILLINGS AVE 1 13 1 1     60     6000417.0 2095694.0 37.7343997262189 -122.44097481223999 (37.7343997262189, -122.44097481224)
60921 240596 2 116 1300 San Jose Ave 8 7 1 1     20     6003644.77453 2095717.8337299998 37.7346484808287 -122.429817043043 (37.7346484808287, -122.429817043043)
151692 240595 2 116 1300 San Jose Ave 7 7 1 1     27     6003654.00301 2095729.23304 37.7346803033401 -122.429785949874 (37.7346803033401, -122.429785949874)
71910 186966 2 116 2800 Sunset Blvd 40 9 1 1     1 Width 0ft   5985198.0961 2096141.0368 37.734748616014 -122.493623703195 (37.734748616014, -122.493623703195)
73058 186967 2 116 2800 Sunset Blvd 41 9 1 1     3 Width 0ft   5985210.5401 2096146.418 37.7347641193316 -122.493581077021 (37.7347641193316, -122.493581077021)
134037 186968 2 116 2800 Sunset Blvd 42 9 1 1     1 Width 0ft   5985205.8316 2096154.4897 37.73478600662639 -122.49359795024999 (37.7347860066264, -122.49359795025)
70926 186856 2 116 2700 Sunset Blvd 5 9 1 1     2 Width 0ft   5985217.4528 2096293.5766 37.735168582064794 -122.49356801735901 (37.7351685820648, -122.493568017359)
60464 186891 2 116 2700 Sunset Blvd 40 9 1 1     3 Width 0ft   5985178.2577 2096509.7223 37.7357597676042 -122.493719449451 (37.7357597676042, -122.493719449451)
178388 184997 2 116 2701 Sunset Blvd 23 9 1 1     1 Width 0ft   5985027.6641 2096515.5033 37.7357668292904 -122.49424052859399 (37.7357668292904, -122.494240528594)
152219 184995 2 116 2701 Sunset Blvd 21 9 1 1     1 Width 0ft   5985022.2207 2096528.9025 37.7358033013739 -122.494260335606 (37.7358033013739, -122.494260335606)
54404 215029 2 116 100 Terrace Dr 24 2 1 1     12     5993749.23334 2096552.6449799999 37.736375328444296 -122.464089591065 (37.7363753284443, -122.464089591065)
31261 215028 2 116 100 Terrace Dr 23 2 1 1     13     5993755.12546 2096561.9752 37.7364012864951 -122.464069896803 (37.7364012864951, -122.464069896803)
164614 215027 2 116 100 Terrace Dr 22 2 1 1     14     5993761.26762 2096568.1489799998 37.7364185921533 -122.464049108976 (37.7364185921533, -122.464049108976)
168319 215026 2 116 100 Terrace Dr 21 2 1 1     13     5993767.12006 2096575.58918 37.7364393583851 -122.46402941471901 (37.7364393583851, -122.464029414719)
171909 186922 2 116 2700 Sunset Blvd 71 9 1 1     2 Width 0ft   5985180.0914 2096773.3145 37.736483628738604 -122.493732527554 (37.7364836287386, -122.493732527554)
171538 186924 2 116 2700 Sunset Blvd 73 9 1 1     1 Width 0ft   5985155.3367 2096781.1077 37.736503578508895 -122.493818687918 (37.7365035785089, -122.493818687918)
187185 186923 2 116 2700 Sunset Blvd 72 9 1 1     1 Width 0ft   5985171.3814 2096790.2761 37.73652969119129 -122.493763890804 (37.7365296911913, -122.493763890804)
135635 240594 2 116 216 Bemis St 1 9 1 1     47     6003152.3623 2096416.5644900003 37.736539139077394 -122.43156934507401 (37.7365391390774, -122.431569345074)
135178 215025 2 116 100 Terrace Dr 14 2 1 1     10     5993646.76934 2096691.5619299999 37.7367508538673 -122.464453932502 (37.7367508538673, -122.464453932502)
60028 215024 2 116 100 Terrace Dr 13 2 1 1     12     5993634.34816 2096702.85203 37.7367811376468 -122.46449769711201 (37.7367811376468, -122.464497697112)
60441 215023 2 116 100 Terrace Dr 12 2 1 1     12     5993620.60867 2096711.6491200002 37.736804500228 -122.464545838734 (37.736804500228, -122.464545838734)
175766 215022 2 116 100 Terrace Dr 11 2 1 1     12     5993608.12799 2096720.10438 37.7368269967784 -122.464589603347 (37.7368269967784, -122.464589603347)
187074 247597 2 116 900 Tompkins Ave 2 9 1 1     12 Width 8ft   6009155.970980001 2096407.45458 37.7368525815689 -122.41081158571001 (37.7368525815689, -122.41081158571)
37950 247598 2 116 900 Tompkins Ave 3 9 1 1     13 Width 10ft   6009167.823059999 2096407.9062599998 37.7368544863348 -122.410770639572 (37.7368544863348, -122.410770639572)
65616 247596 2 116 900 Tompkins Ave 1 9 1 1     13 Width 8ft   6009145.02453 2096408.71868 37.73685543873 -122.410849521814 (37.73685543873, -122.410849521814)
71023 240631 2 116 57 Poppy Ln 1 13 1 1     4 Width 2ft   6002629.35658 2096548.6301400003 37.7368721031581 -122.433387031387 (37.7368721031581, -122.433387031387)
114267 95432 2 116 2675 25th Ave 1 14 1 1     12     5988610.0 2097126.3 37.7376529013161 -122.48189987005101 (37.7376529013161, -122.481899870051)
115606 95435 2 116 2675 25th Ave 2 14 1 1     12     5988610.0 2097126.3 37.7376529013161 -122.48189987005101 (37.7376529013161, -122.481899870051)
74083 187107 2 116 2600 Sunset Blvd 43 9 1 1     1 Width 0ft   5985143.7078 2097238.6019 37.73775905490071 -122.49389259826401 (37.7377590549007, -122.493892598264)
74839 187109 2 116 2600 Sunset Blvd 45 9 1 1     3 Width 0ft   5985172.8615 2097253.1787 37.7378007845896 -122.493792875188 (37.7378007845896, -122.493792875188)
27330 187124 2 116 2600 Sunset Blvd 60 9 1 1     2 Width 0ft   5985135.2439 2097353.8058 37.738074878751895 -122.493930349328 (37.7380748787519, -122.493930349328)
146439 187127 2 116 2600 Sunset Blvd 63 9 1 1     1 Width 0ft   5985167.6891 2097369.3231 37.7381193834059 -122.49381931494301 (37.7381193834059, -122.493819314943)
154850 187128 2 116 2600 Sunset Blvd 64 9 1 1     2 Width 0ft   5985172.8615 2097384.8403 37.738162292099204 -122.49380257480101 (37.7381622920992, -122.493802574801)
74221 215021 2 116 2624 14th Ave 3 1 1 1     19 Width 3ft   5992112.26225 2097456.03758 37.7387613350595 -122.469814985494 (37.7387613350595, -122.469814985494)
117092 113150 6 116 45 BRONTE ST 1 1 1 1     15 3x3   6009384.0 2097185.0 37.7390003361927 -122.410078062228 (37.7390003361927, -122.410078062228)
140384 104978 2 116 66X San Lorenzo Way 1 3 1 1         Permit Number 770332 5993690.5 2097533.7 37.7390656757525 -122.46436386193301 (37.7390656757525, -122.464363861933)
154287 215034 3 116 300x Marietta Dr 32 11 1 2     25 Width 5ft   5999319.41307 2097556.59014 37.7394513821643 -122.444903362803 (37.7394513821643, -122.444903362803)
Powered by Datasette · Query took 11.413ms · Data source: data.sfgov.org