units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, AGNCY_TYP = 6, DES_TP = 1066 and LAYER = 4
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP
ACCESS_TYP 1
- Open 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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]);