trees

Custom SQL query returning 60 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
97976 13567 1 148 484X Market St 1 Sidewalk: Curb side : Cutout Tree 1   02/10/2007 12:00:00 AM 6 4x4   6012939.9788554 2116125.819916 37.791206285852 -122.399112186297 (37.791206285852, -122.399112186297) 4 2 10 28860 6
93294 13520 1 148 388 Market St 3 Sidewalk: Curb side : Cutout Tree 1     30 4X4   6013190.8445953 2116364.9078359 37.7918767419323 -122.3982609742 (37.7918767419323, -122.3982609742) 4 2 10 28860 6
148304 28020 7 148 100 The Embarcadero 17 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 6 3X3   6014303.72001 2117502.15301 37.795061278092 -122.394490060779 (37.795061278092, -122.394490060779) 4 2 10 28860 6
113760 28019 7 148 100 The Embarcadero 16 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 6 3X3   6014278.76301 2117533.62001 37.7951462916621 -122.394578620953 (37.7951462916621, -122.394578620953) 4 2 10 28860 6
153960 28018 7 148 100 The Embarcadero 15 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 6 3X3   6014268.99801 2117554.23701 37.7952023582244 -122.394613854051 (37.7952023582244, -122.394613854051) 4 2 10 28860 6
65902 28017 7 148 100 The Embarcadero 14 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 6 3X3   6014258.14701 2117577.02301 37.7952643199629 -122.394652996927 (37.7952643199629, -122.394652996927) 4 2 10 28860 6
65056 28016 7 148 100 The Embarcadero 13 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 6 3X3   6014245.12601 2117603.06501 37.7953351012525 -122.394699876607 (37.7953351012525, -122.394699876607) 4 2 10 28860 6
188165 28015 7 148 100 The Embarcadero 12 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 6 3X3   6014236.44501 2117630.19201 37.7954091029766 -122.39473181516 (37.7954091029766, -122.39473181516) 4 2 10 28860 6
20337 28014 7 148 100 The Embarcadero 11 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 6 3X3   6014226.68001 2117656.23301 37.7954800625202 -122.394767428538 (37.7954800625202, -122.394767428538) 4 2 10 28860 6
89848 28013 7 148 100 The Embarcadero 10 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 6 3X3   6014214.74401 2117682.27501 37.7955509040886 -122.394810554146 (37.7955509040886, -122.394810554146) 4 2 10 28860 6
117657 28012 7 148 100 The Embarcadero 9 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 6 3X3   6014204.97801 2117711.57201 37.7956308037617 -122.394846399273 (37.7956308037617, -122.394846399273) 4 2 10 28860 6
9581 28011 7 148 100 The Embarcadero 8 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 6 3X3   6014191.95801 2117739.78401 37.795707543335 -122.394893427962 (37.795707543335, -122.394893427962) 4 2 10 28860 6
108085 28010 7 148 100 The Embarcadero 7 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 6 3X3   6014178.93701 2117764.74001 37.7957753426227 -122.394940232051 (37.7957753426227, -122.394940232051) 4 1 10 28860 6
181478 28009 7 148 100 The Embarcadero 6 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 6 3X3   6014164.83101 2117791.86701 37.7958490426136 -122.394990942689 (37.7958490426136, -122.394990942689) 4 1 10 28860 6
136264 28008 7 148 100 The Embarcadero 5 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 6 3x3   6014135.53401 2117846.12001 37.7959963794451 -122.395096118536 (37.7959963794451, -122.395096118536) 3 2 10 28860 6
177314 28007 7 148 100 The Embarcadero 4 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 6 3X3   6014117.08801 2117880.84301 37.7960906948417 -122.395162379187 (37.7960906948417, -122.395162379187) 3 2 10 28860 6
114609 101514 1 148 240X DRUMM ST 5 Sidewalk: Curb side : Cutout Tree 5   11/30/2012 12:00:00 AM   3x3 Permit Number 769442 6013870 2117910 37.796157009088 -122.396019403228 (37.796157009088, -122.396019403228) 3 1 10 28860 6
11651 28006 7 148 100 The Embarcadero 3 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 6 3X3   6014086.70601 2117927.50101 37.7962171170916 -122.395270777766 (37.7962171170916, -122.395270777766) 3 2 10 28860 6
168910 28005 7 148 100 The Embarcadero 2 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 6 3X3   6014065.00401 2117953.54201 37.796287412573 -122.395347696851 (37.796287412573, -122.395347696851) 3 2 10 28860 6
119843 28004 7 148 100 The Embarcadero 1 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 6 3X3   6014041.13301 2117989.35001 37.7963844052449 -122.39543280592 (37.7963844052449, -122.39543280592) 3 2 10 28860 6
67552 27792 7 148 199X The Embarcadero 9 Median : Cutout Tree 6     12     6014015.4653372 2118064.3876984 37.7965890133894 -122.395526881953 (37.7965890133894, -122.395526881953) 3 1 10 28860 6
110174 27789 7 148 199X The Embarcadero 6 Median : Cutout Tree 6     12     6014015.4653372 2118064.3876984 37.7965890133894 -122.395526881953 (37.7965890133894, -122.395526881953) 3 1 10 28860 6
116952 27791 7 148 199X The Embarcadero 8 Median : Cutout Tree 6     12     6014015.4653372 2118064.3876984 37.7965890133894 -122.395526881953 (37.7965890133894, -122.395526881953) 3 1 10 28860 6
137815 27793 7 148 199X The Embarcadero 10 Median : Cutout Tree 6     12     6014015.4653372 2118064.3876984 37.7965890133894 -122.395526881953 (37.7965890133894, -122.395526881953) 3 1 10 28860 6
145831 27790 7 148 199X The Embarcadero 7 Median : Cutout Tree 6     12     6014015.4653372 2118064.3876984 37.7965890133894 -122.395526881953 (37.7965890133894, -122.395526881953) 3 1 10 28860 6
186329 27794 7 148 199X The Embarcadero 11 Median : Cutout Tree 6     12     6014015.4653372 2118064.3876984 37.7965890133894 -122.395526881953 (37.7965890133894, -122.395526881953) 3 1 10 28860 6
29819 27975 7 148 300 The Embarcadero 12 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
33497 27984 7 148 300 The Embarcadero 21 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
47018 27972 7 148 300 The Embarcadero 9 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
53356 27992 7 148 300 The Embarcadero 29 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
54544 27988 7 148 300 The Embarcadero 25 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
58562 27965 7 148 300 The Embarcadero 2 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
61352 27964 7 148 300 The Embarcadero 1 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
76168 27995 7 148 300 The Embarcadero 32 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
83247 27970 7 148 300 The Embarcadero 7 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
87567 27983 7 148 300 The Embarcadero 20 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
95726 27968 7 148 300 The Embarcadero 5 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
110413 27981 7 148 300 The Embarcadero 18 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
115011 27985 7 148 300 The Embarcadero 22 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
117269 27982 7 148 300 The Embarcadero 19 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
118943 27974 7 148 300 The Embarcadero 11 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
124533 27966 7 148 300 The Embarcadero 3 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
125130 27979 7 148 300 The Embarcadero 16 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
125818 27969 7 148 300 The Embarcadero 6 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
130132 27989 7 148 300 The Embarcadero 26 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
130760 27977 7 148 300 The Embarcadero 14 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
132807 27980 7 148 300 The Embarcadero 17 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
147968 27990 7 148 300 The Embarcadero 27 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
150361 27978 7 148 300 The Embarcadero 15 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
154189 27976 7 148 300 The Embarcadero 13 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
155616 27986 7 148 300 The Embarcadero 23 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
157798 27971 7 148 300 The Embarcadero 8 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
162831 27993 7 148 300 The Embarcadero 30 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
167087 27987 7 148 300 The Embarcadero 24 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
169354 27991 7 148 300 The Embarcadero 28 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
180778 27994 7 148 300 The Embarcadero 31 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
182430 27973 7 148 300 The Embarcadero 10 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
190054 27967 7 148 300 The Embarcadero 4 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
191674 27996 7 148 300 The Embarcadero 33 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
88068 27805 7 148 350X The Embarcadero 4 Sidewalk: Curb side : Cutout Tree 6   11/15/2012 12:00:00 AM 12 4x4 Permit Number 769363 6013785.7946449 2118604.8635638 37.7980602547356 -122.396359500707 (37.7980602547356, -122.396359500707) 3 1 10 28860 6