sf-trees

Data source: data.sfgov.org

Custom SQL query returning 24 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
17470 29703 3 99 1488X Guerrero St 5 11 1 2   03/30/2006 12:00:00 AM 6     6005875.752859999 2100395.2692 37.7476177497694 -122.42243602910901 (37.7476177497694, -122.422436029109)
17658 29711 3 99 1534X Guerrero St 6 11 1 2   03/30/2006 12:00:00 AM 6     6005892.92513 2100118.18846 37.7468579179619 -122.422356964326 (37.7468579179619, -122.422356964326)
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)
19578 29700 3 99 1488X Guerrero St 2 11 1 2   03/30/2006 12:00:00 AM 6     6005880.5001300005 2100335.27269 37.747453280849 -122.422415350984 (37.747453280849, -122.422415350984)
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)
22275 29704 3 99 1488X Guerrero St 6 11 1 2   03/30/2006 12:00:00 AM 6     6005876.958869999 2100402.60074 37.7476379485377 -122.422432379649 (37.7476379485377, -122.422432379649)
27590 225203 3 99 1534x Guerrero St 2 11 1 2     6 Width 3ft   6005899.22105 2100030.8366400003 37.746618424914296 -122.422328988218 (37.7466184249143, -122.422328988218)
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)
34064 126015 2 99 500 Post St 1 10 1 1     6 Width 3ft   6009674.03362 2115055.86699 37.788085909974605 -122.410336729273 (37.7880859099746, -122.410336729273)
45626 186972 3 99 2500x Sloat Blvd 2 11 1 2     6 Width 0ft   5982510.8573 2096452.0272 37.7354449395599 -122.50293726958999 (37.7354449395599, -122.50293726959)
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)
52220 225202 3 99 1594x Guerrero St 12 11 1 2     6 Width 3ft   6005906.49686 2099871.3036700003 37.7461807941146 -122.422292496403 (37.7461807941146, -122.422292496403)
75852 225160 2 99 3191 21st St 1 1 1 1     6 Width 3ft   6007035.27064 2103785.32086 37.756991400544294 -122.418666844507 (37.7569914005443, -122.418666844507)
90022 73786 1 99 240 Shotwell St 8 1 1 1 1 12/21/1996 12:00:00 AM 6 3x3   6007780.97837226 2105869.55428135 37.7627561815899 -122.41623551068999 (37.7627561815899, -122.41623551069)
131163 225201 3 99 1594x Guerrero St 11 11 1 2     6 Width 3ft   6005907.02025 2099862.53576 37.7461567489521 -122.422290063739 (37.7461567489521, -122.422290063739)
131352 126018 2 99 500 Post St 4 10 1 1     6 Width 3ft   6009631.44446 2115049.8898 37.788067110556604 -122.41048365871 (37.7880671105566, -122.41048365871)
148722 225150 2 99 21 Prospect Ave 1 1 1 1     6 Width 2ft   6007236.93234 2099402.00378 37.744967159016596 -122.417658748554 (37.7449671590166, -122.417658748554)
150087 225171 2 99 106 Coleridge St 1 1 1 1     6 Width 3ft   6006678.67564 2099088.45084 37.7440747833339 -122.419566860849 (37.7440747833339, -122.419566860849)
157709 225159 2 99 3189 21st St 1 1 1 1     6 Width 3ft   6007127.86585 2103790.91823 37.75701198242339 -122.41834701140301 (37.7570119824234, -122.418347011403)
159626 206047 2 99 575 Rockdale Dr 1 9 1 1     6 Width 3ft   5997894.62452 2097851.39191 37.7401794193521 -122.449850874237 (37.7401794193521, -122.449850874237)
163945 206035 3 99 700x Monterey Blvd 18 11 1 2     6 Width 4ft   5996866.22235 2094722.0274099999 37.7315280455795 -122.453180800271 (37.7315280455795, -122.453180800271)
166477 201674 2 99 401 08th St 10 7 1 1     6     6010278.21151 2109773.9479799997 37.773616854257604 -122.407873762259 (37.7736168542576, -122.407873762259)
181010 126016 2 99 500 Post St 2 10 1 1     6 Width 3ft   6009654.60353 2115055.05542 37.7880825923961 -122.410403896944 (37.7880825923961, -122.410403896944)
181433 190032 2 99 651 Missouri St 29 9 1 1     6 Width 7ft   6013600.610230001 2104091.57262 37.7581997512359 -122.395982716627 (37.7581997512359, -122.395982716627)
Powered by Datasette · Query took 2.742ms · Data source: data.sfgov.org