sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
180380 203655 2 42 230 Edna St 8 17 1 1     12     5998797.91036 2095380.6148 37.7334468948521 -122.446549972903 (37.7334468948521, -122.446549972903)
181115 203656 2 42 232 Edna St 1 17 1 1     11     5998785.56076 2095387.29688 37.733464536852395 -122.446593149381 (37.7334645368524, -122.446593149381)
112048 116664 3 42 199x Esmeralda Ave 18 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
24822 250192 2 42 11 Alta St 2 13 1 1     9 Width 0ft   6011786.88966 2119947.0785 37.8016342173021 -122.403370805543 (37.8016342173021, -122.403370805543)
47761 250191 2 42 11 Alta St 1 13 1 1     11 Width 0ft   6011795.08799 2119945.2148 37.8016295579248 -122.40334230423099 (37.8016295579248, -122.403342304231)
135843 250193 2 42 11 Alta St 3 13 1 1     35 Width 0ft   6011782.399230001 2119949.71509 37.8016412059365 -122.403386530161 (37.8016412059365, -122.403386530161)
159982 220096 2 42 5 Penny Ln 2 13 1 1     4 Width 2ft   6002436.28409 2096397.8300700001 37.736447085360105 -122.43404379100402 (37.7364470853601, -122.434043791004)
166281 220095 2 42 5 Penny Ln 1 13 1 1     7 Width 2ft   6002427.25103 2096406.93673 37.7364715774983 -122.43407567285601 (37.7364715774983, -122.434075672856)
77429 23663 3 42 311 Virginia Ave 2 11 1 2     12 12   6006938.1768512 2098312.3803834 37.7419584813283 -122.41861453896999 (37.7419584813283, -122.41861453897)
91582 23671 3 42 317 Virginia Ave 2 11 1 2     6 12   6006937.941544901 2098264.8464559 37.7418279505329 -122.41861198258002 (37.7418279505329, -122.41861198258)
103201 23678 3 42 319 Virginia Ave 7 11 1 2     6 12   6006936.2458165 2098250.5638735 37.741788638281996 -122.418616833275 (37.741788638282, -122.418616833275)
104707 23675 3 42 319 Virginia Ave 4 11 1 2     6 12   6006936.2458165 2098250.5638735 37.741788638281996 -122.418616833275 (37.741788638282, -122.418616833275)
104998 23677 3 42 319 Virginia Ave 6 11 1 2     6 12   6006936.2458165 2098250.5638735 37.741788638281996 -122.418616833275 (37.741788638282, -122.418616833275)
107814 23676 3 42 319 Virginia Ave 5 11 1 2     6 12   6006936.2458165 2098250.5638735 37.741788638281996 -122.418616833275 (37.741788638282, -122.418616833275)
111638 23659 3 42 305 Virginia Ave 1 11 1 2     12 12   6006899.0385805 2098362.9679323 37.742095179874795 -122.418753453583 (37.7420951798748, -122.418753453583)
112941 23666 3 42 313 Virginia Ave 1 11 1 2     12 12   6006939.3181056 2098298.0428385 37.7419191778851 -122.41860957638501 (37.7419191778851, -122.418609576385)
124400 105235 2 42 182X LOWER TER 27 11 1 1     24 200x30   6000081.0 2106216.0 37.763271458828704 -122.442891809215 (37.7632714588287, -122.442891809215)
128008 23660 3 42 305 Virginia Ave 2 11 1 2     12 12   6006899.0385805 2098362.9679323 37.742095179874795 -122.418753453583 (37.7420951798748, -122.418753453583)
142538 23664 3 42 311 Virginia Ave 3 11 1 2     12 12   6006938.1768512 2098312.3803834 37.7419584813283 -122.41861453896999 (37.7419584813283, -122.41861453897)
154734 203652 3 42 400x Marietta Dr 38 11 1 2     6 Width 3ft   5999131.48243 2096996.51385 37.737902818863795 -122.445512879233 (37.7379028188638, -122.445512879233)
167015 220038 3 42 500x 27th St 11 11 1 2     1 Width 4ft   6002807.79997 2100063.2344299997 37.7465325135634 -122.433021102638 (37.7465325135634, -122.433021102638)
45189 220002 2 42 1001 Jarboe Ave 1 10 1 1     12 Width 8ft   6009383.355930001 2096884.0702099998 37.7381740121064 -122.4100590501 (37.7381740121064, -122.4100590501)
54358 219993 2 42 101 Prospect Ave 3 10 1 1     13     6006993.27252 2098944.7494 37.7436979269164 -122.418468865069 (37.7436979269164, -122.418468865069)
178540 220003 2 42 1001 Jarboe Ave 1 10 1 1     10 Width 8ft   6009365.07591 2096886.4272 37.738179459299296 -122.410122419925 (37.7381794592993, -122.410122419925)
185093 220033 2 42 502 28th St 2 10 1 1     12     6002622.25428 2099488.24408 37.7449431983695 -122.433621612357 (37.7449431983695, -122.433621612357)
19697 85509 1 42 1 Nebraska St 3 9 1 1         Permit Number 49678 6009335.0 2098038.0 37.7413397420659 -122.410307693317 (37.7413397420659, -122.410307693317)
31523 188515 2 42 1401 25th St 3 9 1 1     1     6014455.23285 2101981.54762 37.752453585184604 -122.39287941707799 (37.7524535851846, -122.392879417078)
31819 220062 2 42 430 College Ave 1 9 1 1     13 Width 3ft   6005376.5701 2095055.5296099999 37.7329278583224 -122.423782556133 (37.7329278583224, -122.423782556133)
38771 174961 2 42 54 Santa Ynez Ave 1 9 1 1     4     6000769.59798 2092028.9930200002 37.7243565377 -122.43949313040899 (37.7243565377, -122.439493130409)
41593 220031 2 42 541 Grand View Ave 2 9 1 1     7 Width 5ft   6000040.44223 2101732.89415 37.7509596367958 -122.44271016275101 (37.7509596367958, -122.442710162751)
41760 203657 2 42 226 Joost Ave 2 9 1 1     12 Width 10ft   6000556.64604 2094979.3129099999 37.7324453144793 -122.440440771241 (37.7324453144793, -122.440440771241)
42561 203661 2 42 582 Mangels Ave 4 9 1 1     8 Width 10ft   5997537.55728 2095290.5878599999 37.7331276310309 -122.450900858796 (37.7331276310309, -122.450900858796)
66468 203632 2 42 1400 Monterey Blvd 3 9 1 1     9 Width 10ft   5993831.29855 2094857.6984 37.7317261536347 -122.463682879865 (37.7317261536347, -122.463682879865)
69465 188516 2 42 1506 25th St 2 9 1 1     4 Width 4ft   6014137.77003 2102020.8067900003 37.7525437439982 -122.39398001279301 (37.7525437439982, -122.393980012793)
77508 85510 1 42 1 Nebraska St 4 9 1 1         Permit Number 49678 6009335.0 2098038.0 37.7413397420659 -122.410307693317 (37.7413397420659, -122.410307693317)
88150 121723 2 42 199 Burnside Ave 1 9 1 1     10     6001086.0 2095247.0 37.7332104486713 -122.438629847451 (37.7332104486713, -122.438629847451)
117346 85502 1 42 1 Nebraska St 4 9 1 1           6009335.0 2098038.0 37.7413397420659 -122.410307693317 (37.7413397420659, -122.410307693317)
146004 203662 2 42 337 Detroit St 1 9 1 1     9 Width 5ft   5999398.70847 2094267.55477 37.7304249920009 -122.44439288782301 (37.7304249920009, -122.444392887823)
149197 203647 2 42 70 Manor Dr 1 9 1 1     10 Width 3ft   5993596.72892 2093377.0999599998 37.7276472749004 -122.46438636913099 (37.7276472749004, -122.464386369131)
151268 203651 2 42 1390 Monterey Blvd 3 9 1 1     10 Width 3ft   5993846.97887 2094818.6059299998 37.731619718855704 -122.46362583408701 (37.7316197188557, -122.463625834087)
157925 203650 2 42 1390 Monterey Blvd 2 9 1 1     11 Width 3ft   5993848.38247 2094813.0241599998 37.7316044735649 -122.46362057664699 (37.7316044735649, -122.463620576647)
158134 203631 2 42 1400 Monterey Blvd 2 9 1 1     11 Width 10ft   5993837.01835 2094842.09298 37.7316836345786 -122.46366197331801 (37.7316836345786, -122.463661973318)
166995 203640 2 42 216 Ralston St 5 9 1 1     13 Width 5ft   5992221.60329 2089317.4306299998 37.7164210557753 -122.468844858002 (37.7164210557753, -122.468844858002)
168971 220018 2 42 1129 Douglass St 2 9 1 1     4 Width 6ft   6001364.34858 2100418.37342 37.7474256590636 -122.43803782498999 (37.7474256590636, -122.43803782499)
170022 220032 2 42 4496 24th St 1 9 1 1     8 Width 5ft   6000063.08667 2101692.20447 37.7508492036437 -122.442628935085 (37.7508492036437, -122.442628935085)
170043 203639 2 42 216 Ralston St 4 9 1 1     11 Width 5ft   5992221.12373 2089294.63928 37.7163584485498 -122.46884485801701 (37.7163584485498, -122.468844858017)
178200 203649 2 42 1390 Monterey Blvd 1 9 1 1     7 Width 3ft   5993852.26622 2094804.8663700002 37.731582298063394 -122.46360655802201 (37.7315822980634, -122.463606558022)
186555 203630 2 42 1400 Monterey Blvd 1 9 1 1     11 Width 10ft   5993843.17005 2094826.47883 37.731641116434496 -122.46363957301 (37.7316411164345, -122.46363957301)
5055 253765 6 42 1366 Guerrero St 2 7 1 1       3X3   6005800.0848900005 2101007.6677599996 37.7492949871928 -122.422741198761 (37.7492949871928, -122.422741198761)
12540 108677 1 42 11 Otsego Ave 1 7 1 1 1 12/30/2014 12:00:00 AM 3   Permit Number 773206 6000966.57436 2092971.8241299998 37.7269565451936 -122.438879746024 (37.7269565451936, -122.438879746024)
42028 188510 2 42 101 Pennsylvania Ave 25 7 1 1     2     6014318.1653 2106535.6894400003 37.76495065967789 -122.39367214607401 (37.7649506596779, -122.393672146074)
55738 188509 2 42 101 Pennsylvania Ave 12 7 1 1     2     6014325.646980001 2106424.64729 37.7646461780098 -122.393638496141 (37.7646461780098, -122.393638496141)
60414 188512 2 42 101 Pennsylvania Ave 41 7 1 1     5     6014229.234019999 2106696.64866 37.7653876762377 -122.393991007905 (37.7653876762377, -122.393991007905)
72487 249768 2 42 266 Lombard St 4 7 1 1     12 Width 0ft   6010977.12206 2120702.10235 37.8036620671076 -122.406226211476 (37.8036620671076, -122.406226211476)
169866 188508 2 42 101 Pennsylvania Ave 3 7 1 1     3     6014332.46782 2106283.64375 37.764259392178005 -122.393605035044 (37.764259392178, -122.393605035044)
176295 249709 2 42 2901 Broadway 3 7 1 1     8     5999701.30683 2117014.48804 37.7928996850292 -122.44498136009899 (37.7928996850292, -122.444981360099)
177773 188511 2 42 101 Pennsylvania Ave 33 7 1 1     2     6014272.76615 2106665.73514 37.7653052137955 -122.393838275126 (37.7653052137955, -122.393838275126)
2638 37832 3 42 450X Moscow St 19 5 1 4 2 06/22/2006 12:00:00 AM 3 3x3 Permit Number 48867 6003860.1558 2090386.44981 37.7200218836872 -122.42869247048 (37.7200218836872, -122.42869247048)
2661 37833 3 42 450X Moscow St 20 5 1 4 2 07/07/1998 12:00:00 AM 3 3x3 Permit Number 40134 6003832.66245 2090342.4611400003 37.719899544415604 -122.428784371324 (37.7198995444156, -122.428784371324)
12958 37815 3 42 450X Moscow St 2 5 1 4 2 07/07/1998 12:00:00 AM 8 3x3 Permit Number 40134 6003965.721940001 2090553.1315400002 37.7204855291627 -122.42833943800899 (37.7204855291627, -122.428339438009)
93136 37837 3 42 450X Moscow St 23 5 1 4 2 07/07/1998 12:00:00 AM 8 3x3 Permit Number 40134 6003752.0 2090699.0 37.720873955994 -122.42908860130501 (37.720873955994, -122.429088601305)
96417 37825 3 42 450X Moscow St 12 5 1 4 2 07/07/1998 12:00:00 AM 3 3x3 Permit Number 40134 6003752.0 2090699.0 37.720873955994 -122.42908860130501 (37.720873955994, -122.429088601305)
139322 37829 3 42 450X Moscow St 16 5 1 4 2 07/07/1998 12:00:00 AM 3 3x3 Permit Number 40134 6003752.0 2090699.0 37.720873955994 -122.42908860130501 (37.720873955994, -122.429088601305)
142748 37835 3 42 450X Moscow St 21 5 1 4 2 07/07/1998 12:00:00 AM 8 3x3 Permit Number 40134 6003752.0 2090699.0 37.720873955994 -122.42908860130501 (37.720873955994, -122.429088601305)
53663 220045 2 42 160 Marview Way 1 4 1 1     5 Width 3ft   5998323.68704 2103258.27383 37.755049936933 -122.448756699664 (37.755049936933, -122.448756699664)
68064 188520 2 42 495 Connecticut St 2 4 1 1     9 Width 3ft   6013272.40757 2104812.59187 37.7601612472551 -122.397168349564 (37.7601612472551, -122.397168349564)
69010 188521 2 42 495 Connecticut St 3 4 1 1     7 Width 3ft   6013271.447919999 2104826.1277799997 37.7601983604744 -122.397172617724 (37.7601983604744, -122.397172617724)
76199 220046 2 42 170 Saint Germain Ave 1 4 1 1     6 Width 3ft   5997546.7288 2104141.22433 37.7574298380281 -122.451507313917 (37.7574298380281, -122.451507313917)
165659 203641 2 42 608 Garfield St 1 4 1 1     9 Width 3ft   5992400.09934 2090515.7050700001 37.7197215370907 -122.468315017932 (37.7197215370907, -122.468315017932)
175791 220665 2 42 215 Webster St 1 4 1 1     7 Width 3ft   6004174.507619999 2109590.46036 37.7727694393 -122.42897431622801 (37.7727694393, -122.428974316228)
183876 246998 2 42 33 Clipper St 1 4 1 1     10 Width 4ft   6004927.947919999 2101037.11705 37.7493266028416 -122.42575916347602 (37.7493266028416, -122.425759163476)
24270 188526 3 42 1427x Innes Ave 12 3 1 2     13     6016254.90623 2096663.3838099998 37.7379507994938 -122.386285047323 (37.7379507994938, -122.386285047323)
169840 188527 3 42 1427x Innes Ave 30 3 1 2     15     6016131.12478 2096760.51066 37.7382106379019 -122.386719795784 (37.7382106379019, -122.386719795784)
30672 220054 2 42 300 Virginia Ave 5 2 1 1     6 Width 3ft   6006920.61613 2098340.82095 37.742035584087795 -122.418677274846 (37.7420355840878, -122.418677274846)
38639 174959 2 42 103 De Long St 1 2 1 1     6 Width 10ft   5994397.11424 2086788.06602 37.709601466104104 -122.461142043293 (37.7096014661041, -122.461142043293)
48501 188519 2 42 1451 Rhode Island St 3 2 1 1     13     6012046.50101 2101636.39558 37.7513717861857 -122.401185012303 (37.7513717861857, -122.401185012303)
62900 203646 2 42 45 Dorantes Ave 2 2 1 1     7 Width 3ft   5994072.18954 2100047.28757 37.745989350944 -122.463226505408 (37.745989350944, -122.463226505408)
65658 183506 2 42 2542 27th Ave 2 2 1 1     6 Width 0ft   5988021.6131 2097993.9577 37.7400010259161 -122.483997786352 (37.7400010259161, -122.483997786352)
133071 203620 2 42 358 Pacheco St 2 2 1 1     7 Width 3ft   5994207.97815 2101247.70705 37.7492932209146 -122.46284404261101 (37.7492932209146, -122.462844042611)
156503 174960 2 42 103 De Long St 2 2 1 1     6 Width 10ft   5994409.5991400005 2086788.1181299998 37.709602327657706 -122.461098897396 (37.7096023276577, -122.461098897396)
179698 218406 2 42 225 Castenada Ave 4 2 1 1     6 Width 0ft   5994236.919980001 2100511.7669599997 37.7472741826649 -122.462690582315 (37.7472741826649, -122.462690582315)
117 220007 3 42 929 Valencia St 1 1 1 2   09/12/2015 03:22:00 PM 1 Width 3ft Permit Number 24134 6006336.25046 2104153.4311599997 37.7579627654961 -122.421110461684 (37.7579627654961, -122.421110461684)
371 8188 1 42 1272 Fulton St 1 1 1 1   09/19/1997 12:00:00 AM 10 3X4   6001679.2828 2111174.9406 37.7769784708042 -122.437719062833 (37.7769784708042, -122.437719062833)
1362 36186 1 42 133 Palm Ave 1 1 1 1 1 05/04/1998 12:00:00 AM 8   Permit Number 39255 5995881.41756 2113499.8369 37.783030646722004 -122.45794382331002 (37.783030646722, -122.45794382331)
1434 20063 3 42 100 STAIRWAY54 10 1 1 2     6 15ST            
1536 251472 2 42 11 Hiliritas Ave 1 1 1 1   05/22/2017 12:00:00 AM 3 3x3 Permit Number 780012 6001589.0 2096875.0 37.7377091611847 -122.437007355935 (37.7377091611847, -122.437007355935)
1815 71427 2 42 1852 Stockton St 1 1 1 1 1 06/06/2017 12:00:00 AM 3 4x4   6009993.7542 2120480.0499 37.802997311571104 -122.409613538987 (37.8029973115711, -122.409613538987)
2164 10688 3 42 1221 Hayes St 1 1 1 2   11/18/1991 12:00:00 AM 6 3X3   6002001.6656 2110480.73 37.7750906677438 -122.43655414222 (37.7750906677438, -122.43655414222)
2515 124752 1 42 2478 Sacramento St 1 1 1 1   11/26/2002 12:00:00 AM 9 Width 5ft   6002956.6534 2115870.86114 37.7899448329366 -122.433635939447 (37.7899448329366, -122.433635939447)
2637 37816 3 42 450X Moscow St 4 1 1 4 2 07/07/1998 12:00:00 AM 8 3x3 Permit Number 40134 6003955.6668300005 2090537.19552 37.720441203374 -122.428373060073 (37.720441203374, -122.428373060073)
2852 215287 2 42 335 Noriega St 1 1 1 1     12 Width 3ft Permit Number 780412 5992944.71929 2103190.50616 37.7545548052666 -122.46735363008301 (37.7545548052666, -122.467353630083)
3060 203634 1 42 432 Flood Ave 3 1 1 1   06/23/2000 12:00:00 AM 11 Width 2ft Permit Number 42544 5997859.0322900005 2094116.10367 37.7299211747225 -122.449704832412 (37.7299211747225, -122.449704832412)
3716 20054 3 42 100 STAIRWAY54 1 1 1 2     6 15ST            
3793 39226 1 42 770 36th Ave 1 1 1 1   12/04/1998 12:00:00 AM 9   Permit Number 40869 5984798.64138 2110605.0729799997 37.774439483359 -122.49607147975 (37.774439483359, -122.49607147975)
4165 253615 1 42 2325 Polk St 1 1 1 1   02/17/1998 12:00:00 AM   3x3 Permit Number 38749 6006221.0 2118816.0 37.7982161239914 -122.422550935399 (37.7982161239914, -122.422550935399)
5340 30595 1 42 265 Walter St 2 1 1 1   01/26/1995 12:00:00 AM     Permit Number 34562          
5792 10690 1 42 1233 Hayes St 1 1 1 1     6 3X3   6001959.267000001 2110474.8139 37.7750720141838 -122.43670038449801 (37.7750720141838, -122.436700384498)
5920 139500 2 42 748 CENTRAL AVE 1 1 1 1       Width 0ft   5999620.0523 2111133.4316 37.776747194618395 -122.44483956661199 (37.7767471946184, -122.444839566612)
6724 102771 2 42 1438 Filbert St 1 1 1 1     8 3x3   6006063.66154 2119354.00796 37.7996844799161 -122.42313363592501 (37.7996844799161, -122.423133635925)
6851 20056 3 42 100 STAIRWAY54 3 1 1 2     6 15ST            
7439 19729 3 42 100 STAIRWAY14 7 1 1 2     6 40ST            
Powered by Datasette · Query took 11.701ms · Data source: data.sfgov.org