units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
16 rows where AGNCY_LEV = 2, DES_TP = 2 and MNG_AGENCY = 597
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3258 | 3258 | 3257 | {"type": "Polygon", "coordinates": [[[-121.29952, 38.87705], [-121.29945, 38.87766], [-121.29942, 38.87773], [-121.29936, 38.87775], [-121.29886, 38.87774], [-121.29854, 38.87714], [-121.29859, 38.87706], [-121.29872, 38.87696], [-121.29952, 38.87705]]]} | Open Access 1 | 48712 | Sheffield Park | 33441 | 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 | Placer 35 | 1.415 | Sheffield Park | 0 | Local Park 2 | 4 | |
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 |
4111 | 4111 | 4110 | {"type": "Polygon", "coordinates": [[[-121.30983, 38.89395], [-121.30982, 38.89544], [-121.30861, 38.89591], [-121.3086, 38.89712], [-121.30762, 38.89712], [-121.30764, 38.8939], [-121.30799, 38.8939], [-121.30808, 38.89398], [-121.3082, 38.89401], [-121.30837, 38.89397], [-121.30983, 38.89395]]]} | Open Access 1 | 47086 | Joiner Park | 30740 | 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 | Placer 35 | 12.363 | Joiner Park | 0 | Local Park 2 | 4 | |
10954 | 10954 | 10953 | {"type": "Polygon", "coordinates": [[[-121.31589, 38.87895], [-121.31574, 38.87908], [-121.31563, 38.87923], [-121.31559, 38.87931], [-121.31557, 38.87943], [-121.31558, 38.87979], [-121.31528, 38.87977], [-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.8792], [-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.31493, 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 | 48680 | Machado Park | 33421 | 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-recreation/parks | Placer 35 | 3.192 | Machado Park | 0 | Local Park 2 | 4 |
11063 | 11063 | 11062 | {"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.26938, 38.84611], [-121.26864, 38.84636], [-121.26853, 38.84617], [-121.26839, 38.84598], [-121.26822, 38.84582], [-121.26803, 38.84566], [-121.26874, 38.84496], [-121.26897, 38.84478], [-121.26959, 38.84533], [-121.27061, 38.84606]]]} | Open Access 1 | 48681 | Twelve Bridges Park | 33422 | 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-recreation/parks | Placer 35 | 4.82 | Twelve Bridges Park | 0 | Local Park 2 | 4 |
11064 | 11064 | 11063 | {"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 | 48682 | Wilson Park | 33423 | 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-recreation/parks | Placer 35 | 5.843 | Wilson Park | 0 | Local Park 2 | 4 |
11067 | 11067 | 11066 | {"type": "Polygon", "coordinates": [[[-121.26088, 38.84508], [-121.26041, 38.84552], [-121.26012, 38.84531], [-121.2601, 38.84532], [-121.2595, 38.84622], [-121.2595, 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 | 48683 | Coyote Pond Park | 33424 | 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-recreation/parks | Placer 35 | 34.316 | Coyote Pond Park | 0 | Local Park 2 | 4 |
11087 | 11087 | 11086 | {"type": "Polygon", "coordinates": [[[-121.3187, 38.90558], [-121.31861, 38.90558], [-121.31861, 38.90428], [-121.31692, 38.90427], [-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 | 48684 | Foskett Regional Park | 33425 | 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-recreation/parks | Placer 35 | 38.774 | Foskett RP | 0 | Local Park 2 | 4 |
11469 | 11469 | 11468 | {"type": "Polygon", "coordinates": [[[-121.27421, 38.90427], [-121.27413, 38.90433], [-121.27265, 38.90434], [-121.2726, 38.90431], [-121.27257, 38.90427], [-121.27256, 38.90359], [-121.27263, 38.90353], [-121.27416, 38.90352], [-121.2742, 38.90357], [-121.27421, 38.90427]]]} | Open Access 1 | 48709 | Palo Verde Park | 33438 | 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 | Placer 35 | 3.146 | Palo Verde Park | 0 | Local Park 2 | 4 | |
11470 | 11470 | 11469 | {"type": "Polygon", "coordinates": [[[-121.30951, 38.86215], [-121.3095, 38.86223], [-121.30904, 38.86261], [-121.30896, 38.86262], [-121.30882, 38.86253], [-121.30875, 38.86245], [-121.30871, 38.86237], [-121.3087, 38.86226], [-121.30873, 38.86218], [-121.30885, 38.86205], [-121.309, 38.86199], [-121.30907, 38.86197], [-121.30929, 38.862], [-121.30936, 38.86203], [-121.30951, 38.86215]]]} | Open Access 1 | 48710 | Pete Demas Park | 33439 | 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 | Placer 35 | 0.819 | Pete Demas Park | 0 | Local Park 2 | 4 | |
11471 | 11471 | 11470 | {"type": "Polygon", "coordinates": [[[-121.30527, 38.87704], [-121.30506, 38.87722], [-121.30489, 38.87744], [-121.30482, 38.87763], [-121.30479, 38.87799], [-121.30466, 38.87801], [-121.30457, 38.87797], [-121.30346, 38.8779], [-121.30287, 38.87783], [-121.30303, 38.87757], [-121.30318, 38.87718], [-121.30331, 38.87674], [-121.30346, 38.87643], [-121.30527, 38.87704]]]} | Open Access 1 | 48711 | Peter Singer Park | 33440 | 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 | Placer 35 | 5.474 | Peter Singer 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 |
13878 | 13878 | 13877 | {"type": "Polygon", "coordinates": [[[-121.28887, 38.8904], [-121.28841, 38.8904], [-121.2884, 38.88999], [-121.28834, 38.89], [-121.28834, 38.8904], [-121.28788, 38.8904], [-121.28787, 38.88999], [-121.2876, 38.88999], [-121.2876, 38.8904], [-121.28715, 38.8904], [-121.28713, 38.88999], [-121.28707, 38.89], [-121.28707, 38.8904], [-121.28662, 38.8904], [-121.28662, 38.88999], [-121.28631, 38.88997], [-121.28629, 38.88998], [-121.28628, 38.89037], [-121.28582, 38.89037], [-121.28582, 38.88996], [-121.28576, 38.88997], [-121.28575, 38.89037], [-121.28529, 38.89036], [-121.28528, 38.88995], [-121.285, 38.88996], [-121.285, 38.89036], [-121.28448, 38.89032], [-121.28358, 38.89016], [-121.28301, 38.89014], [-121.28317, 38.88999], [-121.28381, 38.88958], [-121.28414, 38.88925], [-121.28415, 38.88944], [-121.28471, 38.88906], [-121.28506, 38.88877], [-121.28646, 38.88784], [-121.28693, 38.8869], [-121.28696, 38.8869], [-121.28697, 38.88777], [-121.28886, 38.88776], [-121.28887, 38.8904]]]} | Open Access 1 | 36469 | McBean Park | 33462 | 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 | Placer 35 | 25.302 | McBean Park | 0 | Local Park 2 | 4 | |
14286 | 14286 | 14285 | {"type": "Polygon", "coordinates": [[[-121.32615, 38.8895], [-121.32614, 38.88994], [-121.32467, 38.88994], [-121.32467, 38.88923], [-121.32511, 38.88916], [-121.32576, 38.889], [-121.32584, 38.88905], [-121.32586, 38.88921], [-121.32592, 38.88935], [-121.32602, 38.88944], [-121.32615, 38.8895]]]} | Open Access 1 | 44220 | Scheiber Park | 25181 | 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 | Placer 35 | 2.695 | Scheiber 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]);