superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
14 rows where MNG_AGENCY = 11 and MNG_AG_TYP = 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3577 | 3577 | 3576 | {"type": "Polygon", "coordinates": [[[-118.12377, 34.70391], [-118.12177, 34.70393], [-118.12172, 34.70392], [-118.12168, 34.70386], [-118.12165, 34.70386], [-118.12164, 34.70187], [-118.12249, 34.70187], [-118.1225, 34.70171], [-118.12377, 34.7017], [-118.12377, 34.70391]]]} | Open Access 1 | Deputy Pierre W. Bain Park | 18104 | 1169 | Lancaster, City of 11 | City 2 | City Agency 2 | http://www.cityoflancasterca.org/index.aspx?page=23 | City 2 | 11.471 | Deputy Pierre W. Bain Park | ||
3897 | 3897 | 3896 | {"type": "Polygon", "coordinates": [[[-118.12258, 34.69275], [-118.12251, 34.69275], [-118.12249, 34.69267], [-118.1217, 34.69267], [-118.12164, 34.69261], [-118.12164, 34.69054], [-118.12169, 34.69048], [-118.12257, 34.69049], [-118.12258, 34.69275]]]} | Open Access 1 | El Dorado Park | 18505 | 1169 | Lancaster, City of 11 | City 2 | City Agency 2 | http://www.cityoflancasterca.org/index.aspx?page=23 | City 2 | 5.137 | El Dorado Park | ||
4902 | 4902 | 4901 | {"type": "Polygon", "coordinates": [[[-118.14913, 34.66428], [-118.14796, 34.66428], [-118.14794, 34.66187], [-118.1491, 34.66186], [-118.14913, 34.66428]]]} | Open Access 1 | Lancaster Park | 20999 | 1169 | Lancaster, City of 11 | City 2 | City Agency 2 | http://www.cityoflancasterca.org/index.aspx?page=23 | City 2 | 7.068 | Lancaster Park | ||
5484 | 5484 | 5483 | {"type": "Polygon", "coordinates": [[[-118.14227, 34.6921], [-118.14122, 34.69222], [-118.14082, 34.68969], [-118.14088, 34.68964], [-118.14184, 34.68964], [-118.14189, 34.68969], [-118.14227, 34.6921]]]} | Open Access 1 | Jane Reynolds Park | 20360 | 1169 | Lancaster, City of 11 | City 2 | City Agency 2 | http://www.cityoflancasterca.org/index.aspx?page=23 | City 2 | 6.805 | Jane Reynolds Park | ||
6671 | 6671 | 6670 | {"type": "Polygon", "coordinates": [[[-118.14681, 34.71504], [-118.14676, 34.71507], [-118.14445, 34.71507], [-118.14442, 34.71506], [-118.14441, 34.71504], [-118.14438, 34.71315], [-118.14442, 34.71313], [-118.14673, 34.71313], [-118.14676, 34.71314], [-118.14678, 34.71316], [-118.14681, 34.71504]]]} | Open Access 1 | Mariposa Park | 21867 | 1169 | Lancaster, City of 11 | City 2 | City Agency 2 | http://www.cityoflancasterca.org/index.aspx?page=23 | City 2 | 11.692 | Mariposa Park | ||
8410 | 8410 | 8409 | {"type": "Polygon", "coordinates": [[[-118.19722, 34.66567], [-118.19715, 34.66672], [-118.19712, 34.66685], [-118.19704, 34.66703], [-118.19701, 34.66714], [-118.197, 34.6675], [-118.19465, 34.66751], [-118.19464, 34.66842], [-118.1924, 34.66844], [-118.19241, 34.67111], [-118.19025, 34.6711], [-118.19022, 34.66753], [-118.19238, 34.66752], [-118.19238, 34.6657], [-118.19722, 34.66567]]]} | Open Access 1 | Prime Desert Woodland Preserve | 24002 | 1169 | Lancaster, City of 11 | City 2 | City Agency 2 | http://www.cityoflancasterca.org/index.aspx?page=23 | City 2 | 46.437 | Prime Desert Woodland Preserve | ||
8562 | 8562 | 8561 | {"type": "Polygon", "coordinates": [[[-118.19243, 34.67468], [-118.19069, 34.67469], [-118.19068, 34.67388], [-118.19025, 34.67387], [-118.19023, 34.67118], [-118.19241, 34.67122], [-118.19243, 34.67468]]]} | Open Access 1 | Rawley Duntley Park | 24202 | 1169 | Lancaster, City of 11 | City 2 | City Agency 2 | http://www.cityoflancasterca.org/index.aspx?page=23 | City 2 | 18.177 | Rawley Duntley Park | ||
9728 | 9728 | 9727 | {"type": "Polygon", "coordinates": [[[-118.07335, 34.66989], [-118.07336, 34.66992], [-118.07337, 34.67106], [-118.07333, 34.67123], [-118.07316, 34.67165], [-118.07306, 34.67177], [-118.07277, 34.67203], [-118.07259, 34.67215], [-118.07243, 34.67222], [-118.0721, 34.67229], [-118.07185, 34.67232], [-118.07174, 34.67238], [-118.07125, 34.67229], [-118.07115, 34.67201], [-118.07108, 34.67171], [-118.07104, 34.67135], [-118.07103, 34.66998], [-118.07145, 34.66984], [-118.07152, 34.66988], [-118.07162, 34.66991], [-118.07187, 34.66988], [-118.07335, 34.66989]]]} | Open Access 1 | Skytower Park | 25546 | 1169 | Lancaster, City of 11 | City 2 | City Agency 2 | http://www.cityoflancasterca.org/index.aspx?page=23 | City 2 | 12.896 | Skytower Park | ||
10112 | 10112 | 10111 | {"type": "MultiPolygon", "coordinates": [[[[-118.14188, 34.70125], [-118.14138, 34.7013], [-118.14115, 34.69984], [-118.14165, 34.69979], [-118.14188, 34.70125]]], [[[-118.1437, 34.7012], [-118.14367, 34.70122], [-118.1427, 34.70132], [-118.14266, 34.7013], [-118.14262, 34.70116], [-118.14194, 34.70124], [-118.14171, 34.69978], [-118.14216, 34.69973], [-118.14222, 34.69976], [-118.1424, 34.69974], [-118.14245, 34.6997], [-118.14341, 34.69959], [-118.14345, 34.6996], [-118.14347, 34.69963], [-118.14371, 34.70117], [-118.1437, 34.7012]]]]} | Open Access 1 | American Heroes Park | http://www.destinationlancasterca.org/listings/?action=display&listingID=618 | 28310 | 1169 | Lancaster, City of 11 | City 2 | City Agency 2 | http://www.cityoflancasterca.org/index.aspx?page=23 | City 2 | 8.777 | American Heroes Park | |
10360 | 10360 | 10359 | {"type": "Polygon", "coordinates": [[[-118.08147, 34.70071], [-118.07718, 34.70076], [-118.07715, 34.69722], [-118.07923, 34.69719], [-118.07926, 34.69892], [-118.08146, 34.69889], [-118.08147, 34.70071]]]} | Open Access 1 | Tierra Bonita Park | 26351 | 1169 | Lancaster, City of 11 | City 2 | City Agency 2 | http://www.cityoflancasterca.org/index.aspx?page=23 | City 2 | 28.646 | Tierra Bonita Park | ||
11767 | 11767 | 11766 | {"type": "Polygon", "coordinates": [[[-118.14385, 34.71307], [-118.14286, 34.71307], [-118.14277, 34.71297], [-118.14268, 34.71261], [-118.14261, 34.71244], [-118.14239, 34.71233], [-118.14208, 34.71225], [-118.14186, 34.71215], [-118.14159, 34.71207], [-118.14138, 34.71208], [-118.14108, 34.71214], [-118.14081, 34.71217], [-118.14056, 34.71217], [-118.13999, 34.71232], [-118.13984, 34.7123], [-118.13982, 34.71125], [-118.14382, 34.71125], [-118.14385, 34.71307]]]} | Open Access 1 | Whit Carter Park | http://www.cityoflancasterca.org/index.aspx?page=1837 | 28379 | 1169 | Lancaster, City of 11 | City 2 | City Agency 2 | http://www.cityoflancasterca.org/index.aspx?page=23 | City 2 | 12.107 | Whit Carter Park | |
11824 | 11824 | 11823 | {"type": "Polygon", "coordinates": [[[-118.18297, 34.64933], [-118.18095, 34.64936], [-118.1809, 34.64752], [-118.18292, 34.64752], [-118.18297, 34.64933]]]} | Open Access 1 | Forrest E. Hull Park | http://www.cityoflancasterca.org/index.aspx?page=46 | 28466 | 1169 | Lancaster, City of 11 | City 2 | City Agency 2 | http://www.cityoflancasterca.org/index.aspx?page=23 | City 2 | 9.296 | Forrest E. Hull Park | |
13138 | 13138 | 13137 | {"type": "Polygon", "coordinates": [[[-118.15295, 34.66727], [-118.15079, 34.6674], [-118.15012, 34.6675], [-118.14799, 34.66749], [-118.14797, 34.66593], [-118.14914, 34.66592], [-118.14912, 34.66566], [-118.14797, 34.66565], [-118.14796, 34.66428], [-118.14912, 34.66427], [-118.1491, 34.66186], [-118.14958, 34.66186], [-118.14959, 34.66224], [-118.14998, 34.66225], [-118.15004, 34.66228], [-118.15022, 34.66243], [-118.15288, 34.66244], [-118.15292, 34.66664], [-118.15295, 34.66727]]]} | Open Access 1 | Sgt. Steve Owen Memorial Park | https://www.cityoflancasterca.org/about-us/departments-services/parks-recreation-arts/parks/sgt-steve-owen-memorial-park | 31825 | 1169 | Lancaster, City of 11 | City 2 | City Agency 2 | http://www.cityoflancasterca.org/index.aspx?page=23 | City 2 | 56.674 | Sgt. Steve Owen Memorial Park | |
15516 | 15516 | 15515 | {"type": "MultiPolygon", "coordinates": [[[[-118.07661, 34.66475], [-118.07606, 34.66475], [-118.07502, 34.66449], [-118.07377, 34.66452], [-118.07375, 34.66468], [-118.06801, 34.66468], [-118.06796, 34.66371], [-118.06794, 34.66087], [-118.06803, 34.66079], [-118.07648, 34.66082], [-118.07657, 34.66089], [-118.07661, 34.66475]]], [[[-118.08351, 34.66425], [-118.07694, 34.66429], [-118.07691, 34.66192], [-118.07694, 34.66159], [-118.07694, 34.6609], [-118.07703, 34.66082], [-118.08342, 34.66077], [-118.08345, 34.66335], [-118.08351, 34.66425]]]]} | Restricted Access 2 | Lancaster National Soccer Center | 29790 | 1169 | Lancaster, City of 11 | City 2 | City Agency 2 | http://www.cityoflancasterca.org/index.aspx?page=23 | City 2 | 140.148 | Lancaster Nat. Soccer Ctr. |
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]);