superunits_with_maps

Table actions

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

1 row where MNG_AGENCY = 47, MNG_AG_TYP = 5 and PARK_URL = "http://www.parks.ca.gov/?page_id=483"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • State Agency · 1 ✖

MNG_AGENCY 1

  • California Department of Parks and Recreation · 1 ✖

ACCESS_TYP 1

Link rowid ▼ id map ACCESS_TYP PARK_NAME PARK_URL SUID_NMA MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP AGNCY_WEB LAYER ACRES LABEL_NAME YR_EST
15188 15188 15187 {"type": "MultiPolygon", "coordinates": [[[[-122.6137, 38.92436], [-122.61259, 38.92436], [-122.6125, 38.9241], [-122.61244, 38.92371], [-122.61213, 38.92371], [-122.61214, 38.92357], [-122.61214, 38.92289], [-122.61212, 38.92272], [-122.61175, 38.92101], [-122.61177, 38.92085], [-122.61196, 38.92047], [-122.61199, 38.92036], [-122.612, 38.92028], [-122.61198, 38.92016], [-122.61194, 38.92004], [-122.61174, 38.91971], [-122.6116, 38.9195], [-122.6114, 38.91928], [-122.6112, 38.91909], [-122.61098, 38.91891], [-122.61044, 38.91858], [-122.61079, 38.91823], [-122.612, 38.91871], [-122.61208, 38.91924], [-122.61214, 38.91953], [-122.61217, 38.91955], [-122.6123, 38.92006], [-122.6125, 38.92076], [-122.61249, 38.92078], [-122.61278, 38.92183], [-122.61279, 38.9221], [-122.61286, 38.92233], [-122.61361, 38.92419], [-122.61367, 38.92426], [-122.6137, 38.92436]]], [[[-122.65537, 38.93773], [-122.65528, 38.93797], [-122.65412, 38.93823], [-122.65316, 38.93918], [-122.6531, 38.93971], [-122.65177, 38.94069], [-122.65153, 38.94055], [-122.65137, 38.94049], [-122.65095, 38.94038], [-122.65064, 38.94023], [-122.65003, 38.94003], [-122.64934, 38.93952], [-122.6491, 38.93941], [-122.64865, 38.93892], [-122.64818, 38.9386], [-122.6479, 38.93836], [-122.64712, 38.93799], [-122.64669, 38.93775], [-122.64621, 38.9373], [-122.64604, 38.9372], [-122.64573, 38.93691], [-122.64571, 38.93683], [-122.64563, 38.93676], [-122.64558, 38.93676], [-122.64551, 38.93666], [-122.64556, 38.93652], [-122.64553, 38.93641], [-122.64561, 38.93602], [-122.64571, 38.93582], [-122.64568, 38.93553], [-122.64448, 38.93519], [-122.64444, 38.93532], [-122.64426, 38.93564], [-122.6442, 38.93569], [-122.64398, 38.93582], [-122.64373, 38.93606], [-122.64367, 38.93613], [-122.64367, 38.93621], [-122.64362, 38.93628], [-122.64349, 38.93633], [-122.64342, 38.93633], [-122.64336, 38.93631], [-122.64327, 38.93621], [-122.64327, 38.9361], [-122.64324, 38.93606], [-122.64108, 38.93787], [-122.63677, 38.938], [-122.63673, 38.93807], [-122.63623, 38.9383], [-122.6363, 38.93853], [-122.63621, 38.93876], [-122.63392, 38.9387], [-122.63313, 38.93878], [-122.63304, 38.93906], [-122.6315, 38.93908], [-122.63148, 38.93901], [-122.631, 38.93905], [-122.631, 38.93894], [-122.63135, 38.9389], [-122.63138, 38.93777], [-122.63193, 38.93776], [-122.63194, 38.93763], [-122.63196, 38.93767], [-122.63202, 38.93769], [-122.63309, 38.93764], [-122.6331, 38.93585], [-122.63203, 38.93584], [-122.63198, 38.93586], [-122.63195, 38.9359], [-122.63194, 38.93576], [-122.63139, 38.93576], [-122.63141, 38.93353], [-122.63153, 38.9318], [-122.63103, 38.93199], [-122.6307, 38.93203], [-122.63043, 38.93185], [-122.63022, 38.93122], [-122.62962, 38.93081], [-122.6292, 38.93029], [-122.62782, 38.93007], [-122.62721, 38.92968], [-122.6265, 38.9295], [-122.62443, 38.92868], [-122.62369, 38.92807], [-122.62331, 38.92795], [-122.62319, 38.92795], [-122.62264, 38.92777], [-122.62224, 38.92768], [-122.62146, 38.92763], [-122.62104, 38.92756], [-122.62076, 38.92743], [-122.6206, 38.9273], [-122.62043, 38.92711], [-122.62038, 38.92691], [-122.62037, 38.92668], [-122.62002, 38.92625], [-122.61971, 38.92619], [-122.61926, 38.92617], [-122.61902, 38.92622], [-122.61874, 38.92619], [-122.61842, 38.92606], [-122.61803, 38.9258], [-122.61733, 38.92555], [-122.61648, 38.9253], [-122.61589, 38.92523], [-122.61549, 38.92531], [-122.61464, 38.92533], [-122.61451, 38.92514], [-122.61468, 38.92519], [-122.61496, 38.9252], [-122.61505, 38.92516], [-122.6151, 38.92504], [-122.6147, 38.92459], [-122.61437, 38.92413], [-122.61402, 38.92358], [-122.61374, 38.92299], [-122.61363, 38.92274], [-122.61297, 38.92043], [-122.61267, 38.91929], [-122.61274, 38.91919], [-122.61286, 38.91916], [-122.61305, 38.91917], [-122.61332, 38.91925], [-122.6136, 38.9194], [-122.61379, 38.91948], [-122.61397, 38.91953], [-122.61416, 38.91955], [-122.61418, 38.92043], [-122.61897, 38.92044], [-122.619, 38.91759], [-122.6323, 38.91758], [-122.64189, 38.9176], [-122.64172, 38.91871], [-122.64529, 38.91946], [-122.6452, 38.92016], [-122.64726, 38.92039], [-122.65082, 38.91744], [-122.65089, 38.92472], [-122.65125, 38.93212], [-122.65138, 38.9352], [-122.65035, 38.9352], [-122.65037, 38.93622], [-122.65141, 38.93624], [-122.65142, 38.93608], [-122.65197, 38.93608], [-122.65197, 38.93585], [-122.65504, 38.93587], [-122.65532, 38.93687], [-122.65501, 38.93735], [-122.65445, 38.93791], [-122.65537, 38.93773]]]]} Open Access 1 Anderson Marsh State Historic Park http://www.parks.ca.gov/?page_id=483 1391 204 California Department of Parks and Recreation 47 State 5 State Agency 5 http://www.parks.ca.gov/ California Department of Parks and Recreation 9 1354.42 Anderson Marsh SHP 1982

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE superunits_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  PARK_NAME TEXT,
  PARK_URL TEXT,
  SUID_NMA INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
    ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
    ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
    ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
    ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
    ON [superunits_with_maps] ([ACCESS_TYP]);