units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
50 rows where DES_TP = 2 and MNG_AGENCY = 52 sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 30
MNG_AGENCY 1
- Newport Beach, City of · 30 ✖
DES_TP 1
- Local Park · 30 ✖
ACCESS_TYP 1
- Open Access 30
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
6267 | 6267 | 6266 | {"type": "Polygon", "coordinates": [[[-117.86393, 33.6158], [-117.86396, 33.61584], [-117.86399, 33.61608], [-117.86385, 33.61657], [-117.86336, 33.6171], [-117.86315, 33.61702], [-117.86293, 33.61695], [-117.86265, 33.6169], [-117.86252, 33.61689], [-117.86252, 33.61682], [-117.8628, 33.61672], [-117.8628, 33.6167], [-117.86293, 33.6166], [-117.86304, 33.61648], [-117.8631, 33.61623], [-117.86307, 33.61615], [-117.86283, 33.61601], [-117.8627, 33.616], [-117.8624, 33.61583], [-117.86207, 33.61531], [-117.86174, 33.61544], [-117.86165, 33.61527], [-117.86197, 33.61514], [-117.8619, 33.61498], [-117.86172, 33.61469], [-117.86085, 33.61396], [-117.86081, 33.61389], [-117.86068, 33.61383], [-117.85994, 33.61332], [-117.86117, 33.61313], [-117.86149, 33.61351], [-117.86182, 33.61382], [-117.86215, 33.614], [-117.86221, 33.61409], [-117.86235, 33.61453], [-117.86264, 33.61493], [-117.86286, 33.61544], [-117.86305, 33.61551], [-117.86377, 33.61562], [-117.86389, 33.61581], [-117.86393, 33.6158]]]} | Open Access 1 | 1398 | Harbor View Nature Park | 19667 | 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.037 | Harbor View Nature Park | 0 | Local Park 2 | 4 | |
6349 | 6349 | 6348 | {"type": "Polygon", "coordinates": [[[-117.84516, 33.60647], [-117.84512, 33.6066], [-117.84389, 33.6063], [-117.84397, 33.60618], [-117.84398, 33.60601], [-117.84411, 33.60589], [-117.84429, 33.60579], [-117.84447, 33.60574], [-117.84455, 33.60573], [-117.84463, 33.60576], [-117.84472, 33.60583], [-117.84493, 33.60624], [-117.84502, 33.60636], [-117.84516, 33.60647]]]} | Open Access 1 | 47501 | Harbor Watch Park | 31216 | 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 | http://nbgis.newportbeachca.gov/gispub/recreation/facilities/default.aspx | Orange 3 | 1.529 | Harbor Watch Park | 0 | Local Park 2 | 4 |
6480 | 6480 | 6479 | {"type": "Polygon", "coordinates": [[[-117.88244, 33.60781], [-117.88204, 33.60814], [-117.88177, 33.60826], [-117.88164, 33.60833], [-117.88166, 33.60837], [-117.88145, 33.60853], [-117.88142, 33.60852], [-117.88129, 33.60865], [-117.88132, 33.60869], [-117.88122, 33.60882], [-117.88116, 33.609], [-117.88112, 33.60904], [-117.87903, 33.6076], [-117.87967, 33.60695], [-117.87971, 33.60694], [-117.88115, 33.60734], [-117.88169, 33.60757], [-117.88244, 33.60781]]]} | Open Access 1 | 2293 | Irvine Terrace Park | 20271 | 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 | 8.547 | Irvine Terrace Park | 0 | Local Park 2 | 4 | |
6490 | 6490 | 6489 | {"type": "Polygon", "coordinates": [[[-117.866, 33.60265], [-117.86593, 33.6027], [-117.86573, 33.6025], [-117.86554, 33.60226], [-117.86554, 33.60222], [-117.86556, 33.60219], [-117.86577, 33.60204], [-117.86574, 33.60213], [-117.86574, 33.60229], [-117.86576, 33.60238], [-117.86584, 33.60251], [-117.86596, 33.60258], [-117.866, 33.60265]]]} | Open Access 1 | 2405 | Jasmine Creek Park | 20367 | 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.207 | Jasmine Creek Park | 0 | Local Park 2 | 4 | |
6530 | 6530 | 6529 | {"type": "Polygon", "coordinates": [[[-117.91824, 33.6176], [-117.91811, 33.61786], [-117.91789, 33.61778], [-117.91766, 33.61777], [-117.91767, 33.61741], [-117.91824, 33.6176]]]} | Open Access 1 | 2892 | Kings Road Park | 20664 | 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.409 | Kings Road Park | 0 | Local Park 2 | 4 | |
6542 | 6542 | 6541 | {"type": "Polygon", "coordinates": [[[-117.88651, 33.59833], [-117.88649, 33.59832], [-117.88647, 33.59829], [-117.88647, 33.59812], [-117.88651, 33.59809], [-117.8872, 33.59828], [-117.88723, 33.5983], [-117.88719, 33.59833], [-117.88651, 33.59833]]]} | Open Access 1 | 3008 | L Street Park | 20737 | 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.282 | L Street Park | 0 | Local Park 2 | 4 | |
6326 | 6326 | 6325 | {"type": "Polygon", "coordinates": [[[-117.93428, 33.61823], [-117.93424, 33.61826], [-117.93394, 33.61792], [-117.93398, 33.6179], [-117.93428, 33.61823]]]} | Open Access 1 | 47414 | Lake Street Park | 31130 | 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.059 | Lake Street Park | 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 | |
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 | |
12789 | 12789 | 12788 | {"type": "Polygon", "coordinates": [[[-117.87971, 33.65599], [-117.87969, 33.65616], [-117.87963, 33.6562], [-117.87928, 33.65615], [-117.87891, 33.65616], [-117.8791, 33.65598], [-117.87918, 33.65596], [-117.87922, 33.65593], [-117.87928, 33.6558], [-117.87952, 33.65556], [-117.87959, 33.65556], [-117.87966, 33.65568], [-117.87971, 33.6558], [-117.87971, 33.65599]]]} | Open Access 1 | 30220 | Mesa Birch Park | 22172 | 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.707 | Mesa Birch 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 | |
5225 | 5225 | 5224 | {"type": "Polygon", "coordinates": [[[-117.89511, 33.61062], [-117.89508, 33.61063], [-117.89507, 33.61067], [-117.89499, 33.61066], [-117.89481, 33.61061], [-117.89479, 33.61058], [-117.89491, 33.61057], [-117.89511, 33.61061], [-117.89511, 33.61062]]]} | Open Access 1 | 47420 | Myrtle Park | 31137 | 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.047 | Myrtle Park | 0 | Local Park 2 | 4 | |
5373 | 5373 | 5372 | {"type": "Polygon", "coordinates": [[[-117.93448, 33.6189], [-117.93422, 33.61907], [-117.93394, 33.61875], [-117.9342, 33.61859], [-117.93448, 33.6189]]]} | Open Access 1 | 5699 | Newport Island Park | 22737 | 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.329 | Newport Island 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 | |
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 | |
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 | |
12790 | 12790 | 12789 | {"type": "Polygon", "coordinates": [[[-117.88129, 33.66139], [-117.88076, 33.66102], [-117.88076, 33.66102], [-117.88085, 33.66093], [-117.88129, 33.66124], [-117.88125, 33.66131], [-117.88129, 33.66139]]]} | Open Access 1 | 30221 | Orchard Drive Park | 23186 | 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.184 | Orchard Drive Park | 0 | Local Park 2 | 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]);