units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where COUNTY = 10, DES_TP = 1066 and MNG_AG_TYP = 6
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12236 | 12236 | 12235 | {"type": "MultiPolygon", "coordinates": [[[[-117.15208, 33.96111], [-117.13868, 33.96101], [-117.12114, 33.96103], [-117.12139, 33.95827], [-117.12365, 33.95823], [-117.12402, 33.95508], [-117.12386, 33.95212], [-117.12521, 33.95207], [-117.12514, 33.9506], [-117.12533, 33.95058], [-117.12575, 33.95068], [-117.12624, 33.95073], [-117.12651, 33.95071], [-117.1267, 33.95066], [-117.12685, 33.95057], [-117.12694, 33.95049], [-117.12701, 33.9504], [-117.12707, 33.95027], [-117.12735, 33.95016], [-117.12751, 33.95008], [-117.12781, 33.94989], [-117.12803, 33.94981], [-117.12819, 33.9497], [-117.12832, 33.94954], [-117.12885, 33.94917], [-117.12919, 33.94902], [-117.12945, 33.94889], [-117.12967, 33.94872], [-117.12977, 33.94862], [-117.12994, 33.9484], [-117.13046, 33.94804], [-117.13031, 33.95387], [-117.13885, 33.9538], [-117.13904, 33.94658], [-117.14104, 33.94659], [-117.14104, 33.94657], [-117.14103, 33.94655], [-117.14308, 33.94655], [-117.14518, 33.94792], [-117.14426, 33.94939], [-117.14571, 33.95054], [-117.14573, 33.95053], [-117.14674, 33.94894], [-117.14706, 33.94915], [-117.14802, 33.95012], [-117.14752, 33.95344], [-117.14711, 33.95384], [-117.15091, 33.95386], [-117.15096, 33.95648], [-117.15208, 33.95648], [-117.15208, 33.96111]], [[-117.1432, 33.95743], [-117.14326, 33.95382], [-117.13886, 33.9538], [-117.13878, 33.95739], [-117.1432, 33.95743]]], [[[-117.1305, 33.94664], [-117.13047, 33.94772], [-117.13012, 33.9479], [-117.12995, 33.94802], [-117.12979, 33.94815], [-117.12972, 33.94824], [-117.12869, 33.94896], [-117.12847, 33.94907], [-117.12833, 33.94917], [-117.12809, 33.94938], [-117.12768, 33.94966], [-117.12741, 33.94968], [-117.12719, 33.94975], [-117.12707, 33.94982], [-117.12696, 33.94991], [-117.12684, 33.95008], [-117.12661, 33.95014], [-117.12514, 33.95035], [-117.12433, 33.95038], [-117.12414, 33.94668], [-117.1305, 33.94664]]], [[[-117.12668, 33.95037], [-117.1266, 33.95043], [-117.12646, 33.95047], [-117.12624, 33.95049], [-117.12599, 33.95047], [-117.12668, 33.95037]]]]} | Open Access 1 | 25442 | Riverside Clark | 14801 | 2179 | Western Riverside County Regional Conservation Authority 957 | Special District 4 | Open Space District 6 | http://www.wrc-rca.org/ | Special District 4 | 2179 | Western Riverside County Regional Conservation Authority 927 | Special District 4 | Open Space District 6 | Riverside 10 | 724.53 | Riverside Clark | None 1066 |
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]);