units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
6 rows where MNG_AGENCY = 597 and PARK_URL = "http://www.lincolnca.gov/city-hall/departments-divisions/parks-recreation/parks"
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, LABEL_NAME
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4998 | 4998 | 4997 | {"type": "Polygon", "coordinates": [[[-121.31861, 38.90558], [-121.31687, 38.90557], [-121.31691, 38.90427], [-121.31861, 38.90427], [-121.31861, 38.90558]]]} | Open Access 1 | 48685 | Foskett Regional Park | 33425 | 2433 | Western Placer School District 791 | Special District 4 | School District 14 | http://www.wpusd.org/ | Special District 4 | 1175 | Lincoln, City of 597 | City 2 | City Agency 2 | http://www.lincolnca.gov/city-hall/departments-divisions/parks-recreation/parks | Placer 35 | 5.355 | Foskett RP | 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 |
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]);