sf-trees

Data source: data.sfgov.org

Custom SQL query returning 20 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
31275 195449 2 15 400 The Embarcadero 5 10 1 1     5 Width 5ft   6014736.842019999 2117083.55492 37.7939359738125 -122.392962080059 (37.7939359738125, -122.392962080059)
32033 235482 2 15 106 Chattanooga St 6 10 1 1     8 Width 4ft   6004702.50004 2102988.75016 37.7546725903948 -122.42667772741699 (37.7546725903948, -122.426677727417)
32945 178518 2 15 62 Kelloch Ave 1 10 1 1     14 Width 6ft   6008249.62715 2086262.35093 37.708945414261606 -122.41322803793899 (37.7089454142616, -122.413228037939)
38524 124392 2 15 3900 Washington St 1 10 1 1     7 Width 2ft   5996085.26261 2115570.92527 37.788729010018294 -122.45738849109199 (37.7887290100183, -122.457388491092)
40643 195447 2 15 400 The Embarcadero 3 10 1 1     3 Width 5ft   6014706.202819999 2117116.39491 37.794024442814106 -122.393070394401 (37.7940244428141, -122.393070394401)
51822 195451 2 15 400 The Embarcadero 7 10 1 1     6 Width 5ft   6014767.70739 2117048.87622 37.793842468603 -122.392852854701 (37.793842468603, -122.392852854701)
58740 195446 2 15 400 The Embarcadero 2 10 1 1     5 Width 5ft   6014688.3614 2117131.68733 37.794065441128 -122.393133198563 (37.794065441128, -122.393133198563)
59798 195450 2 15 400 The Embarcadero 6 10 1 1     4 Width 5ft   6014751.24936 2117067.54594 37.793892817153704 -122.392911108287 (37.7938928171537, -122.392911108287)
74677 195448 2 15 400 The Embarcadero 4 10 1 1     5 Width 5ft   6014719.29527 2117100.4128400004 37.793981287051295 -122.393023974076 (37.7939812870513, -122.393023974076)
130790 124395 2 15 3900 Washington St 4 10 1 1     12 Width 3ft   5996032.15972 2115565.17728 37.7887101773731 -122.45757180221001 (37.7887101773731, -122.45757180221)
134604 135302 2 15 840 California St 1 10 1 1     12 Width 2ft   6010328.26528 2116562.4227 37.792259202258 -122.408179486788 (37.792259202258, -122.408179486788)
146601 178617 2 15 1686 Alemany Blvd 3 10 1 1     17 Width 3ft   6001466.5158400005 2092244.27913 37.72498730330771 -122.43709939413999 (37.7249873033077, -122.43709939414)
147317 124393 2 15 3900 Washington St 2 10 1 1     7 Width 2ft   5996070.40089 2115569.6533 37.7887246639076 -122.457439818112 (37.7887246639076, -122.457439818112)
147550 135303 2 15 840 California St 2 10 1 1     11 Width 2ft   6010295.40817 2116554.0512599996 37.79223437647521 -122.40829258284799 (37.7922343764752, -122.408292582848)
148359 124394 2 15 3900 Washington St 3 10 1 1     9 Width 2ft   5996045.97336 2115566.9988599997 37.7887159724195 -122.45752414117099 (37.7887159724195, -122.457524141171)
157502 178616 2 15 1686 Alemany Blvd 2 10 1 1     24 Width 4ft   6001474.37484 2092261.25737 37.7250343684236 -122.437073441507 (37.7250343684236, -122.437073441507)
163842 238601 2 15 4808 25th St 1 10 1 1     20 Width 10ft   5999995.98595 2101090.80522 37.7491940814535 -122.442817794501 (37.7491940814535, -122.442817794501)
180318 238602 2 15 4808 25th St 2 10 1 1     11 Width 10ft   5999965.12286 2101089.08454 37.7491875973318 -122.442924395649 (37.7491875973318, -122.442924395649)
182549 134900 2 15 301 Union St 1 10 1 1     7 Width 3ft   6011410.78161 2119701.10617 37.8009378236702 -122.404654992453 (37.8009378236702, -122.404654992453)
186167 195445 2 15 400 The Embarcadero 1 10 1 1     5 Width 5ft   6014671.32996 2117148.01113 37.79410931633421 -122.393193272358 (37.7941093163342, -122.393193272358)
Powered by Datasette · Query took 9.044ms · Data source: data.sfgov.org