calands: superunits_with_maps: 76 rows where LAYER = 2, MNG_AGENCY = 122 and MNG_AG

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

76 rows where LAYER = 2, MNG_AGENCY = 122 and MNG_AG_TYP = 2

Search:

descending

This data as json, copyable, CSV (advanced)

Link	rowid ▼	id	map	ACCESS_TYP	PARK_NAME	PARK_URL	SUID_NMA	MNG_AG_ID	MNG_AGENCY	MNG_AG_LEV	MNG_AG_TYP	AGNCY_WEB	LAYER	ACRES	LABEL_NAME
1560	1560	1559	{"type": "Polygon", "coordinates": [[[-117.94628, 33.67622], [-117.94628, 33.6763], [-117.94625, 33.67634], [-117.94616, 33.67636], [-117.94592, 33.67638], [-117.94564, 33.67662], [-117.94522, 33.67792], [-117.94463, 33.67779], [-117.94518, 33.67613], [-117.94576, 33.67624], [-117.94577, 33.67627], [-117.94615, 33.67622], [-117.9462, 33.67616], [-117.94628, 33.67622]]]}	Open Access 1	Arevalos Park	http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/arevalos-park.cfm	15580	1141	Huntington Beach, City of 122	City 2	City Agency 2	http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm	City 2	2.891	Arevalos Park
1722	1722	1721	{"type": "Polygon", "coordinates": [[[-118.01411, 33.67395], [-118.01404, 33.67436], [-118.01368, 33.67446], [-118.0136, 33.67444], [-118.01358, 33.67441], [-118.01358, 33.67436], [-118.01364, 33.67399], [-118.01366, 33.67398], [-118.0137, 33.67394], [-118.01374, 33.67393], [-118.01411, 33.67395]]]}	Open Access 1	Bailey Park		15760	1141	Huntington Beach, City of 122	City 2	City Agency 2	http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm	City 2	0.556	Bailey Park
1785	1785	1784	{"type": "Polygon", "coordinates": [[[-117.98765, 33.67267], [-117.98687, 33.67386], [-117.98688, 33.67419], [-117.98733, 33.67419], [-117.98734, 33.67457], [-117.98688, 33.67459], [-117.9869, 33.67599], [-117.98641, 33.67682], [-117.98645, 33.67935], [-117.98583, 33.67934], [-117.98577, 33.6793], [-117.98576, 33.67902], [-117.98573, 33.67883], [-117.98566, 33.67864], [-117.98556, 33.67846], [-117.98544, 33.6783], [-117.98528, 33.67815], [-117.98511, 33.67802], [-117.98486, 33.67788], [-117.98473, 33.67777], [-117.98478, 33.67771], [-117.98439, 33.67729], [-117.98438, 33.67724], [-117.98457, 33.677], [-117.98469, 33.67675], [-117.98473, 33.67649], [-117.98472, 33.67606], [-117.98474, 33.6759], [-117.98479, 33.67575], [-117.98565, 33.67392], [-117.98579, 33.67354], [-117.98585, 33.67328], [-117.98588, 33.67301], [-117.98588, 33.67237], [-117.98765, 33.67236], [-117.98765, 33.67267]]]}	Open Access 1	Bartlett Park	http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/bartlett-park.cfm	15843	1141	Huntington Beach, City of 122	City 2	City Agency 2	http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm	City 2	27.767	Bartlett Park
2129	2129	2128	{"type": "Polygon", "coordinates": [[[-118.03039, 33.70438], [-118.03038, 33.70442], [-118.03025, 33.70461], [-118.02969, 33.7044], [-118.02812, 33.70442], [-118.02812, 33.70402], [-118.02845, 33.70383], [-118.02854, 33.7039], [-118.02861, 33.70391], [-118.02886, 33.70387], [-118.02912, 33.70387], [-118.02928, 33.70388], [-118.0297, 33.70398], [-118.02989, 33.70405], [-118.03025, 33.70426], [-118.03039, 33.70438]]]}	Open Access 1	Bolsa View Park	http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/bolsa-view-park.cfm	16249	1141	Huntington Beach, City of 122	City 2	City Agency 2	http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm	City 2	2.675	Bolsa View Park
2154	2154	2153	{"type": "Polygon", "coordinates": [[[-118.06, 33.71724], [-118.05953, 33.71725], [-118.05952, 33.71647], [-118.05955, 33.71643], [-118.05972, 33.71641], [-118.05999, 33.71707], [-118.06, 33.71724]]]}	Open Access 1	Booster Park	http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/booster-park.cfm	16274	1141	Huntington Beach, City of 122	City 2	City Agency 2	http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm	City 2	0.751	Booster Park
2186	2186	2185	{"type": "Polygon", "coordinates": [[[-118.02066, 33.73424], [-118.01946, 33.73425], [-118.01943, 33.73321], [-118.01956, 33.73328], [-118.01967, 33.73337], [-118.01981, 33.73345], [-118.01994, 33.73349], [-118.02008, 33.7335], [-118.02022, 33.7336], [-118.02065, 33.73362], [-118.02066, 33.73424]]]}	Open Access 1	Circle View Park	http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/circle-view-park.cfm	17267	1141	Huntington Beach, City of 122	City 2	City Agency 2	http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm	City 2	2.314	Circle View Park
2349	2349	2348	{"type": "Polygon", "coordinates": [[[-118.02235, 33.74789], [-118.02102, 33.74789], [-118.02099, 33.74694], [-118.02233, 33.74691], [-118.02235, 33.74789]]]}	Open Access 1	Clegg-Stacey Park	http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/clegg-stacey-park.cfm	17418	1141	Huntington Beach, City of 122	City 2	City Agency 2	http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm	City 2	3.253	Clegg-Stacey Park
2365	2365	2364	{"type": "Polygon", "coordinates": [[[-117.95978, 33.66175], [-117.95953, 33.66177], [-117.95945, 33.6618], [-117.95939, 33.66186], [-117.95936, 33.66197], [-117.95937, 33.66243], [-117.95934, 33.66247], [-117.95888, 33.66264], [-117.95866, 33.66266], [-117.95859, 33.66263], [-117.95857, 33.66158], [-117.95855, 33.6615], [-117.95978, 33.66149], [-117.95978, 33.66175]]]}	Open Access 1	Burke Park	http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/burke-park.cfm	16521	1141	Huntington Beach, City of 122	City 2	City Agency 2	http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm	City 2	2.488	Burke Park
2374	2374	2373	{"type": "Polygon", "coordinates": [[[-117.9594, 33.67707], [-117.9594, 33.67765], [-117.95937, 33.67768], [-117.95933, 33.67769], [-117.95882, 33.67769], [-117.95873, 33.67771], [-117.95827, 33.67769], [-117.95825, 33.67781], [-117.95819, 33.67781], [-117.95818, 33.6777], [-117.958, 33.67751], [-117.95803, 33.67743], [-117.95798, 33.67731], [-117.95795, 33.67708], [-117.95825, 33.67707], [-117.95827, 33.67701], [-117.95936, 33.67701], [-117.9594, 33.67707]]]}	Open Access 1	Bushard Park	http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/bushard-park.cfm	16539	1141	Huntington Beach, City of 122	City 2	City Agency 2	http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm	City 2	2.374	Bushard Park
2658	2658	2657	{"type": "Polygon", "coordinates": [[[-118.02397, 33.72238], [-118.02391, 33.72239], [-118.02391, 33.72252], [-118.02388, 33.72257], [-118.02382, 33.72259], [-118.02366, 33.7226], [-118.02365, 33.72265], [-118.0219, 33.72266], [-118.02187, 33.72052], [-118.02394, 33.72051], [-118.02397, 33.72238]]]}	Open Access 1	Carr Park	http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/carr-park.cfm	16906	1141	Huntington Beach, City of 122	City 2	City Agency 2	http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm	City 2	11.206	Carr Park
3101	3101	3100	{"type": "Polygon", "coordinates": [[[-118.01229, 33.72641], [-118.0119, 33.72641], [-118.01192, 33.72613], [-118.0119, 33.72607], [-118.01186, 33.72601], [-118.0118, 33.72598], [-118.01173, 33.72596], [-118.01142, 33.72599], [-118.01138, 33.72597], [-118.01136, 33.72594], [-118.01136, 33.72567], [-118.01141, 33.72551], [-118.01146, 33.72541], [-118.01169, 33.72513], [-118.01177, 33.72497], [-118.01181, 33.72481], [-118.01186, 33.72477], [-118.01215, 33.72476], [-118.01215, 33.72503], [-118.01227, 33.72504], [-118.01229, 33.72641]]]}	Open Access 1	College View Park	http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/college-view-park.cfm	17515	1141	Huntington Beach, City of 122	City 2	City Agency 2	http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm	City 2	2.594	College View Park
3154	3154	3153	{"type": "Polygon", "coordinates": [[[-118.06828, 33.72459], [-118.06804, 33.72464], [-118.06803, 33.72458], [-118.06796, 33.72453], [-118.06789, 33.72451], [-118.0678, 33.72454], [-118.06773, 33.72449], [-118.06743, 33.72457], [-118.06714, 33.7247], [-118.06707, 33.72464], [-118.06699, 33.72463], [-118.06694, 33.72464], [-118.06688, 33.72468], [-118.06685, 33.72474], [-118.06656, 33.72481], [-118.0666, 33.72492], [-118.06633, 33.72499], [-118.06631, 33.72503], [-118.06623, 33.72502], [-118.06616, 33.72505], [-118.06612, 33.72508], [-118.0661, 33.72514], [-118.06612, 33.72522], [-118.06592, 33.7253], [-118.06556, 33.7253], [-118.06555, 33.72559], [-118.06499, 33.72559], [-118.065, 33.72549], [-118.06519, 33.72548], [-118.06531, 33.72529], [-118.06529, 33.72524], [-118.06536, 33.7252], [-118.06539, 33.72515], [-118.06546, 33.72516], [-118.06572, 33.72507], [-118.06594, 33.7249], [-118.06594, 33.72485], [-118.066, 33.72483], [-118.06605, 33.7248], [-118.0662, 33.72481], [-118.06648, 33.72463], [-118.06662, 33.7244], [-118.06668, 33.72441], [-118.06676, 33.72439], [-118.0668, 33.72437], [-118.06683, 33.72431], [-118.06696, 33.72426], [-118.06712, 33.72403], [-118.06733, 33.72411], [-118.06749, 33.72388], [-118.06775, 33.72403], [-118.0676, 33.72427], [-118.06828, 33.72459]]]}	Open Access 1	Conrad Park	http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/conrad-park.cfm	17595	1141	Huntington Beach, City of 122	City 2	City Agency 2	http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm	City 2	2.765	Conrad Park
3614	3614	3613	{"type": "MultiPolygon", "coordinates": [[[[-118.01043, 33.68427], [-118.01036, 33.68434], [-118.01026, 33.68438], [-118.0102, 33.68444], [-118.01013, 33.6844], [-118.01005, 33.68443], [-118.00998, 33.68442], [-118.00994, 33.68444], [-118.00981, 33.68434], [-118.0082, 33.68347], [-118.00802, 33.68341], [-118.00783, 33.68337], [-118.00763, 33.68335], [-118.00732, 33.68337], [-118.00727, 33.68291], [-118.00769, 33.68287], [-118.0081, 33.68289], [-118.00852, 33.68297], [-118.00891, 33.6831], [-118.00926, 33.68329], [-118.00949, 33.68344], [-118.01041, 33.68419], [-118.01043, 33.68427]]], [[[-118.01234, 33.68482], [-118.01231, 33.68488], [-118.01232, 33.68507], [-118.01193, 33.68516], [-118.0113, 33.68493], [-118.01118, 33.68493], [-118.01108, 33.68498], [-118.01071, 33.68488], [-118.01068, 33.68489], [-118.0106, 33.68516], [-118.01057, 33.68545], [-118.01057, 33.68584], [-118.01061, 33.68587], [-118.01046, 33.68585], [-118.01039, 33.68587], [-118.01039, 33.6854], [-118.01043, 33.68513], [-118.0105, 33.68485], [-118.0105, 33.68469], [-118.01044, 33.68467], [-118.01032, 33.68468], [-118.01027, 33.68465], [-118.01025, 33.6846], [-118.01038, 33.68459], [-118.01044, 33.68456], [-118.01048, 33.68451], [-118.01049, 33.68442], [-118.01056, 33.68435], [-118.01065, 33.68434], [-118.01084, 33.68444], [-118.0111, 33.68455], [-118.01151, 33.68467], [-118.01194, 33.68473], [-118.01229, 33.68474], [-118.01229, 33.68478], [-118.01234, 33.68482]]]]}	Open Access 1	Discovery Well Park	http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/discovery-well-park.cfm	18168	1141	Huntington Beach, City of 122	City 2	City Agency 2	http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm	City 2	7.078	Discovery Well Park
3708	3708	3707	{"type": "Polygon", "coordinates": [[[-117.98267, 33.6682], [-117.98263, 33.66821], [-117.98258, 33.66825], [-117.98254, 33.66832], [-117.98253, 33.66844], [-117.98254, 33.66877], [-117.98249, 33.66881], [-117.9816, 33.66881], [-117.98159, 33.66789], [-117.98266, 33.66788], [-117.98266, 33.66817], [-117.98267, 33.6682]]]}	Open Access 1	Drew Park		18272	1141	Huntington Beach, City of 122	City 2	City Agency 2	http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm	City 2	2.309	Drew Park
3763	3763	3762	{"type": "Polygon", "coordinates": [[[-117.96625, 33.64478], [-117.96566, 33.64478], [-117.96564, 33.64375], [-117.96508, 33.64374], [-117.96508, 33.64337], [-117.96624, 33.64336], [-117.96625, 33.64478]]]}	Open Access 1	Eader Park	http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/eader-park.cfm	18334	1141	Huntington Beach, City of 122	City 2	City Agency 2	http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm	City 2	2.686	Eader Park
4227	4227	4226	{"type": "Polygon", "coordinates": [[[-118.01016, 33.68053], [-118.00996, 33.68077], [-118.0093, 33.6804], [-118.00927, 33.68037], [-118.00927, 33.68033], [-118.00937, 33.68019], [-118.00941, 33.68017], [-118.00946, 33.68017], [-118.00976, 33.68034], [-118.00983, 33.68045], [-118.00989, 33.68049], [-118.00996, 33.6805], [-118.01005, 33.68047], [-118.01016, 33.68053]]]}	Open Access 1	Finley Park		18905	1141	Huntington Beach, City of 122	City 2	City Agency 2	http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm	City 2	0.557	Finley Park
4383	4383	4382	{"type": "Polygon", "coordinates": [[[-118.02866, 33.75342], [-118.02769, 33.75342], [-118.02749, 33.75337], [-118.02741, 33.7534], [-118.02734, 33.75347], [-118.02707, 33.7534], [-118.02705, 33.75282], [-118.02729, 33.75282], [-118.02737, 33.75286], [-118.02739, 33.75291], [-118.02741, 33.75315], [-118.02825, 33.75314], [-118.02841, 33.75306], [-118.02866, 33.75306], [-118.02866, 33.75342]]]}	Open Access 1	Franklin Park		19062	1141	Huntington Beach, City of 122	City 2	City Agency 2	http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm	City 2	1.452	Franklin Park
4559	4559	4558	{"type": "Polygon", "coordinates": [[[-118.036, 33.71978], [-118.0359, 33.71996], [-118.03581, 33.72025], [-118.03579, 33.72045], [-118.03583, 33.72074], [-118.0358, 33.72076], [-118.03539, 33.72084], [-118.0353, 33.72088], [-118.03522, 33.7208], [-118.03495, 33.7208], [-118.03493, 33.72083], [-118.03282, 33.72084], [-118.0328, 33.72002], [-118.0349, 33.72], [-118.03491, 33.71978], [-118.036, 33.71978]]]}	Open Access 1	Gibbs Park	http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/gibbs-park.cfm	19289	1141	Huntington Beach, City of 122	City 2	City Agency 2	http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm	City 2	6.858	Gibbs Park
4573	4573	4572	{"type": "Polygon", "coordinates": [[[-117.96216, 33.65367], [-117.96217, 33.65436], [-117.96215, 33.6544], [-117.9621, 33.65444], [-117.96168, 33.65444], [-117.96166, 33.65417], [-117.95798, 33.65419], [-117.95797, 33.65472], [-117.95756, 33.65473], [-117.95755, 33.65454], [-117.95718, 33.65454], [-117.95716, 33.65419], [-117.95382, 33.65421], [-117.95382, 33.65372], [-117.96216, 33.65367]]]}	Open Access 1	Gisler Park	http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/gisler-park.cfm	19304	1141	Huntington Beach, City of 122	City 2	City Agency 2	http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm	City 2	11.754	Gisler Park
4592	4592	4591	{"type": "Polygon", "coordinates": [[[-118.01213, 33.73489], [-118.01191, 33.73503], [-118.01177, 33.73516], [-118.0117, 33.73525], [-118.01163, 33.7355], [-118.01163, 33.73585], [-118.01122, 33.73585], [-118.01119, 33.73402], [-118.01212, 33.73402], [-118.01213, 33.73489]]]}	Open Access 1	Glen View Park		19325	1141	Huntington Beach, City of 122	City 2	City Agency 2	http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm	City 2	3.31	Glen View Park

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE superunits_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  PARK_NAME TEXT,
  PARK_URL TEXT,
  SUID_NMA INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
    ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
    ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
    ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
    ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
    ON [superunits_with_maps] ([ACCESS_TYP]);