units_with_maps

Table actions

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

1 row where AGNCY_TYP = 3, DES_TP = 1006 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
11405 11405 11404 {"type": "MultiPolygon", "coordinates": [[[[-121.12189, 38.448], [-121.12205, 38.44809], [-121.12216, 38.44818], [-121.12227, 38.44831], [-121.12236, 38.44848], [-121.12238, 38.44862], [-121.12238, 38.4488], [-121.12234, 38.44893], [-121.12227, 38.44905], [-121.12217, 38.44916], [-121.12199, 38.44928], [-121.12184, 38.44934], [-121.12163, 38.44939], [-121.12143, 38.44941], [-121.12126, 38.44939], [-121.12109, 38.44935], [-121.12094, 38.44929], [-121.12081, 38.4492], [-121.12068, 38.44908], [-121.12056, 38.44893], [-121.1205, 38.44881], [-121.12047, 38.4486], [-121.1205, 38.44842], [-121.12058, 38.44827], [-121.12071, 38.44812], [-121.12055, 38.44804], [-121.12043, 38.44795], [-121.12031, 38.44782], [-121.12023, 38.4477], [-121.12017, 38.44754], [-121.12015, 38.4474], [-121.12018, 38.44722], [-121.12023, 38.44709], [-121.12032, 38.44698], [-121.12047, 38.44684], [-121.12066, 38.44674], [-121.12087, 38.44667], [-121.1211, 38.44665], [-121.12132, 38.44667], [-121.12154, 38.44672], [-121.12169, 38.44679], [-121.12186, 38.44691], [-121.12201, 38.44709], [-121.12208, 38.44721], [-121.12212, 38.44734], [-121.12212, 38.44748], [-121.12209, 38.44763], [-121.122, 38.4478], [-121.12183, 38.44796], [-121.12189, 38.448]]], [[[-121.12616, 38.44975], [-121.12493, 38.44976], [-121.12493, 38.44977], [-121.12538, 38.45016], [-121.12535, 38.45016], [-121.12506, 38.45015], [-121.12485, 38.45009], [-121.12463, 38.44997], [-121.12455, 38.44991], [-121.12445, 38.4498], [-121.1244, 38.44972], [-121.12435, 38.44959], [-121.12433, 38.44947], [-121.12434, 38.44932], [-121.12438, 38.44919], [-121.12447, 38.44901], [-121.12463, 38.44882], [-121.12446, 38.44867], [-121.12437, 38.44854], [-121.12431, 38.44837], [-121.12429, 38.44824], [-121.12431, 38.4481], [-121.12438, 38.44793], [-121.12446, 38.44781], [-121.12457, 38.44771], [-121.12475, 38.4476], [-121.12497, 38.44753], [-121.12537, 38.44747], [-121.1255, 38.44744], [-121.12581, 38.44739], [-121.12598, 38.44738], [-121.1262, 38.4474], [-121.12663, 38.44751], [-121.12682, 38.44761], [-121.12698, 38.44776], [-121.1271, 38.44795], [-121.12713, 38.44804], [-121.12714, 38.44817], [-121.12711, 38.44835], [-121.12701, 38.44854], [-121.12694, 38.44861], [-121.12681, 38.44872], [-121.12662, 38.44882], [-121.1264, 38.44888], [-121.12612, 38.44889], [-121.12627, 38.44913], [-121.12632, 38.44931], [-121.12631, 38.44944], [-121.12628, 38.44954], [-121.12624, 38.44963], [-121.12616, 38.44975]]]]} Unknown Access 4 22224 River City Aggragates 24408 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 23.425 River City Aggragates   None 1006  

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