units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 2, DES_TP = 3, MNG_AGENCY = 569 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency · 1 ✖
MNG_AGENCY 1
- Rocklin, City of · 1 ✖
DES_TP 1
- Local Recreation Area · 1 ✖
ACCESS_TYP 1
- Restricted Access · 1 ✖
| 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 |
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]);