units_with_maps

Table actions

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

2 rows where AGNCY_TYP = 5, COUNTY = 37, DES_TP = 39 and MNG_AG_TYP = 5

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • State Agency · 2 ✖

DES_TP 1

  • State Recreation Area · 2 ✖

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
16643 16643 16642 {"type": "MultiPolygon", "coordinates": [[[[-120.71064, 37.41137], [-120.71033, 37.41164], [-120.71023, 37.41171], [-120.71021, 37.41179], [-120.71045, 37.41221], [-120.71068, 37.41275], [-120.71082, 37.41315], [-120.71082, 37.41343], [-120.7108, 37.4138], [-120.71073, 37.414], [-120.71042, 37.41446], [-120.71023, 37.41462], [-120.70997, 37.41468], [-120.7098, 37.41468], [-120.70954, 37.4146], [-120.70927, 37.41459], [-120.70905, 37.4147], [-120.70879, 37.41547], [-120.70862, 37.41609], [-120.70839, 37.41633], [-120.70804, 37.41653], [-120.70761, 37.41651], [-120.70716, 37.41646], [-120.7068, 37.41639], [-120.70668, 37.41632], [-120.70707, 37.41615], [-120.70789, 37.41564], [-120.70829, 37.41431], [-120.70867, 37.41332], [-120.70864, 37.41249], [-120.70893, 37.41152], [-120.70876, 37.41146], [-120.70886, 37.41135], [-120.71064, 37.41137]]], [[[-120.71347, 37.41563], [-120.71346, 37.41689], [-120.7131, 37.41716], [-120.71202, 37.4173], [-120.7119, 37.41785], [-120.71141, 37.41845], [-120.71067, 37.41842], [-120.70995, 37.41796], [-120.70744, 37.41669], [-120.70763, 37.41672], [-120.70816, 37.41674], [-120.70862, 37.41648], [-120.70889, 37.41618], [-120.70908, 37.41553], [-120.70932, 37.41478], [-120.70954, 37.4148], [-120.7098, 37.41488], [-120.71006, 37.41488], [-120.71041, 37.4148], [-120.71068, 37.41458], [-120.71099, 37.41408], [-120.71109, 37.41383], [-120.71113, 37.41313], [-120.71073, 37.41215], [-120.71053, 37.4118], [-120.71053, 37.41174], [-120.71057, 37.41167], [-120.71074, 37.41152], [-120.71079, 37.41143], [-120.7109, 37.41135], [-120.71224, 37.41135], [-120.71239, 37.41375], [-120.71347, 37.41563]]]]} Open Access 1 16885 McConnell State Recreation Area 1628 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=554 Merced 37 66.96 McConnell SRA 1949 State Recreation Area 39 4
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]);