superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
33 rows where MNG_AGENCY = 242
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 | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7185 | 7185 | 7184 | {"type": "Polygon", "coordinates": [[[-118.39965, 33.84813], [-118.39896, 33.84828], [-118.39862, 33.84723], [-118.39869, 33.84718], [-118.39878, 33.84709], [-118.39886, 33.84712], [-118.39892, 33.84715], [-118.39965, 33.84813]]]} | Open Access 1 | Moonstone Park | 22456 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1.46 | Moonstone Park | ||
7308 | 7308 | 7307 | {"type": "MultiPolygon", "coordinates": [[[[-118.37492, 33.81806], [-118.37492, 33.81912], [-118.37442, 33.81908], [-118.37443, 33.81802], [-118.37492, 33.81806]]], [[[-118.37894, 33.85955], [-118.37878, 33.85955], [-118.37878, 33.85916], [-118.37876, 33.85914], [-118.37876, 33.85884], [-118.37894, 33.85875], [-118.37894, 33.85955]]], [[[-118.38545, 33.86935], [-118.38521, 33.86935], [-118.38521, 33.86898], [-118.38541, 33.86928], [-118.38545, 33.86935]]], [[[-118.38767, 33.87273], [-118.3875, 33.87272], [-118.38747, 33.8727], [-118.38746, 33.87241], [-118.38767, 33.87273]]], [[[-118.38942, 33.87265], [-118.3894, 33.87269], [-118.38871, 33.87271], [-118.3884, 33.87224], [-118.38898, 33.87199], [-118.38942, 33.87265]]]]} | Open Access 1 | Redondo Beach Open Space | 24239 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 2.971 | Redondo Beach OS | ||
8096 | 8096 | 8095 | {"type": "Polygon", "coordinates": [[[-118.37572, 33.8587], [-118.37493, 33.8587], [-118.37492, 33.85844], [-118.37497, 33.85841], [-118.37568, 33.85841], [-118.37571, 33.85844], [-118.37572, 33.8587]]]} | Open Access 1 | Perry Allison Playfield | 23612 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 0.582 | Perry Allison Playfield | ||
8098 | 8098 | 8097 | {"type": "Polygon", "coordinates": [[[-118.37053, 33.86995], [-118.36856, 33.86996], [-118.36856, 33.86914], [-118.37053, 33.86913], [-118.37053, 33.86995]]]} | Open Access 1 | Perry Park | 23614 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 4.106 | Perry Park | ||
8592 | 8592 | 8591 | {"type": "Polygon", "coordinates": [[[-118.39283, 33.83951], [-118.39263, 33.84033], [-118.39231, 33.84086], [-118.39198, 33.84097], [-118.39202, 33.84109], [-118.3922, 33.84141], [-118.39168, 33.84149], [-118.39159, 33.84168], [-118.39154, 33.84186], [-118.39152, 33.84203], [-118.39172, 33.84269], [-118.39164, 33.84273], [-118.39136, 33.84219], [-118.39128, 33.8422], [-118.39113, 33.84191], [-118.39097, 33.84196], [-118.39083, 33.84171], [-118.39099, 33.84163], [-118.39088, 33.84142], [-118.39082, 33.84143], [-118.39057, 33.84096], [-118.39024, 33.84107], [-118.38999, 33.84059], [-118.39021, 33.84049], [-118.38985, 33.83979], [-118.38981, 33.83979], [-118.38965, 33.8395], [-118.38964, 33.83947], [-118.38977, 33.83944], [-118.38978, 33.83942], [-118.3895, 33.83887], [-118.3897, 33.839], [-118.38981, 33.83904], [-118.38987, 33.83908], [-118.39001, 33.83909], [-118.39012, 33.83936], [-118.39055, 33.83926], [-118.39045, 33.83892], [-118.3912, 33.83873], [-118.39117, 33.83862], [-118.39155, 33.83854], [-118.39172, 33.83877], [-118.39239, 33.83861], [-118.39267, 33.83944], [-118.39283, 33.83951]]]} | Open Access 1 | Redondo Beach Pier | 24241 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 17.489 | Redondo Beach Pier | ||
9745 | 9745 | 9744 | {"type": "Polygon", "coordinates": [[[-118.38198, 33.8634], [-118.38162, 33.86356], [-118.38151, 33.8634], [-118.38168, 33.8634], [-118.38198, 33.8634]]]} | Open Access 1 | Sneary Parkette | 25580 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 0.098 | Sneary Parkette | ||
10431 | 10431 | 10430 | {"type": "Polygon", "coordinates": [[[-118.3671, 33.86571], [-118.3671, 33.86611], [-118.36694, 33.86612], [-118.36694, 33.8657], [-118.3671, 33.86571]]]} | Open Access 1 | Townsend Parkette | 26498 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 0.168 | Townsend Parkette | ||
10830 | 10830 | 10829 | {"type": "Polygon", "coordinates": [[[-118.39016, 33.83762], [-118.3901, 33.83809], [-118.39011, 33.83828], [-118.38943, 33.8384], [-118.38926, 33.83835], [-118.38905, 33.83822], [-118.38875, 33.8381], [-118.38848, 33.83805], [-118.38825, 33.83803], [-118.3882, 33.83799], [-118.38822, 33.83795], [-118.38818, 33.83755], [-118.38853, 33.83752], [-118.38853, 33.83748], [-118.38861, 33.83736], [-118.38858, 33.83687], [-118.38872, 33.83674], [-118.38844, 33.83659], [-118.38857, 33.83643], [-118.38878, 33.83623], [-118.38948, 33.83623], [-118.3895, 33.83645], [-118.38952, 33.83644], [-118.38956, 33.83627], [-118.38974, 33.83628], [-118.38984, 33.83639], [-118.38996, 33.83657], [-118.39003, 33.83675], [-118.39016, 33.83762]], [[-118.3886, 33.8377], [-118.38857, 33.83767], [-118.38831, 33.83774], [-118.38837, 33.8379], [-118.38843, 33.83798], [-118.38868, 33.83786], [-118.3886, 33.8377]]]} | Open Access 1 | Veterans Park | 27048 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 7.846 | Veterans Park | ||
10902 | 10902 | 10901 | {"type": "MultiPolygon", "coordinates": [[[[-118.38413, 33.84424], [-118.3838, 33.84437], [-118.38362, 33.84405], [-118.3836, 33.84397], [-118.38363, 33.8439], [-118.38368, 33.84385], [-118.38376, 33.84383], [-118.38386, 33.84383], [-118.38392, 33.84387], [-118.38397, 33.84393], [-118.38413, 33.84424]]], [[[-118.38438, 33.84494], [-118.38429, 33.84499], [-118.3841, 33.84497], [-118.38404, 33.8449], [-118.38388, 33.84456], [-118.38423, 33.84445], [-118.38441, 33.84478], [-118.38441, 33.84486], [-118.38438, 33.84494]]]]} | Open Access 1 | Vincent Park | 27128 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 0.924 | Vincent Park | ||
13507 | 13507 | 13506 | {"type": "Polygon", "coordinates": [[[-118.39791, 33.85232], [-118.3975, 33.85245], [-118.39733, 33.85227], [-118.39724, 33.85212], [-118.3973, 33.85209], [-118.39724, 33.85198], [-118.3973, 33.85196], [-118.39735, 33.85207], [-118.39742, 33.85206], [-118.39747, 33.8521], [-118.39767, 33.85213], [-118.3978, 33.85208], [-118.39791, 33.85232]]]} | Open Access 1 | Gateway Parkette | 32663 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 0.422 | Gateway Parkette | 2015 | |
14145 | 14145 | 14144 | {"type": "Polygon", "coordinates": [[[-118.38032, 33.83008], [-118.38014, 33.83049], [-118.38004, 33.83074], [-118.37953, 33.83259], [-118.37946, 33.83264], [-118.37939, 33.83263], [-118.37864, 33.83203], [-118.3785, 33.83189], [-118.37858, 33.83155], [-118.37918, 33.82935], [-118.3792, 33.82933], [-118.37923, 33.82933], [-118.37961, 33.82944], [-118.37995, 33.82962], [-118.38006, 33.8297], [-118.37989, 33.82988], [-118.37984, 33.82998], [-118.38032, 33.83008]]]} | Restricted Access 2 | Alta Vista Park | http://www.redondo.org/depts/public_works/parks/altavista.asp | 31602 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 8.548 | Alta Vista Park | |
14184 | 14184 | 14183 | {"type": "Polygon", "coordinates": [[[-118.39535, 33.84489], [-118.3944, 33.84514], [-118.39429, 33.8451], [-118.3941, 33.84517], [-118.39403, 33.84513], [-118.39382, 33.84468], [-118.39327, 33.84426], [-118.39374, 33.84384], [-118.39428, 33.84415], [-118.39471, 33.84422], [-118.39513, 33.84427], [-118.39535, 33.84489]]]} | Open Access 1 | Seaside Lagoon Park | 32657 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 3.802 | Seaside Lagoon Park | ||
14257 | 14257 | 14256 | {"type": "Polygon", "coordinates": [[[-118.37521, 33.81927], [-118.37481, 33.81924], [-118.37482, 33.81911], [-118.37521, 33.81914], [-118.37521, 33.81927]]]} | Open Access 1 | Massena Parkette | 21945 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 0.136 | Massena Parkette |
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]);