units_with_maps

Table actions

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

2 rows where ACCESS_TYP = 1, AGNCY_NAME = 423 and DES_TP = 3

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

DES_TP 1

  • Local Recreation Area · 2 ✖

ACCESS_TYP 1

  • Open Access · 2 ✖
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
10494 10494 10493 {"type": "Polygon", "coordinates": [[[-120.63498, 35.13975], [-120.63483, 35.13986], [-120.63297, 35.1412], [-120.63286, 35.13966], [-120.63285, 35.13965], [-120.63273, 35.13972], [-120.63268, 35.13915], [-120.63297, 35.13913], [-120.63473, 35.13962], [-120.63498, 35.13975]]]} Open Access 1 18600 Pismo Beach Sports Park 23746 1253 Pismo Beach, City of 423 City 2 City Agency 2 http://www.pismobeach.org/69/Parks-Halls City 2 1253 Pismo Beach, City of 417 City 2 City Agency 2   San Luis Obispo 1 5.906 Pismo Beach Sports Park 0 Local Recreation Area 3 4
10503 10503 10502 {"type": "Polygon", "coordinates": [[[-120.7155, 35.17647], [-120.71532, 35.17671], [-120.71502, 35.17656], [-120.71492, 35.17653], [-120.71464, 35.17652], [-120.7144, 35.17646], [-120.71298, 35.17625], [-120.71214, 35.17602], [-120.712, 35.17597], [-120.71183, 35.17586], [-120.7115, 35.17559], [-120.71136, 35.17551], [-120.71117, 35.17544], [-120.71042, 35.1753], [-120.70961, 35.17522], [-120.70837, 35.17482], [-120.70817, 35.17477], [-120.70797, 35.17475], [-120.70779, 35.17475], [-120.70738, 35.17481], [-120.70727, 35.17481], [-120.70726, 35.17476], [-120.70732, 35.17476], [-120.70733, 35.17474], [-120.70729, 35.1747], [-120.70724, 35.17469], [-120.70745, 35.17424], [-120.70747, 35.17424], [-120.70734, 35.17411], [-120.70737, 35.17408], [-120.70761, 35.1742], [-120.70781, 35.17421], [-120.70781, 35.17419], [-120.70761, 35.17404], [-120.7077, 35.17404], [-120.70804, 35.17422], [-120.70812, 35.17423], [-120.70841, 35.17436], [-120.70857, 35.17448], [-120.70863, 35.17455], [-120.7089, 35.17474], [-120.70902, 35.1748], [-120.70923, 35.17481], [-120.70935, 35.17487], [-120.70968, 35.17501], [-120.7098, 35.17501], [-120.70979, 35.1749], [-120.70988, 35.17483], [-120.70993, 35.17472], [-120.70998, 35.17474], [-120.71015, 35.17471], [-120.71035, 35.17475], [-120.71045, 35.17483], [-120.71073, 35.17479], [-120.71088, 35.17466], [-120.71091, 35.17458], [-120.71088, 35.17451], [-120.71095, 35.17448], [-120.71105, 35.17449], [-120.71117, 35.17458], [-120.71157, 35.17478], [-120.71154, 35.17481], [-120.71163, 35.17486], [-120.71165, 35.17492], [-120.71177, 35.17498], [-120.71177, 35.17501], [-120.71187, 35.17512], [-120.71176, 35.17514], [-120.71177, 35.17519], [-120.71185, 35.17518], [-120.71195, 35.17539], [-120.71185, 35.17562], [-120.71195, 35.17576], [-120.71292, 35.17611], [-120.7146, 35.17641], [-120.7155, 35.17647]]]} Open Access 1 18624 Bluff Coastal Trail 16196 1253 Pismo Beach, City of 423 City 2 City Agency 2 http://www.pismobeach.org/69/Parks-Halls City 2 1253 Pismo Beach, City of 417 City 2 City Agency 2   San Luis Obispo 1 7.316 Bluff Coastal Trail 0 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]);