calands: units_with_maps: 8 rows where ACCESS_TYP = 1, AGNCY_LEV = 7 and MNG_AG

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

8 rows where ACCESS_TYP = 1, AGNCY_LEV = 7 and MNG_AG_TYP = 4

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	DES_TP	GAP_STS
4163	4163	4162	{"type": "Polygon", "coordinates": [[[-117.13273, 33.61299], [-117.13267, 33.61334], [-117.13238, 33.61333], [-117.13235, 33.61297], [-117.13273, 33.61299]]]}	Open Access 1	48381	Mahogany Meadows Pocket Park	32945	6124	Mahogany Hills Home Owner Association 727	Private 7	Home Owners Association 16		Private 14	2171	Valley-Wide Recreation and Park District 156	Special District 4	Recreation/Parks District 4	https://www.gorecreation.org/mahogany-meadows-pocket-park	Riverside 10	0.3	Mahogany Meadows PP	Local Park 2	4
4456	4456	4455	{"type": "Polygon", "coordinates": [[[-117.1099, 33.59108], [-117.10987, 33.59122], [-117.10982, 33.59131], [-117.10976, 33.59136], [-117.10963, 33.59141], [-117.10945, 33.59141], [-117.1093, 33.59153], [-117.10929, 33.59152], [-117.10934, 33.59147], [-117.10936, 33.5914], [-117.10933, 33.59112], [-117.10941, 33.59108], [-117.1099, 33.59108]]]}	Open Access 1	48396	Capri Park	32961	6123	Brindisi Owners Association 763	Private 7	Home Owners Association 16		Private 14	2171	Valley-Wide Recreation and Park District 156	Special District 4	Recreation/Parks District 4	https://www.gorecreation.org/capri-pocket-park	Riverside 10	0.419	Capri Park	Local Park 2	4
5257	5257	5256	{"type": "Polygon", "coordinates": [[[-117.13403, 33.61701], [-117.13395, 33.61707], [-117.13333, 33.617], [-117.13282, 33.61699], [-117.13274, 33.61693], [-117.13274, 33.61667], [-117.13278, 33.6165], [-117.13278, 33.61645], [-117.13273, 33.61639], [-117.13265, 33.61637], [-117.13264, 33.61635], [-117.13261, 33.61635], [-117.1325, 33.61602], [-117.13258, 33.616], [-117.13263, 33.61592], [-117.13259, 33.61572], [-117.13259, 33.61544], [-117.13266, 33.61539], [-117.13289, 33.61536], [-117.13311, 33.61532], [-117.13381, 33.61508], [-117.13391, 33.61513], [-117.13398, 33.61534], [-117.13402, 33.61557], [-117.13403, 33.61701]]]}	Open Access 1	48382	Mahogany Meadows Park	32946	7029	KB Home Coastal Inc 785	Private 7	Commercial 20	https://www.kbhome.com/	Private 14	2171	Valley-Wide Recreation and Park District 156	Special District 4	Recreation/Parks District 4	https://github.com/GreenInfo-Network/cpad/issues/37	Riverside 10	6.166	Mahogany Meadows Park	Local Park 2	4
5258	5258	5257	{"type": "Polygon", "coordinates": [[[-117.1093, 33.59153], [-117.1089, 33.59184], [-117.10882, 33.59184], [-117.10882, 33.59154], [-117.10915, 33.59157], [-117.10922, 33.59155], [-117.10929, 33.59152], [-117.1093, 33.59153]]]}	Open Access 1	48383	Pompei Pocket Park	32947	6123	Brindisi Owners Association 763	Private 7	Home Owners Association 16		Private 14	2171	Valley-Wide Recreation and Park District 156	Special District 4	Recreation/Parks District 4	https://www.gorecreation.org/pompei-pocket-park	Riverside 10	0.197	Pompei PP	Local Park 2	4
5283	5283	5282	{"type": "Polygon", "coordinates": [[[-117.12889, 33.61282], [-117.12851, 33.61291], [-117.12886, 33.61428], [-117.12859, 33.61432], [-117.12851, 33.61411], [-117.12842, 33.61354], [-117.1283, 33.61315], [-117.1283, 33.61293], [-117.12828, 33.61271], [-117.12798, 33.6127], [-117.128, 33.61263], [-117.12799, 33.61259], [-117.12794, 33.61253], [-117.12789, 33.61251], [-117.1278, 33.61251], [-117.12774, 33.61254], [-117.12769, 33.61249], [-117.12733, 33.61255], [-117.12733, 33.61251], [-117.12788, 33.61241], [-117.12845, 33.61224], [-117.12854, 33.61226], [-117.12889, 33.61282]]]}	Open Access 1	48401	Linear Workout Park	32968	7029	KB Home Coastal Inc 785	Private 7	Commercial 20	https://www.kbhome.com/	Private 14	2171	Valley-Wide Recreation and Park District 156	Special District 4	Recreation/Parks District 4		Riverside 10	2.073	Linear Workout Park	Local Park 2	4
6391	6391	6390	{"type": "Polygon", "coordinates": [[[-117.10569, 33.59244], [-117.10566, 33.59249], [-117.10549, 33.59255], [-117.10527, 33.59259], [-117.10527, 33.59237], [-117.10566, 33.59232], [-117.10569, 33.59244]]]}	Open Access 1	48388	Sicily Pocket Park	32952	6123	Brindisi Owners Association 763	Private 7	Home Owners Association 16		Private 14	2171	Valley-Wide Recreation and Park District 156	Special District 4	Recreation/Parks District 4	https://www.gorecreation.org/sicily-pocket-park	Riverside 10	0.212	Sicily PP	Local Park 2	4
6654	6654	6653	{"type": "MultiPolygon", "coordinates": [[[[-117.12789, 33.61483], [-117.12781, 33.61497], [-117.12736, 33.61482], [-117.12736, 33.61462], [-117.12789, 33.61483]]], [[[-117.13261, 33.61635], [-117.13258, 33.61637], [-117.13251, 33.61627], [-117.13216, 33.61628], [-117.1318, 33.61633], [-117.13175, 33.61638], [-117.13168, 33.61636], [-117.13159, 33.61638], [-117.13157, 33.61636], [-117.13119, 33.61627], [-117.13083, 33.61626], [-117.13079, 33.61632], [-117.1307, 33.6163], [-117.13063, 33.61632], [-117.13059, 33.61628], [-117.13025, 33.61622], [-117.12986, 33.61627], [-117.12979, 33.61625], [-117.12974, 33.61624], [-117.12967, 33.61627], [-117.12963, 33.61629], [-117.12928, 33.61634], [-117.12953, 33.61752], [-117.12898, 33.61754], [-117.12897, 33.61697], [-117.1289, 33.61693], [-117.12892, 33.61686], [-117.1289, 33.6168], [-117.12884, 33.61676], [-117.1288, 33.61674], [-117.12879, 33.61611], [-117.12881, 33.61605], [-117.12874, 33.61562], [-117.12851, 33.61563], [-117.12827, 33.61563], [-117.12826, 33.61543], [-117.12832, 33.61507], [-117.12803, 33.61495], [-117.12809, 33.61483], [-117.12838, 33.61496], [-117.12852, 33.61482], [-117.12871, 33.61474], [-117.12865, 33.61447], [-117.12905, 33.6144], [-117.12911, 33.61468], [-117.12905, 33.61474], [-117.12911, 33.6149], [-117.12917, 33.61569], [-117.12942, 33.61577], [-117.12942, 33.61586], [-117.12948, 33.61593], [-117.12957, 33.61595], [-117.12965, 33.61593], [-117.1297, 33.61603], [-117.13006, 33.61602], [-117.13037, 33.61593], [-117.13041, 33.61589], [-117.13048, 33.61591], [-117.13058, 33.61591], [-117.13061, 33.61596], [-117.13097, 33.61604], [-117.13137, 33.61605], [-117.13142, 33.61598], [-117.13148, 33.616], [-117.13156, 33.616], [-117.13161, 33.6161], [-117.13235, 33.61611], [-117.13241, 33.61602], [-117.13248, 33.61604], [-117.1325, 33.61602], [-117.13261, 33.61635]]]]}	Open Access 1	48402	Linear Park	32969	7029	KB Home Coastal Inc 785	Private 7	Commercial 20	https://www.kbhome.com/	Private 14	2171	Valley-Wide Recreation and Park District 156	Special District 4	Recreation/Parks District 4	https://www.gorecreation.org/linear-park	Riverside 10	7.128	Linear Park	Local Park 2	4
6713	6713	6712	{"type": "Polygon", "coordinates": [[[-121.2326, 40.30976], [-121.23197, 40.31049], [-121.23162, 40.31034], [-121.23162, 40.31029], [-121.23127, 40.31012], [-121.23133, 40.31004], [-121.23107, 40.30991], [-121.23167, 40.30916], [-121.23253, 40.30955], [-121.2326, 40.30976]]]}	Open Access 1	48415	Truman Collins Sports Complex	33012	7030	Collins Pine Company 841	Private 7	Commericial 30	http://www.collinsco.com/	Private 14	2427	Almanor Recreation and Park District 818	Special District 4	Recreation/Parks District 4	https://ceqanet.opr.ca.gov/2003038103	Plumas 57	2.653	Truman Collins Sports Complex	Local Recreation Area 3	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]);