units_with_maps

Table actions

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

8 rows where COUNTY = 1, MNG_AGENCY = 643 and YR_EST = 0

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Grover Beach, City of · 8 ✖

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
3514 3514 3513 {"type": "Polygon", "coordinates": [[[-120.61439, 35.11511], [-120.61433, 35.11594], [-120.61209, 35.11583], [-120.61214, 35.115], [-120.61439, 35.11511]]]} Open Access 1 26522 Mentone Basin Park 22157 1452 Grover Beach, City of 654 City 2 City Agency 2 http://www.grover.org/index.aspx?nid=141 City 2 1452 Grover Beach, City of 643 City 2 City Agency 2   San Luis Obispo 1 4.654 Mentone Basin Park 0 Local Park 2 4
3670 3670 3669 {"type": "Polygon", "coordinates": [[[-120.61242, 35.11026], [-120.61236, 35.11057], [-120.61232, 35.11061], [-120.61228, 35.11061], [-120.61184, 35.11056], [-120.61162, 35.11056], [-120.61162, 35.11015], [-120.61204, 35.11017], [-120.61239, 35.11023], [-120.61242, 35.11026]]]} Open Access 1 44247 Hero Community Park 19875 1452 Grover Beach, City of 654 City 2 City Agency 2 http://www.grover.org/index.aspx?nid=141 City 2 1452 Grover Beach, City of 643 City 2 City Agency 2   San Luis Obispo 1 0.771 Hero Community Park 0 Local Park 2 4
12381 12381 12380 {"type": "Polygon", "coordinates": [[[-120.62008, 35.12262], [-120.62005, 35.12313], [-120.61953, 35.12311], [-120.61949, 35.12374], [-120.619, 35.12372], [-120.61908, 35.12257], [-120.62008, 35.12262]]]} Open Access 1 26517 Ramona Garden Park 24113 1452 Grover Beach, City of 654 City 2 City Agency 2 http://www.grover.org/index.aspx?nid=141 City 2 1452 Grover Beach, City of 643 City 2 City Agency 2   San Luis Obispo 1 2.054 Ramona Garden Park 0 Local Park 2 4
12382 12382 12381 {"type": "Polygon", "coordinates": [[[-120.62064, 35.12747], [-120.62062, 35.12788], [-120.62023, 35.12788], [-120.62022, 35.12806], [-120.61962, 35.12805], [-120.6196, 35.12831], [-120.61945, 35.12842], [-120.61927, 35.12849], [-120.61901, 35.12917], [-120.61815, 35.12891], [-120.61839, 35.12836], [-120.61837, 35.12795], [-120.61842, 35.12735], [-120.62064, 35.12747]]]} Open Access 1 26518 Grover Heights Park 19536 1452 Grover Beach, City of 654 City 2 City Agency 2 http://www.grover.org/index.aspx?nid=141 City 2 1452 Grover Beach, City of 643 City 2 City Agency 2   San Luis Obispo 1 6.012 Grover Heights Park 0 Local Park 2 4
12383 12383 12382 {"type": "Polygon", "coordinates": [[[-120.61031, 35.12154], [-120.61029, 35.12194], [-120.60969, 35.12191], [-120.60971, 35.12151], [-120.61031, 35.12154]]]} Open Access 1 26519 South County Skate Park 25645 1452 Grover Beach, City of 654 City 2 City Agency 2 http://www.grover.org/index.aspx?nid=141 City 2 1452 Grover Beach, City of 643 City 2 City Agency 2   San Luis Obispo 1 0.608 South County Skate Park 0 Local Recreation Area 3 4
12384 12384 12383 {"type": "Polygon", "coordinates": [[[-120.61198, 35.11407], [-120.61192, 35.1148], [-120.60972, 35.11469], [-120.60972, 35.11439], [-120.60966, 35.11409], [-120.61027, 35.11394], [-120.61038, 35.11396], [-120.6107, 35.11398], [-120.61068, 35.114], [-120.61069, 35.11401], [-120.61198, 35.11407]]]} Open Access 1 26521 16th Street Park 15175 1452 Grover Beach, City of 654 City 2 City Agency 2 http://www.grover.org/index.aspx?nid=141 City 2 1452 Grover Beach, City of 643 City 2 City Agency 2   San Luis Obispo 1 4.082 16th Street Park 0 Local Park 2 4
12460 12460 12459 {"type": "Polygon", "coordinates": [[[-120.60826, 35.11002], [-120.60826, 35.1106], [-120.60753, 35.1106], [-120.60746, 35.11057], [-120.60745, 35.11003], [-120.60826, 35.11002]]]} Open Access 1 48759 Costa Bella Park 33486 1452 Grover Beach, City of 654 City 2 City Agency 2 http://www.grover.org/index.aspx?nid=141 City 2 1452 Grover Beach, City of 643 City 2 City Agency 2   San Luis Obispo 1 1.155 Costa Bella Park 0 Local Park 2 4
14298 14298 14297 {"type": "Polygon", "coordinates": [[[-120.61047, 35.10757], [-120.61022, 35.10769], [-120.61023, 35.10811], [-120.61013, 35.10811], [-120.61013, 35.10769], [-120.60987, 35.10757], [-120.60988, 35.10752], [-120.60987, 35.10747], [-120.61013, 35.10735], [-120.61012, 35.10693], [-120.6102, 35.10693], [-120.61021, 35.10734], [-120.61047, 35.10746], [-120.61045, 35.10751], [-120.61047, 35.10757]]]} Open Access 1 44260 Golden West Park 19376 1452 Grover Beach, City of 654 City 2 City Agency 2 http://www.grover.org/index.aspx?nid=141 City 2 1452 Grover Beach, City of 643 City 2 City Agency 2   San Luis Obispo 1 0.533 Golden West Park 0 Local Park 2 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]);