sf-trees

Data source: data.sfgov.org

Custom SQL query returning 33 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
4319 221466 3 109 300x Guerrero St 11 11 1 2   06/19/2015 10:17:00 AM 2 Width 3ft   6005511.21858 2106780.74139 37.7651301958204 -122.42415061986601 (37.7651301958204, -122.424150619866)
4325 221461 3 109 300x Guerrero St 6 11 1 2   06/19/2015 10:37:00 AM 2 Width 3ft   6005500.86915 2106969.86586 37.7656489022957 -122.42419986763399 (37.7656489022957, -122.424199867634)
4332 221460 3 109 300x Guerrero St 5 11 1 2   06/19/2015 10:41:00 AM 2 Width 3ft   6005499.89777 2107004.0817 37.76574279600489 -122.424205661071 (37.7657427960049, -122.424205661071)
4334 221464 3 109 300x Guerrero St 9 11 1 2   06/19/2015 10:25:00 AM 2 Width 3ft   6005509.872909999 2106837.4843200003 37.7652859224425 -122.42415931 (37.7652859224425, -122.42415931)
4373 221456 3 109 300x Guerrero St 1 11 1 2   06/19/2015 10:59:00 AM 2 Width 3ft   6005491.36744 2107155.48275 37.7661580255906 -122.424245934501 (37.7661580255906, -122.424245934501)
4379 221468 3 109 400x Guerrero St 1 11 1 2   04/29/2015 10:37:00 AM 2 Width 3ft   6005525.86145 2106563.70328 37.764535087455 -122.42408453767099 (37.764535087455, -122.424084537671)
4384 221465 3 109 300x Guerrero St 10 11 1 2   06/19/2015 10:21:00 AM 2 Width 3ft   6005511.348730001 2106807.4282299997 37.76520347889029 -122.42415206777599 (37.7652034788903, -122.424152067776)
4403 221458 3 109 300x Guerrero St 3 11 1 2   06/19/2015 10:49:00 AM 2 Width 3ft   6005493.2574 2107088.45627 37.7659740935515 -122.424234630048 (37.7659740935515, -122.424234630048)
4454 221495 3 109 600x Guerrero St 2 11 1 2   02/21/2015 10:54:00 PM 2 Width 3ft   6005593.17627 2105367.35468 37.761253997298205 -122.42376664264299 (37.7612539972982, -122.423766642643)
4478 221500 3 109 600x Guerrero St 7 11 1 2   02/28/2015 11:10:00 PM 2 Width 3ft   6005602.08318 2105171.2083400004 37.7607159284129 -122.423721890569 (37.7607159284129, -122.423721890569)
4481 221502 3 109 600x Guerrero St 9 11 1 2   02/21/2015 11:07:00 PM 2 Width 3ft   6005607.7078 2105081.85863 37.760470912626296 -122.42369608451 (37.7604709126263, -122.42369608451)
4487 221504 3 109 600x Guerrero St 11 11 1 2   02/21/2015 11:05:00 PM 2 Width 3ft   6005611.75297 2105011.45268 37.7602778227802 -122.42367708812901 (37.7602778227802, -122.423677088129)
4491 221497 3 109 600x Guerrero St 4 11 1 2   02/21/2015 10:57:00 PM 2 Width 3ft   6005595.06917 2105295.4476799998 37.761056664463204 -122.42375498292499 (37.7610566644632, -122.423754982925)
4499 221499 3 109 600x Guerrero St 6 11 1 2   02/28/2015 11:01:00 PM 2 Width 3ft   6005601.090469999 2105206.48742 37.760812740428904 -122.42372783238899 (37.7608127404289, -122.423727832389)
4507 221494 3 109 600x Guerrero St 1 11 1 2   02/21/2015 10:53:00 PM 2 Width 3ft   6005589.49697 2105398.2938599996 37.7613387412987 -122.423781567769 (37.7613387412987, -122.423781567769)
4517 221503 3 109 600x Guerrero St 10 11 1 2   02/21/2015 11:06:00 PM 2 Width 3ft   6005610.53101 2105047.42068 37.7603765134773 -122.423683871708 (37.7603765134773, -122.423683871708)
4523 221496 3 109 600x Guerrero St 3 11 1 2   02/21/2015 12:00:00 AM 2 Width 3ft   6005594.03058 2105332.56679 37.761158526170895 -122.423761214331 (37.7611585261709, -122.423761214331)
4526 221501 3 109 600x Guerrero St 8 11 1 2   02/21/2015 11:08:00 PM 2 Width 3ft   6005604.17413 2105138.97106 37.7606275304574 -122.423712366728 (37.7606275304574, -122.423712366728)
30827 221416 3 109 800x Guerrero St 2 11 1 2     2 Width 3ft   6005677.18728 2103848.76992 37.757089061516204 -122.42336812603399 (37.7570890615162, -122.423368126034)
34286 221545 3 109 1000x Guerrero St 1 11 1 2     2 Width 3ft   6005721.87722 2103062.7074700003 37.754933239094704 -122.423157698184 (37.7549332390947, -122.423157698184)
38301 221488 3 109 500x Guerrero St 8 11 1 2     2 Width 3ft   6005571.71667 2105739.51079 37.7622746387822 -122.42386732621999 (37.7622746387822, -122.42386732622)
45394 203292 2 109 10 Jules Ave 2 1 1 1     2 Width 2ft   5994458.02189 2089982.3581700001 37.7183757412389 -122.461162923744 (37.7183757412389, -122.461162923744)
46563 221509 2 109 1201 San Jose Ave 38 7 1 1     2     6004439.440880001 2096038.0117799998 37.735572586401894 -122.42709240931102 (37.7355725864019, -122.427092409311)
47104 221492 3 109 500x Guerrero St 12 11 1 2     2 Width 3ft   6005579.45797 2105601.3239599997 37.761895647375205 -122.42383072560301 (37.7618956473752, -122.423830725603)
48680 221505 3 109 600x Guerrero St 12 11 1 2     2 Width 3ft   6005615.32825 2104975.43597 37.760179131174795 -122.423662162075 (37.7601791311748, -122.423662162075)
51561 221489 3 109 500x Guerrero St 9 11 1 2     2 Width 3ft   6005574.236269999 2105711.57302 37.7621980705008 -122.423856625205 (37.7621980705008, -122.423856625205)
52085 221487 3 109 500x Guerrero St 7 11 1 2     2 Width 3ft   6005570.243559999 2105766.57088 37.762348856238205 -122.42387434542101 (37.7623488562382, -122.423874345421)
65305 221484 3 109 500x Guerrero St 4 11 1 2     2 Width 3ft   6005563.22827 2105880.05418 37.7626600585326 -122.42390667874399 (37.7626600585326, -122.423906678744)
75610 221438 3 109 100x Guerrero St 11 11 1 2     2 Width 3ft   6005446.19377 2108068.2932700003 37.7686618344154 -122.42446711555901 (37.7686618344154, -122.424467115559)
143107 221551 3 109 1000x Guerrero St 9 11 1 2     2 Width 3ft   6005731.5319 2102850.00284 37.7543497463656 -122.423109191463 (37.7543497463656, -122.423109191463)
159086 221493 3 109 500x Guerrero St 13 11 1 2     2 Width 3ft   6005583.08285 2105563.4275 37.7617917972666 -122.42381549380801 (37.7617917972666, -122.423815493808)
169767 221481 3 109 500x Guerrero St 1 11 1 2     2 Width 3ft   6005557.328430001 2105982.39063 37.7629407171602 -122.423934361684 (37.7629407171602, -122.423934361684)
182798 221555 3 109 1000x Guerrero St 13 11 1 2     2 Width 3ft   6005738.9106 2102712.57542 37.753972818908 -122.423073906548 (37.753972818908, -122.423073906548)
Powered by Datasette · Query took 4.916ms · Data source: data.sfgov.org