sf-trees

Data source: data.sfgov.org

Custom SQL query returning 35 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
162586 183640 2 48 1484 47th Ave 3 2 1 1     3 Width 0ft   5981572.1323 2104991.2828 37.7588361283195 -122.506815916291 (37.7588361283195, -122.506815916291)
164615 250999 2 48 206 Point Lobos Ave 2 2 1 1     2 Width 3ft   5982160.80138 2112648.7463599998 37.7798959540729 -122.505347618625 (37.7798959540729, -122.505347618625)
175623 184549 2 48 3501 Moraga St 3 2 1 1     1 Width 0ft   5983411.1343 2103548.3965 37.754982490057 -122.50034921882099 (37.754982490057, -122.500349218821)
70054 184494 2 48 1875 38th Ave 2 2 1 1     3 Width 0ft   5984410.615 2102424.5695 37.7519553887834 -122.496809845733 (37.7519553887834, -122.496809845733)
72194 121883 2 48 50 18th Ave 5 2 1 1     5 Width 5ft   5990230.48175 2114847.31405 37.786404156248004 -122.477592056385 (37.786404156248, -122.477592056385)
35773 121884 2 48 50 18th Ave 4 2 1 1     3 Width 5ft   5990230.5783400005 2114834.8193200002 37.78636985483121 -122.477590808601 (37.7863698548312, -122.477590808601)
157266 207035 2 48 100 Quintara St 3 2 1 1     4 Width 3ft   5993108.07657 2101214.12996 37.749137613916396 -122.46664505153299 (37.7491376139164, -122.466645051533)
172822 207034 2 48 100 Quintara St 2 2 1 1     4 Width 3ft   5993127.0368800005 2101215.11136 37.7491414027515 -122.466579558421 (37.7491414027515, -122.466579558421)
132209 207033 2 48 100 Quintara St 1 2 1 1     4 Width 3ft   5993145.27059 2101214.49823 37.74914077145029 -122.46651646199301 (37.7491407714503, -122.466516461993)
50907 207039 2 48 270 Magellan Ave 3 2 1 1     2 Width 4ft   5994635.03268 2100302.9111 37.7467236374953 -122.461298810415 (37.7467236374953, -122.461298810415)
56930 207038 2 48 270 Magellan Ave 2 2 1 1     1 Width 4ft   5994641.46146 2100307.8933900003 37.7467376875983 -122.461276941602 (37.7467376875983, -122.461276941602)
4451 216718 2 48 978 Capitol Ave 2 2 1 1   10/13/2017 11:36:00 AM 3 Width 3ft   5995057.03199 2090421.24862 37.7196152839906 -122.45912417326299 (37.7196152839906, -122.459124173263)
169214 207041 2 48 1414 Plymouth Ave 1 2 1 1     8 Width 3ft   5995889.45634 2093373.1410400001 37.727768297568005 -122.456460143934 (37.727768297568, -122.456460143934)
4096 181028 2 48 95 Rolph St 2 2 1 1   10/05/2017 04:38:00 PM 3 Width 4ft   6000533.08885 2088674.4676599998 37.715132307492794 -122.44007027934201 (37.7151323074928, -122.440070279342)
4113 181027 2 48 95 Rolph St 1 2 1 1   10/05/2017 04:23:00 PM 3 Width 4ft   6000546.58685 2088667.2481099998 37.7151132526545 -122.440023107188 (37.7151132526545, -122.440023107188)
4220 181020 2 48 183 Rolph St 1 2 1 1   10/10/2017 12:41:00 PM 3 Width 4ft   6000952.49174 2088426.9301099998 37.714476492181895 -122.438602919392 (37.7144764921819, -122.438602919392)
4245 181019 2 48 191 Rolph St 1 2 1 1   10/10/2017 12:36:00 PM 3 Width 4ft   6000981.45407 2088409.26942 37.714429647391896 -122.438501549606 (37.7144296473919, -122.438501549606)
4273 181018 2 48 197 Rolph St 2 2 1 1   10/10/2017 11:31:00 AM 3 Width 4ft   6001005.57228 2088396.0469099998 37.714394713229105 -122.43841724088999 (37.7143947132291, -122.43841724089)
4227 181017 2 48 197 Rolph St 1 2 1 1   10/10/2017 11:28:00 AM 3 Width 4ft   6001019.31887 2088386.79799 37.7143700996689 -122.43836906510201 (37.7143700996689, -122.438369065102)
4306 181011 2 48 207 Rolph St 1 2 1 1   10/10/2017 11:21:00 AM 3 Width 4ft   6001121.315830001 2088326.0025400002 37.714208969932706 -122.438012171843 (37.7142089699327, -122.438012171843)
4257 181010 2 48 215 Rolph St 1 2 1 1   10/10/2017 11:17:00 AM 3 Width 4ft   6001139.6561 2088316.9005900002 37.7141850209845 -122.437948129327 (37.7141850209845, -122.437948129327)
134721 227548 2 48 290 Jersey St 1 2 1 1     2 Width 3ft   6003268.76291 2101573.30364 37.7507049460775 -122.43153493071199 (37.7507049460775, -122.431534930712)
12904 117426 1 48 395 Athens St 1 2 1 1   06/14/2016 12:00:00 AM 3   Permit Number 775297 6003998.920059999 2091015.17385 37.7217560742586 -122.428257595231 (37.7217560742586, -122.428257595231)
33343 227094 2 48 100 Alemany Blvd 35 2 1 1     2     6009153.630890001 2095762.56962 37.7350817355269 -122.410774146024 (37.7350817355269, -122.410774146024)
33605 227093 2 48 100 Alemany Blvd 31 2 1 1     3 Width 9ft   6009184.481319999 2095791.0539799999 37.7351616771725 -122.41066949551201 (37.7351616771725, -122.410669495512)
171469 227092 2 48 100 Alemany Blvd 30 2 1 1     3 Width 9ft   6009197.49082 2095788.0482299998 37.7351541534232 -122.410624304588 (37.7351541534232, -122.410624304588)
171127 227091 2 48 100 Alemany Blvd 29 2 1 1     8 Width 5ft   6009293.034440001 2095834.7354700002 37.735287702767 -122.410297269721 (37.735287702767, -122.410297269721)
170337 227090 2 48 100 Alemany Blvd 22 2 1 1     8 Width 3ft   6009411.625 2095915.20486 37.7355153013828 -122.40989293540702 (37.7355153013828, -122.409892935407)
134809 227089 2 48 100 Alemany Blvd 17 2 1 1     2 Width 4ft   6009456.29094 2095946.4902299999 37.735603707435395 -122.409740715285 (37.7356037074354, -122.409740715285)
41197 227088 2 48 100 Alemany Blvd 12 2 1 1     2 Width 5ft   6009533.30641 2096029.17809 37.7358350661275 -122.409480276115 (37.7358350661275, -122.409480276115)
59198 227086 2 48 100 Alemany Blvd 6 2 1 1     4 Width 5ft   6009619.77164 2096165.8193400002 37.7362150980513 -122.409190969587 (37.7362150980513, -122.409190969587)
2387 201822 2 48 100 Friedell St 6 2 1 1   07/12/2017 12:00:00 AM 3 Width 4ft   6021035.49669 2093250.0299200001 37.72884183267921 -122.36952018972299 (37.7288418326792, -122.369520189723)
2383 201821 2 48 100 Friedell St 5 2 1 1   07/12/2017 12:00:00 AM 3 Width 4ft   6021045.51426 2093266.4470799998 37.7288874606638 -122.369486691782 (37.7288874606638, -122.369486691782)
2408 201820 2 48 100 Friedell St 4 2 1 1   07/12/2017 12:00:00 AM 3 Width 4ft   6021056.53291 2093279.09213 37.728922786051506 -122.369449472416 (37.7289227860515, -122.369449472416)
2417 201819 2 48 100 Friedell St 3 2 1 1   07/12/2017 12:00:00 AM 3 Width 4ft   6021071.50009 2093300.7706900002 37.7289831323462 -122.369399226393 (37.7289831323462, -122.369399226393)
Powered by Datasette · Query took 20.266ms · Data source: data.sfgov.org