calands: units_with_maps: 2 rows where ACCESS_TYP = 1, AGNCY_TYP = 2 and MNG

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

2 rows where ACCESS_TYP = 1, AGNCY_TYP = 2 and MNG_AGENCY = 138

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
9944	9944	9943	{"type": "MultiPolygon", "coordinates": [[[[-117.76222, 33.57793], [-117.76221, 33.57794], [-117.76006, 33.57795], [-117.76026, 33.57771], [-117.76114, 33.57773], [-117.76143, 33.57793], [-117.76222, 33.57793]]], [[[-117.77259, 33.55359], [-117.77256, 33.55666], [-117.77201, 33.55663], [-117.76932, 33.56064], [-117.76878, 33.56109], [-117.76727, 33.56041], [-117.7667, 33.56206], [-117.76664, 33.56205], [-117.7666, 33.56215], [-117.7658, 33.56183], [-117.76493, 33.56185], [-117.76466, 33.56149], [-117.76455, 33.56156], [-117.76453, 33.5622], [-117.76368, 33.56271], [-117.76348, 33.56293], [-117.76318, 33.56274], [-117.76278, 33.56327], [-117.76256, 33.56377], [-117.76247, 33.56426], [-117.76112, 33.5641], [-117.76072, 33.56636], [-117.76207, 33.56653], [-117.75923, 33.56645], [-117.75918, 33.56686], [-117.76061, 33.56704], [-117.76061, 33.56707], [-117.76069, 33.56713], [-117.76069, 33.56718], [-117.76067, 33.56722], [-117.76039, 33.56743], [-117.76027, 33.56759], [-117.76019, 33.56759], [-117.76035, 33.56791], [-117.76016, 33.56896], [-117.76133, 33.56911], [-117.76097, 33.56993], [-117.7611, 33.57], [-117.76118, 33.57007], [-117.7615, 33.57067], [-117.76154, 33.57078], [-117.76156, 33.5709], [-117.76155, 33.57102], [-117.76141, 33.57135], [-117.7614, 33.57142], [-117.76142, 33.57148], [-117.7615, 33.57156], [-117.76215, 33.57203], [-117.76225, 33.57214], [-117.76232, 33.57226], [-117.76235, 33.57238], [-117.76235, 33.57277], [-117.76007, 33.57278], [-117.76007, 33.57432], [-117.75934, 33.57433], [-117.7592, 33.57794], [-117.7612, 33.57802], [-117.76104, 33.57874], [-117.76203, 33.57874], [-117.76191, 33.57929], [-117.7609, 33.57931], [-117.76069, 33.58024], [-117.75555, 33.5803], [-117.75557, 33.58188], [-117.74937, 33.58194], [-117.74941, 33.5563], [-117.75694, 33.55625], [-117.75696, 33.55673], [-117.75807, 33.55671], [-117.75809, 33.55692], [-117.75932, 33.55689], [-117.75975, 33.5562], [-117.76386, 33.55613], [-117.767, 33.55632], [-117.76702, 33.555], [-117.76729, 33.555], [-117.76729, 33.55468], [-117.76928, 33.55469], [-117.76931, 33.55466], [-117.76913, 33.55443], [-117.76888, 33.55429], [-117.76859, 33.55416], [-117.76841, 33.554], [-117.76854, 33.55404], [-117.76864, 33.55404], [-117.76911, 33.55386], [-117.76921, 33.5538], [-117.76934, 33.55369], [-117.76926, 33.55357], [-117.76982, 33.5536], [-117.77029, 33.55356], [-117.77069, 33.5535], [-117.77127, 33.55354], [-117.77125, 33.55326], [-117.77142, 33.55327], [-117.77259, 33.55359]], [[-117.75922, 33.57949], [-117.75919, 33.57946], [-117.7588, 33.57963], [-117.75901, 33.57998], [-117.75941, 33.57981], [-117.75922, 33.57949]], [[-117.75533, 33.57725], [-117.75514, 33.57779], [-117.75556, 33.5779], [-117.75572, 33.57773], [-117.75573, 33.57765], [-117.75563, 33.57732], [-117.75533, 33.57725]], [[-117.75784, 33.57433], [-117.75754, 33.57433], [-117.75754, 33.57464], [-117.75784, 33.57464], [-117.75784, 33.57433]], [[-117.76033, 33.55702], [-117.76033, 33.55718], [-117.7603, 33.55734], [-117.76024, 33.55749], [-117.76015, 33.55763], [-117.76026, 33.55783], [-117.76039, 33.55798], [-117.76058, 33.55808], [-117.76073, 33.55812], [-117.76088, 33.55812], [-117.76102, 33.5581], [-117.76116, 33.55805], [-117.76128, 33.55798], [-117.76138, 33.55788], [-117.76147, 33.55771], [-117.76149, 33.55753], [-117.76143, 33.55735], [-117.76131, 33.55719], [-117.76113, 33.55708], [-117.76099, 33.55704], [-117.76084, 33.55702], [-117.76033, 33.55702]]]]}	Open Access 1	47960	Aliso and Wood Canyons Wilderness Park	8041	1164	Laguna Beach, City of 181	City 2	City Agency 2	http://www.lagunabeachcity.net/cityhall/pw/parks.asp	City 2	312	Orange, County of 138	County 3	County Agency 3	http://www.ocparks.com/parks/aliso	Orange 3	885.097	Aliso and Wood Canyons Wilderness Park	0	Local Conservation Area 4	2
9945	9945	9944	{"type": "Polygon", "coordinates": [[[-117.75367, 33.87309], [-117.7534, 33.8731], [-117.75323, 33.87313], [-117.75305, 33.87321], [-117.75276, 33.87329], [-117.75249, 33.8734], [-117.7522, 33.87353], [-117.75193, 33.87367], [-117.75157, 33.87392], [-117.75115, 33.87428], [-117.75095, 33.87452], [-117.7508, 33.87474], [-117.7507, 33.87478], [-117.74982, 33.87457], [-117.75063, 33.8741], [-117.75188, 33.87343], [-117.75274, 33.87301], [-117.75361, 33.87262], [-117.75367, 33.87309]]]}	Open Access 1	47963	Yorba Regional Park	27778	1006	Anaheim, City of 59	City 2	City Agency 2	http://www.anaheim.net/comm_svc/parks/	City 2	312	Orange, County of 138	County 3	County Agency 3	http://www.ocparks.com/parks/yorba	Orange 3	3.53	Yorba RP	0	Local Park 2	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]);