units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where COUNTY = 10, MNG_AGENCY = 363 and MNG_AG_TYP = 3
This data as json, copyable, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7794 | 7794 | 7793 | {"type": "MultiPolygon", "coordinates": [[[[-117.59978, 33.92761], [-117.59968, 33.92761], [-117.5996, 33.92794], [-117.59951, 33.92816], [-117.59743, 33.92817], [-117.59743, 33.92907], [-117.59603, 33.92908], [-117.59537, 33.93021], [-117.59516, 33.93078], [-117.59487, 33.93088], [-117.59431, 33.93143], [-117.59398, 33.93193], [-117.59369, 33.93247], [-117.59365, 33.9326], [-117.59398, 33.93286], [-117.5933, 33.93304], [-117.5931, 33.93327], [-117.5931, 33.93348], [-117.5915, 33.93546], [-117.59123, 33.93545], [-117.59098, 33.93574], [-117.59072, 33.93592], [-117.59057, 33.93611], [-117.59051, 33.93715], [-117.59051, 33.93769], [-117.59012, 33.93853], [-117.5898, 33.93894], [-117.58891, 33.93962], [-117.58857, 33.94005], [-117.58816, 33.94048], [-117.58814, 33.94047], [-117.58805, 33.94057], [-117.58752, 33.94074], [-117.58722, 33.94075], [-117.58635, 33.94092], [-117.58595, 33.94116], [-117.58533, 33.94145], [-117.58403, 33.9417], [-117.58358, 33.94192], [-117.58309, 33.94226], [-117.58257, 33.94246], [-117.582, 33.94257], [-117.58189, 33.94376], [-117.58183, 33.94394], [-117.58197, 33.9447], [-117.58164, 33.94532], [-117.58111, 33.94602], [-117.58065, 33.94631], [-117.58007, 33.94632], [-117.58006, 33.94709], [-117.57996, 33.94713], [-117.57991, 33.9472], [-117.57991, 33.94724], [-117.57994, 33.94739], [-117.57994, 33.94756], [-117.57755, 33.94757], [-117.57754, 33.94814], [-117.57571, 33.94814], [-117.57571, 33.94632], [-117.567, 33.94633], [-117.5668, 33.94367], [-117.57228, 33.94333], [-117.5737, 33.94228], [-117.5741, 33.94036], [-117.5745, 33.93948], [-117.57547, 33.93877], [-117.57587, 33.93862], [-117.57958, 33.93734], [-117.58067, 33.93635], [-117.58057, 33.93579], [-117.57911, 33.93535], [-117.58097, 33.93352], [-117.5811, 33.93275], [-117.58138, 33.93274], [-117.58281, 33.93137], [-117.5863, 33.9279], [-117.58598, 33.92729], [-117.58738, 33.92677], [-117.58834, 33.92582], [-117.58866, 33.92511], [-117.5883, 33.92447], [-117.59007, 33.9231], [-117.59488, 33.92596], [-117.59702, 33.92315], [-117.59815, 33.92438], [-117.599, 33.92524], [-117.59922, 33.9255], [-117.59935, 33.92569], [-117.59956, 33.92607], [-117.59961, 33.92625], [-117.59966, 33.92623], [-117.59976, 33.92654], [-117.59982, 33.92686], [-117.59983, 33.92707], [-117.59982, 33.92729], [-117.59978, 33.92761]]], [[[-117.61099, 33.91709], [-117.61098, 33.92207], [-117.60494, 33.9211], [-117.60438, 33.92222], [-117.60419, 33.92349], [-117.60422, 33.92387], [-117.60418, 33.92415], [-117.60436, 33.92437], [-117.60424, 33.92475], [-117.60446, 33.92483], [-117.60512, 33.92432], [-117.60558, 33.92412], [-117.60544, 33.9245], [-117.60501, 33.92528], [-117.60531, 33.92578], [-117.60415, 33.9262], [-117.60411, 33.92815], [-117.60219, 33.92814], [-117.60187, 33.9279], [-117.60149, 33.9277], [-117.60152, 33.92764], [-117.6014, 33.92759], [-117.60113, 33.9275], [-117.60073, 33.92743], [-117.6007, 33.92749], [-117.60025, 33.92746], [-117.60016, 33.92742], [-117.60012, 33.92733], [-117.60011, 33.92688], [-117.60003, 33.92642], [-117.59991, 33.92609], [-117.59976, 33.92576], [-117.59957, 33.92545], [-117.59934, 33.92516], [-117.59842, 33.92422], [-117.61099, 33.91709]]]]} | Open Access 1 | 8860 | Prado Basin Park | 10144 | 318 | San Bernardino, County of 368 | County 3 | County Agency 3 | http://cms.sbcounty.gov/parks/Home.aspx | County 3 | 318 | San Bernardino, County of 363 | County 3 | County Agency 3 | Riverside 10 | 809.854 | Prado Basin 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]);