units_with_maps

Table actions

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

1 row where COUNTY = 4, MNG_AGENCY = 47 and UNIT_NAME = "South Carlsbad State Beach"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • California Department of Parks and Recreation · 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
8347 8347 8346 {"type": "MultiPolygon", "coordinates": [[[[-117.30949, 33.07645], [-117.30906, 33.07644], [-117.30901, 33.0763], [-117.30937, 33.07619], [-117.30949, 33.07645]]], [[[-117.31306, 33.0869], [-117.31259, 33.08702], [-117.31202, 33.08552], [-117.31186, 33.08522], [-117.31168, 33.08496], [-117.31141, 33.08466], [-117.31004, 33.08339], [-117.30942, 33.08286], [-117.30979, 33.08247], [-117.31009, 33.08239], [-117.3103, 33.0823], [-117.3105, 33.08229], [-117.3109, 33.08238], [-117.31107, 33.08245], [-117.31125, 33.0826], [-117.31161, 33.08247], [-117.31163, 33.08195], [-117.31193, 33.08194], [-117.31186, 33.08282], [-117.31306, 33.0869]]], [[[-117.334, 33.12842], [-117.33311, 33.12887], [-117.33086, 33.12566], [-117.32925, 33.12395], [-117.3289, 33.12345], [-117.32878, 33.12323], [-117.32867, 33.12327], [-117.32824, 33.12303], [-117.32759, 33.12179], [-117.3274, 33.12126], [-117.32724, 33.12067], [-117.3269, 33.11982], [-117.327, 33.11979], [-117.32701, 33.11977], [-117.32694, 33.11962], [-117.32682, 33.11965], [-117.32546, 33.11637], [-117.32519, 33.11564], [-117.32475, 33.1147], [-117.32459, 33.1144], [-117.3237, 33.11288], [-117.32273, 33.11199], [-117.32028, 33.10596], [-117.3193, 33.10344], [-117.31719, 33.09833], [-117.31575, 33.09511], [-117.31524, 33.09404], [-117.31291, 33.08829], [-117.3135, 33.08802], [-117.31402, 33.08952], [-117.31415, 33.08983], [-117.31442, 33.09034], [-117.31467, 33.09088], [-117.31521, 33.09214], [-117.31594, 33.09368], [-117.31699, 33.09615], [-117.31736, 33.09698], [-117.31829, 33.09875], [-117.31867, 33.0996], [-117.31903, 33.10036], [-117.31937, 33.10131], [-117.31995, 33.10275], [-117.32081, 33.10475], [-117.3221, 33.10788], [-117.32265, 33.10937], [-117.32288, 33.10989], [-117.32316, 33.11041], [-117.3234, 33.11089], [-117.32369, 33.11151], [-117.32389, 33.11198], [-117.32498, 33.11505], [-117.3254, 33.11605], [-117.32564, 33.11655], [-117.3279, 33.12066], [-117.32803, 33.12066], [-117.32893, 33.12229], [-117.3291, 33.12265], [-117.32959, 33.12357], [-117.32972, 33.12377], [-117.33025, 33.12446], [-117.33082, 33.12505], [-117.33114, 33.12515], [-117.33139, 33.12538], [-117.33263, 33.12684], [-117.33394, 33.12836], [-117.334, 33.12842]]], [[[-117.33126, 33.1309], [-117.33063, 33.13121], [-117.32643, 33.12292], [-117.32652, 33.12293], [-117.32683, 33.12311], [-117.3273, 33.12345], [-117.32768, 33.12357], [-117.3277, 33.12377], [-117.32765, 33.1242], [-117.32847, 33.12498], [-117.3288, 33.1252], [-117.32918, 33.12537], [-117.32941, 33.12544], [-117.33003, 33.12559], [-117.33033, 33.12569], [-117.33067, 33.12592], [-117.33096, 33.12634], [-117.32917, 33.12724], [-117.33004, 33.12859], [-117.33126, 33.1309]]], [[[-117.32945, 33.1245], [-117.32941, 33.12451], [-117.32858, 33.12388], [-117.32862, 33.12374], [-117.32871, 33.12358], [-117.32901, 33.12401], [-117.32945, 33.1245]]]]} Open Access 1 12899 South Carlsbad State Beach 1752 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=660 San Diego 4 117.377 South Carlsbad SB 1949 State Park 15 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]);