sf-trees

Data source: data.sfgov.org

Custom SQL query returning 25 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
17666 16203 3 99 501X Monterey Blvd 3 11 1 2   02/02/2003 12:00:00 AM 12 5   5998659.38581 2094694.1828400001 37.731554201452106 -122.446979509806 (37.7315542014521, -122.446979509806)
18341 29708 3 99 1534X Guerrero St 3 11 1 2   03/30/2006 12:00:00 AM 6     6005897.61494 2100055.38982 37.746685751754605 -122.422336286217 (37.7466857517546, -122.422336286217)
18826 16271 3 99 601X Monterey Blvd 3 11 1 2   02/02/2003 12:00:00 AM 18 5   5997920.42958 2094705.3029200002 37.731542488687204 -122.449535014353 (37.7315424886872, -122.449535014353)
21501 639 1 99 3203 24th St 3 1 1 1   04/01/1991 12:00:00 AM 18 3X3   6007596.74853 2102059.47083 37.7522842059666 -122.416602782609 (37.7522842059666, -122.416602782609)
21912 29701 3 99 1488X Guerrero St 3 11 1 2   03/30/2006 12:00:00 AM 6     6005878.92208 2100344.0622799997 37.7474773260372 -122.42242143222201 (37.7474773260372, -122.422421432222)
22067 16311 3 99 700X Monterey Blvd 3 11 1 2   02/02/2003 12:00:00 AM 3 5   5997346.34886 2094713.5127 37.7315321725506 -122.45152030461901 (37.7315321725506, -122.451520304619)
32476 126017 2 99 500 Post St 3 10 1 1     6 Width 3ft   6009644.05128 2115053.2571900003 37.788077063340204 -122.410440279012 (37.7880770633402, -122.410440279012)
34786 126022 2 99 550 Geary St 3 10 1 1     4 Width 4ft   6009023.96612 2114628.9203 37.786877155513004 -122.412555665234 (37.786877155513, -122.412555665234)
34889 175846 2 99 210 Tocoloma Ave 3 1 1 1     8 Width 3ft   6012734.12087 2087510.3732 37.7126229867466 -122.397816364158 (37.7126229867466, -122.397816364158)
40866 225175 2 99 3309 Folsom St 3 1 1 1     3 Width 3ft   6008515.82219 2099330.37365 37.7448423609829 -122.41323150034901 (37.7448423609829, -122.413231500349)
49752 225207 2 99 3816 24th St 3 10 1 1     6 Width 3ft   6004299.338409999 2101924.10637 37.7517265264651 -122.427996107428 (37.7517265264651, -122.427996107428)
54105 206046 2 99 82 Ventura Ave 3 2 1 1     5 Width 3ft   5994334.26497 2101814.09479 37.750855650885605 -122.462448420067 (37.7508556508856, -122.462448420067)
60112 225210 2 99 3641 17th St 3 10 1 1     7 Width 3ft   6004615.0966300005 2105985.22525 37.7628952609247 -122.427193419352 (37.7628952609247, -122.427193419352)
61054 247121 2 99 2301 Castro St 3 9 1 1     5     6002764.34837 2098855.27399 37.743213271472705 -122.433085061551 (37.7432132714727, -122.433085061551)
76779 225196 2 99 3160 21st St 3 1 1 1     9 Width 3ft   6007182.851 2103832.80652 37.7571300930895 -122.41815982112699 (37.7571300930895, -122.418159821127)
106572 225189 2 99 500 Capp St 3 1 1 1     10 Width 3ft   6007250.88683 2103937.06131 37.757420182006605 -122.41793191673901 (37.7574201820066, -122.417931916739)
137477 189995 2 99 1301 Minnesota St 3 7 1 1     3     6015392.22277 2102247.2850900004 37.753235244428204 -122.389657680355 (37.7532352444282, -122.389657680355)
148481 225146 2 99 1706 Dolores St 3 2 1 1     10 Width 6ft   6005275.161069999 2098395.65522 37.7420933673216 -122.424370639893 (37.7420933673216, -122.424370639893)
156182 189998 2 99 1950 18th St 3 9 1 1     8 Width 6ft   6011839.98262 2105629.53813 37.7623245520575 -122.402179893599 (37.7623245520575, -122.402179893599)
166308 225184 2 99 240 Shotwell St 3 1 1 1     8 Width 3ft   6007748.54808 2106641.05965 37.764872732518704 -122.416402325519 (37.7648727325187, -122.416402325519)
173741 206038 2 99 280 Brighton Ave 3 1 1 1     10 Width 3ft   5996260.86716 2091785.79325 37.72343113441671 -122.45506152366998 (37.7234311344167, -122.45506152367)
178754 190010 2 99 499 Arkansas St 3 10 1 1     12 Width 3ft   6013000.60503 2104793.1604 37.7600927575897 -122.398107028633 (37.7600927575897, -122.398107028633)
183926 225156 2 99 104 Franconia St 3 1 1 1     10 Width 2ft   6010015.03813 2099834.46528 37.746310541115896 -122.408083012937 (37.7463105411159, -122.408083012937)
16169 100329 1 99 555 04th St 3 1 1 1   04/01/2012 12:00:00 AM 3 3x3 Permit Number 768623 6013411.2884599995 2111661.36797 37.7789741867392 -122.39716827132 (37.7789741867392, -122.39716827132)
181963 104417 1 99 335 Marina Blvd 3 1 1 1   10/02/2013 12:00:00 AM 12   Permit Number 770730 6001763.35391 2121819.4095799997 37.8062102070855 -122.438190954371 (37.8062102070855, -122.438190954371)
Powered by Datasette · Query took 3.479ms · Data source: data.sfgov.org