superunits_with_maps

Table actions

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

32 rows where MNG_AGENCY = 114

This data as json, copyable, CSV (advanced)

ACCESS_TYP 2

MNG_AG_TYP 1

MNG_AGENCY 1

  • Costa Mesa, City of · 32 ✖
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
380 380 379 {"type": "MultiPolygon", "coordinates": [[[[-117.9371, 33.6686], [-117.93478, 33.66862], [-117.93474, 33.66617], [-117.93453, 33.666], [-117.93434, 33.66577], [-117.93426, 33.66553], [-117.93425, 33.66529], [-117.93433, 33.66497], [-117.9345, 33.66461], [-117.93476, 33.66411], [-117.93485, 33.66379], [-117.93489, 33.66314], [-117.93476, 33.66312], [-117.93473, 33.66086], [-117.93497, 33.66095], [-117.93521, 33.66102], [-117.93618, 33.66122], [-117.93643, 33.66131], [-117.93665, 33.66142], [-117.93691, 33.66158], [-117.93716, 33.66179], [-117.93736, 33.66201], [-117.93752, 33.66224], [-117.93762, 33.6624], [-117.93772, 33.66267], [-117.93776, 33.66286], [-117.93777, 33.66485], [-117.93776, 33.66565], [-117.93773, 33.66589], [-117.93767, 33.66611], [-117.93755, 33.66638], [-117.93733, 33.66677], [-117.93716, 33.66716], [-117.9371, 33.66746], [-117.93709, 33.66788], [-117.9371, 33.6686]]], [[[-117.94524, 33.66565], [-117.94451, 33.66855], [-117.93744, 33.6686], [-117.93741, 33.66756], [-117.93743, 33.66739], [-117.93755, 33.66705], [-117.93791, 33.66635], [-117.93801, 33.6661], [-117.93807, 33.6659], [-117.93809, 33.66568], [-117.93811, 33.66544], [-117.93808, 33.66335], [-117.93808, 33.66306], [-117.93806, 33.66286], [-117.93791, 33.66239], [-117.93772, 33.66208], [-117.93756, 33.66186], [-117.93735, 33.66164], [-117.93691, 33.6613], [-117.93866, 33.66024], [-117.93867, 33.65964], [-117.94073, 33.65963], [-117.94071, 33.65784], [-117.94224, 33.65783], [-117.94357, 33.65784], [-117.94334, 33.66349], [-117.94295, 33.66519], [-117.94524, 33.66565]]]]} Open Access 1 Fairview Park http://www.costamesaca.gov/index.aspx?page=247 2844 1071 Costa Mesa, City of 114 City 2 City Agency 2 http://www.costamesaca.gov/index.aspx?page=70 City 2 202.434 Fairview Park  
1192 1192 1191 {"type": "Polygon", "coordinates": [[[-117.93128, 33.63885], [-117.9311, 33.63884], [-117.9311, 33.63844], [-117.93127, 33.63844], [-117.93128, 33.63885]]]} Open Access 1 Shalimar Park   25353 1071 Costa Mesa, City of 114 City 2 City Agency 2 http://www.costamesaca.gov/index.aspx?page=70 City 2 0.179 Shalimar Park  
2230 2230 2229 {"type": "Polygon", "coordinates": [[[-117.89586, 33.65551], [-117.89554, 33.65584], [-117.89512, 33.65555], [-117.89446, 33.6562], [-117.89426, 33.65606], [-117.89521, 33.65512], [-117.89547, 33.65529], [-117.89575, 33.65543], [-117.89586, 33.65551]]]} Open Access 1 Brentwood Park   16358 1071 Costa Mesa, City of 114 City 2 City Agency 2 http://www.costamesaca.gov/index.aspx?page=70 City 2 1.395 Brentwood Park  
2600 2600 2599 {"type": "Polygon", "coordinates": [[[-117.94388, 33.65053], [-117.94298, 33.65055], [-117.94297, 33.64956], [-117.94221, 33.64903], [-117.94242, 33.64852], [-117.94219, 33.64805], [-117.94197, 33.64801], [-117.94124, 33.64827], [-117.93923, 33.6483], [-117.93923, 33.64781], [-117.93994, 33.6472], [-117.93958, 33.64674], [-117.93878, 33.64692], [-117.93836, 33.64726], [-117.93812, 33.64802], [-117.93748, 33.64796], [-117.93643, 33.64778], [-117.93643, 33.64733], [-117.93741, 33.64732], [-117.93742, 33.64661], [-117.93774, 33.64661], [-117.93778, 33.64667], [-117.93797, 33.64664], [-117.93798, 33.64661], [-117.93818, 33.6466], [-117.93816, 33.64589], [-117.93925, 33.64587], [-117.93924, 33.64524], [-117.93875, 33.64428], [-117.93875, 33.64414], [-117.93984, 33.64411], [-117.93984, 33.64505], [-117.94018, 33.64569], [-117.9409, 33.64553], [-117.94173, 33.64553], [-117.94174, 33.64781], [-117.94383, 33.64781], [-117.94388, 33.65053]]]} Open Access 1 Canyon Park   16823 1071 Costa Mesa, City of 114 City 2 City Agency 2 http://www.costamesaca.gov/index.aspx?page=70 City 2 35.417 Canyon Park  
2933 2933 2932 {"type": "Polygon", "coordinates": [[[-117.90754, 33.67295], [-117.90754, 33.67441], [-117.90273, 33.67445], [-117.9027, 33.67296], [-117.90754, 33.67295]]]} Open Access 1 Farm Sports Complex   18845 1071 Costa Mesa, City of 114 City 2 City Agency 2 http://www.costamesaca.gov/index.aspx?page=70 City 2 18.102 Farm Sports Complex  
3534 3534 3533 {"type": "Polygon", "coordinates": [[[-117.88005, 33.68343], [-117.88004, 33.68419], [-117.88001, 33.68423], [-117.87996, 33.68424], [-117.87885, 33.68425], [-117.87886, 33.68343], [-117.88005, 33.68343]]]} Open Access 1 Del Mesa Park   18038 1071 Costa Mesa, City of 114 City 2 City Agency 2 http://www.costamesaca.gov/index.aspx?page=70 City 2 2.464 Del Mesa Park  
4059 4059 4058 {"type": "Polygon", "coordinates": [[[-117.9385, 33.67267], [-117.93847, 33.67503], [-117.93841, 33.67502], [-117.93789, 33.67429], [-117.93753, 33.67395], [-117.93727, 33.67379], [-117.93692, 33.6736], [-117.93658, 33.67352], [-117.93629, 33.67352], [-117.93586, 33.6736], [-117.93572, 33.67329], [-117.93563, 33.67307], [-117.93559, 33.67289], [-117.93558, 33.67274], [-117.93563, 33.67273], [-117.93565, 33.67268], [-117.9385, 33.67267]]]} Open Access 1 Estancia Park   18720 1071 Costa Mesa, City of 114 City 2 City Agency 2 http://www.costamesaca.gov/index.aspx?page=70 City 2 8.832 Estancia Park  
4572 4572 4571 {"type": "Polygon", "coordinates": [[[-117.91234, 33.68711], [-117.91234, 33.68758], [-117.91151, 33.68755], [-117.90816, 33.68727], [-117.90801, 33.68716], [-117.90801, 33.68702], [-117.90918, 33.68704], [-117.90918, 33.68713], [-117.90923, 33.68714], [-117.90926, 33.68705], [-117.91061, 33.68703], [-117.91061, 33.68712], [-117.91063, 33.68713], [-117.91066, 33.687], [-117.912, 33.68701], [-117.91202, 33.68711], [-117.91234, 33.68711]]]} Open Access 1 Gisler Park   19303 1071 Costa Mesa, City of 114 City 2 City Agency 2 http://www.costamesaca.gov/index.aspx?page=70 City 2 4.357 Gisler Park  
4853 4853 4852 {"type": "Polygon", "coordinates": [[[-117.92536, 33.68693], [-117.92049, 33.68692], [-117.92045, 33.68687], [-117.92044, 33.68679], [-117.92043, 33.6847], [-117.92533, 33.68468], [-117.92533, 33.68494], [-117.92536, 33.68693]]]} Open Access 1 Harbor Rest Memorial Park   19665 1071 Costa Mesa, City of 114 City 2 City Agency 2 http://www.costamesaca.gov/index.aspx?page=70 City 2 27.822 Harbor Rest Memorial Park  
4914 4914 4913 {"type": "Polygon", "coordinates": [[[-117.91056, 33.6321], [-117.91, 33.63265], [-117.90957, 33.63237], [-117.91011, 33.63178], [-117.91056, 33.6321]]]} Open Access 1 Harper Park   19689 1071 Costa Mesa, City of 114 City 2 City Agency 2 http://www.costamesaca.gov/index.aspx?page=70 City 2 1.045 Harper Park  
5020 5020 5019 {"type": "Polygon", "coordinates": [[[-117.9211, 33.63125], [-117.9205, 33.63183], [-117.92012, 33.63158], [-117.9199, 33.6314], [-117.91952, 33.63113], [-117.92009, 33.63056], [-117.9211, 33.63125]]]} Open Access 1 Heller Park   19806 1071 Costa Mesa, City of 114 City 2 City Agency 2 http://www.costamesaca.gov/index.aspx?page=70 City 2 2.521 Heller Park  
5602 5602 5601 {"type": "Polygon", "coordinates": [[[-117.90111, 33.64326], [-117.90042, 33.64395], [-117.8996, 33.64336], [-117.9003, 33.64266], [-117.90111, 33.64326]]]} Open Access 1 Jordan Park   20490 1071 Costa Mesa, City of 114 City 2 City Agency 2 http://www.costamesaca.gov/index.aspx?page=70 City 2 2.483 Jordan Park  
5731 5731 5730 {"type": "Polygon", "coordinates": [[[-117.92271, 33.6527], [-117.92269, 33.65297], [-117.92211, 33.65298], [-117.9221, 33.65274], [-117.92173, 33.65273], [-117.92171, 33.65261], [-117.92264, 33.65264], [-117.92271, 33.6527]]]} Open Access 1 Ketchum-Libolt Park   20637 1071 Costa Mesa, City of 114 City 2 City Agency 2 http://www.costamesaca.gov/index.aspx?page=70 City 2 0.618 Ketchum-Libolt Park  
6214 6214 6213 {"type": "Polygon", "coordinates": [[[-117.90107, 33.65222], [-117.90012, 33.65317], [-117.89899, 33.65237], [-117.90032, 33.65106], [-117.90067, 33.6513], [-117.9005, 33.65148], [-117.90057, 33.65155], [-117.90053, 33.65183], [-117.90107, 33.65222]]]} Open Access 1 Lindbergh Park   21287 1071 Costa Mesa, City of 114 City 2 City Agency 2 http://www.costamesaca.gov/index.aspx?page=70 City 2 5.326 Lindbergh Park  
6252 6252 6251 {"type": "Polygon", "coordinates": [[[-117.9232, 33.64208], [-117.92122, 33.64211], [-117.9212, 33.63994], [-117.92319, 33.63992], [-117.9232, 33.64208]]]} Open Access 1 Lions Park   21318 1071 Costa Mesa, City of 114 City 2 City Agency 2 http://www.costamesaca.gov/index.aspx?page=70 City 2 10.917 Lions Park  
6656 6656 6655 {"type": "Polygon", "coordinates": [[[-117.94332, 33.64278], [-117.94304, 33.64276], [-117.94312, 33.64316], [-117.94235, 33.64317], [-117.94234, 33.64285], [-117.94201, 33.64285], [-117.94194, 33.64278], [-117.94185, 33.64275], [-117.94156, 33.64278], [-117.94156, 33.64239], [-117.94317, 33.64238], [-117.94304, 33.64271], [-117.94331, 33.64275], [-117.94332, 33.64278]]]} Open Access 1 Marina View Park   21839 1071 Costa Mesa, City of 114 City 2 City Agency 2 http://www.costamesaca.gov/index.aspx?page=70 City 2 2.332 Marina View Park  
6946 6946 6945 {"type": "Polygon", "coordinates": [[[-117.93311, 33.67525], [-117.93289, 33.67546], [-117.93278, 33.67564], [-117.93273, 33.67568], [-117.93241, 33.6756], [-117.93223, 33.67557], [-117.93019, 33.67538], [-117.93014, 33.67536], [-117.93022, 33.67502], [-117.93065, 33.67501], [-117.9312, 33.67508], [-117.93228, 33.67519], [-117.93311, 33.67525]]]} Open Access 1 Mesa Verde Park   22179 1071 Costa Mesa, City of 114 City 2 City Agency 2 http://www.costamesaca.gov/index.aspx?page=70 City 2 2.756 Mesa Verde Park  
7178 7178 7177 {"type": "Polygon", "coordinates": [[[-117.93472, 33.69366], [-117.93397, 33.69474], [-117.93286, 33.69432], [-117.93313, 33.69422], [-117.93323, 33.69429], [-117.93332, 33.6943], [-117.93356, 33.69417], [-117.93373, 33.69412], [-117.93387, 33.69411], [-117.93399, 33.69402], [-117.93401, 33.69391], [-117.93472, 33.69366]]]} Open Access 1 Moon Park   22449 1071 Costa Mesa, City of 114 City 2 City Agency 2 http://www.costamesaca.gov/index.aspx?page=70 City 2 1.684 Moon Park  
8033 8033 8032 {"type": "Polygon", "coordinates": [[[-117.90125, 33.6842], [-117.90106, 33.6842], [-117.90105, 33.68448], [-117.90086, 33.68448], [-117.90086, 33.68422], [-117.90077, 33.68421], [-117.90076, 33.68247], [-117.90123, 33.68247], [-117.90125, 33.6842]]]} Open Access 1 Paularino Park   23534 1071 Costa Mesa, City of 114 City 2 City Agency 2 http://www.costamesaca.gov/index.aspx?page=70 City 2 2.233 Paularino Park  
8163 8163 8162 {"type": "Polygon", "coordinates": [[[-117.91502, 33.63059], [-117.91441, 33.6312], [-117.91347, 33.63056], [-117.9137, 33.63033], [-117.91372, 33.63034], [-117.9141, 33.62995], [-117.91502, 33.63059]]]} Open Access 1 Pinkley Park   23698 1071 Costa Mesa, City of 114 City 2 City Agency 2 http://www.costamesaca.gov/index.aspx?page=70 City 2 2.465 Pinkley 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]);