calands: units_with_maps: 11 rows where AGNCY_TYP = 16 and DES

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

11 rows where AGNCY_TYP = 16 and DES_TP = 2

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
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
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
8372	8372	8371	{"type": "Polygon", "coordinates": [[[-121.13806, 36.21648], [-121.13809, 36.21658], [-121.13804, 36.21705], [-121.138, 36.21722], [-121.13792, 36.21739], [-121.13781, 36.21754], [-121.13767, 36.21767], [-121.13751, 36.21779], [-121.13718, 36.21797], [-121.13712, 36.21799], [-121.13705, 36.21799], [-121.13694, 36.21794], [-121.13639, 36.21725], [-121.13787, 36.21647], [-121.13806, 36.21648]]]}	Open Access 1	48506	CreekBridge Baseball Park	33217	7033	Creekbridge Homes LLC 892	Private 7	Home Owners Association 16		Private 14	1152	King City, City of 473	City 2	City Agency 2		Monterey 14	3.565	CreekBridge Baseball Park	Local Park 2	4
11154	11154	11153	{"type": "Polygon", "coordinates": [[[-117.79698, 33.70006], [-117.79706, 33.70012], [-117.79707, 33.70016], [-117.79689, 33.70036], [-117.79686, 33.70044], [-117.79687, 33.70049], [-117.79677, 33.70052], [-117.7967, 33.70048], [-117.79666, 33.70047], [-117.79649, 33.70063], [-117.79644, 33.7006], [-117.79664, 33.7004], [-117.79662, 33.70038], [-117.79668, 33.70036], [-117.79698, 33.70006]]]}	Open Access 1	48692	Flagstone Park	18936	6033	Windwood Homeowners Association 926	Private 7	Home Owners Association 16		Private 14	1148	Irvine, City of 266	City 2	City Agency 2		Orange 3	0.248	Flagstone Park	Local Park 2	4
11155	11155	11154	{"type": "Polygon", "coordinates": [[[-117.71514, 33.7026], [-117.71503, 33.70272], [-117.71348, 33.70165], [-117.71319, 33.70188], [-117.71283, 33.70221], [-117.71279, 33.70214], [-117.71274, 33.70194], [-117.71273, 33.70165], [-117.71268, 33.70136], [-117.71281, 33.70133], [-117.71297, 33.70113], [-117.71496, 33.70241], [-117.715, 33.70239], [-117.71508, 33.70244], [-117.71514, 33.7026]]]}	Open Access 1	48695	Orchard Trail Park	33407	6128	Portola Springs Community Association 967	Private 7	Home Owners Association 16	https://portolasprings.org/	Private 14	1148	Irvine, City of 266	City 2	City Agency 2		Orange 3	2.227	Orchard Trail Park	Local Park 2	4
13144	13144	13143	{"type": "Polygon", "coordinates": [[[-117.6363, 33.4373], [-117.63625, 33.43732], [-117.63621, 33.43736], [-117.63622, 33.43744], [-117.63619, 33.43747], [-117.63618, 33.43754], [-117.63611, 33.43758], [-117.6361, 33.43765], [-117.636, 33.43768], [-117.63601, 33.43753], [-117.63591, 33.4373], [-117.63591, 33.43715], [-117.63589, 33.4371], [-117.6358, 33.43706], [-117.6357, 33.43709], [-117.63566, 33.43715], [-117.63567, 33.4372], [-117.6357, 33.43723], [-117.63547, 33.43703], [-117.63541, 33.437], [-117.63532, 33.43699], [-117.63532, 33.43695], [-117.63553, 33.43688], [-117.63566, 33.43668], [-117.6357, 33.43666], [-117.63577, 33.43667], [-117.63585, 33.43672], [-117.63594, 33.43687], [-117.63593, 33.43698], [-117.63596, 33.43709], [-117.63593, 33.43725], [-117.63595, 33.43735], [-117.63598, 33.43737], [-117.63604, 33.43735], [-117.6362, 33.43724], [-117.63627, 33.43727], [-117.6363, 33.4373]]]}	Open Access 1	48825	Vista Del Sol Park	33544	6132	Marblehead Development Partners LLC 1045	Private 7	Home Owners Association 16		Private 14	1296	San Clemente, City of 350	City 2	City Agency 2	https://www.san-clemente.org/Home/Components/FacilityDirectory/FacilityDirectory/175/2553?npage=2	Orange 3	0.637	Vista Del Sol Park	Local Park 2	4
13701	13701	13700	{"type": "MultiPolygon", "coordinates": [[[[-117.63252, 33.4339], [-117.63259, 33.43393], [-117.63262, 33.43399], [-117.63263, 33.43406], [-117.63262, 33.43414], [-117.63251, 33.43429], [-117.63248, 33.43427], [-117.63244, 33.43427], [-117.63226, 33.43438], [-117.6319, 33.43429], [-117.63182, 33.43432], [-117.63142, 33.43433], [-117.63138, 33.43432], [-117.63136, 33.43428], [-117.6312, 33.43434], [-117.63105, 33.43432], [-117.63095, 33.43434], [-117.63103, 33.43432], [-117.63107, 33.43427], [-117.63109, 33.43427], [-117.63111, 33.43423], [-117.63109, 33.43416], [-117.63125, 33.43393], [-117.63252, 33.4339]]], [[[-117.63431, 33.44132], [-117.6342, 33.44142], [-117.63397, 33.44124], [-117.63408, 33.44114], [-117.63431, 33.44132]]]]}	Open Access 1	48828	Pico Park	33547	6132	Marblehead Development Partners LLC 1045	Private 7	Home Owners Association 16		Private 14	1296	San Clemente, City of 350	City 2	City Agency 2	https://www.san-clemente.org/Home/Components/FacilityDirectory/FacilityDirectory/177/2783	Orange 3	1.598	Pico Park	Local Park 2	4
13710	13710	13709	{"type": "Polygon", "coordinates": [[[-117.63508, 33.43915], [-117.63504, 33.43931], [-117.63483, 33.43958], [-117.6348, 33.43975], [-117.63483, 33.43992], [-117.63482, 33.43996], [-117.6348, 33.43996], [-117.63467, 33.43984], [-117.63463, 33.43977], [-117.63447, 33.43944], [-117.63446, 33.43937], [-117.63453, 33.43926], [-117.63476, 33.43918], [-117.63492, 33.4391], [-117.63508, 33.43915]]]}	Open Access 1	48829	Canyon View Park	33548	6132	Marblehead Development Partners LLC 1045	Private 7	Home Owners Association 16		Private 14	1296	San Clemente, City of 350	City 2	City Agency 2	https://www.san-clemente.org/Home/Components/FacilityDirectory/FacilityDirectory/173/2783	Orange 3	0.667	Canyon View Park	Local Park 2	4
15168	15168	15167	{"type": "Polygon", "coordinates": [[[-118.32353, 33.34225], [-118.32381, 33.34224], [-118.32377, 33.34263], [-118.32321, 33.34256], [-118.32326, 33.34241], [-118.32332, 33.34234], [-118.32339, 33.34229], [-118.32353, 33.34225]]]}	Open Access 1	46018	Avalon City Park	29343	6013	Northwood II Community Association 1139	Private 7	Home Owners Association 16		Private 14	1016	Avalon, City of 327	City 2	City Agency 2		Los Angeles 6	0.445	Avalon City Park	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]);