superunits_with_maps

Table actions

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

76 rows where MNG_AGENCY = 122

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Huntington Beach, City of · 66 ✖

ACCESS_TYP 1

YR_EST 0 ✖

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 YR_EST
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  
4641 4641 4640 {"type": "Polygon", "coordinates": [[[-118.01306, 33.71283], [-118.0119, 33.71284], [-118.01185, 33.71282], [-118.01182, 33.7128], [-118.0118, 33.71276], [-118.01179, 33.71217], [-118.01174, 33.71208], [-118.01164, 33.71202], [-118.0118, 33.71188], [-118.01231, 33.71188], [-118.01233, 33.71203], [-118.01263, 33.71203], [-118.01265, 33.71208], [-118.01305, 33.71207], [-118.01306, 33.71283]]]} Open Access 1 Golden View Park http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/golden-view-park.cfm 19374 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.75 Golden View Park  
4713 4713 4712 {"type": "MultiPolygon", "coordinates": [[[[-118.00915, 33.73873], [-118.00872, 33.73874], [-118.00873, 33.73936], [-118.00767, 33.73936], [-118.00765, 33.73733], [-118.00913, 33.73732], [-118.00915, 33.73873]]], [[[-118.00929, 33.73713], [-118.00927, 33.73717], [-118.00918, 33.73721], [-118.00791, 33.73722], [-118.00788, 33.7356], [-118.00795, 33.7356], [-118.00796, 33.73588], [-118.00906, 33.73604], [-118.00909, 33.73631], [-118.00927, 33.73696], [-118.00929, 33.73713]]]]} Open Access 1 Greer Park http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/greer-park.cfm 19494 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.095 Greer Park  
4720 4720 4719 {"type": "Polygon", "coordinates": [[[-118.00009, 33.6893], [-117.99911, 33.69028], [-117.99831, 33.68971], [-117.99828, 33.68967], [-117.99828, 33.68963], [-117.9983, 33.6896], [-117.99894, 33.68897], [-117.99921, 33.68877], [-117.99957, 33.68859], [-118.00009, 33.6893]]]} Open Access 1 Green Park http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/green-park.cfm 19465 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.998 Green Park  
4765 4765 4764 {"type": "Polygon", "coordinates": [[[-117.97795, 33.6865], [-117.97735, 33.6865], [-117.97731, 33.68648], [-117.97729, 33.68645], [-117.97724, 33.68366], [-117.97155, 33.68368], [-117.97154, 33.68313], [-117.97592, 33.68312], [-117.97593, 33.6831], [-117.97577, 33.68279], [-117.9757, 33.68275], [-117.97573, 33.68269], [-117.97575, 33.68258], [-117.9758, 33.68254], [-117.97637, 33.68253], [-117.97645, 33.68251], [-117.97653, 33.68245], [-117.97691, 33.68242], [-117.9778, 33.68241], [-117.9778, 33.68269], [-117.97786, 33.68274], [-117.97784, 33.68279], [-117.97784, 33.68285], [-117.9779, 33.68311], [-117.97795, 33.6865]]]} Open Access 1 Lagenbeck Park http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/lagenbeck-park.cfm 20838 1141 Huntington Beach, City of 122 City 2 City Agency 2 http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm City 2 17.044 Lagenbeck Park  
4875 4875 4874 {"type": "Polygon", "coordinates": [[[-118.00068, 33.66868], [-118.00066, 33.66872], [-118.00061, 33.66874], [-118.00025, 33.6687], [-118.0, 33.66874], [-117.99983, 33.66879], [-117.99953, 33.66895], [-117.99934, 33.66902], [-117.99913, 33.66907], [-117.99893, 33.66909], [-117.99872, 33.66908], [-117.99851, 33.66905], [-117.99832, 33.66899], [-117.99805, 33.66886], [-117.99804, 33.66848], [-117.99819, 33.66832], [-117.99832, 33.66824], [-117.99846, 33.66819], [-117.99862, 33.66816], [-117.99885, 33.66818], [-117.99927, 33.66828], [-117.99968, 33.66832], [-118.00008, 33.66831], [-118.00047, 33.66825], [-118.00052, 33.66829], [-118.00068, 33.66868]]]} Open Access 1 Lake Park http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/lake-park.cfm 20959 1141 Huntington Beach, City of 122 City 2 City Agency 2 http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm City 2 4.226 Lake Park  
4897 4897 4896 {"type": "Polygon", "coordinates": [[[-118.05443, 33.72234], [-118.0544, 33.72239], [-118.05436, 33.72241], [-118.05417, 33.72241], [-118.05415, 33.72158], [-118.05339, 33.72158], [-118.05338, 33.72109], [-118.05364, 33.72107], [-118.05364, 33.7207], [-118.05357, 33.72068], [-118.05357, 33.72042], [-118.05361, 33.72031], [-118.05367, 33.72022], [-118.05376, 33.72014], [-118.054, 33.72003], [-118.05407, 33.72006], [-118.05425, 33.7205], [-118.05433, 33.72078], [-118.05441, 33.72126], [-118.05443, 33.72234]]]} Open Access 1 Harbour View Park   19671 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.415 Harbour View Park  
4969 4969 4968 {"type": "Polygon", "coordinates": [[[-118.04595, 33.72971], [-118.04398, 33.72972], [-118.04391, 33.72969], [-118.0439, 33.72907], [-118.04415, 33.72895], [-118.04415, 33.72858], [-118.04461, 33.72858], [-118.04463, 33.72874], [-118.0448, 33.72873], [-118.04482, 33.72859], [-118.0449, 33.72859], [-118.04491, 33.72892], [-118.04501, 33.72893], [-118.04503, 33.72962], [-118.04595, 33.72962], [-118.04595, 33.72971]]]} Open Access 1 Haven View Park http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/haven-view-park.cfm 19741 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.97 Haven View Park  
4970 4970 4969 {"type": "Polygon", "coordinates": [[[-117.95893, 33.66789], [-117.95781, 33.6679], [-117.9578, 33.66708], [-117.95781, 33.66704], [-117.95787, 33.66701], [-117.95834, 33.66699], [-117.95844, 33.66703], [-117.95854, 33.66704], [-117.95857, 33.66703], [-117.95862, 33.66698], [-117.95864, 33.66689], [-117.95891, 33.66689], [-117.95893, 33.66789]]]} Open Access 1 Hawes Park http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/hawes-park.cfm 19742 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.598 Hawes Park  
5024 5024 5023 {"type": "Polygon", "coordinates": [[[-117.98565, 33.69303], [-117.98466, 33.69303], [-117.98465, 33.69223], [-117.98564, 33.69223], [-117.98565, 33.69303]]]} Open Access 1 Helme Park http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/helme-park.cfm 19809 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.0 Helme Park  
5251 5251 5250 {"type": "Polygon", "coordinates": [[[-118.01718, 33.70818], [-118.01661, 33.70819], [-118.01657, 33.70552], [-118.01715, 33.70552], [-118.01718, 33.70818]]]} Open Access 1 Hope View Park   20087 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.923 Hope View Park  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);