sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
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)
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)
41668 203664 2 42 123 Detroit St 1 1 1 1     6 Width 2ft   5999403.203369999 2093610.5277599997 37.7286212055976 -122.444330150233 (37.7286212055976, -122.444330150233)
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)
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)
41964 246075 2 42 635 Clayton St 1 1 1 1     12 Width 0ft   5998492.5621 2108432.0423 37.7692654626532 -122.44854527514299 (37.7692654626532, -122.448545275143)
42028 188510 2 42 101 Pennsylvania Ave 25 7 1 1     2     6014318.1653 2106535.6894400003 37.76495065967789 -122.39367214607401 (37.7649506596779, -122.393672146074)
42347 203665 2 42 123 Detroit St 3 1 1 1     8 Width 2ft   5999403.44951 2093584.38933 37.728549449599704 -122.444327421686 (37.7285494495997, -122.444327421686)
42359 138339 2 42 2250 Sutter St 3 1 1 1     7 Width 0ft   6001909.1348 2114331.7204 37.7856592553419 -122.437150009777 (37.7856592553419, -122.437150009777)
42523 220064 2 42 4086 23rd St 1 1 1 1     10 Width 3ft   6002590.76073 2102413.7777400003 37.7529742368948 -122.43393958746701 (37.7529742368948, -122.433939587467)
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)
42577 139655 2 42 848 BAKER ST 2 1 1 1     11 Width 0ft   6000491.15 2111934.8144 37.7789972619427 -122.441883720544 (37.7789972619427, -122.441883720544)
43321 220677 2 42 3625 20th St 1 1 1 1     7 Width 3ft   6006108.91147 2104316.6789599997 37.758398187543996 -122.42190829343399 (37.758398187544, -122.421908293434)
43667 203624 2 42 15 Teresita Blvd 3 1 1 1     1 Width 3ft   5997319.6106 2099609.0427 37.7449725828299 -122.45196580449199 (37.7449725828299, -122.451965804492)
44083 32557 1 42 3822 22nd St 1 1 1 1   10/22/1996 12:00:00 AM     Permit Number 770192 6002956.41958884 2103022.59282687 37.7546666427143 -122.43271855723499 (37.7546666427143, -122.432718557235)
44341 220066 2 42 1109 Castro St 1 1 1 1     8 Width 3ft   6002537.114630001 2102291.1496200003 37.7526344847082 -122.434116340213 (37.7526344847082, -122.434116340213)
44479 220686 2 42 430 Hickory St 1 1 1 1     8 Width 3ft   6004903.16789 2110400.7033700002 37.775035387294295 -122.426511501216 (37.7750353872943, -122.426511501216)
45030 220037 2 42 4263 26th St 1 1 1 1     10 Width 4ft   6002187.26734 2100592.3557700003 37.74795013829029 -122.43520467366301 (37.7479501382903, -122.435204673663)
45041 188518 2 42 805 Vermont St 1 1 1 1     6 Width 3ft   6011322.68807 2104548.86682 37.75932838242 -122.403892982475 (37.75932838242, -122.403892982475)
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)
45153 140717 2 42 556 SCOTT ST 2 1 1 1     7 Width 0ft   6002162.097 2110427.6982 37.774954171002 -122.43599537996201 (37.774954171002, -122.435995379962)
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)
45254 220074 2 42 148 Hartford St 1 1 1 1     3 Width 3ft   6002660.22221 2105037.36162 37.7601819118789 -122.43388688897 (37.7601819118789, -122.43388688897)
45390 220087 2 42 69 Diamond St 1 1 1 1     8 Width 3ft   6001718.50654 2105457.8427 37.7612829653482 -122.437173938027 (37.7612829653482, -122.437173938027)
45531 220666 2 42 1 Dorland St 3 1 1 1     8 Width 3ft   6005487.19676 2105743.72088 37.7622814268651 -122.42415994852199 (37.7622814268651, -122.424159948522)
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)
47068 220057 2 42 938 Shotwell St 1 1 1 1     8 Width 3ft   6007984.69118 2102236.05472 37.752790875909 -122.41527371052099 (37.752790875909, -122.415273710521)
47075 220067 2 42 3781 21st St 1 1 1 1     7 Width 3ft   6003185.70208 2103572.60316 37.756189841101296 -122.431964909158 (37.7561898411013, -122.431964909158)
47237 220016 2 42 70 Quartz Way 1 1 1 1     4 Width 3ft   5998965.77386 2099787.09557 37.74555562500829 -122.44628649854201 (37.7455556250083, -122.446286498542)
47618 220674 2 42 3548 19th St 1 1 1 1     5 Width 3ft   6005923.11971 2104936.6524900002 37.760090010159104 -122.42259489975201 (37.7600900101591, -122.422594899752)
47710 44248 1 42 1960 Jefferson St 1 1 1 1   01/31/2001 12:00:00 AM 8   Permit Number 43683 5999863.264769999 2121264.87303 37.8045793513217 -122.44472662894199 (37.8045793513217, -122.444726628942)
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)
47962 219999 2 42 62 Santa Marina St 1 1 1 1     8 Width 3ft   6005999.49716 2097639.92479 37.740059177277004 -122.421812441905 (37.740059177277, -122.421812441905)
48265 220667 2 42 1337 Natoma St 1 1 1 1     9 Width 2ft   6007176.0273400005 2107716.44116 37.767793265562894 -122.41845879174801 (37.7677932655629, -122.418458791748)
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)
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)
48563 117040 2 42 2220x SUTTER ST 8 1 1 1       3x3   6001781.0 2114465.0 37.786017922595605 -122.437602866759 (37.7860179225956, -122.437602866759)
48670 220058 2 42 564 Shotwell St 1 1 1 1     12 Width 3ft   6007852.78726 2104670.9495900003 37.7594691272161 -122.415902267384 (37.7594691272161, -122.415902267384)
49170 220036 2 42 1711 Castro St 2 1 1 1     11 Width 3ft   6002636.29383 2100481.40221 37.747670974341396 -122.43364403244 (37.7476709743414, -122.43364403244)
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)
49864 203621 2 42 21 Juanita Way 1 1 1 1     2 Width 2ft   5997303.382119999 2099336.74248 37.7442239835511 -122.452002277389 (37.7442239835511, -122.452002277389)
50057 220672 2 42 25 Cumberland St 1 1 1 1     1 Width 3ft   6005444.88154 2104573.79472 37.759066695887 -122.42422309172701 (37.759066695887, -122.424223091727)
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)
50333 220053 2 42 50 Coleridge St 1 1 1 1     6 Width 3ft   6006880.915569999 2099461.25928 37.7451098211639 -122.418893994368 (37.7451098211639, -122.418893994368)
50765 244169 2 42 1752 Page St 1 1 1 1     10 Width 0ft   5998187.9203 2108956.9743 37.7706893684237 -122.449636842472 (37.7706893684237, -122.449636842472)
51056 203627 2 42 133 Maywood Dr 1 1 1 1     11 Width 2ft   5994260.237269999 2095673.9858 37.7339921852793 -122.462259143365 (37.7339921852793, -122.462259143365)
51120 66858 1 42 103 Ashbury St 1 1 1 1   11/15/1991 12:00:00 AM 9   Permit Number 30164 5998644.5770000005 2110362.2819 37.774574098301294 -122.448158471707 (37.7745740983013, -122.448158471707)
51454 44091 1 42 807 Vermont St 1 1 1 1   11/01/2000 12:00:00 AM 6   Permit Number 43606 6011323.913930001 2104520.92035 37.759251716121796 -122.40388677626001 (37.7592517161218, -122.40388677626)
52495 220079 2 42 4021 20th St 2 1 1 1     2 Width 3ft   6003566.56829 2104171.42308 37.7578556427516 -122.43069047448799 (37.7578556427516, -122.430690474488)
53450 220065 2 42 561 Elizabeth St 1 1 1 1     3 Width 3ft   6002722.15364 2102085.17478 37.7520794267235 -122.43346172547501 (37.7520794267235, -122.433461725475)
53649 219989 2 42 936 Clayton St 2 1 1 1     5 Width 3ft   5998793.85425 2106724.38466 37.7645938887298 -122.447380197361 (37.7645938887298, -122.447380197361)
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)
53685 220687 2 42 430 Hickory St 2 1 1 1     12 Width 3ft   6004894.475319999 2110399.44382 37.775031437471704 -122.426541481018 (37.7750314374717, -122.426541481018)
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)
53977 220014 2 42 60 Elizabeth St 1 1 1 1     13 Width 3ft   6005833.61465 2102298.65201 37.7528416246662 -122.422716983617 (37.7528416246662, -122.422716983617)
54206 220691 2 42 455 28th St 1 1 1 1     6 Width 2ft   6002941.274019999 2099459.3166400003 37.7448818664203 -122.432516435499 (37.7448818664203, -122.432516435499)
54226 137665 2 42 1901 GOLDEN GATE AVE 2 1 1 1     7 Width 0ft   6000382.7272 2111637.7254 37.778175352566 -122.44223746490101 (37.778175352566, -122.442237464901)
54358 219993 2 42 101 Prospect Ave 3 10 1 1     13     6006993.27252 2098944.7494 37.7436979269164 -122.418468865069 (37.7436979269164, -122.418468865069)
54361 203635 2 42 418 Flood Ave 2 1 1 1     10 Width 2ft   5997950.41926 2094116.13567 37.7299264906077 -122.44938890058201 (37.7299264906077, -122.449388900582)
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)
55582 220093 2 42 1754 Sanchez St 1 1 1 1     10 Width 3ft   6003963.29373 2098007.80301 37.7409542473406 -122.428879018678 (37.7409542473406, -122.428879018678)
55738 188509 2 42 101 Pennsylvania Ave 12 7 1 1     2     6014325.646980001 2106424.64729 37.7646461780098 -122.393638496141 (37.7646461780098, -122.393638496141)
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)
56967 92754 1 42 880 Peru Ave 1 1 1 1   10/08/2009 12:00:00 AM 6 3x3 Permit Number 52983 6005536.79298 2091854.05704 37.724146362548204 -122.423001157676 (37.7241463625482, -122.423001157676)
57888 220056 2 42 1424 Alabama St 1 1 1 1     12 Width 4ft   6009277.433730001 2100868.30065 37.7491078976199 -122.410706569176 (37.7491078976199, -122.410706569176)
58064 220047 2 42 1201 Shrader St 1 1 1 1     13 Width 3ft   5997716.00381 2106428.96316 37.7637210849721 -122.451086869165 (37.7637210849721, -122.451086869165)
58566 220089 2 42 101 Ord Ct 1 1 1 1     7 Width 2ft   6000884.7117 2105729.84303 37.7619823797984 -122.44007717983101 (37.7619823797984, -122.440077179831)
58569 174964 2 42 1645 Felton St 1 1 1 1     5 Width 2ft   6006075.21093 2092385.5914900003 37.7256362082245 -122.421177650028 (37.7256362082245, -122.421177650028)
58771 220011 2 42 110 San Jose Ave 1 1 1 1     8 Width 3ft   6006153.26604 2102345.16587 37.7529873705964 -122.421614871629 (37.7529873705964, -122.421614871629)
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)
59933 220069 2 42 1047 Sanchez St 1 1 1 1     10 Width 3ft   6003827.33604 2102174.6628400004 37.7523877808826 -122.42964622220501 (37.7523877808826, -122.429646222205)
60147 220040 2 42 816 Alvarado St 1 1 1 1     8 Width 4ft   6001002.40026 2102614.77247 37.7534358534934 -122.439446835117 (37.7534358534934, -122.439446835117)
60228 245868 2 42 415 Laguna St 1 1 1 1     6 Width 0ft   6005026.3603 2110433.2652 37.775131757595204 -122.42608767011801 (37.7751317575952, -122.426087670118)
60414 188512 2 42 101 Pennsylvania Ave 41 7 1 1     5     6014229.234019999 2106696.64866 37.7653876762377 -122.393991007905 (37.7653876762377, -122.393991007905)
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)
60577 245840 2 42 421 Laguna St 1 1 1 1     5 Width 0ft   6005021.78 2110481.0306 37.775262650872 -122.42610691556601 (37.775262650872, -122.426106915566)
61286 203225 2 42 1575 07th Ave 1 1 1 1     9 Width 2ft   5993973.71625 2104850.02282 37.759170760036994 -122.463915566851 (37.759170760037, -122.463915566851)
61594 203663 2 42 271 Staples Ave 1 1 1 1     9 Width 2ft   5998288.8054599995 2093783.09686 37.7290313953773 -122.44819509282699 (37.7290313953773, -122.448195092827)
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)
61990 140718 2 42 556 SCOTT ST 3 1 1 1     12 Width 0ft   6002160.0013 2110449.3533 37.7750135114472 -122.436004179308 (37.7750135114472, -122.436004179308)
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)
62430 246034 2 42 618 Clayton St 1 1 1 1     4 Width 0ft   5998524.9649 2108501.9958 37.7694593898353 -122.44843823441002 (37.7694593898353, -122.44843823441)
62851 203648 2 42 1907 09th Ave 1 1 1 1     6 Width 3ft   5993437.25696 2102479.71785 37.7526315852957 -122.46559868313 (37.7526315852957, -122.46559868313)
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)
63361 220063 2 42 930 Noe St 1 1 1 1     7 Width 3ft   6003095.90411 2102839.48353 37.75417177772871 -122.432223106309 (37.7541717777287, -122.432223106309)
63850 138348 2 42 2499 Bush St 1 1 1 1     6 Width 0ft   6001613.9728 2114589.4995 37.786350268304 -122.43818965646001 (37.786350268304, -122.43818965646)
64130 248395 2 42 1655 Waller St 1 1 1 1     8 Width 0ft   5997659.0251 2108142.2349 37.768422030688896 -122.451407517669 (37.7684220306889, -122.451407517669)
64167 203628 2 42 133 Maywood Dr 2 1 1 1     3 Width 2ft   5994258.53071 2095683.80268 37.734019041749 -122.46226575516701 (37.734019041749, -122.462265755167)
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)
65145 124758 2 42 1513 Jackson St 1 1 1 1     7 Width 3ft   6006956.23003 2117363.82528 37.79427026621129 -122.419903713582 (37.7942702662113, -122.419903713582)
65413 137613 2 42 1502 MCALLISTER ST 1 1 1 1     8 Width 0ft   6001914.7987 2111556.8609 37.778040516588604 -122.436931690487 (37.7780405165886, -122.436931690487)
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)
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)
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)
67640 220077 2 42 4160 20th St 1 1 1 1     11 Width 3ft   6002637.75275 2104169.9909900003 37.7577990456928 -122.433902601035 (37.7577990456928, -122.433902601035)
67828 219994 2 42 49 Elsie St 1 1 1 1     1 Width 3ft   6007506.429690001 2099145.6461 37.7442784195283 -122.41670871553801 (37.7442784195283, -122.416708715538)
67963 220015 2 42 70 Quartz Way 2 1 1 1     4 Width 3ft   5998973.5201 2099794.49518 37.745576384946 -122.44626024553601 (37.745576384946, -122.446260245536)
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)
68651 220688 2 42 434 Hickory St 1 1 1 1     12 Width 3ft   6004866.02058 2110397.15298 37.7750235387365 -122.426639749043 (37.7750235387365, -122.426639749043)
68717 203626 2 42 12 Juanita Way 1 1 1 1     7 Width 2ft   5997325.36011 2099393.7124400004 37.7443816679834 -122.451930391889 (37.7443816679834, -122.451930391889)
68889 220068 2 42 3749 21st St 1 1 1 1     3 Width 3ft   6003417.1638 2103582.09113 37.756229011985 -122.43116511330601 (37.756229011985, -122.431165113306)
Powered by Datasette · Query took 7.221ms · Data source: data.sfgov.org