units_with_maps

Table actions

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

1 row where DES_TP = 39, MNG_AGENCY = 47 and YR_EST = 1953

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • California Department of Parks and Recreation · 1 ✖

DES_TP 1

  • State Recreation Area · 1 ✖

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
16656 16656 16655 {"type": "Polygon", "coordinates": [[[-120.96193, 37.35067], [-120.962, 37.35072], [-120.96207, 37.3508], [-120.96213, 37.35095], [-120.96211, 37.35115], [-120.96206, 37.35124], [-120.96192, 37.35138], [-120.96152, 37.35189], [-120.9613, 37.35212], [-120.96071, 37.35284], [-120.9605, 37.35328], [-120.96046, 37.35359], [-120.9605, 37.35393], [-120.96063, 37.35428], [-120.96074, 37.35474], [-120.96081, 37.35527], [-120.96074, 37.35593], [-120.96058, 37.3567], [-120.96042, 37.35757], [-120.96034, 37.35831], [-120.96019, 37.35881], [-120.9598, 37.35945], [-120.9593, 37.36001], [-120.95894, 37.36026], [-120.95783, 37.35936], [-120.95664, 37.35954], [-120.95616, 37.35943], [-120.95548, 37.35945], [-120.95475, 37.35896], [-120.95512, 37.35769], [-120.95537, 37.35766], [-120.95565, 37.35766], [-120.956, 37.35776], [-120.95626, 37.35791], [-120.95651, 37.35809], [-120.9568, 37.35827], [-120.95711, 37.35851], [-120.9574, 37.35866], [-120.95779, 37.35872], [-120.95815, 37.35866], [-120.95839, 37.35852], [-120.95853, 37.35834], [-120.95863, 37.35812], [-120.95869, 37.35785], [-120.95861, 37.35722], [-120.95861, 37.35687], [-120.9587, 37.3566], [-120.95892, 37.3564], [-120.95933, 37.35616], [-120.95976, 37.35596], [-120.96012, 37.35574], [-120.96035, 37.35552], [-120.96046, 37.3553], [-120.9605, 37.35497], [-120.96044, 37.35471], [-120.96022, 37.35446], [-120.96009, 37.35417], [-120.95991, 37.35393], [-120.95956, 37.35359], [-120.95938, 37.35325], [-120.95911, 37.35285], [-120.9589, 37.35247], [-120.95857, 37.35224], [-120.95731, 37.35186], [-120.95657, 37.35153], [-120.95632, 37.35132], [-120.95618, 37.35112], [-120.95608, 37.35084], [-120.95606, 37.35043], [-120.95638, 37.34955], [-120.95655, 37.34925], [-120.95686, 37.34915], [-120.95735, 37.34909], [-120.95782, 37.34913], [-120.95816, 37.34927], [-120.95852, 37.34948], [-120.95876, 37.34971], [-120.95897, 37.35], [-120.9593, 37.35058], [-120.95955, 37.35088], [-120.95985, 37.35105], [-120.96017, 37.35116], [-120.96056, 37.35117], [-120.96108, 37.35109], [-120.96128, 37.35104], [-120.96173, 37.35086], [-120.96193, 37.35067]]]} Open Access 1 16880 George J. Hatfield State Recreation Area 1547 204 California Department of Parks and Recreation 48 State 5 State Agency 5 http://www.parks.ca.gov/ California Department of Parks and Recreation 9 204 California Department of Parks and Recreation 47 State 5 State Agency 5 http://www.parks.ca.gov/?page_id=556 Merced 37 61.406 George J. Hatfield SRA 1953 State Recreation Area 39 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]);