units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where DES_TP = 3, MNG_AGENCY = 569 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency · 2 ✖
MNG_AGENCY 1
- Rocklin, City of · 2 ✖
DES_TP 1
- Local Recreation Area · 2 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15648 | 15648 | 15647 | {"type": "Polygon", "coordinates": [[[-121.24386, 38.82628], [-121.24338, 38.82653], [-121.24316, 38.82678], [-121.24269, 38.82757], [-121.2426, 38.82819], [-121.24261, 38.82837], [-121.24276, 38.8288], [-121.24279, 38.82901], [-121.24259, 38.82921], [-121.24234, 38.82955], [-121.24214, 38.82972], [-121.24193, 38.82984], [-121.24176, 38.8299], [-121.2412, 38.83006], [-121.24087, 38.83021], [-121.24074, 38.8303], [-121.24061, 38.83041], [-121.24031, 38.83079], [-121.24, 38.83065], [-121.23921, 38.8312], [-121.23844, 38.83177], [-121.23802, 38.83236], [-121.2377, 38.83295], [-121.23717, 38.83334], [-121.23707, 38.83352], [-121.23724, 38.83378], [-121.237, 38.83387], [-121.23689, 38.83389], [-121.23676, 38.83388], [-121.23661, 38.83384], [-121.23616, 38.83363], [-121.23625, 38.83326], [-121.2365, 38.83304], [-121.23661, 38.83289], [-121.23668, 38.83256], [-121.23696, 38.83233], [-121.23697, 38.83231], [-121.23655, 38.83224], [-121.23609, 38.83253], [-121.23603, 38.83253], [-121.23596, 38.83255], [-121.2359, 38.83231], [-121.23563, 38.83231], [-121.23541, 38.8322], [-121.23533, 38.8322], [-121.23527, 38.83223], [-121.23521, 38.83228], [-121.23511, 38.83249], [-121.23495, 38.8326], [-121.23491, 38.83267], [-121.23488, 38.83279], [-121.23481, 38.83289], [-121.23455, 38.83364], [-121.23458, 38.83372], [-121.23484, 38.83381], [-121.23462, 38.83412], [-121.2345, 38.83421], [-121.23325, 38.83502], [-121.23312, 38.83505], [-121.23298, 38.83504], [-121.23286, 38.835], [-121.23274, 38.8349], [-121.2327, 38.83482], [-121.23269, 38.83473], [-121.2327, 38.83467], [-121.23275, 38.83459], [-121.23316, 38.83423], [-121.23331, 38.83406], [-121.23335, 38.83407], [-121.2334, 38.83399], [-121.23347, 38.83383], [-121.2335, 38.8337], [-121.23345, 38.83369], [-121.23346, 38.83356], [-121.2335, 38.83344], [-121.23355, 38.83336], [-121.23377, 38.83337], [-121.23403, 38.83351], [-121.2341, 38.83344], [-121.23416, 38.83309], [-121.23391, 38.83279], [-121.23382, 38.83239], [-121.23383, 38.8323], [-121.23432, 38.83137], [-121.23448, 38.83114], [-121.23552, 38.83011], [-121.23588, 38.83006], [-121.23637, 38.82985], [-121.23661, 38.82979], [-121.23686, 38.82976], [-121.23739, 38.82976], [-121.2377, 38.82974], [-121.23799, 38.82966], [-121.23827, 38.82953], [-121.23887, 38.82911], [-121.23874, 38.82898], [-121.23879, 38.82893], [-121.2387, 38.82884], [-121.23864, 38.82873], [-121.23857, 38.82865], [-121.23868, 38.82857], [-121.23851, 38.82842], [-121.23847, 38.82836], [-121.23747, 38.82747], [-121.23738, 38.82745], [-121.23745, 38.82737], [-121.23721, 38.82713], [-121.23788, 38.82657], [-121.23814, 38.82643], [-121.23824, 38.82636], [-121.23982, 38.82494], [-121.24003, 38.82478], [-121.2403, 38.82463], [-121.2405, 38.82453], [-121.24081, 38.82441], [-121.24087, 38.82451], [-121.24081, 38.82454], [-121.24052, 38.82512], [-121.24106, 38.82544], [-121.24183, 38.82536], [-121.24209, 38.82551], [-121.24235, 38.82551], [-121.24333, 38.82605], [-121.24361, 38.82597], [-121.24386, 38.82628]]]} | Restricted Access 2 | 20825 | City of Rocklin Golf Courses | 33073 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 89.934 | City of Rocklin GC | 0 | Local Recreation Area 3 | 4 | |
16813 | 16813 | 16812 | {"type": "MultiPolygon", "coordinates": [[[[-121.24935, 38.79757], [-121.24887, 38.7976], [-121.24888, 38.79736], [-121.24862, 38.79729], [-121.2486, 38.79701], [-121.24788, 38.79639], [-121.24756, 38.79629], [-121.24638, 38.79603], [-121.24591, 38.79611], [-121.24558, 38.79621], [-121.24526, 38.79664], [-121.24512, 38.79694], [-121.24485, 38.79709], [-121.24378, 38.7975], [-121.24094, 38.79876], [-121.24094, 38.79877], [-121.24112, 38.79902], [-121.24073, 38.79922], [-121.24054, 38.79896], [-121.23974, 38.79931], [-121.23958, 38.79911], [-121.23981, 38.7985], [-121.23945, 38.79817], [-121.2406, 38.79786], [-121.24375, 38.79649], [-121.2443, 38.79581], [-121.24429, 38.7958], [-121.2442, 38.7958], [-121.24484, 38.79531], [-121.24604, 38.79445], [-121.24636, 38.79473], [-121.24652, 38.79518], [-121.24729, 38.79541], [-121.2479, 38.79543], [-121.24805, 38.79534], [-121.24878, 38.79605], [-121.24909, 38.79654], [-121.24928, 38.79708], [-121.24934, 38.79735], [-121.24935, 38.79757]]], [[[-121.25255, 38.7998], [-121.25223, 38.80002], [-121.25251, 38.80029], [-121.25098, 38.80127], [-121.24815, 38.80405], [-121.24782, 38.80431], [-121.24743, 38.80455], [-121.24494, 38.8056], [-121.24452, 38.80574], [-121.24407, 38.80574], [-121.24396, 38.80605], [-121.24361, 38.80596], [-121.2433, 38.80581], [-121.24304, 38.80562], [-121.24284, 38.80538], [-121.24271, 38.80511], [-121.24237, 38.80408], [-121.24228, 38.80386], [-121.24216, 38.80366], [-121.242, 38.80347], [-121.24184, 38.80331], [-121.24168, 38.80319], [-121.24194, 38.80296], [-121.24086, 38.80233], [-121.24045, 38.80189], [-121.24021, 38.80132], [-121.24015, 38.8003], [-121.24006, 38.80006], [-121.24075, 38.79973], [-121.24057, 38.79946], [-121.24109, 38.79923], [-121.24126, 38.79947], [-121.24142, 38.79983], [-121.24149, 38.80031], [-121.24174, 38.80044], [-121.24236, 38.80036], [-121.24253, 38.80015], [-121.2423, 38.79946], [-121.2421, 38.79913], [-121.24418, 38.79821], [-121.24535, 38.79776], [-121.24594, 38.79761], [-121.24654, 38.79765], [-121.2474, 38.79783], [-121.24743, 38.79896], [-121.24579, 38.79935], [-121.24484, 38.79916], [-121.24397, 38.7995], [-121.244, 38.80063], [-121.24357, 38.80114], [-121.24342, 38.80191], [-121.24445, 38.80209], [-121.24565, 38.80187], [-121.24573, 38.80237], [-121.24541, 38.80249], [-121.24543, 38.80279], [-121.24583, 38.80285], [-121.2465, 38.80259], [-121.24734, 38.80186], [-121.24764, 38.80162], [-121.24906, 38.80072], [-121.24952, 38.80026], [-121.25005, 38.79988], [-121.2504, 38.79967], [-121.25064, 38.79948], [-121.25112, 38.799], [-121.25148, 38.79878], [-121.25255, 38.7998]]], [[[-121.26336, 38.7949], [-121.26216, 38.79573], [-121.26081, 38.79691], [-121.25822, 38.79824], [-121.25393, 38.79935], [-121.25344, 38.79967], [-121.25314, 38.79939], [-121.25282, 38.7996], [-121.25177, 38.7986], [-121.2521, 38.7984], [-121.25393, 38.79763], [-121.25471, 38.79763], [-121.25541, 38.7972], [-121.25571, 38.79678], [-121.25665, 38.79627], [-121.25694, 38.7964], [-121.25724, 38.79647], [-121.25756, 38.79649], [-121.25786, 38.79645], [-121.25816, 38.79633], [-121.25931, 38.79573], [-121.25953, 38.79557], [-121.26037, 38.79477], [-121.26072, 38.7945], [-121.26198, 38.79366], [-121.26336, 38.7949]]]]} | Open Access 1 | 49034 | Sunset Whitney Recreation Area | 33741 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | https://www.rocklin.ca.us/news/west-trails-sunset-whitney-rec-area-now-open | Placer 35 | 178.722 | Sunset Whitney Rec. Area | 2018 | 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]);