superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where ACCESS_TYP = 1 and PARK_URL = "http://www.lincolnca.gov/city-hall/departments-divisions/parks-recreation/parks"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13284 | 13284 | 13283 | {"type": "Polygon", "coordinates": [[[-121.31589, 38.87895], [-121.31574, 38.87908], [-121.31563, 38.87923], [-121.31559, 38.87931], [-121.31557, 38.87944], [-121.31558, 38.87979], [-121.31528, 38.87978], [-121.31501, 38.87999], [-121.3149, 38.87983], [-121.31465, 38.87964], [-121.31447, 38.87957], [-121.31412, 38.87946], [-121.31409, 38.87943], [-121.31408, 38.87939], [-121.31416, 38.87919], [-121.31419, 38.87898], [-121.31426, 38.87895], [-121.3144, 38.87895], [-121.31462, 38.879], [-121.31471, 38.87906], [-121.31471, 38.87918], [-121.31474, 38.87922], [-121.31478, 38.87925], [-121.31484, 38.87926], [-121.31492, 38.87925], [-121.31499, 38.87916], [-121.31503, 38.87916], [-121.3151, 38.87905], [-121.31509, 38.87832], [-121.3153, 38.87841], [-121.31549, 38.87854], [-121.31588, 38.8789], [-121.31589, 38.87895]]]} | Open Access 1 | Machado Park | http://www.lincolnca.gov/city-hall/departments-divisions/parks-recreation/parks | 33421 | 1175 | Lincoln, City of 597 | City 2 | City Agency 2 | http://www.ci.lincoln.ca.us/default.aspx?Jpage=41500 | City 2 | 3.193 | Machado Park | |
13290 | 13290 | 13289 | {"type": "Polygon", "coordinates": [[[-121.27061, 38.84606], [-121.26986, 38.84631], [-121.26981, 38.8463], [-121.2697, 38.8462], [-121.26961, 38.84617], [-121.26952, 38.84616], [-121.26942, 38.84618], [-121.26937, 38.84612], [-121.26864, 38.84636], [-121.26853, 38.84617], [-121.26839, 38.84598], [-121.26822, 38.84581], [-121.26803, 38.84566], [-121.26874, 38.84496], [-121.26897, 38.84478], [-121.26959, 38.84533], [-121.27061, 38.84606]]]} | Open Access 1 | Twelve Bridges Park | http://www.lincolnca.gov/city-hall/departments-divisions/parks-recreation/parks | 33422 | 1175 | Lincoln, City of 597 | City 2 | City Agency 2 | http://www.ci.lincoln.ca.us/default.aspx?Jpage=41500 | City 2 | 4.821 | Twelve Bridges Park | |
13293 | 13293 | 13292 | {"type": "Polygon", "coordinates": [[[-121.28975, 38.84529], [-121.28927, 38.84568], [-121.28784, 38.84665], [-121.28679, 38.84581], [-121.28707, 38.84516], [-121.28975, 38.84529]]]} | Open Access 1 | Wilson Park | http://www.lincolnca.gov/city-hall/departments-divisions/parks-recreation/parks | 33423 | 1175 | Lincoln, City of 597 | City 2 | City Agency 2 | http://www.ci.lincoln.ca.us/default.aspx?Jpage=41500 | City 2 | 5.842 | Wilson Park | |
13294 | 13294 | 13293 | {"type": "Polygon", "coordinates": [[[-121.26088, 38.84508], [-121.26041, 38.84552], [-121.26012, 38.84532], [-121.2601, 38.84532], [-121.2595, 38.84622], [-121.25951, 38.8463], [-121.25984, 38.84644], [-121.25976, 38.84675], [-121.25941, 38.8467], [-121.25878, 38.84807], [-121.25695, 38.8483], [-121.25726, 38.84925], [-121.2552, 38.84947], [-121.2557, 38.84847], [-121.25607, 38.8476], [-121.25628, 38.84701], [-121.25693, 38.84541], [-121.25732, 38.8451], [-121.25796, 38.84417], [-121.25895, 38.8435], [-121.26088, 38.84508]]]} | Open Access 1 | Coyote Pond Park | http://www.lincolnca.gov/city-hall/departments-divisions/parks-recreation/parks | 33424 | 1175 | Lincoln, City of 597 | City 2 | City Agency 2 | http://www.ci.lincoln.ca.us/default.aspx?Jpage=41500 | City 2 | 34.33 | Coyote Pond Park | |
13300 | 13300 | 13299 | {"type": "Polygon", "coordinates": [[[-121.3187, 38.90558], [-121.31687, 38.90557], [-121.31688, 38.90593], [-121.31639, 38.90641], [-121.31638, 38.90793], [-121.31547, 38.90787], [-121.31483, 38.90772], [-121.31214, 38.90775], [-121.31215, 38.90442], [-121.31249, 38.90436], [-121.31288, 38.90442], [-121.31316, 38.90454], [-121.31346, 38.9046], [-121.31384, 38.90457], [-121.31412, 38.90449], [-121.31484, 38.90436], [-121.31502, 38.90427], [-121.31564, 38.90411], [-121.31622, 38.904], [-121.31867, 38.90395], [-121.3187, 38.90558]]]} | Open Access 1 | Foskett Regional Park | http://www.lincolnca.gov/city-hall/departments-divisions/parks-recreation/parks | 33425 | 1175 | Lincoln, City of 597 | City 2 | City Agency 2 | http://www.ci.lincoln.ca.us/default.aspx?Jpage=41500 | City 2 | 44.119 | Foskett RP |
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]);