units_with_maps

Table actions

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

2 rows where LABEL_NAME = "Bodie SHP", MNG_AGENCY = 47 and MNG_AG_TYP = 5

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • State Agency · 2 ✖

MNG_AGENCY 1

  • California Department of Parks and Recreation · 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
10804 10804 10803 {"type": "MultiPolygon", "coordinates": [[[[-119.02102, 38.20596], [-119.0187, 38.20593], [-119.01888, 38.21321], [-119.01658, 38.21318], [-119.01656, 38.21394], [-119.0155, 38.21345], [-119.01513, 38.21375], [-119.01475, 38.21386], [-119.01429, 38.21394], [-119.01408, 38.21401], [-119.01375, 38.21443], [-119.01346, 38.21463], [-119.0129, 38.21482], [-119.01253, 38.21491], [-119.01169, 38.21543], [-119.01113, 38.21575], [-119.01102, 38.21626], [-119.01094, 38.21676], [-119.01027, 38.21779], [-119.00921, 38.21891], [-119.00887, 38.21938], [-119.00817, 38.22067], [-119.0077, 38.22125], [-119.00738, 38.22194], [-119.00709, 38.22238], [-119.00699, 38.21995], [-119.00706, 38.21975], [-119.00705, 38.21844], [-119.00707, 38.21322], [-119.00727, 38.21298], [-119.00724, 38.21094], [-119.00631, 38.21248], [-119.00615, 38.21244], [-119.00477, 38.21466], [-119.00394, 38.21584], [-119.00384, 38.21581], [-119.00263, 38.21695], [-119.00264, 38.21697], [-119.00457, 38.21755], [-119.00285, 38.22138], [-119.00264, 38.22132], [-119.00024, 38.22428], [-118.99826, 38.22363], [-118.99864, 38.22319], [-118.99864, 38.22318], [-118.99689, 38.22228], [-118.99714, 38.22202], [-118.99714, 38.22201], [-118.99541, 38.22109], [-118.99647, 38.21992], [-118.99455, 38.21914], [-118.99745, 38.21581], [-118.99931, 38.21654], [-119.00114, 38.21273], [-118.99802, 38.21143], [-119.00021, 38.20863], [-119.00091, 38.20888], [-119.00216, 38.20643], [-119.00058, 38.2053], [-119.00304, 38.20303], [-119.00303, 38.20302], [-119.00297, 38.20301], [-119.00458, 38.19908], [-119.00631, 38.19953], [-119.00787, 38.19572], [-119.00839, 38.19581], [-119.00786, 38.19184], [-119.00987, 38.19162], [-119.00998, 38.19351], [-119.00999, 38.19352], [-119.01082, 38.19313], [-119.01135, 38.19027], [-119.01163, 38.19002], [-119.01343, 38.18999], [-119.01249, 38.19402], [-119.01115, 38.19402], [-119.01169, 38.19598], [-119.01109, 38.19623], [-119.01109, 38.19624], [-119.01207, 38.19632], [-119.01215, 38.19477], [-119.01247, 38.19478], [-119.0124, 38.19635], [-119.01297, 38.19641], [-119.01286, 38.19726], [-119.01374, 38.19735], [-119.01375, 38.19859], [-119.02085, 38.19867], [-119.02102, 38.20596]], [[-119.00401, 38.20568], [-119.00419, 38.20572], [-119.00487, 38.2038], [-119.00319, 38.2054], [-119.0032, 38.20541], [-119.00387, 38.20562], [-119.0021, 38.20934], [-119.0022, 38.20937], [-119.00401, 38.20568]], [[-119.00262, 38.21699], [-119.0026, 38.21698], [-119.00236, 38.21723], [-119.00255, 38.2173], [-119.00262, 38.21699]], [[-119.01181, 38.20815], [-119.01161, 38.20198], [-119.01115, 38.20198], [-119.01066, 38.20427], [-119.00916, 38.20349], [-119.00738, 38.20654], [-119.00711, 38.20642], [-119.00886, 38.20341], [-119.00885, 38.20333], [-119.00884, 38.20332], [-119.00775, 38.20516], [-119.00743, 38.20503], [-119.00753, 38.20482], [-119.00722, 38.20469], [-119.00791, 38.20357], [-119.00744, 38.20339], [-119.0065, 38.20484], [-119.00753, 38.20521], [-119.00684, 38.20645], [-119.0052, 38.20589], [-119.00462, 38.20752], [-119.00464, 38.20753], [-119.00579, 38.20617], [-119.00605, 38.20635], [-119.00588, 38.20658], [-119.00588, 38.2066], [-119.00696, 38.20699], [-119.00579, 38.20895], [-119.00674, 38.20945], [-119.00661, 38.20972], [-119.00722, 38.20998], [-119.00723, 38.20997], [-119.00722, 38.20942], [-119.00931, 38.20944], [-119.00942, 38.20948], [-119.01054, 38.20949], [-119.01056, 38.20947], [-119.01055, 38.20946], [-119.0114, 38.20947], [-119.0115, 38.20951], [-119.01169, 38.20951], [-119.01172, 38.20947], [-119.01184, 38.20947], [-119.01181, 38.20815]], [[-119.00563, 38.21244], [-119.00593, 38.21193], [-119.00562, 38.21179], [-119.00495, 38.21329], [-119.0051, 38.21332], [-119.00563, 38.21244]], [[-119.00642, 38.21121], [-119.00634, 38.21082], [-119.00612, 38.21074], [-119.00573, 38.21156], [-119.00642, 38.21121]]], [[[-118.99833, 38.2125], [-118.99645, 38.2154], [-118.99712, 38.21569], [-118.99687, 38.21621], [-118.99504, 38.21567], [-118.99683, 38.21204], [-118.99833, 38.2125]]], [[[-119.01658, 38.21681], [-119.01657, 38.21683], [-119.01201, 38.21676], [-119.01196, 38.21697], [-119.012, 38.2197], [-119.01198, 38.22471], [-119.00709, 38.22472], [-119.00709, 38.22287], [-119.00761, 38.22211], [-119.0078, 38.22169], [-119.00893, 38.21984], [-119.00927, 38.21933], [-119.01062, 38.21774], [-119.01107, 38.21714], [-119.01129, 38.2167], [-119.0114, 38.21599], [-119.01149, 38.21581], [-119.01196, 38.21558], [-119.01246, 38.21522], [-119.01302, 38.21503], [-119.0136, 38.21485], [-119.01398, 38.2146], [-119.01438, 38.21411], [-119.015, 38.21403], [-119.01543, 38.21385], [-119.01572, 38.21399], [-119.01642, 38.21426], [-119.01658, 38.21681]]], [[[-119.01143, 38.20523], [-119.0091, 38.20893], [-119.00879, 38.20877], [-119.00909, 38.20828], [-119.00848, 38.208], [-119.0108, 38.20431], [-119.01143, 38.20458], [-119.01111, 38.20508], [-119.01143, 38.20523]]]]} Open Access 1 20459 Bodie State Historic Park 1442 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=509 Mono 32 984.405 Bodie SHP 1962 State Historic or Cultural Area 132 4
16484 16484 16483 {"type": "MultiPolygon", "coordinates": [[[[-119.01057, 38.20947], [-119.01055, 38.20949], [-119.00942, 38.20948], [-119.00928, 38.20943], [-119.00946, 38.20913], [-119.01015, 38.20939], [-119.01026, 38.20928], [-119.01057, 38.20947]]], [[[-119.01178, 38.20939], [-119.01169, 38.20951], [-119.0115, 38.20951], [-119.01103, 38.20932], [-119.01116, 38.20913], [-119.01178, 38.20939]]], [[[-119.01184, 38.2092], [-119.01121, 38.20895], [-119.01181, 38.20814], [-119.01183, 38.20889], [-119.01184, 38.2092]]], [[[-119.01512, 38.22152], [-119.0145, 38.22283], [-119.01199, 38.2221], [-119.012, 38.2197], [-119.01512, 38.22152]]]]} Open Access 1 20763 Bodie State Historic Park 1442 102 United States Bureau of Land Management 1 Federal 1 Federal Agency 1 http://www.blm.gov/wo/st/en.html US Bureau of Land Management 1 204 California Department of Parks and Recreation 47 State 5 State Agency 5 http://www.parks.ca.gov/?page_id=509 Mono 32 15.241 Bodie SHP 1962 State Historic or Cultural Area 132 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]);