calands: units_with_maps: 2 rows where COUNTY = 4 and SUID

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

2 rows where COUNTY = 4 and SUID_NMA = 1461

Search:

descending

This data as json, copyable, CSV (advanced)

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
8098	8098	8097	{"type": "MultiPolygon", "coordinates": [[[[-117.28072, 33.01369], [-117.2807, 33.01369], [-117.28063, 33.01356], [-117.28072, 33.01369], [-117.28072, 33.01369]]], [[[-117.28063, 33.01356], [-117.28045, 33.01326], [-117.28026, 33.01287], [-117.28008, 33.01244], [-117.27991, 33.01197], [-117.27956, 33.01203], [-117.27926, 33.01079], [-117.27908, 33.01002], [-117.27893, 33.00928], [-117.27874, 33.00818], [-117.27846, 33.00623], [-117.27838, 33.00492], [-117.27806, 33.0039], [-117.27784, 33.00333], [-117.27751, 33.00264], [-117.27729, 33.00228], [-117.27657, 33.00125], [-117.27671, 33.00128], [-117.27704, 33.00097], [-117.27745, 33.00082], [-117.2777, 33.00067], [-117.27798, 33.00055], [-117.27817, 33.00055], [-117.2781, 33.00006], [-117.27798, 33.00005], [-117.27798, 33.00001], [-117.2778, 32.99993], [-117.27767, 32.99954], [-117.27738, 32.99917], [-117.2774, 32.99916], [-117.27784, 32.99911], [-117.27799, 32.99932], [-117.27817, 32.99965], [-117.2783, 32.99995], [-117.27839, 33.00025], [-117.27846, 33.00067], [-117.27848, 33.00173], [-117.27849, 33.00175], [-117.27851, 33.00234], [-117.27855, 33.00446], [-117.27861, 33.00551], [-117.27867, 33.006], [-117.27882, 33.00684], [-117.27909, 33.00803], [-117.27933, 33.00876], [-117.27993, 33.01114], [-117.28063, 33.01356]]], [[[-117.28192, 33.01539], [-117.28192, 33.01545], [-117.28187, 33.01556], [-117.28179, 33.01567], [-117.28138, 33.0157], [-117.2813, 33.01547], [-117.28049, 33.01418], [-117.28033, 33.01395], [-117.28016, 33.01376], [-117.28076, 33.01375], [-117.28192, 33.01539]]]]}	Open Access 1	12170	Cardiff State Beach	1461	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/default.asp?page_id=656	San Diego 4	23.131	Cardiff SB	1949	State Park 15	4
11340	11340	11339	{"type": "Polygon", "coordinates": [[[-117.29351, 33.0127], [-117.28215, 33.01572], [-117.28063, 33.01356], [-117.27993, 33.01114], [-117.2788, 33.00672], [-117.27857, 33.00476], [-117.27851, 33.00234], [-117.27849, 33.00175], [-117.27848, 33.00174], [-117.27846, 33.00067], [-117.27843, 33.00048], [-117.27835, 33.00009], [-117.27817, 32.99964], [-117.27799, 32.99932], [-117.27783, 32.9991], [-117.2793, 32.99887], [-117.27931, 32.9989], [-117.28762, 32.99758], [-117.29351, 33.0127]]]}	Open Access 1	28052	Cardiff State Beach	1461	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/default.asp?page_id=656	San Diego 4	485.781	Cardiff SB	1949	State Park 15	4

Advanced export

JSON shape: default, array, newline-delimited

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