sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
113837 116669 3 47 100 Esmeralda Ave 6 14 1 2     20     6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
886 19568 3 47 100 STAIRWAY1 2 1 1 2     48 100ST            
6533 19565 3 47 100 STAIRWAY1 -11 1 1 2     36 100ST            
8903 19566 3 47 100 STAIRWAY1 -9 1 1 2     36 100ST            
10571 19570 3 47 100 STAIRWAY1 4 1 1 2     48 100ST            
10705 19569 3 47 100 STAIRWAY1 3 1 1 2     48 100ST            
7938 19700 3 47 100 STAIRWAY11 2 1 1 2     36 40ST            
15767 19699 3 47 100 STAIRWAY11 1 1 1 2     24 40ST            
13158 19753 3 47 100 STAIRWAY15 11 1 1 2     12 10ST            
5855 19776 3 47 100 STAIRWAY18 2 1 1 2     18 50ST            
9072 19804 3 47 100 STAIRWAY22 3 1 1 2     6 20            
14206 19813 3 47 100 STAIRWAY24 4 1 1 2     12 100ST            
12151 19869 3 47 100 STAIRWAY33 1 1 1 2     24 25ST            
6023 19905 3 47 100 STAIRWAY35 1 1 1 2     12 120ST            
6147 19906 3 47 100 STAIRWAY35 2 1 1 2     6 120ST            
6517 19907 3 47 100 STAIRWAY35 3 1 1 2     12 120ST            
10816 19910 3 47 100 STAIRWAY35 6 1 1 2     12 120ST            
15771 19908 3 47 100 STAIRWAY35 4 1 1 2     6 120ST            
16878 19909 3 47 100 STAIRWAY35 5 1 1 2     12 120ST            
6952 19935 3 47 100 STAIRWAY38 4 1 1 2     12 10ST            
10674 19936 3 47 100 STAIRWAY38 5 1 1 2     12 10ST            
10949 19933 3 47 100 STAIRWAY38 2 1 1 2     12 10ST            
14400 19934 3 47 100 STAIRWAY38 3 1 1 2     12 10ST            
14992 19932 3 47 100 STAIRWAY38 1 1 1 2     12 10ST            
15978 19943 3 47 100 STAIRWAY38 12 1 1 2     12 10ST            
6834 19955 3 47 100 STAIRWAY39 12 1 1 2     12 2ST            
7732 19948 3 47 100 STAIRWAY39 5 1 1 2     18 25ST            
7886 19945 3 47 100 STAIRWAY39 2 1 1 2     6 25ST            
11220 19950 3 47 100 STAIRWAY39 7 1 1 2     12 25ST            
12812 19953 3 47 100 STAIRWAY39 10 1 1 2     12 25ST            
16424 19949 3 47 100 STAIRWAY39 6 1 1 2     24 25ST            
16608 19951 3 47 100 STAIRWAY39 8 1 1 2     12 25ST            
16721 19947 3 47 100 STAIRWAY39 4 1 1 2     18 25ST            
17092 19978 3 47 100 STAIRWAY45 5 1 1 2     36 30ST            
13184 20013 3 47 100 STAIRWAY47 1 1 1 2     6 100ST            
14425 19694 3 47 100 STAIRWAY7 1 1 1 2     24 12ST            
1822 251717 3 47 1000X San Jose Ave 1 7 1 2           6004710.0 2096486.0 37.736817957153605 -122.426188866367 (37.7368179571536, -122.426188866367)
67961 206836 3 47 100x Idora Ave 14 3 1 2     66 Width 9ft   5995604.17085 2099350.4744700002 37.7441642119029 -122.45787873812799 (37.7441642119029, -122.457878738128)
187642 206837 3 47 100x Idora Ave 25 3 1 2     63 Width 9ft   5995840.17489 2099294.03492 37.7440227989188 -122.45705861128401 (37.7440227989188, -122.457058611284)
102194 101037 3 47 1010X Portola Dr 11 7 1 2           5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621)
6006 20312 3 47 101X Sunset Blvd 1 1 1 2     24 60            
7548 20317 3 47 101X Sunset Blvd 6 1 1 2     18 60            
32031 190995 3 47 10x Cashmere St 3 3 1 2     28     6017237.22965 2095860.87095 37.7358015834667 -122.38283280631599 (37.7358015834667, -122.382832806316)
142607 11185 3 47 110 Idora Ave 1 11 1 2     48 8   5995900.4612004 2099322.604417 37.744104705607704 -122.45685222203001 (37.7441047056077, -122.45685222203)
7419 97731 3 47 1150 Francisco St 9 1 1 4 2   3 3x3 Permit Number 50638 6005778.11415 2120709.05822 37.803388983478605 -122.42421815984501 (37.8033889834786, -122.424218159845)
24947 206807 3 47 11x Saint Francis Blvd 1 3 1 2     12     5991689.221530001 2095992.9314700002 37.734719554257296 -122.471171081279 (37.7347195542573, -122.471171081279)
158032 206808 3 47 11x Saint Francis Blvd 2 3 1 2     13     5991782.03455 2095997.5477200001 37.734737597362205 -122.470850534124 (37.7347375973622, -122.470850534124)
77993 12500 3 47 1200X Lake Merced Blvd 2 11 1 2     6 8   5987438.4549992 2087542.2692131 37.7112694082243 -122.485247377649 (37.7112694082243, -122.485247377649)
90329 12501 3 47 1200X Lake Merced Blvd 3 11 1 2     6 8   5987438.4549992 2087542.2692131 37.7112694082243 -122.485247377649 (37.7112694082243, -122.485247377649)
91431 12502 3 47 1200X Lake Merced Blvd 4 11 1 2     12 8   5987438.4549992 2087542.2692131 37.7112694082243 -122.485247377649 (37.7112694082243, -122.485247377649)
10904 19431 3 47 1200X Sloat Blvd 4 11 1 2   11/13/2007 12:00:00 AM 6 20   5987714.9376 2095926.0092 37.7343051218756 -122.48490645815501 (37.7343051218756, -122.484906458155)
173128 185117 3 47 1200x Sloat Blvd 7 11 1 2     28 Width 0ft   5987506.2336 2095918.1597 37.7342714110431 -122.485627430105 (37.7342714110431, -122.485627430105)
181042 186841 3 47 1200x Sunset Blvd 1 11 1 2     32 Width 0ft   5984746.1314 2106971.8455 37.764460596444295 -122.495985031222 (37.7644605964443, -122.495985031222)
12637 19441 3 47 1300X Sloat Blvd 4 11 1 2     3 20   5986928.6035 2095895.7656 37.7341762495639 -122.487622811763 (37.7341762495639, -122.487622811763)
19244 20545 3 47 1303X Sunset Blvd 23 1 1 2     3 6O   5984802.8376111 2106327.3646052 37.7626943540195 -122.49574136031299 (37.7626943540195, -122.495741360313)
79366 20549 3 47 1303X Sunset Blvd 27 1 1 2     42 6O   5984802.8376111 2106327.3646052 37.7626943540195 -122.49574136031299 (37.7626943540195, -122.495741360313)
85580 20539 3 47 1303X Sunset Blvd 17 1 1 2     48 6O   5984802.8376111 2106327.3646052 37.7626943540195 -122.49574136031299 (37.7626943540195, -122.495741360313)
94781 20541 3 47 1303X Sunset Blvd 19 1 1 2     48 6O   5984802.8376111 2106327.3646052 37.7626943540195 -122.49574136031299 (37.7626943540195, -122.495741360313)
96354 20544 3 47 1303X Sunset Blvd 22 1 1 2     3 6O   5984802.8376111 2106327.3646052 37.7626943540195 -122.49574136031299 (37.7626943540195, -122.495741360313)
96636 20528 3 47 1303X Sunset Blvd 6 1 1 2     48 6O   5984802.8376111 2106327.3646052 37.7626943540195 -122.49574136031299 (37.7626943540195, -122.495741360313)
96863 20540 3 47 1303X Sunset Blvd 18 1 1 2     48 6O   5984802.8376111 2106327.3646052 37.7626943540195 -122.49574136031299 (37.7626943540195, -122.495741360313)
102455 20538 3 47 1303X Sunset Blvd 16 1 1 2     12 6O   5984802.8376111 2106327.3646052 37.7626943540195 -122.49574136031299 (37.7626943540195, -122.495741360313)
108770 20531 3 47 1303X Sunset Blvd 9 1 1 2     48 6O   5984802.8376111 2106327.3646052 37.7626943540195 -122.49574136031299 (37.7626943540195, -122.495741360313)
111174 20524 3 47 1303X Sunset Blvd 2 1 1 2     48 6O   5984802.8376111 2106327.3646052 37.7626943540195 -122.49574136031299 (37.7626943540195, -122.495741360313)
115048 20527 3 47 1303X Sunset Blvd 5 1 1 2     48 6O   5984802.8376111 2106327.3646052 37.7626943540195 -122.49574136031299 (37.7626943540195, -122.495741360313)
115611 20542 3 47 1303X Sunset Blvd 20 1 1 2     36 6O   5984802.8376111 2106327.3646052 37.7626943540195 -122.49574136031299 (37.7626943540195, -122.495741360313)
116613 20526 3 47 1303X Sunset Blvd 4 1 1 2     42 6O   5984802.8376111 2106327.3646052 37.7626943540195 -122.49574136031299 (37.7626943540195, -122.495741360313)
127519 20547 3 47 1303X Sunset Blvd 25 1 1 2     48 6O   5984802.8376111 2106327.3646052 37.7626943540195 -122.49574136031299 (37.7626943540195, -122.495741360313)
139297 20530 3 47 1303X Sunset Blvd 8 1 1 2     36 6O   5984802.8376111 2106327.3646052 37.7626943540195 -122.49574136031299 (37.7626943540195, -122.495741360313)
142008 20523 3 47 1303X Sunset Blvd 1 1 1 2     48 6O   5984802.8376111 2106327.3646052 37.7626943540195 -122.49574136031299 (37.7626943540195, -122.495741360313)
146309 20535 3 47 1303X Sunset Blvd 13 1 1 2     48 6O   5984802.8376111 2106327.3646052 37.7626943540195 -122.49574136031299 (37.7626943540195, -122.495741360313)
25946 126425 3 47 1306x Montgomery St 27 3 1 2     13 Width 8ft   6011438.821769999 2120037.4711599997 37.8018629670555 -122.40458165273701 (37.8018629670555, -122.404581652737)
39759 126424 3 47 1306x Montgomery St 26 3 1 2     15 Width 8ft   6011439.456040001 2120033.94187 37.801853311934096 -122.404579209268 (37.8018533119341, -122.404579209268)
38782 139327 3 47 1350x GEARY BLVD 1 11 1 2     22 Width 0ft   6005396.3086 2114138.3218 37.785325835852795 -122.425071614426 (37.7853258358528, -122.425071614426)
54250 139328 3 47 1350x GEARY BLVD 2 11 1 2     17 Width 0ft   6005318.1985 2114131.1202 37.7853016493854 -122.42534133927 (37.7853016493854, -122.42534133927)
72905 139357 3 47 1350x GEARY BLVD 6 11 1 2     19 Width 0ft   6005019.8844 2114088.1873 37.785166908017004 -122.426370358064 (37.785166908017, -122.426370358064)
90982 20574 3 47 1392X Sunset Blvd 13 1 1 2     36 60   5984737.8310875995 2105717.624989 37.7610163726955 -122.49592120853 (37.7610163726955, -122.49592120853)
99122 20576 3 47 1392X Sunset Blvd 15 1 1 2     24 60   5984737.8310875995 2105717.624989 37.7610163726955 -122.49592120853 (37.7610163726955, -122.49592120853)
99295 20577 3 47 1392X Sunset Blvd 16 1 1 2     12 60   5984737.8310875995 2105717.624989 37.7610163726955 -122.49592120853 (37.7610163726955, -122.49592120853)
117082 20566 3 47 1392X Sunset Blvd 5 1 1 2     42 60   5984737.8310875995 2105717.624989 37.7610163726955 -122.49592120853 (37.7610163726955, -122.49592120853)
9916 173733 3 47 14 Richland Ave 1 17 1 2       3x3   6004601.0 2096122.0 37.7358123337564 -122.426539816145 (37.7358123337564, -122.426539816145)
84848 20592 3 47 1401X Sunset Blvd 3 1 1 2     42 60   5984800.4502922995 2105635.4093669 37.760794298851295 -122.495698574627 (37.7607942988513, -122.495698574627)
84860 20603 3 47 1401X Sunset Blvd 14 1 1 2     48 60   5984800.4502922995 2105635.4093669 37.760794298851295 -122.495698574627 (37.7607942988513, -122.495698574627)
120013 20593 3 47 1401X Sunset Blvd 4 1 1 2     48 60   5984800.4502922995 2105635.4093669 37.760794298851295 -122.495698574627 (37.7607942988513, -122.495698574627)
141352 109893 3 47 1408x SUNSET BLVD 3 11 1 2     40 3x3   5984818.0 2105324.0 37.7599402834086 -122.49561490918 (37.7599402834086, -122.49561490918)
127498 11191 3 47 148 Idora Ave 1 11 1 2     48 8   5995624.0655798 2099382.6906533 37.7442538125131 -122.457812277707 (37.7442538125131, -122.457812277707)
66637 20618 3 47 1492X Sunset Blvd 1 1 1 2     42 60   5984803.7392562 2105036.6950477003 37.759150589029495 -122.495643037613 (37.7591505890295, -122.495643037613)
85885 20639 3 47 1492X Sunset Blvd 22 1 1 2     42 60   5984803.7392562 2105036.6950477003 37.759150589029495 -122.495643037613 (37.7591505890295, -122.495643037613)
93133 20621 3 47 1492X Sunset Blvd 4 1 1 2     42 60   5984803.7392562 2105036.6950477003 37.759150589029495 -122.495643037613 (37.7591505890295, -122.495643037613)
94819 20619 3 47 1492X Sunset Blvd 2 1 1 2     30 60   5984803.7392562 2105036.6950477003 37.759150589029495 -122.495643037613 (37.7591505890295, -122.495643037613)
104956 20637 3 47 1492X Sunset Blvd 20 1 1 2     36 60   5984803.7392562 2105036.6950477003 37.759150589029495 -122.495643037613 (37.7591505890295, -122.495643037613)
129401 20638 3 47 1492X Sunset Blvd 21 1 1 2     12 60   5984803.7392562 2105036.6950477003 37.759150589029495 -122.495643037613 (37.7591505890295, -122.495643037613)
140332 20627 3 47 1492X Sunset Blvd 10 1 1 2     42 60   5984803.7392562 2105036.6950477003 37.759150589029495 -122.495643037613 (37.7591505890295, -122.495643037613)
4098 8400 3 47 1500 Geary Blvd 11 11 1 2     18 8   6003921.0381 2113941.5724 37.7847021645415 -122.430161561145 (37.7847021645415, -122.430161561145)
4214 8397 3 47 1500 Geary Blvd 8 11 1 2     18 8   6004036.9348 2113953.0096 37.7847401317276 -122.42976141314301 (37.7847401317276, -122.429761413143)
6096 8399 3 47 1500 Geary Blvd 10 11 1 2     18 8   6003960.687000001 2113944.6223 37.7847127843654 -122.430024606782 (37.7847127843654, -122.430024606782)
6510 8398 3 47 1500 Geary Blvd 9 11 1 2     18 8   6003997.2859 2113948.4347 37.784725324941604 -122.429898258777 (37.7847253249416, -122.429898258777)
6794 8396 3 47 1500 Geary Blvd 7 11 1 2   06/09/1994 12:00:00 AM 6 8   6004125.3824 2113965.9717 37.7847807304874 -122.429456338379 (37.7847807304874, -122.429456338379)
7230 8401 3 47 1500 Geary Blvd 12 11 1 2     18 8   6003886.7265 2113933.9476 37.7846792853457 -122.43027972368401 (37.7846792853457, -122.430279723684)
17384 16354 3 47 1500X Monterey Blvd 4 11 1 2     18 4-HOA   5993443.33225 2095241.5642099997 37.7327577911269 -122.465052016742 (37.7327577911269, -122.465052016742)
83484 20665 3 47 1501X Sunset Blvd 19 1 1 2     42 60   5984817.9532367 2104951.7766639 37.7589182591611 -122.49558761620101 (37.7589182591611, -122.495587616201)
Powered by Datasette · Query took 65.237ms · Data source: data.sfgov.org