sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
60414 188512 2 42 101 Pennsylvania Ave 41 7 1 1     5     6014229.234019999 2106696.64866 37.7653876762377 -122.393991007905 (37.7653876762377, -122.393991007905)
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)
177773 188511 2 42 101 Pennsylvania Ave 33 7 1 1     2     6014272.76615 2106665.73514 37.7653052137955 -122.393838275126 (37.7653052137955, -122.393838275126)
169840 188527 3 42 1427x Innes Ave 30 3 1 2     15     6016131.12478 2096760.51066 37.7382106379019 -122.386719795784 (37.7382106379019, -122.386719795784)
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)
178617 188524 2 42 65 Whitney Young Cir 27 1 1 1     12 Width 3ft   6017319.36932 2094988.95682 37.7334120182438 -122.38248816719299 (37.7334120182438, -122.382488167193)
187683 188523 2 42 65 Whitney Young Cir 26 1 1 1     10 Width 3ft   6017281.36531 2094970.41702 37.733359012210606 -122.382618269437 (37.7333590122106, -122.382618269437)
41095 220673 2 42 100 Alemany Blvd 25 1 1 1     12 Width 3ft   6009345.21028 2095878.12902 37.735409776738294 -122.410119940478 (37.7354097767383, -122.410119940478)
42028 188510 2 42 101 Pennsylvania Ave 25 7 1 1     2     6014318.1653 2106535.6894400003 37.76495065967789 -122.39367214607401 (37.7649506596779, -122.393672146074)
60547 184904 2 42 1990 41st Ave 23 1 1 1     7 Width 0ft   5983548.4855 2101753.1406 37.7500612779998 -122.499741544392 (37.7500612779998, -122.499741544392)
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)
45099 184964 2 42 1990 41st Ave 22 1 1 1     8 Width 0ft   5983545.7781 2101731.1432 37.7500007203614 -122.499749280915 (37.7500007203614, -122.499749280915)
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)
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)
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)
33826 184961 2 42 1990 41st Ave 19 1 1 1     8 Width 0ft   5983548.8239 2101628.2630000003 37.7497184185455 -122.4997311455 (37.7497184185455, -122.4997311455)
112048 116664 3 42 199x Esmeralda Ave 18 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
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)
10291 19793 3 42 100 STAIRWAY19 15 1 1 2     6 20ST            
78948 37828 3 42 450X Moscow St 15 1 1 4 2 06/22/2006 12:00:00 AM 8 3x3 Permit Number 48867 6003752.0 2090699.0 37.720873955994 -122.42908860130501 (37.720873955994, -122.429088601305)
107642 24822 1 42 400X Alemany Blvd 14 1 1 1   03/03/2006 12:00:00 AM 3 3x3   6007873.98451 2094939.34624 37.732749510625 -122.41514010253701 (37.732749510625, -122.415140102537)
175294 141632 2 42 1801 GROVE ST 14 1 1 1     7 Width 0ft   5999054.1432 2110418.5587 37.7747520248793 -122.446745757486 (37.7747520248793, -122.446745757486)
21499 24820 1 42 400X Alemany Blvd 12 1 1 5   05/22/2008 12:00:00 AM 12 3x3   6007910.58435 2094958.48618 37.732804121515606 -122.415014921609 (37.7328041215156, -122.415014921609)
24270 188526 3 42 1427x Innes Ave 12 3 1 2     13     6016254.90623 2096663.3838099998 37.7379507994938 -122.386285047323 (37.7379507994938, -122.386285047323)
25501 141630 2 42 1801 GROVE ST 12 1 1 1     8 Width 0ft   5999025.3732 2110414.9246 37.774740403045996 -122.446845016858 (37.774740403046, -122.446845016858)
55738 188509 2 42 101 Pennsylvania Ave 12 7 1 1     2     6014325.646980001 2106424.64729 37.7646461780098 -122.393638496141 (37.7646461780098, -122.393638496141)
62065 188522 2 42 65 Whitney Young Cir 12 1 1 1     12 Width 4ft   6016938.13191 2094902.8329099999 37.7331544721811 -122.38380023041701 (37.7331544721811, -122.383800230417)
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)
99995 103895 1 42 1750 Fulton St 12 1 1 1       3x3   5999354.6 2110868.3 37.7760040584969 -122.44573877005101 (37.7760040584969, -122.445738770051)
16172 20064 3 42 100 STAIRWAY54 11 1 1 2     6 15ST            
81411 24833 1 42 200X Alemany Blvd 11 1 1 5   01/12/1996 12:00:00 AM 25 3X3   6009416.6826304 2095906.0445619 37.735490432624104 -122.409874802768 (37.7354904326241, -122.409874802768)
93890 98217 3 42 1501X 42nd Ave 11 1 1 10 6   5 3x25   5982958.4 2104692.7 37.758097840563 -122.50199954491 (37.758097840563, -122.50199954491)
104489 37824 3 42 450X Moscow St 11 1 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)
108074 103894 1 42 1750 Fulton St 11 1 1 1       3x3   5999354.6 2110868.3 37.7760040584969 -122.44573877005101 (37.7760040584969, -122.445738770051)
108432 24819 3 42 400X Alemany Blvd 11 1 1 2   04/09/2001 12:00:00 AM 18 3x3   6007950.68171 2094974.0594400002 37.7328491354706 -122.41487739629801 (37.7328491354706, -122.414877396298)
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)
1434 20063 3 42 100 STAIRWAY54 10 1 1 2     6 15ST            
41788 138778 2 42 2250 Sutter St 10 1 1 1     1 Width 0ft   6001713.8653 2114306.3395 37.785578464198 -122.437823766308 (37.785578464198, -122.437823766308)
55440 138357 2 42 2499 Bush St 10 1 1 1     7 Width 0ft   6001830.9567 2114618.7351 37.7864428800724 -122.437441043234 (37.7864428800724, -122.437441043234)
128352 117042 2 42 2220x SUTTER ST 10 1 1 1       3x3   6001781.0 2114465.0 37.786017922595605 -122.437602866759 (37.7860179225956, -122.437602866759)
175370 103893 1 42 1750 Fulton St 10 1 1 1     8 3x3   5999294.1521 2110847.1267 37.7759424705585 -122.445946351246 (37.7759424705585, -122.445946351246)
15394 20062 3 42 100 STAIRWAY54 9 1 1 2     6 15ST            
38222 103892 1 42 1750 Fulton St 9 1 1 1     10 3x3   5999308.7043 2110849.4957 37.7759498061666 -122.44589618201 (37.7759498061666, -122.44589618201)
128456 49579 1 42 400REVISED Alemany Blvd 9 1 1 1   05/29/2003 12:00:00 AM     Permit Number 46462 6008204.64175087 2095122.01632245 37.7332696598424 -122.414009852171 (37.7332696598424, -122.414009852171)
15210 20061 3 42 100 STAIRWAY54 8 1 1 2     12 15ST            
48563 117040 2 42 2220x SUTTER ST 8 1 1 1       3x3   6001781.0 2114465.0 37.786017922595605 -122.437602866759 (37.7860179225956, -122.437602866759)
50236 103891 1 42 1750 Fulton St 8 1 1 1     9 3x3   5999322.5796 2110851.5262 37.7759561736689 -122.445848329979 (37.7759561736689, -122.445848329979)
109529 49577 1 42 400REVISED Alemany Blvd 8 1 1 1   05/29/2003 12:00:00 AM     Permit Number 46462 6008204.64175087 2095122.01632245 37.7332696598424 -122.414009852171 (37.7332696598424, -122.414009852171)
180380 203655 2 42 230 Edna St 8 17 1 1     12     5998797.91036 2095380.6148 37.7334468948521 -122.446549972903 (37.7334468948521, -122.446549972903)
187692 138344 2 42 2250 Sutter St 8 1 1 1     9 Width 0ft   6001758.896000001 2114311.2519 37.785594512870205 -122.43766832543301 (37.7855945128702, -122.437668325433)
7439 19729 3 42 100 STAIRWAY14 7 1 1 2     6 40ST            
7770 20060 3 42 100 STAIRWAY54 7 1 1 2     12 15ST            
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)
110361 29224 3 42 1902X 41st Ave 7 1 1 2     6 3X3   5983534.517682901 2102185.1808128003 37.7512467209802 -122.499821775189 (37.7512467209802, -122.499821775189)
122865 49581 1 42 400REVISED Alemany Blvd 7 1 1 1   05/29/2003 12:00:00 AM     Permit Number 46462 6008204.64175087 2095122.01632245 37.7332696598424 -122.414009852171 (37.7332696598424, -122.414009852171)
185661 124762 2 42 1055 Greenwich St 7 1 1 1     10 Width 3ft   6007906.12641 2119914.20021 37.8013264288216 -122.416797725058 (37.8013264288216, -122.416797725058)
188390 103890 1 42 1750 Fulton St 7 1 1 1     13 3x3   5999343.5617 2110855.9257 37.7759694515949 -122.445776064165 (37.7759694515949, -122.445776064165)
12807 17229 3 42 1880X Alemany Blvd 6 1 1 2     14 3X3   6000980.939130001 2091103.3398799999 37.7218269300432 -122.438696258244 (37.7218269300432, -122.438696258244)
16839 20059 3 42 100 STAIRWAY54 6 1 1 2     12 15ST            
45939 138342 2 42 2250 Sutter St 6 1 1 1     8 Width 0ft   6001808.8392 2114319.4393 37.7856198329437 -122.437496123305 (37.7856198329437, -122.437496123305)
64612 103889 1 42 1750 Fulton St 6 1 1 1     7 3x3   5999356.4217 2110857.6178 37.7759748319201 -122.44573169994499 (37.7759748319201, -122.445731699945)
92157 29223 3 42 1902X 41st Ave 6 1 1 2     6 3X3   5983534.517682901 2102185.1808128003 37.7512467209802 -122.499821775189 (37.7512467209802, -122.499821775189)
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)
108705 49578 1 42 400REVISED Alemany Blvd 6 1 1 1   05/29/2003 12:00:00 AM     Permit Number 46462 6008204.64175087 2095122.01632245 37.7332696598424 -122.414009852171 (37.7332696598424, -122.414009852171)
143492 117038 2 42 2220x SUTTER ST 6 1 1 1       3x3   6001781.0 2114465.0 37.786017922595605 -122.437602866759 (37.7860179225956, -122.437602866759)
188012 138353 2 42 2499 Bush St 6 1 1 1     9 Width 0ft   6001742.4732 2114607.6747 37.786407480206705 -122.43774638091499 (37.7864074802067, -122.437746380915)
22043 859 3 42 400X Alemany Blvd 5 1 1 2     16 3x3   6008091.178180001 2095049.40427 37.7330639095777 -122.41439699202299 (37.7330639095777, -122.414396992023)
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)
30832 203666 2 42 123 Detroit St 5 1 1 1     9 Width 2ft   5999405.93855 2093561.74161 37.728487406244604 -122.44431719010001 (37.7284874062446, -122.4443171901)
49836 103888 1 42 1750 Fulton St 5 1 1 1     11 3x3   5999371.6507 2110859.3099 37.775980347483504 -122.44567914075701 (37.7759803474835, -122.445679140757)
53857 220052 2 42 50 Coleridge St 5 1 1 1     5 Width 3ft   6006851.995619999 2099403.94647 37.7449508246175 -122.418989930439 (37.7449508246175, -122.418989930439)
65727 19285 3 42 1770 Scott St 5 1 1 2   06/01/1998 12:00:00 AM 11 3X3   6001619.01622 2114490.46983 37.786078645055 -122.43816511087601 (37.786078645055, -122.438165110876)
70197 138347 2 42 1770 SCOTT ST 5 1 1 1     11 Width 0ft   6001586.1357 2114554.9139 37.786253721877706 -122.438283486898 (37.7862537218777, -122.438283486898)
78530 42106 1 42 305 Hearst Ave 5 1 1 1 1 06/21/2000 12:00:00 AM     Permit Number 42409 5999382.77994639 2094344.80390055 37.730636191213996 -122.444453504412 (37.730636191214, -122.444453504412)
81412 39503 1 42 216 Jersey St 5 1 1 1 1 12/28/1998 12:00:00 AM     Permit Number 40959 6003716.05884842 2101601.85489178 37.7508086831914 -122.42999018002399 (37.7508086831914, -122.429990180024)
90886 42110 1 42 100@ Detroit Judson Ave 5 1 1 1 1 06/21/2000 12:00:00 AM     Permit Number 42411 5999403.96940848 2093509.81726433 37.7283447217324 -122.444320267584 (37.7283447217324, -122.444320267584)
103765 75790 2 42 2080 FOLSOM ST 5 1 1 3   03/15/1997 12:00:00 AM   3x3   6008075.0 2106289.0 37.763924410887206 -122.41524828442499 (37.7639244108872, -122.415248284425)
107521 49582 1 42 400REVISED Alemany Blvd 5 1 1 1   05/29/2003 12:00:00 AM     Permit Number 46462 6008204.64175087 2095122.01632245 37.7332696598424 -122.414009852171 (37.7332696598424, -122.414009852171)
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)
107835 32345 1 42 1201 35th Ave 5 1 1 1 1 10/23/1996 12:00:00 AM     Permit Number 37068 5985179.95256355 2107022.76154853 37.7646257968319 -122.494488338591 (37.7646257968319, -122.494488338591)
112271 50471 1 42 3010X Lyon St 5 1 1 1   10/21/2003 12:00:00 AM 5 3x3 Permit Number 47106 5999184.20401146 2119093.85477845 37.798579545974704 -122.446920252577 (37.7985795459747, -122.446920252577)
140001 50664 1 42 1 Santa Ynez Ave 5 1 1 1         Permit Number 47244 6000978.87890111 2091807.60057831 37.723760552916296 -122.43875382021002 (37.7237605529163, -122.43875382021)
150574 138352 2 42 2499 Bush St 5 1 1 1     4 Width 0ft   6001715.4366 2114603.3734 37.78639413258121 -122.437839612353 (37.7863941325812, -122.437839612353)
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)
184876 203227 2 42 1575 07th Ave 5 1 1 1     10 Width 2ft   5993976.11047 2104705.81134 37.7587749306244 -122.463896818706 (37.7587749306244, -122.463896818706)
188982 220022 2 42 1334 Diamond St 5 1 1 1     8 Width 3ft   6001965.3710900005 2100066.86744 37.746494668288996 -122.435934385359 (37.746494668289, -122.435934385359)
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)
11185 20057 3 42 100 STAIRWAY54 4 1 1 2     6 15ST            
16814 105175 2 42 1601X Newcomb Ave 4 1 1 19     10 3x3   6015153.3918 2095715.6028 37.735287354242395 -122.390027366589 (37.7352873542424, -122.390027366589)
23355 76748 3 42 1501X 42nd Ave 4 1 1 4 2 05/14/1994 12:00:00 AM 7 3x12   5983093.5463 2104693.1195 37.7581069307926 -122.501532189631 (37.7581069307926, -122.501532189631)
25195 203226 2 42 1575 07th Ave 4 1 1 1     11 Width 2ft   5993976.59011 2104728.66377 37.7588377051234 -122.463896818678 (37.7588377051234, -122.463896818678)
27735 38051 1 42 2700 Bush St 4 1 1 1 1 07/10/1998 12:00:00 AM 0   Permit Number 40248 6000571.40891222 2114495.1875696997 37.786031962456896 -122.44178988005899 (37.7860319624569, -122.441789880059)
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)
48557 50472 1 42 3010X Lyon St 4 1 1 1   10/21/2003 12:00:00 AM 5 3x3 Permit Number 47106 5999184.20401146 2119093.85477845 37.798579545974704 -122.446920252577 (37.7985795459747, -122.446920252577)
56688 122010 2 42 1342 Cabrillo St 4 1 1 1     10 Width 3ft   5991362.52356 2110673.50037 37.775009640229605 -122.473370979732 (37.7750096402296, -122.473370979732)
59298 203625 2 42 15 Teresita Blvd 4 1 1 1     2 Width 3ft   5997311.4729 2099621.76413 37.7450070466421 -122.45199486067499 (37.7450070466421, -122.451994860675)
61827 138346 2 42 1770 SCOTT ST 4 1 1 1     8 Width 0ft   6001590.3534 2114514.4235 37.7861427855089 -122.438265993007 (37.7861427855089, -122.438265993007)
70529 138351 2 42 2499 Bush St 4 1 1 1     7 Width 0ft   6001690.7359 2114600.4656 37.786384743909295 -122.437924862001 (37.7863847439093, -122.437924862001)
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)
74967 124761 2 42 1055 Greenwich St 4 1 1 1     10 Width 3ft   6007856.93229 2119906.6476 37.8013029241584 -122.41696742351101 (37.8013029241584, -122.416967423511)
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)
Powered by Datasette · Query took 10.2ms · Data source: data.sfgov.org