units_with_maps

Table actions

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

3 rows where COUNTY = 4, MNG_AGENCY = 73 and MNG_AG_TYP = 5

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • State Agency · 3 ✖

MNG_AGENCY 1

  • California State Lands Commission · 3 ✖

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
7960 7960 7959 {"type": "Polygon", "coordinates": [[[-116.77151, 33.12419], [-116.76285, 33.1242], [-116.76283, 33.12035], [-116.7715, 33.12036], [-116.77151, 33.12419]]]} Open Access 1 12841 California State Lands Commission 16724 209 California State Lands Commission 75 State 5 State Agency 5 http://www.slc.ca.gov/ Other State 5 209 California State Lands Commission 73 State 5 State Agency 5   San Diego 4 85.079 SLC 0 State Resource Management Area 55 3
14803 14803 14802 {"type": "MultiPolygon", "coordinates": [[[[-116.17464, 32.69733], [-116.15733, 32.69758], [-116.15691, 32.68285], [-116.17365, 32.68294], [-116.17464, 32.69733]]], [[[-116.67842, 32.77602], [-116.67832, 32.78694], [-116.67406, 32.78701], [-116.67408, 32.77962], [-116.67412, 32.77604], [-116.67842, 32.77602]]]]} Open Access 1 45219 California State Lands Commission 16724 209 California State Lands Commission 75 State 5 State Agency 5 http://www.slc.ca.gov/ Other State 5 209 California State Lands Commission 73 State 5 State Agency 5   San Diego 4 757.572 SLC 0 State Resource Management Area 55 3
16878 16878 16877 {"type": "MultiPolygon", "coordinates": [[[[-116.37736, 32.77099], [-116.37719, 32.78545], [-116.36908, 32.78539], [-116.36111, 32.78551], [-116.36094, 32.771], [-116.36789, 32.77098], [-116.37736, 32.77099]]], [[[-116.63182, 32.82654], [-116.63151, 32.83004], [-116.62895, 32.83016], [-116.62861, 32.82978], [-116.62829, 32.82938], [-116.62737, 32.8277], [-116.62747, 32.82664], [-116.63182, 32.82654]]], [[[-116.76726, 33.09473], [-116.76721, 33.0981], [-116.763, 33.09817], [-116.76306, 33.09471], [-116.76726, 33.09473]]], [[[-116.84133, 33.00435], [-116.84115, 33.00636], [-116.83671, 33.00635], [-116.83673, 33.00778], [-116.83244, 33.00778], [-116.83252, 33.00417], [-116.84133, 33.00435]]], [[[-117.14854, 33.31086], [-117.14411, 33.31101], [-117.14413, 33.30739], [-117.14836, 33.30736], [-117.14854, 33.31086]]]]} Open Access 1 23401 California State Lands Commission 16724 209 California State Lands Commission 75 State 5 State Agency 5 http://www.slc.ca.gov/ Other State 5 209 California State Lands Commission 73 State 5 State Agency 5   San Diego 4 775.732 SLC 0 State Resource Management Area 55 3

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