sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
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)
55462 113717 1 42 1342 Cabrillo St 2 1 1 1 1   12     5991400.52029 2110673.00421 37.775010478076794 -122.47323950591299 (37.7750104780768, -122.473239505913)
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)
55604 35336 1 42 2311 19th St 1 1 1 1 1 10/12/2005 12:00:00 AM 1   Permit Number 48271 6010839.4517 2105063.96093 37.7607157062843 -122.40560053693501 (37.7607157062843, -122.405600536935)
55738 188509 2 42 101 Pennsylvania Ave 12 7 1 1     2     6014325.646980001 2106424.64729 37.7646461780098 -122.393638496141 (37.7646461780098, -122.393638496141)
55919 31468 1 42 523 Elizabeth St 1 1 1 1 1 05/01/1995 12:00:00 AM 9   Permit Number 35034 6002955.92893 2102097.8639599998 37.752127528763204 -122.432654202633 (37.7521275287632, -122.432654202633)
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)
56697 35266 1 42 2323 Polk St 1 1 1 1 1 02/17/1998 12:00:00 AM 8 3x3 Permit Number 38750 6006292.04033 2118835.34945 37.798273260158 -122.42230648984699 (37.798273260158, -122.422306489847)
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)
58356 71805 2 42 2451 29th Ave 1 1 1 1 1 06/02/1990 12:00:00 AM 4     5987333.5642 2098599.3879 37.741623296224205 -122.486421183565 (37.7416232962242, -122.486421183565)
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)
60100 83227 2 42 495 Connecticut St 1 1 1 1 1 08/20/2005 12:00:00 AM 10     6013273.66902 2104798.74295 37.7601232913798 -122.39716301566901 (37.7601232913798, -122.397163015669)
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)
61126 50520 1 42 85 Beaumont Ave 1 1 1 1 1 10/30/2003 12:00:00 AM 5   Permit Number 47158 5996681.6204 2112482.6347 37.7802836203489 -122.455101936973 (37.7802836203489, -122.455101936973)
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)
64061 32346 1 42 1201 35th Ave 3 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)
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)
64628 71308 2 42 1949 Golden Gate Ave 1 1 1 1 1 06/11/1988 12:00:00 AM 8     6000243.5 2111616.6716 37.7781096083019 -122.44271758887699 (37.7781096083019, -122.442717588877)
65053 37086 1 42 1426 46th Ave 1 1 1 1 1 06/01/1998 12:00:00 AM 0   Permit Number 39686 5981873.63686209 2105374.96731705 37.7599073668224 -122.505801636192 (37.7599073668224, -122.505801636192)
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)
68937 48447 1 42 2600 Post St 1 1 1 1   07/31/2002 12:00:00 AM 8   Permit Number 45819 5999656.5928 2113671.6674 37.783718621904896 -122.44489566584998 (37.7837186219049, -122.44489566585)
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)
69034 220048 2 42 1401 Rivoli St 3 1 1 1     3 Width 5ft   5997746.6978 2105897.5577 37.7622637372081 -122.450942387687 (37.7622637372081, -122.450942387687)
69451 38054 1 42 2779 Bush St 2 1 1 1 1 01/01/1999 12:00:00 AM 7   Permit Number 40250 6000242.4339 2114393.9483 37.7857352353713 -122.442920768491 (37.7857352353713, -122.442920768491)
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)
69574 245838 2 42 423 Laguna St 1 1 1 1     10 Width 0ft   6005012.6195 2110528.7961 37.7753932855436 -122.426142005084 (37.7753932855436, -122.426142005084)
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)
70342 220043 2 42 49 Hoffman Ave 1 1 1 1     10 Width 4ft   6000611.236219999 2102612.95968 37.753408606731 -122.440799429852 (37.753408606731, -122.440799429852)
70350 35250 1 42 1385 Greenwich St 3 1 1 1 1 02/17/1998 12:00:00 AM 8   Permit Number 38738 6006287.30636 2119683.41372 37.800601562682296 -122.42238315976999 (37.8006015626823, -122.42238315977)
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)
70549 40816 1 42 1770 Scott St 3 1 1 1   08/26/1999 12:00:00 AM 8   Permit Number 41760 6001593.7276 2114497.5525 37.7860966539785 -122.438253110129 (37.7860966539785, -122.438253110129)
70721 245867 2 42 419 Laguna St 1 1 1 1     5 Width 0ft   6005023.743 2110457.4751 37.775198084155605 -122.42609844781799 (37.7751980841556, -122.426098447818)
72259 220008 2 42 3447 25th St 1 1 1 1     11 Width 3ft   6006809.37202 2101432.95646 37.7505196263839 -122.419281221778 (37.7505196263839, -122.419281221778)
72341 220010 2 42 3561 20th St 1 1 1 1     12 Width 3ft   6006555.55006 2104341.3837900003 37.758491199927 -122.420365369767 (37.758491199927, -122.420365369767)
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)
73601 40189 1 42 600 Silliman St 2 1 1 1   04/30/1999 12:00:00 AM 8   Permit Number 41375 6008978.52665 2093804.69628 37.7296960159571 -122.411241285381 (37.7296960159571, -122.411241285381)
73916 200693 2 42 1607 Newcomb Ave 1 1 1 1     11 Width 0ft   6015092.9345 2095762.8694 37.7354137854933 -122.39023969268999 (37.7354137854933, -122.39023969269)
74240 141691 2 42 101 Beaumont Ave 1 1 1 1     9 Width 0ft   5996753.535 2112367.4021 37.7799713474759 -122.45484482437 (37.7799713474759, -122.45484482437)
74936 42897 1 42 2016 Wawona St 2 1 1 1 1 07/03/2000 12:00:00 AM 7   Permit Number 42813 5986657.8903 2096958.6583 37.737078880033 -122.488636837876 (37.737078880033, -122.488636837876)
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)
75192 220070 2 42 410 Sanchez St 1 1 1 1     6 Width 3ft   6003569.73703 2105814.1279 37.762366296795996 -122.43079674288 (37.762366296796, -122.43079674288)
75193 139501 2 42 750 CENTRAL AVE 1 1 1 1     10 Width 0ft   5999619.0371 2111147.3069 37.7767852347068 -122.444844076108 (37.7767852347068, -122.444844076108)
75611 182146 2 42 1690 21st Ave 2 1 1 1     9 Width 0ft   5989681.6149 2103872.2722 37.756237834999 -122.478688039412 (37.756237834999, -122.478688039412)
75622 203667 2 42 100 Judson Ave 2 1 1 1     8 Width 4ft   5999360.3584 2093511.22392 37.7283460957947 -122.444471133337 (37.7283460957947, -122.444471133337)
75943 44033 1 42 230 Ashbury St 1 1 1 1 1 10/02/2000 12:00:00 AM 9   Permit Number 43569 5998819.8857 2109894.1205 37.7732986671632 -122.447518341015 (37.7732986671632, -122.447518341015)
76144 220025 2 42 4247 25th St 1 1 1 1     6 Width 4ft   6002149.21455 2101175.68513 37.7495496617103 -122.435377979316 (37.7495496617103, -122.435377979316)
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)
77394 36576 1 42 2959 25th St 2 1 1 1 1 05/20/1998 12:00:00 AM     Permit Number 39438 6009743.48880831 2101591.28473575 37.7511191714417 -122.409145947985 (37.7511191714417, -122.409145947985)
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)
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)
77653 109672 2 42 798x GRAFTON AVE 2 1 1 1       3x3   5994496.0 2090624.0 37.72013972186421 -122.461078132621 (37.7201397218642, -122.461078132621)
77700 37051 1 42 364 Day St 1 1 1 1 1 06/01/1998 12:00:00 AM     Permit Number 39656 6003583.41460965 2098669.49042288 37.7427495797017 -122.43023969551201 (37.7427495797017, -122.430239695512)
77854 63851 1 42 1233 Hayes St 1 1 1 1 1 07/16/1987 12:00:00 AM     Permit Number 24548 6001965.88884277 2110471.51360831 37.775063328726 -122.43667724183999 (37.775063328726, -122.43667724184)
78102 32344 1 42 1201 35th Ave 4 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)
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)
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)
79057 32274 1 42 623 Anderson St 1 1 1 1 1 06/19/1998 12:00:00 AM     Permit Number 39911 6007825.97257693 2096019.31993336 37.7357121847697 -122.415382520688 (37.7357121847697, -122.415382520688)
79707 46270 1 42 16 Joost Ave 1 1 1 1 1 01/16/2002 12:00:00 AM     Permit Number 44554 6001971.15717323 2094954.12044598 37.732456582979495 -122.435548678389 (37.7324565829795, -122.435548678389)
79886 67804 1 42 215 Clipper St 1 1 1 1 1 02/12/1994 12:00:00 AM     Permit Number 31453 6003763.62243652 2100965.95054031 37.7490653321175 -122.429780349464 (37.7490653321175, -122.429780349464)
79951 32740 1 42 139 Lobos St 1 1 1 1 1 10/29/1996 12:00:00 AM     Permit Number 37123 5995564.95354615 2088674.66529796 37.7148487646576 -122.457242200681 (37.7148487646576, -122.457242200681)
80404 37853 1 42 639 Excelsior Ave 2 1 1 1 1 07/07/1998 12:00:00 AM     Permit Number 40143 6003947.74961722 2091786.98448726 37.723872400431496 -122.428489463759 (37.7238724004315, -122.428489463759)
80747 68174 1 42 449 Parker Ave 1 1 1 1 1 04/01/1995 12:00:00 AM     Permit Number 31945 5997091.52876923 2111801.84543591 37.778437859612005 -122.45363471008001 (37.778437859612, -122.45363471008)
81201 67531 1 42 55 Mississippi St 1 1 1 1 1 09/22/1992 12:00:00 AM     Permit Number 31069 6014000.26557437 2106870.40644282 37.765852048761104 -122.394795132512 (37.7658520487611, -122.394795132512)
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)
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)
81631 64135 1 42 674 29th St 1 1 1 1 1 12/29/1992 12:00:00 AM     Permit Number 31501 6002183.05937143 2098884.5643421 37.7432607055203 -122.43509709755399 (37.7432607055203, -122.435097097554)
81838 35367 1 42 619 San Bruno Ave 1 1 1 1 1 02/23/1998 12:00:00 AM     Permit Number 38827 6011631.49743277 2091601.49478662 37.723794911059606 -122.401914809778 (37.7237949110596, -122.401914809778)
81874 65160 1 42 878 Alvarado St 1 1 1 1 1 07/24/1989 12:00:00 AM     Permit Number 27140 6000731.49768107 2102608.84071127 37.7534041452721 -122.440383246008 (37.7534041452721, -122.440383246008)
81910 42335 1 42 207 Flood Ave 1 1 1 1 1 06/23/2000 12:00:00 AM     Permit Number 42540 5999365.95160297 2094049.74226531 37.7298250607238 -122.444490484515 (37.7298250607238, -122.444490484515)
Powered by Datasette · Query took 2.88ms · Data source: data.sfgov.org