calands: units_with_maps: 21 rows where COUNTY = 3, MNG_AGENCY = 131 and YR

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

21 rows where COUNTY = 3, MNG_AGENCY = 131 and YR_EST = 0

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
330	330	329	{"type": "Polygon", "coordinates": [[[-117.67006, 33.45754], [-117.67005, 33.45792], [-117.66979, 33.45796], [-117.66978, 33.45783], [-117.66974, 33.45773], [-117.66967, 33.45761], [-117.66935, 33.45735], [-117.66951, 33.45716], [-117.67006, 33.45754]]]}	Open Access 1	887	Palisades Gazebo Park	23328	1079	Dana Point, City of 134	City 2	City Agency 2	http://www.danapoint.org/index.aspx?page=170	City 2	1079	Dana Point, City of 131	City 2	City Agency 2	Orange 3	0.658	Palisades Gazebo Park	Local Park 2	4
901	901	900	{"type": "Polygon", "coordinates": [[[-117.66184, 33.46377], [-117.66182, 33.46383], [-117.66178, 33.46386], [-117.66149, 33.46387], [-117.66112, 33.46385], [-117.66082, 33.46378], [-117.66056, 33.4637], [-117.66027, 33.46356], [-117.66001, 33.46338], [-117.65999, 33.46335], [-117.65999, 33.46331], [-117.66022, 33.46318], [-117.66036, 33.46312], [-117.66068, 33.46302], [-117.66079, 33.46302], [-117.66101, 33.46308], [-117.66132, 33.46306], [-117.66136, 33.46309], [-117.66141, 33.46315], [-117.66184, 33.46377]]]}	Open Access 1	5800	Sunset Park	26053	1079	Dana Point, City of 134	City 2	City Agency 2	http://www.danapoint.org/index.aspx?page=170	City 2	1079	Dana Point, City of 131	City 2	City Agency 2	Orange 3	2.612	Sunset Park	Local Park 2	4
1570	1570	1569	{"type": "Polygon", "coordinates": [[[-117.70667, 33.47812], [-117.70659, 33.4798], [-117.70661, 33.48059], [-117.7065, 33.48059], [-117.70648, 33.48064], [-117.70605, 33.48082], [-117.7061, 33.48092], [-117.70599, 33.48106], [-117.70598, 33.48127], [-117.70515, 33.48177], [-117.70498, 33.48203], [-117.70498, 33.48205], [-117.70527, 33.48218], [-117.70526, 33.4822], [-117.70495, 33.48207], [-117.70448, 33.48277], [-117.70436, 33.48264], [-117.7042, 33.48253], [-117.70378, 33.48232], [-117.70377, 33.48229], [-117.70379, 33.4821], [-117.70378, 33.48197], [-117.70368, 33.48173], [-117.70382, 33.48156], [-117.70391, 33.48138], [-117.70399, 33.48129], [-117.70468, 33.48092], [-117.70496, 33.48078], [-117.70474, 33.48046], [-117.70532, 33.48034], [-117.70567, 33.4801], [-117.7056, 33.47961], [-117.70465, 33.47939], [-117.70402, 33.47921], [-117.70363, 33.47905], [-117.70294, 33.47912], [-117.70342, 33.47872], [-117.70333, 33.47797], [-117.70384, 33.47804], [-117.70408, 33.4781], [-117.70587, 33.47808], [-117.70604, 33.47811], [-117.70667, 33.47812]]]}	Open Access 1	12042	Sea Canyon Park	25231	1079	Dana Point, City of 134	City 2	City Agency 2	http://www.danapoint.org/index.aspx?page=170	City 2	1079	Dana Point, City of 131	City 2	City Agency 2	Orange 3	21.33	Sea Canyon Park	Local Park 2	4
2704	2704	2703	{"type": "Polygon", "coordinates": [[[-117.70402, 33.48479], [-117.70386, 33.48502], [-117.70378, 33.48506], [-117.70372, 33.48512], [-117.70364, 33.4853], [-117.70341, 33.48565], [-117.70336, 33.48567], [-117.70303, 33.48554], [-117.70273, 33.48536], [-117.70262, 33.48526], [-117.70238, 33.48501], [-117.70271, 33.4848], [-117.70287, 33.48448], [-117.70286, 33.48428], [-117.70303, 33.48435], [-117.70339, 33.48456], [-117.70402, 33.48479]]]}	Open Access 1	18351	Dana Crest Park	17909	1079	Dana Point, City of 134	City 2	City Agency 2	http://www.danapoint.org/index.aspx?page=170	City 2	1079	Dana Point, City of 131	City 2	City Agency 2	Orange 3	2.927	Dana Crest Park	Local Park 2	4
3705	3705	3704	{"type": "Polygon", "coordinates": [[[-117.69339, 33.46661], [-117.69327, 33.46682], [-117.69286, 33.4667], [-117.69222, 33.46655], [-117.69079, 33.46631], [-117.69087, 33.46607], [-117.69253, 33.46636], [-117.69294, 33.46646], [-117.69339, 33.46661]]]}	Open Access 1	30259	Crystal Cove Park	17844	1079	Dana Point, City of 134	City 2	City Agency 2	http://www.danapoint.org/index.aspx?page=170	City 2	1079	Dana Point, City of 131	City 2	City Agency 2	Orange 3	1.606	Crystal Cove Park	Local Park 2	4
7743	7743	7742	{"type": "Polygon", "coordinates": [[[-117.6661, 33.45584], [-117.666, 33.45591], [-117.66581, 33.45611], [-117.66574, 33.45613], [-117.66504, 33.45562], [-117.66492, 33.45549], [-117.66473, 33.45521], [-117.66459, 33.45484], [-117.6645, 33.45471], [-117.6644, 33.45458], [-117.66401, 33.45421], [-117.66451, 33.45387], [-117.66441, 33.45367], [-117.66424, 33.45343], [-117.66542, 33.45415], [-117.6657, 33.45434], [-117.66557, 33.45451], [-117.6655, 33.45479], [-117.66555, 33.455], [-117.66577, 33.45522], [-117.6661, 33.45584]]]}	Open Access 1	8509	Pines Park	23690	1079	Dana Point, City of 134	City 2	City Agency 2	http://www.danapoint.org/index.aspx?page=170	City 2	1079	Dana Point, City of 131	City 2	City Agency 2	Orange 3	5.806	Pines Park	Local Park 2	4
8213	8213	8212	{"type": "Polygon", "coordinates": [[[-117.67782, 33.46207], [-117.67771, 33.46227], [-117.67737, 33.46213], [-117.67731, 33.46208], [-117.67725, 33.46196], [-117.67719, 33.46188], [-117.67715, 33.46174], [-117.67713, 33.4617], [-117.67707, 33.46167], [-117.67701, 33.46168], [-117.67691, 33.46179], [-117.67689, 33.46179], [-117.67697, 33.46153], [-117.67782, 33.46207]]]}	Open Access 1	12475	Louise Leyden Park	21549	1079	Dana Point, City of 134	City 2	City Agency 2	http://www.danapoint.org/index.aspx?page=170	City 2	1079	Dana Point, City of 131	City 2	City Agency 2	Orange 3	0.521	Louise Leyden Park	Local Park 2	4
8954	8954	8953	{"type": "Polygon", "coordinates": [[[-117.69074, 33.4777], [-117.68943, 33.47835], [-117.68941, 33.47669], [-117.69008, 33.47658], [-117.69013, 33.47658], [-117.69016, 33.47665], [-117.69026, 33.47692], [-117.69036, 33.47712], [-117.69074, 33.4777]]]}	Open Access 1	14752	Thunderbird Park	26337	1079	Dana Point, City of 134	City 2	City Agency 2	http://www.danapoint.org/index.aspx?page=170	City 2	1079	Dana Point, City of 131	City 2	City Agency 2	Orange 3	3.805	Thunderbird Park	Local Park 2	4
11965	11965	11964	{"type": "Polygon", "coordinates": [[[-117.68421, 33.46825], [-117.68397, 33.46869], [-117.68382, 33.46877], [-117.6837, 33.46897], [-117.68367, 33.46911], [-117.68367, 33.46923], [-117.68372, 33.46931], [-117.68378, 33.46937], [-117.68384, 33.46939], [-117.68377, 33.46957], [-117.68374, 33.46963], [-117.68367, 33.46966], [-117.68349, 33.46961], [-117.68341, 33.46955], [-117.6834, 33.4695], [-117.68334, 33.46947], [-117.68327, 33.46922], [-117.6832, 33.46913], [-117.68299, 33.46891], [-117.68297, 33.46882], [-117.68303, 33.46865], [-117.6823, 33.46841], [-117.68245, 33.46806], [-117.68241, 33.46804], [-117.68258, 33.46752], [-117.68277, 33.4667], [-117.68405, 33.46714], [-117.68398, 33.46729], [-117.68372, 33.46723], [-117.68364, 33.46725], [-117.68357, 33.46736], [-117.68341, 33.46749], [-117.68333, 33.46762], [-117.68374, 33.46775], [-117.68368, 33.46791], [-117.68373, 33.46793], [-117.68366, 33.46808], [-117.68421, 33.46825]]]}	Open Access 1	24585	Del Obispo Park	18043	1079	Dana Point, City of 134	City 2	City Agency 2	http://www.danapoint.org/index.aspx?page=170	City 2	1079	Dana Point, City of 131	City 2	City Agency 2	Orange 3	7.065	Del Obispo Park	Local Park 2	4
11966	11966	11965	{"type": "Polygon", "coordinates": [[[-117.69807, 33.46235], [-117.69807, 33.46339], [-117.69794, 33.46341], [-117.69795, 33.46533], [-117.69789, 33.46539], [-117.6979, 33.46445], [-117.69788, 33.46429], [-117.69782, 33.46425], [-117.69786, 33.46418], [-117.69785, 33.46412], [-117.69791, 33.4641], [-117.6979, 33.46398], [-117.69774, 33.46365], [-117.69764, 33.46368], [-117.69743, 33.46356], [-117.69742, 33.4635], [-117.69737, 33.46345], [-117.69742, 33.46337], [-117.69733, 33.46325], [-117.69717, 33.46316], [-117.69702, 33.46313], [-117.69679, 33.46322], [-117.69672, 33.46317], [-117.69662, 33.46317], [-117.69659, 33.46318], [-117.69656, 33.46324], [-117.69646, 33.46323], [-117.69625, 33.4633], [-117.69608, 33.46344], [-117.69602, 33.46343], [-117.69596, 33.46343], [-117.69589, 33.4635], [-117.6958, 33.46349], [-117.69567, 33.46318], [-117.69558, 33.46257], [-117.69807, 33.46235]]]}	Open Access 1	24586	Heritage Park	19847	1079	Dana Point, City of 134	City 2	City Agency 2	http://www.danapoint.org/index.aspx?page=170	City 2	1079	Dana Point, City of 131	City 2	City Agency 2	Orange 3	5.919	Heritage Park	Local Park 2	4
12727	12727	12726	{"type": "Polygon", "coordinates": [[[-117.69382, 33.48532], [-117.69353, 33.48567], [-117.69361, 33.4864], [-117.69369, 33.48736], [-117.69286, 33.48735], [-117.69295, 33.48446], [-117.69315, 33.48458], [-117.69326, 33.48469], [-117.69343, 33.48503], [-117.6935, 33.48513], [-117.69358, 33.4852], [-117.69371, 33.48528], [-117.69382, 33.48532]]]}	Open Access 1	30266	Dana Woods Park	17915	1079	Dana Point, City of 134	City 2	City Agency 2	http://www.danapoint.org/index.aspx?page=170	City 2	1079	Dana Point, City of 131	City 2	City Agency 2	Orange 3	4.753	Dana Woods Park	Local Park 2	4
12814	12814	12813	{"type": "MultiPolygon", "coordinates": [[[[-117.68, 33.4774], [-117.67968, 33.47877], [-117.67924, 33.47862], [-117.67947, 33.47751], [-117.67952, 33.47734], [-117.68, 33.4774]]], [[[-117.68103, 33.47492], [-117.68036, 33.47591], [-117.68023, 33.47625], [-117.68017, 33.47633], [-117.67999, 33.47724], [-117.67954, 33.47718], [-117.67983, 33.47571], [-117.67937, 33.47553], [-117.67953, 33.47496], [-117.67961, 33.47464], [-117.68103, 33.47492]]]]}	Open Access 1	30257	Creekside Park	17773	1079	Dana Point, City of 134	City 2	City Agency 2	http://www.danapoint.org/index.aspx?page=170	City 2	1079	Dana Point, City of 131	City 2	City Agency 2	Orange 3	6.647	Creekside Park	Local Park 2	4
12815	12815	12814	{"type": "Polygon", "coordinates": [[[-117.68367, 33.46985], [-117.68351, 33.46991], [-117.68335, 33.46994], [-117.68231, 33.47077], [-117.68152, 33.47151], [-117.6814, 33.47167], [-117.68113, 33.47206], [-117.6809, 33.47254], [-117.6804, 33.47396], [-117.68031, 33.4743], [-117.68003, 33.47407], [-117.68027, 33.47329], [-117.68061, 33.47236], [-117.68083, 33.47192], [-117.68118, 33.47141], [-117.68141, 33.47112], [-117.68185, 33.4707], [-117.68267, 33.47009], [-117.68317, 33.46968], [-117.68367, 33.46985]]]}	Open Access 1	30258	Sycamore Creek Trail	26124	1079	Dana Point, City of 134	City 2	City Agency 2	http://www.danapoint.org/index.aspx?page=170	City 2	1079	Dana Point, City of 131	City 2	City Agency 2	Orange 3	4.795	Sycamore Creek Trail	Local Recreation Area 3	4
12816	12816	12815	{"type": "Polygon", "coordinates": [[[-117.68886, 33.46637], [-117.68881, 33.46642], [-117.6888, 33.46647], [-117.68882, 33.46662], [-117.68869, 33.46661], [-117.68873, 33.46658], [-117.68874, 33.46654], [-117.68871, 33.46649], [-117.68865, 33.46646], [-117.68867, 33.46638], [-117.68848, 33.46613], [-117.68824, 33.46605], [-117.68831, 33.46585], [-117.68878, 33.46598], [-117.68886, 33.46637]]]}	Open Access 1	30260	Sea View Park	25237	1079	Dana Point, City of 134	City 2	City Agency 2	http://www.danapoint.org/index.aspx?page=170	City 2	1079	Dana Point, City of 131	City 2	City Agency 2	Orange 3	0.501	Sea View Park	Local Park 2	4
12817	12817	12816	{"type": "Polygon", "coordinates": [[[-117.69767, 33.46954], [-117.69752, 33.46954], [-117.69752, 33.46919], [-117.69767, 33.46919], [-117.69766, 33.46937], [-117.69767, 33.46954]]]}	Open Access 1	30261	Shipwreck Park	25414	1079	Dana Point, City of 134	City 2	City Agency 2	http://www.danapoint.org/index.aspx?page=170	City 2	1079	Dana Point, City of 131	City 2	City Agency 2	Orange 3	0.131	Shipwreck Park	Local Park 2	4
12818	12818	12817	{"type": "Polygon", "coordinates": [[[-117.69929, 33.46711], [-117.69929, 33.46832], [-117.69903, 33.46831], [-117.69903, 33.46717], [-117.69929, 33.46711]]]}	Open Access 1	30262	La Plaza Park	20793	1079	Dana Point, City of 134	City 2	City Agency 2	http://www.danapoint.org/index.aspx?page=170	City 2	1079	Dana Point, City of 131	City 2	City Agency 2	Orange 3	0.781	La Plaza Park	Local Park 2	4
12820	12820	12819	{"type": "Polygon", "coordinates": [[[-117.70075, 33.46947], [-117.70035, 33.46948], [-117.70034, 33.46925], [-117.70036, 33.4692], [-117.7004, 33.46919], [-117.70074, 33.4692], [-117.70075, 33.46947]]]}	Open Access 1	30264	Lantern Village Community Park	21017	1079	Dana Point, City of 134	City 2	City Agency 2	http://www.danapoint.org/index.aspx?page=170	City 2	1079	Dana Point, City of 131	City 2	City Agency 2	Orange 3	0.285	Lantern Village Community Park	Local Park 2	4
12821	12821	12820	{"type": "Polygon", "coordinates": [[[-117.72107, 33.48182], [-117.71992, 33.48188], [-117.71981, 33.48185], [-117.71968, 33.48178], [-117.7184, 33.48061], [-117.7183, 33.48054], [-117.71813, 33.48049], [-117.71728, 33.48048], [-117.7172, 33.4809], [-117.71683, 33.48091], [-117.71572, 33.48073], [-117.71567, 33.47938], [-117.7164, 33.47922], [-117.71675, 33.47889], [-117.71691, 33.47864], [-117.71672, 33.47833], [-117.7167, 33.47823], [-117.71672, 33.47795], [-117.71642, 33.47769], [-117.71618, 33.47762], [-117.71581, 33.4774], [-117.71645, 33.47698], [-117.71594, 33.47642], [-117.71656, 33.47609], [-117.71766, 33.47762], [-117.71836, 33.47867], [-117.719, 33.47961], [-117.71934, 33.48003], [-117.72033, 33.48114], [-117.72107, 33.48182]]]}	Open Access 1	30265	Sea Terrace Park	25236	1079	Dana Point, City of 134	City 2	City Agency 2	http://www.danapoint.org/index.aspx?page=170	City 2	1079	Dana Point, City of 131	City 2	City Agency 2	Orange 3	27.329	Sea Terrace Park	Local Park 2	4
12864	12864	12863	{"type": "Polygon", "coordinates": [[[-117.71104, 33.46017], [-117.71103, 33.46132], [-117.71091, 33.46132], [-117.71082, 33.46129], [-117.71053, 33.46117], [-117.71035, 33.46112], [-117.71006, 33.46109], [-117.7098, 33.46111], [-117.70924, 33.46126], [-117.70911, 33.46123], [-117.70902, 33.46126], [-117.70898, 33.46133], [-117.709, 33.46143], [-117.70887, 33.46176], [-117.70813, 33.46154], [-117.70793, 33.46151], [-117.70785, 33.46153], [-117.70771, 33.46161], [-117.70757, 33.4618], [-117.70768, 33.46192], [-117.70724, 33.46192], [-117.70717, 33.46174], [-117.70713, 33.46155], [-117.7071, 33.46152], [-117.70708, 33.46145], [-117.70709, 33.46122], [-117.70715, 33.46108], [-117.70718, 33.46086], [-117.70724, 33.46071], [-117.70752, 33.46051], [-117.70763, 33.46051], [-117.70792, 33.46064], [-117.70826, 33.46076], [-117.70852, 33.46079], [-117.70925, 33.46045], [-117.70975, 33.46033], [-117.71008, 33.46028], [-117.71032, 33.46031], [-117.71078, 33.46019], [-117.71104, 33.46017]]]}	Open Access 1	44544	Dana Point Park	17912	1079	Dana Point, City of 134	City 2	City Agency 2	http://www.danapoint.org/index.aspx?page=170	City 2	1079	Dana Point, City of 131	City 2	City Agency 2	Orange 3	9.325	Dana Point Park	Local Park 2	4
13901	13901	13900	{"type": "Polygon", "coordinates": [[[-117.69747, 33.47613], [-117.69739, 33.47621], [-117.69661, 33.47623], [-117.69665, 33.47578], [-117.69677, 33.47564], [-117.69673, 33.47537], [-117.69664, 33.47519], [-117.69692, 33.47509], [-117.69713, 33.47505], [-117.69731, 33.47504], [-117.69737, 33.47509], [-117.6974, 33.47572], [-117.69747, 33.47613]]]}	Open Access 1	36512	Dana Point holding 1	17911	1079	Dana Point, City of 134	City 2	City Agency 2	http://www.danapoint.org/index.aspx?page=170	City 2	1079	Dana Point, City of 131	City 2	City Agency 2	Orange 3	2.085	Dana Point holding 1	Local Other or Unknown 14	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]);