units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
11 rows where MNG_AGENCY = 216 and MNG_AG_TYP = 2 sorted by AGNCY_TYP
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
607 | 607 | 606 | {"type": "Polygon", "coordinates": [[[-116.20372, 33.73346], [-116.20136, 33.73345], [-116.20135, 33.73248], [-116.20244, 33.73249], [-116.20262, 33.73252], [-116.2029, 33.73262], [-116.20312, 33.73267], [-116.20332, 33.73268], [-116.20372, 33.73268], [-116.20372, 33.73346]]]} | Open Access 1 | 2112 | Cahuilla Park | 16664 | 1145 | Indio, City of 220 | City 2 | City Agency 2 | http://www.indio.org/index.aspx?page=90 | City 2 | 1145 | Indio, City of 216 | City 2 | City Agency 2 | Riverside 10 | 5.361 | Cahuilla Park | 0 | Local Park 2 | 4 | |
715 | 715 | 714 | {"type": "Polygon", "coordinates": [[[-116.22695, 33.72294], [-116.22567, 33.72294], [-116.22566, 33.72343], [-116.2256, 33.72344], [-116.2256, 33.72375], [-116.22473, 33.72375], [-116.22472, 33.72386], [-116.22348, 33.72385], [-116.2235, 33.72127], [-116.22693, 33.72129], [-116.22696, 33.72135], [-116.22695, 33.72294]]]} | Open Access 1 | 5359 | Miles Avenue Park | 22218 | 1145 | Indio, City of 220 | City 2 | City Agency 2 | http://www.indio.org/index.aspx?page=90 | City 2 | 1145 | Indio, City of 216 | City 2 | City Agency 2 | Riverside 10 | 19.373 | Miles Avenue Park | 0 | Local Park 2 | 4 | |
1413 | 1413 | 1412 | {"type": "Polygon", "coordinates": [[[-116.2603, 33.71559], [-116.26019, 33.71569], [-116.26001, 33.71554], [-116.25966, 33.71554], [-116.25966, 33.71507], [-116.26003, 33.71497], [-116.26004, 33.71507], [-116.26008, 33.71508], [-116.26009, 33.71504], [-116.26021, 33.71503], [-116.2602, 33.71543], [-116.2603, 33.71559]]]} | Open Access 1 | 39060 | Shields Park | 25407 | 1145 | Indio, City of 220 | City 2 | City Agency 2 | http://www.indio.org/index.aspx?page=90 | City 2 | 1145 | Indio, City of 216 | City 2 | City Agency 2 | Riverside 10 | 0.787 | Shields Park | 0 | Local Park 2 | 4 | |
3007 | 3007 | 3006 | {"type": "Polygon", "coordinates": [[[-116.21623, 33.71146], [-116.21622, 33.71192], [-116.21491, 33.71193], [-116.2149, 33.71223], [-116.214, 33.71224], [-116.21399, 33.71312], [-116.21205, 33.71313], [-116.21204, 33.71375], [-116.21022, 33.71376], [-116.21022, 33.71403], [-116.20988, 33.71403], [-116.20987, 33.71151], [-116.21623, 33.71146]]]} | Open Access 1 | 24267 | South Jackson Park | 25658 | 1145 | Indio, City of 220 | City 2 | City Agency 2 | http://www.indio.org/index.aspx?page=90 | City 2 | 1145 | Indio, City of 216 | City 2 | City Agency 2 | Riverside 10 | 24.083 | South Jackson Park | 0 | Local Park 2 | 4 | |
3136 | 3136 | 3135 | {"type": "Polygon", "coordinates": [[[-116.21751, 33.72078], [-116.21751, 33.72092], [-116.21735, 33.72115], [-116.21714, 33.72105], [-116.21699, 33.72092], [-116.21699, 33.72069], [-116.21751, 33.7207], [-116.21751, 33.72078]]]} | Open Access 1 | 39057 | Doug York Plaza | 18240 | 1145 | Indio, City of 220 | City 2 | City Agency 2 | http://www.indio.org/index.aspx?page=90 | City 2 | 1145 | Indio, City of 216 | City 2 | City Agency 2 | Riverside 10 | 0.476 | Doug York Plaza | 0 | Local Park 2 | 4 | |
3196 | 3196 | 3195 | {"type": "Polygon", "coordinates": [[[-116.20066, 33.71858], [-116.20066, 33.71881], [-116.19995, 33.71937], [-116.19949, 33.71896], [-116.20008, 33.71895], [-116.20009, 33.71858], [-116.20066, 33.71858]]]} | Open Access 1 | 39058 | Mulligan Dog Park | 22598 | 1145 | Indio, City of 220 | City 2 | City Agency 2 | http://www.indio.org/index.aspx?page=90 | City 2 | 1145 | Indio, City of 216 | City 2 | City Agency 2 | Riverside 10 | 1.035 | Mulligan Dog Park | 0 | Local Park 2 | 4 | |
3422 | 3422 | 3421 | {"type": "Polygon", "coordinates": [[[-116.236, 33.72465], [-116.236, 33.72515], [-116.23582, 33.72509], [-116.23569, 33.72507], [-116.23545, 33.72507], [-116.23447, 33.72536], [-116.23386, 33.72536], [-116.23387, 33.72466], [-116.236, 33.72465]]]} | Open Access 1 | 25146 | Dominguez Park | 18196 | 1145 | Indio, City of 220 | City 2 | City Agency 2 | http://www.indio.org/index.aspx?page=90 | City 2 | 1145 | Indio, City of 216 | City 2 | City Agency 2 | Riverside 10 | 3.095 | Dominguez Park | 0 | Local Park 2 | 4 | |
5156 | 5156 | 5155 | {"type": "Polygon", "coordinates": [[[-116.23189, 33.70746], [-116.23189, 33.70846], [-116.23111, 33.70846], [-116.23111, 33.70747], [-116.23189, 33.70746]]]} | Open Access 1 | 25145 | Dr. Carreon Park | 18266 | 1145 | Indio, City of 220 | City 2 | City Agency 2 | http://www.indio.org/index.aspx?page=90 | City 2 | 1145 | Indio, City of 216 | City 2 | City Agency 2 | Riverside 10 | 1.986 | Dr. Carreon Park | 0 | Local Park 2 | 4 | |
11617 | 11617 | 11616 | {"type": "Polygon", "coordinates": [[[-116.23029, 33.73267], [-116.22948, 33.73267], [-116.22944, 33.73266], [-116.22942, 33.73262], [-116.22942, 33.73214], [-116.22947, 33.73212], [-116.23029, 33.73211], [-116.23029, 33.73267]]]} | Open Access 1 | 24639 | Yucca Park | 27848 | 1145 | Indio, City of 220 | City 2 | City Agency 2 | http://www.indio.org/index.aspx?page=90 | City 2 | 1145 | Indio, City of 216 | City 2 | City Agency 2 | Riverside 10 | 1.218 | Yucca Park | 0 | Local Park 2 | 4 | |
14054 | 14054 | 14053 | {"type": "Polygon", "coordinates": [[[-116.20543, 33.73682], [-116.20543, 33.73778], [-116.20384, 33.73778], [-116.20379, 33.73775], [-116.20379, 33.73753], [-116.20386, 33.73744], [-116.20387, 33.73738], [-116.20379, 33.7372], [-116.20379, 33.73686], [-116.20382, 33.73686], [-116.20388, 33.73681], [-116.20543, 33.73682]]]} | Open Access 1 | 39056 | Patton Park | 23523 | 1145 | Indio, City of 220 | City 2 | City Agency 2 | http://www.indio.org/index.aspx?page=90 | City 2 | 1145 | Indio, City of 216 | City 2 | City Agency 2 | Riverside 10 | 3.994 | Patton Park | 0 | Local Park 2 | 4 | |
14061 | 14061 | 14060 | {"type": "Polygon", "coordinates": [[[-116.21454, 33.74765], [-116.20803, 33.7476], [-116.20804, 33.74405], [-116.21453, 33.7441], [-116.21454, 33.74765]]]} | Restricted Access 2 | 39062 | Indio's Municipal Golf Course | 33103 | 1145 | Indio, City of 220 | City 2 | City Agency 2 | http://www.indio.org/index.aspx?page=90 | City 2 | 1145 | Indio, City of 216 | City 2 | City Agency 2 | Riverside 10 | 58.615 | Indio's Municipal GC | 0 | Local Recreation Area 3 | 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]);