sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1707 19767 3 40 100 STAIRWAY16 6 1 1 2     12 30ST            
1811 19991 3 40 100 STAIRWAY46 11 1 1 2     12 40            
1842 19990 3 40 100 STAIRWAY46 10 1 1 2     6 40            
2751 19916 3 40 100 STAIRWAY35 12 1 1 2     6 120ST            
5450 19643 3 40 100 STAIRWAY5 42 1 1 2     12 30            
5580 19952 3 40 100 STAIRWAY39 9 1 1 2     12 25ST            
5629 19629 3 40 100 STAIRWAY5 28 1 1 2     6 30            
5638 19734 3 40 100 STAIRWAY14 12 1 1 2     12 40ST            
6130 19637 3 40 100 STAIRWAY5 36 1 1 2     12 30            
6465 20050 3 40 100 STAIRWAY52 6 1 1 2     12 10            
6552 19622 3 40 100 STAIRWAY5 21 1 1 2     12 30            
6727 20046 3 40 100 STAIRWAY52 2 1 1 2     3 10            
6840 19703 3 40 100 STAIRWAY13 1 1 1 2     12 40ST            
6859 19881 3 40 100 STAIRWAY33 13 1 1 2     12 25ST            
7127 19877 3 40 100 STAIRWAY33 9 1 1 2     24 25ST            
8000 19575 3 40 100 STAIRWAY1 10 1 1 2     36 100ST            
8376 17629 3 40 150 Phelps St 2 1 1 2     12 10M            
8874 19879 3 40 100 STAIRWAY33 11 1 1 2     12 25ST            
8891 19873 3 40 100 STAIRWAY33 5 1 1 2     30 25ST            
9101 19626 3 40 100 STAIRWAY5 25 1 1 2     12 30            
9670 19824 3 40 100 STAIRWAY25 8 1 1 2     6 10ST            
10584 19572 3 40 100 STAIRWAY1 6 1 1 2     24 100ST            
10624 19574 3 40 100 STAIRWAY1 8 1 1 2     12 100ST            
10757 19823 3 40 100 STAIRWAY25 7 1 1 2     6 10ST            
10946 19995 3 40 100 STAIRWAY46 15 1 1 2     12 40            
11109 19996 3 40 100 STAIRWAY46 16 1 1 2     12 40            
11188 19822 3 40 100 STAIRWAY25 6 1 1 2     6 10ST            
11496 19573 3 40 100 STAIRWAY1 7 1 1 2     12 100ST            
11523 19635 3 40 100 STAIRWAY5 34 1 1 2     12 30            
11623 19765 3 40 100 STAIRWAY16 4 1 1 2     12 30ST            
12152 19571 3 40 100 STAIRWAY1 5 1 1 2     24 100ST            
12720 19640 3 40 100 STAIRWAY5 39 1 1 2     6 30            
12830 19619 3 40 100 STAIRWAY5 18 1 1 2     12 30            
12952 19628 3 40 100 STAIRWAY5 27 1 1 2     6 30            
13122 19636 3 40 100 STAIRWAY5 35 1 1 2     12 30            
13156 20391 3 40 262X Sunset Blvd 37 1 1 2     12 60            
13560 20028 3 40 100 STAIRWAY49 1 1 1 2     12 10            
13632 19618 3 40 100 STAIRWAY5 17 1 1 2     6 30            
13773 19987 3 40 100 STAIRWAY46 7 1 1 2     6 40            
13883 19639 3 40 100 STAIRWAY5 38 1 1 2     6 30            
14157 17628 3 40 150 Phelps St 1 1 1 2     12 10M            
14188 19617 3 40 100 STAIRWAY5 16 1 1 2     6 30            
14653 19921 3 40 100 STAIRWAY37 1 1 1 2     12 3X3            
15445 19918 3 40 100 STAIRWAY35 14 1 1 2     6 120ST            
15768 19884 3 40 100 STAIRWAY33 16 1 1 2     18 25ST            
15790 87061 1 40     19 1 1       3x3 Permit Number 50003          
15852 19567 3 40 100 STAIRWAY1 1 1 1 2     24 100ST            
15947 19630 3 40 100 STAIRWAY5 29 1 1 2     12 30            
16203 19623 3 40 100 STAIRWAY5 22 1 1 2     12 30            
16222 19870 3 40 100 STAIRWAY33 2 1 1 2     36 25ST            
16278 19770 3 40 100 STAIRWAY16 9 1 1 2     6 30ST            
16313 19876 3 40 100 STAIRWAY33 8 1 1 2     12 25ST            
16376 19641 3 40 100 STAIRWAY5 40 1 1 2     12 30            
16486 19701 3 40 100 STAIRWAY12 1 1 1 2     12 60            
16953 19917 3 40 100 STAIRWAY35 13 1 1 2     6 120ST            
119576 68317 1 40 1999X 48th Ave 1 1 1 1 1 08/09/1993 12:00:00 AM     Permit Number 32130 5981353.71840295 2101490.23529545 37.7492103807501 -122.50731153380801 (37.7492103807501, -122.507311533808)
121834 69022 1 40 2094 48th Ave 1 1 1 1 1 01/05/1994 12:00:00 AM     Permit Number 33026 5981407.07152231 2100831.13487358 37.7474038185251 -122.507078153918 (37.7474038185251, -122.507078153918)
93083 34702 1 40 546 46th Ave 3 1 1 1 1 07/28/1997 12:00:00 AM     Permit Number 38359 5981647.34162822 2112027.92469202 37.7781611337001 -122.50707780583099 (37.7781611337001, -122.507077805831)
50313 69180 1 40 1310 45th Ave 1 1 1 1 1 01/26/1994 12:00:00 AM 8   Permit Number 33219 5982156.72464205 2106168.22486515 37.7621020835294 -122.504881372035 (37.7621020835294, -122.504881372035)
152160 51577 1 40 584 43rd Ave 1 1 1 1 1 01/08/2005 12:00:00 AM 28   Permit Number 47871 5982583.51771 2111812.9357 37.7776259284617 -122.50382336032 (37.7776259284617, -122.50382336032)
165342 62644 1 40 1255 42nd Ave 1 1 1 1   06/03/2008 12:00:00 AM 1 3x3 Permit Number 50627 5983022.3246657 2106594.48040873 37.763323345885404 -122.50191918393699 (37.7633233458854, -122.501919183937)
85692 63202 1 40 7 Shore View Ave 1 1 1 1 1 12/18/1986 12:00:00 AM     Permit Number 23744 5984650.094069201 2112837.90974399 37.78056150785579 -122.496750144554 (37.7805615078558, -122.496750144554)
182351 181588 2 40 1227 37th Ave 2 1 1 1     11 Width 0ft   5984569.5881 2106811.9615 37.764011258359105 -122.496583837339 (37.7640112583591, -122.496583837339)
166229 183716 2 40 1231 37th Ave 1 1 1 1     9 Width 0ft   5984571.0948 2106790.8677 37.7639534289968 -122.49657706948 (37.7639534289968, -122.49657706948)
111909 60551 1 40 539 35th Ave 1 1 1 1 1 12/18/1982 12:00:00 AM     Permit Number 20161 5985003.93496372 2112200.51497155 37.7788321315722 -122.49547903508801 (37.7788321315722, -122.495479035088)
126005 60557 1 40 646 35th Ave 1 1 1 1 1 12/18/1982 12:00:00 AM     Permit Number 20167 5985081.30797731 2111459.74994128 37.776802733932 -122.495156735304 (37.776802733932, -122.495156735304)
99896 20988 3 40 2002X Sunset Blvd 28 1 1 2     200 40   5984887.616570599 2101567.3225095 37.7496295616808 -122.49509712324499 (37.7496295616808, -122.495097123245)
41295 187029 2 40 2501 Sunset Blvd 48 9 1 1     38 Width 0ft   5984947.4301 2097843.1311 37.7394074439231 -122.49461576933999 (37.7394074439231, -122.49461576934)
43878 187030 2 40 2501 Sunset Blvd 49 9 1 1     16 Width 0ft   5984957.5185 2097843.1311 37.7394080343891 -122.49458088860901 (37.7394080343891, -122.494580888609)
182619 187037 2 40 2501 Sunset Blvd 56 9 1 1     29 Width 0ft   5984959.5362 2097794.0341 37.7392733453171 -122.49457029390899 (37.7392733453171, -122.494570293909)
72098 187038 2 40 2501 Sunset Blvd 57 9 1 1     3 Width 0ft   5984961.8902 2097789.6624 37.7392614795793 -122.494561832752 (37.7392614795793, -122.494561832752)
131781 187031 2 40 2501 Sunset Blvd 50 9 1 1     19 Width 0ft   5984966.2618 2097842.7948 37.7394076227298 -122.494550633787 (37.7394076227298, -122.494550633787)
28658 187032 2 40 2501 Sunset Blvd 51 9 1 1     11 Width 0ft   5984967.607000001 2097835.0603 37.73938646460329 -122.494545412715 (37.7393864646033, -122.494545412715)
19129 12492 1 40 307 Lake Merced Blvd 37 1 1 13     36 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
77867 12494 1 40 307 Lake Merced Blvd 39 1 1 13     12 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
78081 12493 1 40 307 Lake Merced Blvd 38 1 1 13     18 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
82877 12490 1 40 307 Lake Merced Blvd 35 1 1 13     24 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
96574 12496 1 40 307 Lake Merced Blvd 41 1 1 13     24 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
107551 12488 1 40 307 Lake Merced Blvd 33 1 1 13     24 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
108276 12495 1 40 307 Lake Merced Blvd 40 1 1 13     18 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
170536 32593 1 40 1375 34th Ave 1 1 1 1 1 10/22/1996 12:00:00 AM 1   Permit Number 37061 5985530.158172799 2105866.8789552 37.7614725555795 -122.49319192882099 (37.7614725555795, -122.493191928821)
36977 186970 3 40 1650x Sloat Blvd 1 11 1 2     10 Width 0ft   5986025.4295 2095869.2083 37.734050611594604 -122.49074337328301 (37.7340506115946, -122.490743373283)
104967 108502 2 40 2300 33RD AVE 1 13 1 1     32     5986128.8 2099536.7 37.7441266056665 -122.49065574130199 (37.7441266056665, -122.490655741302)
69668 66337 1 40 1230 31st Ave 1 1 1 1 1 12/10/1990 12:00:00 AM 12   Permit Number 29458 5986478.94641131 2106871.16119587 37.7642854833106 -122.489984375656 (37.7642854833106, -122.489984375656)
53330 186974 3 40 1600x Sloat Blvd 1 11 1 2     9 Width 0ft   5986249.0864 2095869.2083 37.7340636742344 -122.489970132524 (37.7340636742344, -122.489970132524)
94515 107708 2 40 1798X 31st Ave 2 1 1 1       3x3   5986575.46002 2103344.33269 37.7546074174257 -122.489391225039 (37.7546074174257, -122.489391225039)
100492 107709 2 40 1798X 31st Ave 3 1 1 1       3x3   5986575.46002 2103344.33269 37.7546074174257 -122.489391225039 (37.7546074174257, -122.489391225039)
120953 107712 2 40 1798X 31st Ave 6 1 1 1       3x3   5986575.46002 2103344.33269 37.7546074174257 -122.489391225039 (37.7546074174257, -122.489391225039)
139574 107711 2 40 1798X 31st Ave 5 1 1 1       3x3   5986575.46002 2103344.33269 37.7546074174257 -122.489391225039 (37.7546074174257, -122.489391225039)
81453 114249 6 40 499x 24TH AVE 1 5 1 1       3x3   5988415.0 2112957.0 37.78110836988721 -122.483734439284 (37.7811083698872, -122.483734439284)
132300 185059 3 40 700x Sloat Blvd 3 11 1 2     13 Width 0ft   5988840.8776 2095965.7184 37.7344796690595 -122.481016672562 (37.7344796690595, -122.481016672562)
58856 185127 3 40 700x Sloat Blvd 2 11 1 2     10 Width 0ft   5989015.4133 2095969.6432 37.734500589899504 -122.480413539116 (37.7345005898995, -122.480413539116)
117345 51287 1 40 726 21st Ave 1 1 1 1 1 08/09/1993 12:00:00 AM     Permit Number 47659 5989465.45229129 2110387.70383509 37.774114887360504 -122.479912367003 (37.7741148873605, -122.479912367003)
98498 109631 2 40 390 BUCKINGHAM WAY   1 1 1       9x9   5989374.0 2093588.0 37.7279820381776 -122.478999652651 (37.7279820381776, -122.478999652651)
77778 64888 1 40 2418 22nd Ave 1 1 1 1 1 03/01/1989 12:00:00 AM     Permit Number 25914 5989547.06003251 2098884.34921412 37.742534500381105 -122.478788583135 (37.7425345003811, -122.478788583135)
131175 218283 3 40 2x Sloat Blvd 8 3 1 2     10     5990775.7158 2095986.69925 37.7346495609245 -122.474328895956 (37.7346495609245, -122.474328895956)
88646 69470 1 40 1570 16th Ave 1 1 1 1 1 05/16/1994 12:00:00 AM     Permit Number 33586 5991155.36555461 2104799.07062441 37.75886803765071 -122.47365896033001 (37.7588680376507, -122.47365896033)
147460 217803 3 40 2x Sloat Blvd 3 3 1 2     34     5991018.47185 2095992.29774 37.734678993934494 -122.473490022742 (37.7346789939345, -122.473490022742)
185691 217802 3 40 2x Sloat Blvd 2 3 1 2     15     5991046.80022 2095992.48375 37.734681145124505 -122.47339209648001 (37.7346811451245, -122.47339209648)
187769 122180 2 40 100 14th Ave 1 2 1 1     21 Width 3ft   5991527.0848 2114155.02215 37.784578471021 -122.47305567737601 (37.784578471021, -122.473055677376)
99337 29918 3 40 810 Junipero Serra Blvd 7 1 1 2     14     5991252.04535388 2092080.81829703 37.7239525748811 -122.472397431071 (37.7239525748811, -122.472397431071)
Powered by Datasette · Query took 6.897ms · Data source: data.sfgov.org