units_with_maps

Table actions

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

1 row where AGNCY_LEV = 3, DES_TP = 972 and MNG_AG_TYP = 3

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • County Agency · 1 ✖

MNG_AGENCY 1

DES_TP 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
11134 11134 11133 {"type": "MultiPolygon", "coordinates": [[[[-121.35455, 38.51709], [-121.3545, 38.51715], [-121.35442, 38.51718], [-121.35373, 38.5172], [-121.35298, 38.51727], [-121.35225, 38.5174], [-121.35179, 38.51751], [-121.3517, 38.51748], [-121.35166, 38.51743], [-121.35166, 38.51736], [-121.35171, 38.51731], [-121.35187, 38.51726], [-121.35204, 38.51726], [-121.35228, 38.51719], [-121.35251, 38.5171], [-121.35272, 38.51697], [-121.35284, 38.51691], [-121.35299, 38.5169], [-121.35312, 38.51694], [-121.35328, 38.517], [-121.35345, 38.51702], [-121.35362, 38.51698], [-121.35365, 38.51696], [-121.35399, 38.51694], [-121.35409, 38.51692], [-121.35441, 38.51693], [-121.3545, 38.51696], [-121.35455, 38.51702], [-121.35455, 38.51709]]], [[[-121.35432, 38.51553], [-121.35427, 38.5156], [-121.3541, 38.51566], [-121.35309, 38.51629], [-121.35292, 38.51649], [-121.35269, 38.51664], [-121.3522, 38.51683], [-121.35209, 38.51683], [-121.35195, 38.51683], [-121.35186, 38.51678], [-121.35182, 38.5167], [-121.35182, 38.51662], [-121.35187, 38.51655], [-121.35249, 38.51617], [-121.35256, 38.51606], [-121.35255, 38.51596], [-121.35248, 38.51586], [-121.35236, 38.5158], [-121.35222, 38.51579], [-121.35213, 38.51583], [-121.35197, 38.51584], [-121.35189, 38.51584], [-121.35181, 38.5158], [-121.35177, 38.51574], [-121.35178, 38.51566], [-121.35183, 38.5156], [-121.35279, 38.51544], [-121.35358, 38.51537], [-121.35418, 38.51535], [-121.35427, 38.51538], [-121.35432, 38.51545], [-121.35432, 38.51553]]], [[[-121.35456, 38.51613], [-121.35451, 38.51619], [-121.35443, 38.51622], [-121.35412, 38.51626], [-121.35381, 38.51634], [-121.35353, 38.51646], [-121.3535, 38.51646], [-121.35367, 38.51628], [-121.35388, 38.51614], [-121.35413, 38.51605], [-121.3544, 38.51601], [-121.35449, 38.51602], [-121.35455, 38.51607], [-121.35456, 38.51613]]], [[[-121.35835, 38.5161], [-121.35832, 38.51617], [-121.35824, 38.51623], [-121.35814, 38.51625], [-121.35804, 38.51623], [-121.35786, 38.51611], [-121.35774, 38.51607], [-121.35751, 38.51606], [-121.35743, 38.5161], [-121.35739, 38.51617], [-121.35749, 38.51636], [-121.35747, 38.51643], [-121.3574, 38.51646], [-121.35734, 38.51646], [-121.35719, 38.51634], [-121.35708, 38.51618], [-121.3567, 38.51597], [-121.35641, 38.51587], [-121.35611, 38.5158], [-121.35601, 38.51579], [-121.35592, 38.51574], [-121.35587, 38.51567], [-121.35588, 38.51558], [-121.35594, 38.51551], [-121.35603, 38.51547], [-121.35614, 38.51548], [-121.35672, 38.51557], [-121.35748, 38.51574], [-121.3582, 38.51595], [-121.35828, 38.51601], [-121.35835, 38.5161]]], [[[-121.35658, 38.51631], [-121.35641, 38.51634], [-121.35628, 38.51633], [-121.35605, 38.51625], [-121.35599, 38.51617], [-121.35599, 38.51608], [-121.35617, 38.51607], [-121.35634, 38.5161], [-121.35649, 38.51619], [-121.35658, 38.51631]]], [[[-121.35831, 38.51766], [-121.35829, 38.51774], [-121.35821, 38.5178], [-121.35813, 38.5178], [-121.35742, 38.51758], [-121.3567, 38.5174], [-121.35624, 38.51732], [-121.35615, 38.51727], [-121.35611, 38.51719], [-121.35613, 38.51711], [-121.35621, 38.51705], [-121.35632, 38.51704], [-121.35648, 38.51708], [-121.35658, 38.51714], [-121.35674, 38.5172], [-121.35709, 38.51725], [-121.35718, 38.51723], [-121.35723, 38.51718], [-121.35723, 38.5171], [-121.35688, 38.51665], [-121.35686, 38.51659], [-121.35686, 38.51657], [-121.35689, 38.51655], [-121.35702, 38.51655], [-121.35718, 38.51665], [-121.35723, 38.51679], [-121.35737, 38.51698], [-121.35747, 38.51717], [-121.35798, 38.51748], [-121.35826, 38.51759], [-121.35831, 38.51766]]]]} Restricted Access 2 21428 Morrison Creek Mining 22496 316 Sacramento, County of 550 County 3 County Agency 3 http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx County 3 316 Sacramento, County of 543 County 3 County Agency 3   Sacramento 41 10.801 Morrison Creek Mining   None 972  

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]);