units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where DES_TP = 2 and PARK_URL = "http://www.lincolnca.gov/city-hall/departments-divisions/parks-and-recreation"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3356 | 3356 | 3355 | {"type": "Polygon", "coordinates": [[[-121.33164, 38.90965], [-121.33137, 38.90972], [-121.33102, 38.90984], [-121.33074, 38.90939], [-121.33134, 38.90917], [-121.33164, 38.90965]]]} | Open Access 1 | 48731 | Brown Park | 33459 | 1175 | Lincoln, City of 608 | City 2 | City Agency 2 | http://www.ci.lincoln.ca.us/default.aspx?Jpage=41500 | City 2 | 1175 | Lincoln, City of 597 | City 2 | City Agency 2 | http://www.lincolnca.gov/city-hall/departments-divisions/parks-and-recreation | Placer 35 | 0.811 | Brown Park | 0 | Local Park 2 | 4 |
12143 | 12143 | 12142 | {"type": "Polygon", "coordinates": [[[-121.31723, 38.87165], [-121.31722, 38.87175], [-121.31703, 38.87191], [-121.3169, 38.87211], [-121.31686, 38.87214], [-121.31637, 38.87209], [-121.31601, 38.87208], [-121.31566, 38.87209], [-121.31522, 38.87214], [-121.31511, 38.87191], [-121.31499, 38.87175], [-121.31474, 38.87147], [-121.31457, 38.87132], [-121.3149, 38.87106], [-121.31496, 38.87107], [-121.31501, 38.87101], [-121.31508, 38.87098], [-121.31507, 38.87085], [-121.31554, 38.87078], [-121.31566, 38.87072], [-121.31588, 38.87079], [-121.31614, 38.87072], [-121.31654, 38.87031], [-121.31674, 38.87002], [-121.31687, 38.87002], [-121.31688, 38.87073], [-121.31692, 38.87105], [-121.31704, 38.87136], [-121.31723, 38.87165]]]} | Open Access 1 | 48732 | Aitken Park | 33461 | 1175 | Lincoln, City of 608 | City 2 | City Agency 2 | http://www.ci.lincoln.ca.us/default.aspx?Jpage=41500 | City 2 | 1175 | Lincoln, City of 597 | City 2 | City Agency 2 | http://www.lincolnca.gov/city-hall/departments-divisions/parks-and-recreation | Placer 35 | 7.419 | Aitken Park | 0 | Local Park 2 | 4 |
12153 | 12153 | 12152 | {"type": "Polygon", "coordinates": [[[-121.32319, 38.86416], [-121.32285, 38.86434], [-121.32284, 38.86441], [-121.32276, 38.86442], [-121.32265, 38.86448], [-121.3223, 38.86458], [-121.32121, 38.86494], [-121.32114, 38.86491], [-121.3209, 38.86458], [-121.32057, 38.86424], [-121.32056, 38.8642], [-121.32059, 38.86415], [-121.32103, 38.86383], [-121.32122, 38.86372], [-121.32144, 38.86362], [-121.32178, 38.86352], [-121.32228, 38.86343], [-121.3224, 38.86344], [-121.32248, 38.86342], [-121.32254, 38.86337], [-121.32256, 38.8633], [-121.32249, 38.86314], [-121.32265, 38.86307], [-121.32272, 38.86331], [-121.32293, 38.86332], [-121.32319, 38.86416]]]} | Open Access 1 | 48733 | Nathan Dubin Park | 33463 | 1175 | Lincoln, City of 608 | City 2 | City Agency 2 | http://www.ci.lincoln.ca.us/default.aspx?Jpage=41500 | City 2 | 1175 | Lincoln, City of 597 | City 2 | City Agency 2 | http://www.lincolnca.gov/city-hall/departments-divisions/parks-and-recreation | Placer 35 | 6.217 | Nathan Dubin Park | 0 | Local Park 2 | 4 |
12154 | 12154 | 12153 | {"type": "Polygon", "coordinates": [[[-121.31084, 38.87461], [-121.31081, 38.87429], [-121.31071, 38.87414], [-121.31068, 38.87396], [-121.30986, 38.87328], [-121.30966, 38.87314], [-121.30893, 38.87375], [-121.30862, 38.87392], [-121.30839, 38.87401], [-121.30814, 38.87408], [-121.30788, 38.87411], [-121.30711, 38.87415], [-121.30636, 38.87421], [-121.30617, 38.87397], [-121.30594, 38.87375], [-121.30596, 38.87373], [-121.30593, 38.87369], [-121.30593, 38.87365], [-121.30595, 38.87361], [-121.30651, 38.87322], [-121.3066, 38.87312], [-121.30666, 38.87301], [-121.30669, 38.8729], [-121.30668, 38.87278], [-121.30666, 38.87271], [-121.30622, 38.87205], [-121.30571, 38.87226], [-121.30545, 38.87213], [-121.30571, 38.87188], [-121.30578, 38.87192], [-121.3061, 38.87167], [-121.30815, 38.87209], [-121.30843, 38.87218], [-121.3087, 38.87229], [-121.30896, 38.87242], [-121.30919, 38.87258], [-121.30927, 38.87269], [-121.30937, 38.87278], [-121.31004, 38.87327], [-121.31064, 38.87381], [-121.31068, 38.87392], [-121.31092, 38.87442], [-121.31092, 38.8745], [-121.31084, 38.87461]]]} | Open Access 1 | 48737 | Robert "Chief" Jimenez Park | 33464 | 1175 | Lincoln, City of 608 | City 2 | City Agency 2 | http://www.ci.lincoln.ca.us/default.aspx?Jpage=41500 | City 2 | 1175 | Lincoln, City of 597 | City 2 | City Agency 2 | http://www.lincolnca.gov/city-hall/departments-divisions/parks-and-recreation | Placer 35 | 15.129 | Robert "Chief" Jimenez 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]);