calands: units_with_maps: 7 rows where AGNCY_NAME = 54 and DES

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

7 rows where AGNCY_NAME = 54 and DES_TP = 3

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	COUNTY	ACRES	LABEL_NAME	DES_TP	GAP_STS
4093	4093	4092	{"type": "Polygon", "coordinates": [[[-117.90419, 33.63263], [-117.90311, 33.63371], [-117.90243, 33.63323], [-117.90214, 33.63297], [-117.90198, 33.63277], [-117.90184, 33.63256], [-117.90169, 33.63222], [-117.90161, 33.63187], [-117.90159, 33.63163], [-117.90196, 33.6316], [-117.90221, 33.63156], [-117.90352, 33.63246], [-117.90368, 33.63231], [-117.90419, 33.63263]]]}	Open Access 1	47498	Mariners Park and VJ Community Center	31213	1224	Newport Beach, City of 54	City 2	City Agency 2	http://www.newportbeachca.gov/index.aspx?page=66	City 2	1224	Newport Beach, City of 52	City 2	City Agency 2	Orange 3	7.141	Mariners Park and VJ Community Ctr.	Local Recreation Area 3	4
5227	5227	5226	{"type": "Polygon", "coordinates": [[[-117.86524, 33.60879], [-117.86483, 33.60907], [-117.86416, 33.6095], [-117.86411, 33.60951], [-117.86405, 33.60949], [-117.86372, 33.60917], [-117.86319, 33.60873], [-117.86378, 33.60813], [-117.86428, 33.60812], [-117.86524, 33.60879]]]}	Open Access 1	47423	San Joaquin Hills Park and Lawn Bowling Center	31139	1224	Newport Beach, City of 54	City 2	City Agency 2	http://www.newportbeachca.gov/index.aspx?page=66	City 2	1224	Newport Beach, City of 52	City 2	City Agency 2	Orange 3	4.07	San Joaquin Hills Park and Lawn Bowling Ctr.	Local Recreation Area 3	4
6613	6613	6612	{"type": "Polygon", "coordinates": [[[-117.86382, 33.60982], [-117.86172, 33.61131], [-117.86129, 33.61119], [-117.86101, 33.61109], [-117.86082, 33.61098], [-117.86122, 33.6105], [-117.86108, 33.6102], [-117.86144, 33.6101], [-117.86202, 33.60937], [-117.86076, 33.60849], [-117.8612, 33.60805], [-117.86152, 33.60818], [-117.86184, 33.60833], [-117.86257, 33.60876], [-117.86318, 33.6092], [-117.86358, 33.60957], [-117.86382, 33.60982]]]}	Open Access 1	4178	Lincoln Athletic Center	21246	1224	Newport Beach, City of 54	City 2	City Agency 2	http://www.newportbeachca.gov/index.aspx?page=66	City 2	1224	Newport Beach, City of 52	City 2	City Agency 2	Orange 3	11.879	Lincoln Athletic Ctr.	Local Recreation Area 3	4
6714	6714	6713	{"type": "Polygon", "coordinates": [[[-117.89547, 33.62507], [-117.89512, 33.62537], [-117.89455, 33.62546], [-117.89418, 33.62594], [-117.89326, 33.6255], [-117.89307, 33.62508], [-117.89331, 33.6246], [-117.89335, 33.62458], [-117.89391, 33.62465], [-117.89473, 33.62505], [-117.8949, 33.62511], [-117.895, 33.62513], [-117.89516, 33.6251], [-117.89533, 33.62496], [-117.89547, 33.62507]]]}	Open Access 1	5667	Newport Aquatic Center	22732	1224	Newport Beach, City of 54	City 2	City Agency 2	http://www.newportbeachca.gov/index.aspx?page=66	City 2	1224	Newport Beach, City of 52	City 2	City Agency 2	Orange 3	4.173	Newport Aquatic Ctr.	Local Recreation Area 3	4
7710	7710	7709	{"type": "MultiPolygon", "coordinates": [[[[-117.85528, 33.62737], [-117.85512, 33.62771], [-117.85493, 33.62817], [-117.85485, 33.62821], [-117.85431, 33.62807], [-117.85385, 33.62797], [-117.85346, 33.62791], [-117.85297, 33.62786], [-117.85262, 33.62785], [-117.85196, 33.62787], [-117.85144, 33.62793], [-117.85086, 33.62804], [-117.84982, 33.6283], [-117.84977, 33.62827], [-117.84956, 33.6274], [-117.8496, 33.62734], [-117.85038, 33.62707], [-117.85038, 33.62705], [-117.85084, 33.62693], [-117.85128, 33.62684], [-117.85167, 33.62679], [-117.85241, 33.62675], [-117.8531, 33.62677], [-117.85392, 33.62689], [-117.8541, 33.62692], [-117.85442, 33.627], [-117.85523, 33.62726], [-117.85528, 33.62737]]], [[[-117.86099, 33.62921], [-117.85988, 33.62926], [-117.85987, 33.62924], [-117.85905, 33.62926], [-117.85843, 33.62921], [-117.85801, 33.62915], [-117.858, 33.62917], [-117.85748, 33.62906], [-117.85688, 33.62887], [-117.85641, 33.6287], [-117.85616, 33.62859], [-117.85537, 33.62835], [-117.85528, 33.62827], [-117.85563, 33.62746], [-117.85574, 33.62742], [-117.85622, 33.62759], [-117.85778, 33.6279], [-117.85833, 33.62799], [-117.85992, 33.62813], [-117.85963, 33.62876], [-117.86099, 33.62921]]], [[[-117.86191, 33.62918], [-117.86118, 33.62842], [-117.86097, 33.62823], [-117.86069, 33.62805], [-117.86033, 33.62792], [-117.86016, 33.62788], [-117.86035, 33.62761], [-117.86067, 33.62697], [-117.86081, 33.62647], [-117.86078, 33.62612], [-117.86074, 33.62521], [-117.86068, 33.62474], [-117.86023, 33.62329], [-117.86013, 33.62198], [-117.86037, 33.62199], [-117.86042, 33.62174], [-117.86048, 33.62129], [-117.86055, 33.62104], [-117.8603, 33.62065], [-117.86052, 33.62055], [-117.86071, 33.62036], [-117.86076, 33.62029], [-117.86084, 33.6201], [-117.86093, 33.6198], [-117.86147, 33.61991], [-117.86116, 33.62058], [-117.86105, 33.62093], [-117.86089, 33.62157], [-117.86083, 33.62201], [-117.8608, 33.62277], [-117.86083, 33.62325], [-117.86092, 33.6238], [-117.86102, 33.62428], [-117.86131, 33.62535], [-117.86158, 33.62667], [-117.86184, 33.62781], [-117.86212, 33.62888], [-117.86212, 33.62902], [-117.8621, 33.62908], [-117.86201, 33.62915], [-117.86191, 33.62918]]]]}	Open Access 1	7785	Bonita Canyon Sports Park	16258	1224	Newport Beach, City of 54	City 2	City Agency 2	http://www.newportbeachca.gov/index.aspx?page=66	City 2	1224	Newport Beach, City of 52	City 2	City Agency 2	Orange 3	44.715	Bonita Canyon Sports Park	Local Recreation Area 3	4
8844	8844	8843	{"type": "Polygon", "coordinates": [[[-117.89841, 33.60599], [-117.89815, 33.60629], [-117.89792, 33.60615], [-117.89821, 33.60581], [-117.89841, 33.60599]]]}	Open Access 1	14438	Balboa Island Park at Carroll Beek Community Center	15771	1224	Newport Beach, City of 54	City 2	City Agency 2	http://www.newportbeachca.gov/index.aspx?page=66	City 2	1224	Newport Beach, City of 52	City 2	City Agency 2	Orange 3	0.279	Balboa Island Park at Carroll Beek Community Ctr.	Local Recreation Area 3	4
14510	14510	14509	{"type": "Polygon", "coordinates": [[[-117.86267, 33.64909], [-117.86194, 33.64709], [-117.86197, 33.64568], [-117.862, 33.64568], [-117.862, 33.64573], [-117.86204, 33.64578], [-117.86211, 33.64582], [-117.86267, 33.64583], [-117.86309, 33.6458], [-117.86336, 33.64575], [-117.86363, 33.64567], [-117.86368, 33.64567], [-117.86372, 33.6457], [-117.8638, 33.64593], [-117.86392, 33.64669], [-117.86398, 33.64689], [-117.86406, 33.64708], [-117.86447, 33.64777], [-117.86448, 33.64781], [-117.86446, 33.64784], [-117.86439, 33.64789], [-117.86428, 33.64793], [-117.86413, 33.64804], [-117.86405, 33.64814], [-117.86313, 33.6488], [-117.86267, 33.64909]]]}	Open Access 1	47406	Bonita Creek Park and Community Center	31123	1224	Newport Beach, City of 54	City 2	City Agency 2	http://www.newportbeachca.gov/index.aspx?page=66	City 2	1224	Newport Beach, City of 52	City 2	City Agency 2	Orange 3	14.269	Bonita Creek Park and Community Ctr.	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]);