sf-trees

Data source: data.sfgov.org

Custom SQL query returning 22 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
185 251243 2 58 299x Chapman St 1 1 1 2       3x3   6008953.0 2098186.0 37.7417246968109 -122.411638974942 (37.7417246968109, -122.411638974942)
3497 247942 4 58 29 Joy St 5 14 1 2     3   Permit Number 775404 6010292.72224 2098904.67919 37.7437730949632 -122.40705728398399 (37.7437730949632, -122.407057283984)
3510 247941 4 58 29 Joy St 4 14 1 2     5   Permit Number 775404 6010287.82636 2098909.7574 37.743786764646 -122.40707457072901 (37.743786764646, -122.407074570729)
3511 247940 4 58 29 Joy St 3 14 1 2     5   Permit Number 775404 6010280.31746 2098909.2881400003 37.7437850559498 -122.407100501782 (37.7437850559498, -122.407100501782)
17436 29576 3 58 400X Junipero Serra Blvd 5 11 1 2   04/01/2007 12:00:00 AM 3 3X3   5991377.92956 2094240.4375599998 37.7298896363903 -122.47211961513099 (37.7298896363903, -122.472119615131)
17688 29574 3 58 400X Junipero Serra Blvd 7 11 1 2     9 3X3   5991374.696380001 2094208.91815 37.729802904883 -122.472128495928 (37.729802904883, -122.472128495928)
18868 15071 3 58 1X Minerva St 3 11 1 2     3 11   5995959.8595900005 2089005.6685900001 37.7157802951115 -122.45590116312201 (37.7157802951115, -122.455901163122)
19241 116677 3 58 100 Esmeralda Ave 16 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
24677 111241 3 58 745X SANCHEZ ST 4 3 1 2     6     6003713.0 2103768.0 37.7567562336472 -122.430155272915 (37.7567562336472, -122.430155272915)
34874 175804 3 58 500x Mansell St 7 11 1 2     12 Width 0ft   6010489.90873 2090338.0061700002 37.72026185429429 -122.40577215548402 (37.7202618542943, -122.405772155484)
56364 204718 3 58 1485x Northwood Dr 6 3 1 2     3     5995836.31697 2094012.72029 37.7295213774971 -122.456690081702 (37.7295213774971, -122.456690081702)
62729 96749 3 58 399X Liberty St 3 1 1 2     6 1.5x2   6003700.0 2103889.2 37.7570882837734 -122.430208878023 (37.7570882837734, -122.430208878023)
75225 204717 3 58 1485x Northwood Dr 5 3 1 2     2     5995876.20042 2094034.0159599998 37.7295821401899 -122.456553740875 (37.7295821401899, -122.456553740875)
79996 96750 3 58 399X Liberty St 4 1 1 2     6 1.5x2   6003700.0 2103889.2 37.7570882837734 -122.430208878023 (37.7570882837734, -122.430208878023)
81119 22153 3 58 1570X Fairfax Ave 4 1 1 2     0 3X3   6015582.155925799 2098251.0940713002 37.742273066345604 -122.388721900676 (37.7422730663456, -122.388721900676)
91704 188404 3 58 1300x De Haro St 10 3 1 2     2     6012258.41015 2102196.39231 37.7529212353325 -122.40049153337401 (37.7529212353325, -122.400491533374)
121505 96747 3 58 399X Liberty St 1 1 1 2     4 1.5x2   6003700.0 2103889.2 37.7570882837734 -122.430208878023 (37.7570882837734, -122.430208878023)
127057 116678 3 58 100 Esmeralda Ave 17 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
145019 96748 3 58 399X Liberty St 2 1 1 2     4 1.5x2   6003700.0 2103889.2 37.7570882837734 -122.430208878023 (37.7570882837734, -122.430208878023)
165288 188407 3 58 1300x De Haro St 5 3 1 2     6     6012285.79175 2102196.41625 37.7529228280459 -122.400396843734 (37.7529228280459, -122.400396843734)
171476 188405 3 58 1300x De Haro St 9 3 1 2     9     6012256.82794 2102204.54617 37.752943535820606 -122.400497577699 (37.7529435358206, -122.400497577699)
185898 188406 3 58 1300x De Haro St 6 3 1 2     6 Width 9ft   6012288.20028 2102185.92507 37.75289415586 -122.400387777694 (37.75289415586, -122.400387777694)
Powered by Datasette · Query took 4.503ms · Data source: data.sfgov.org