units_with_maps

Table actions

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

58 rows where GAP_STS = 4, MNG_AGENCY = 52 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 58 ✖

MNG_AGENCY 1

  • Newport Beach, City of · 58 ✖

ACCESS_TYP 1

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 PARK_URL COUNTY ACRES LABEL_NAME YR_EST DES_TP GAP_STS
126 126 125 {"type": "Polygon", "coordinates": [[[-117.92158, 33.62047], [-117.92075, 33.62131], [-117.92059, 33.62077], [-117.92003, 33.62037], [-117.92034, 33.62006], [-117.92071, 33.62032], [-117.92089, 33.62015], [-117.92158, 33.62047]]]} Open Access 1 318 Ensign View Park 18682 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 2.134 Ensign View Park 0 Local Park 2 4
168 168 167 {"type": "Polygon", "coordinates": [[[-117.89514, 33.614], [-117.89456, 33.61397], [-117.89358, 33.61385], [-117.8935, 33.61387], [-117.89229, 33.61421], [-117.89219, 33.61426], [-117.89104, 33.61503], [-117.89096, 33.61513], [-117.89091, 33.61526], [-117.89088, 33.61554], [-117.89077, 33.61565], [-117.89026, 33.61591], [-117.88975, 33.61562], [-117.88988, 33.61545], [-117.89005, 33.61555], [-117.89018, 33.61539], [-117.89068, 33.61565], [-117.89078, 33.61558], [-117.89081, 33.61554], [-117.89085, 33.61536], [-117.8908, 33.61528], [-117.89079, 33.61519], [-117.8908, 33.61509], [-117.89113, 33.61463], [-117.891, 33.61454], [-117.89084, 33.6145], [-117.89066, 33.61444], [-117.89044, 33.61441], [-117.89041, 33.61439], [-117.89036, 33.61433], [-117.89018, 33.6143], [-117.89004, 33.61433], [-117.8898, 33.61442], [-117.88968, 33.61453], [-117.88966, 33.61452], [-117.89069, 33.61325], [-117.89076, 33.61318], [-117.89086, 33.61314], [-117.89096, 33.61312], [-117.89107, 33.61312], [-117.89435, 33.61364], [-117.89433, 33.61373], [-117.89514, 33.614]]]} Open Access 1 536 Back Bay View Park 15751 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 10.648 Back Bay View Park 0 Local Park 2 4
299 299 298 {"type": "Polygon", "coordinates": [[[-117.89118, 33.62744], [-117.89109, 33.6275], [-117.89102, 33.62758], [-117.89077, 33.62794], [-117.89073, 33.62809], [-117.89075, 33.62825], [-117.8904, 33.62835], [-117.8906, 33.62779], [-117.89072, 33.62716], [-117.8909, 33.6271], [-117.89118, 33.62744]]]} Open Access 1 803 Galaxy View Park 19171 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.948 Galaxy View Park 0 Local Park 2 4
461 461 460 {"type": "Polygon", "coordinates": [[[-117.87133, 33.59796], [-117.87133, 33.59796], [-117.87119, 33.59799], [-117.8713, 33.59788], [-117.87133, 33.59796]]]} Open Access 1 47411 Corona del Mar Pocket Park 31210 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.015 Corona del Mar PP 0 Local Park 2 4
598 598 597 {"type": "Polygon", "coordinates": [[[-117.92689, 33.61603], [-117.92681, 33.61619], [-117.92653, 33.6162], [-117.92643, 33.61603], [-117.92689, 33.61603]]]} Open Access 1 4130 Lido Park 21228 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.157 Lido Park 0 Local Park 2 4
638 638 637 {"type": "Polygon", "coordinates": [[[-117.88386, 33.59796], [-117.88404, 33.59799], [-117.88405, 33.59813], [-117.884, 33.59813], [-117.88389, 33.59805], [-117.88384, 33.59799], [-117.88386, 33.59796]]]} Open Access 1 4921 M Street Park 21618 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.056 M Street Park 0 Local Park 2 4
765 765 764 {"type": "Polygon", "coordinates": [[[-117.88503, 33.63009], [-117.88493, 33.63054], [-117.88456, 33.63087], [-117.8844, 33.63098], [-117.88427, 33.63103], [-117.8841, 33.63106], [-117.88263, 33.63112], [-117.88253, 33.63115], [-117.88206, 33.63138], [-117.88279, 33.63178], [-117.88289, 33.63186], [-117.88295, 33.63192], [-117.883, 33.63202], [-117.88302, 33.63212], [-117.88308, 33.63273], [-117.88312, 33.63284], [-117.88322, 33.63295], [-117.88329, 33.63301], [-117.8846, 33.63364], [-117.88467, 33.63377], [-117.88483, 33.63395], [-117.88461, 33.63407], [-117.88448, 33.6339], [-117.88271, 33.63315], [-117.8824, 33.63265], [-117.88259, 33.63222], [-117.88182, 33.63176], [-117.88079, 33.63166], [-117.88049, 33.6317], [-117.88027, 33.6317], [-117.87975, 33.63121], [-117.87955, 33.63087], [-117.87928, 33.63058], [-117.87925, 33.63029], [-117.87852, 33.62913], [-117.87825, 33.629], [-117.87804, 33.62901], [-117.87802, 33.62898], [-117.87782, 33.62903], [-117.87737, 33.62921], [-117.87721, 33.62923], [-117.87699, 33.6293], [-117.87664, 33.62918], [-117.87761, 33.62757], [-117.87822, 33.62674], [-117.87836, 33.62695], [-117.87841, 33.62732], [-117.87879, 33.6275], [-117.87934, 33.62797], [-117.87967, 33.62852], [-117.88023, 33.62895], [-117.88053, 33.62966], [-117.88079, 33.62984], [-117.88109, 33.62989], [-117.8824, 33.62957], [-117.88277, 33.62964], [-117.88345, 33.63013], [-117.88367, 33.63011], [-117.8839, 33.62992], [-117.88411, 33.62993], [-117.8842, 33.62989], [-117.88503, 33.63009]]]} Open Access 1 4965 Big Canyon Park 16076 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 39.132 Big Canyon Park 0 Local Park 2 4
908 908 907 {"type": "MultiPolygon", "coordinates": [[[[-117.87425, 33.60258], [-117.87399, 33.60284], [-117.8737, 33.60264], [-117.87395, 33.60238], [-117.87425, 33.60258]]], [[[-117.87457, 33.60281], [-117.87432, 33.60307], [-117.87404, 33.60287], [-117.8743, 33.60262], [-117.87457, 33.60281]]]]} Open Access 1 6362 Old School Park 23103 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.62 Old School Park 0 Local Park 2 4
942 942 941 {"type": "MultiPolygon", "coordinates": [[[[-117.89533, 33.62496], [-117.89517, 33.6251], [-117.895, 33.62513], [-117.89474, 33.62505], [-117.89391, 33.62465], [-117.89335, 33.62458], [-117.8934, 33.62439], [-117.89349, 33.62395], [-117.89343, 33.62333], [-117.89533, 33.6249], [-117.89535, 33.62493], [-117.89533, 33.62496]]], [[[-117.89512, 33.62537], [-117.89436, 33.62602], [-117.89436, 33.62603], [-117.89448, 33.6261], [-117.8943, 33.62622], [-117.89414, 33.62637], [-117.89399, 33.62655], [-117.8936, 33.62678], [-117.89295, 33.62699], [-117.89176, 33.62704], [-117.89137, 33.62694], [-117.89144, 33.6267], [-117.89157, 33.62648], [-117.89272, 33.62566], [-117.89298, 33.62568], [-117.89309, 33.62565], [-117.89323, 33.62558], [-117.89326, 33.6255], [-117.89417, 33.62594], [-117.89455, 33.62546], [-117.89512, 33.62537]]]]} Open Access 1 5956 North Star Beach 22859 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.265 North Star Beach 0 Local Park 2 4
1053 1053 1052 {"type": "MultiPolygon", "coordinates": [[[[-117.92987, 33.61876], [-117.92979, 33.61914], [-117.92968, 33.6191], [-117.92985, 33.61876], [-117.92987, 33.61876]]], [[[-117.93059, 33.61792], [-117.93044, 33.61839], [-117.93035, 33.61837], [-117.93034, 33.61835], [-117.93036, 33.61789], [-117.93059, 33.61792]]]]} Open Access 1 5654 Gateway Park 19238 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.272 Gateway Park 0 Local Park 2 4
1287 1287 1286 {"type": "Polygon", "coordinates": [[[-117.9478, 33.62663], [-117.9478, 33.62663], [-117.94751, 33.62698], [-117.94748, 33.62644], [-117.9478, 33.62663]]]} Open Access 1 5709 Newport Shores Park 22740 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.211 Newport Shores Park 0 Local Park 2 4
1304 1304 1303 {"type": "Polygon", "coordinates": [[[-117.92564, 33.62824], [-117.92557, 33.62842], [-117.92508, 33.6285], [-117.92518, 33.62839], [-117.9252, 33.62829], [-117.92525, 33.62831], [-117.92564, 33.62824]]]} Open Access 1 7321 Bolsa Park 16247 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.197 Bolsa Park 0 Local Park 2 4
1369 1369 1368 {"type": "Polygon", "coordinates": [[[-117.90004, 33.60061], [-117.8997, 33.60129], [-117.89766, 33.60064], [-117.89775, 33.6005], [-117.89762, 33.60045], [-117.89793, 33.59997], [-117.89813, 33.60006], [-117.89822, 33.59994], [-117.89828, 33.59992], [-117.89928, 33.60027], [-117.89926, 33.60034], [-117.90004, 33.60061]]]} Open Access 1 8249 Peninsula Park 23579 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.539 Peninsula Park 0 Local Park 2 4
1738 1738 1737 {"type": "Polygon", "coordinates": [[[-117.84482, 33.61091], [-117.84442, 33.6108], [-117.84419, 33.6107], [-117.84396, 33.61058], [-117.8442, 33.61028], [-117.84435, 33.6102], [-117.84453, 33.61016], [-117.84464, 33.61024], [-117.84461, 33.61032], [-117.84464, 33.61041], [-117.8447, 33.61045], [-117.84478, 33.61046], [-117.84482, 33.61091]]]} Open Access 1 12947 Spyglass Hill Reservoir Park 25757 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.949 Spyglass Hill Reservoir Park 0 Local Park 2 4
1745 1745 1744 {"type": "Polygon", "coordinates": [[[-117.92184, 33.60768], [-117.92172, 33.60823], [-117.92104, 33.60813], [-117.92107, 33.60796], [-117.9206, 33.60789], [-117.92068, 33.60751], [-117.92184, 33.60768]]]} Open Access 1 15014 Veterans Memorial Park 27029 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 1.457 Veterans Memorial Park 0 Local Park 2 4
2352 2352 2351 {"type": "Polygon", "coordinates": [[[-117.85359, 33.61808], [-117.85184, 33.6207], [-117.8518, 33.62072], [-117.85175, 33.62071], [-117.85126, 33.62047], [-117.85098, 33.62026], [-117.85073, 33.62], [-117.85148, 33.61962], [-117.85164, 33.61951], [-117.85188, 33.61926], [-117.85227, 33.61923], [-117.85249, 33.61903], [-117.8526, 33.61887], [-117.85289, 33.61831], [-117.8527, 33.61799], [-117.85232, 33.61781], [-117.85204, 33.61758], [-117.85208, 33.61732], [-117.85201, 33.61705], [-117.85166, 33.6168], [-117.8515, 33.61672], [-117.85112, 33.61646], [-117.8512, 33.61642], [-117.85359, 33.61808]]]} Open Access 1 11189 San Miguel Park 24958 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.292 San Miguel Park 0 Local Park 2 4
2828 2828 2827 {"type": "Polygon", "coordinates": [[[-117.89054, 33.59896], [-117.89013, 33.59896], [-117.89013, 33.59888], [-117.89015, 33.59884], [-117.89012, 33.59877], [-117.89015, 33.59873], [-117.89054, 33.59896]]]} Open Access 1 47419 Miramar Park 31136 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.125 Miramar Park 0 Local Park 2 4
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. 0 Local Recreation Area 3 4
4134 4134 4133 {"type": "Polygon", "coordinates": [[[-117.92489, 33.60778], [-117.92468, 33.60878], [-117.92225, 33.60844], [-117.92237, 33.60782], [-117.92183, 33.60774], [-117.92183, 33.60768], [-117.92168, 33.60766], [-117.92169, 33.6076], [-117.92144, 33.60757], [-117.9215, 33.6073], [-117.92489, 33.60778]]]} Open Access 1 47418 Marina Park 31135 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.25 Marina Park 0 Local Park 2 4
4848 4848 4847 {"type": "Polygon", "coordinates": [[[-117.93748, 33.62363], [-117.93728, 33.62371], [-117.9371, 33.62381], [-117.93693, 33.62393], [-117.9367, 33.62416], [-117.93646, 33.62403], [-117.93612, 33.6238], [-117.93624, 33.6237], [-117.93632, 33.62366], [-117.93648, 33.6236], [-117.93665, 33.62356], [-117.93691, 33.62355], [-117.93729, 33.62357], [-117.93748, 33.62359], [-117.93748, 33.62363]]]} Open Access 1 47424 Sunset Ridge Park 31140 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 1.077 Sunset Ridge Park 0 Local Park 2 4

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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