units_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

6 rows where COUNTY = 15, DES_TP = 3 and MNG_AGENCY = 421

This data as json, copyable, CSV (advanced)

Suggested facets: ACRES, YR_EST

MNG_AG_TYP 1

MNG_AGENCY 1

  • Daly City, City of · 6 ✖

DES_TP 1

  • Local Recreation Area · 6 ✖

ACCESS_TYP 1

Link rowid ▼ id map ACCESS_TYP UNIT_ID UNIT_NAME SUID_NMA AGNCY_ID AGNCY_NAME AGNCY_LEV AGNCY_TYP AGNCY_WEB LAYER MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP PARK_URL COUNTY ACRES LABEL_NAME YR_EST DES_TP GAP_STS
5148 5148 5147 {"type": "Polygon", "coordinates": [[[-122.47214, 37.65904], [-122.47192, 37.65919], [-122.47189, 37.65924], [-122.47161, 37.65914], [-122.47162, 37.65906], [-122.47158, 37.65901], [-122.47176, 37.65883], [-122.47214, 37.65904]]]} Open Access 1 15599 Cameo Tot Lot 28794 1078 Daly City, City of 427 City 2 City Agency 2 http://www.dalycity.org/ City 2 1078 Daly City, City of 421 City 2 City Agency 2   San Mateo 15 0.303 Cameo Tot Lot 1972 Local Recreation Area 3 4
5149 5149 5148 {"type": "Polygon", "coordinates": [[[-122.47106, 37.65288], [-122.47049, 37.65305], [-122.47037, 37.65276], [-122.47096, 37.65265], [-122.47106, 37.65288]]]} Open Access 1 15601 Canterbury Tot Lot 28796 1078 Daly City, City of 427 City 2 City Agency 2 http://www.dalycity.org/ City 2 1078 Daly City, City of 421 City 2 City Agency 2   San Mateo 15 0.402 Canterbury Tot Lot 1969 Local Recreation Area 3 4
5256 5256 5255 {"type": "Polygon", "coordinates": [[[-122.45944, 37.65127], [-122.45942, 37.65138], [-122.45937, 37.65145], [-122.45928, 37.65151], [-122.45917, 37.65153], [-122.45905, 37.65152], [-122.45887, 37.65145], [-122.4588, 37.65138], [-122.45877, 37.65129], [-122.45877, 37.65123], [-122.45944, 37.65127]]]} Open Access 1 15597 Camelot Tot Lot 28793 1078 Daly City, City of 427 City 2 City Agency 2 http://www.dalycity.org/ City 2 1078 Daly City, City of 421 City 2 City Agency 2   San Mateo 15 0.361 Camelot Tot Lot 1972 Local Recreation Area 3 4
8841 8841 8840 {"type": "Polygon", "coordinates": [[[-122.46503, 37.70656], [-122.46473, 37.70672], [-122.46448, 37.70646], [-122.46452, 37.70643], [-122.46498, 37.7065], [-122.46503, 37.70656]]]} Open Access 1 46693 John Daly Tot Lot 30038 1078 Daly City, City of 427 City 2 City Agency 2 http://www.dalycity.org/ City 2 1078 Daly City, City of 421 City 2 City Agency 2   San Mateo 15 0.189 John Daly Tot Lot 0 Local Recreation Area 3 4
9337 9337 9336 {"type": "Polygon", "coordinates": [[[-122.46174, 37.65483], [-122.46141, 37.65508], [-122.46109, 37.65483], [-122.4614, 37.65458], [-122.46174, 37.65483]]]} Open Access 1 15604 Hampshire Tot Lot 28797 1078 Daly City, City of 427 City 2 City Agency 2 http://www.dalycity.org/ City 2 1078 Daly City, City of 421 City 2 City Agency 2   San Mateo 15 0.402 Hampshire Tot Lot 1972 Local Recreation Area 3 4
9339 9339 9338 {"type": "Polygon", "coordinates": [[[-122.46717, 37.65442], [-122.46684, 37.65445], [-122.46683, 37.65457], [-122.46653, 37.65456], [-122.46654, 37.65449], [-122.46649, 37.65441], [-122.46641, 37.65438], [-122.46632, 37.65439], [-122.46624, 37.65412], [-122.46683, 37.65403], [-122.46688, 37.65431], [-122.46681, 37.65432], [-122.46683, 37.65441], [-122.46717, 37.65438], [-122.46717, 37.65442]]]} Open Access 1 15606 Lycett Tot Lot 28798 1078 Daly City, City of 427 City 2 City Agency 2 http://www.dalycity.org/ City 2 1078 Daly City, City of 421 City 2 City Agency 2   San Mateo 15 0.601 Lycett Tot Lot 1980 Local Recreation Area 3 4

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE units_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  UNIT_ID INT,
  UNIT_NAME TEXT,
  SUID_NMA INT,
  AGNCY_ID INT,
  AGNCY_NAME INT,
  AGNCY_LEV INT,
  AGNCY_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  PARK_URL TEXT,
  COUNTY INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
  DES_TP INT,
  GAP_STS TEXT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]),
   FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]),
   FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]),
   FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]),
   FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]),
   FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]),
   FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]),
   FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]),
   FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]),
   FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id])
);
CREATE INDEX [idx_units_with_maps_DES_TP]
    ON [units_with_maps] ([DES_TP]);
CREATE INDEX [idx_units_with_maps_COUNTY]
    ON [units_with_maps] ([COUNTY]);
CREATE INDEX [idx_units_with_maps_MNG_AG_TYP]
    ON [units_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_units_with_maps_MNG_AG_LEV]
    ON [units_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_units_with_maps_MNG_AGENCY]
    ON [units_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_units_with_maps_LAYER]
    ON [units_with_maps] ([LAYER]);
CREATE INDEX [idx_units_with_maps_AGNCY_TYP]
    ON [units_with_maps] ([AGNCY_TYP]);
CREATE INDEX [idx_units_with_maps_AGNCY_LEV]
    ON [units_with_maps] ([AGNCY_LEV]);
CREATE INDEX [idx_units_with_maps_AGNCY_NAME]
    ON [units_with_maps] ([AGNCY_NAME]);
CREATE INDEX [idx_units_with_maps_ACCESS_TYP]
    ON [units_with_maps] ([ACCESS_TYP]);