units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, MNG_AG_TYP = 1 and SUID_NMA = 14261
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5410 | 5410 | 5409 | {"type": "MultiPolygon", "coordinates": [[[[-118.75087, 34.11885], [-118.75058, 34.11902], [-118.75051, 34.11908], [-118.75064, 34.11891], [-118.75074, 34.11886], [-118.75087, 34.11885]]], [[[-118.75359, 34.11659], [-118.75356, 34.11674], [-118.75349, 34.11691], [-118.75315, 34.11733], [-118.75306, 34.11741], [-118.75104, 34.11872], [-118.75072, 34.11875], [-118.75057, 34.11882], [-118.75049, 34.11889], [-118.75042, 34.11899], [-118.75027, 34.11924], [-118.75018, 34.11951], [-118.75035, 34.11811], [-118.74568, 34.11811], [-118.74573, 34.11065], [-118.74682, 34.11178], [-118.74705, 34.11195], [-118.7472, 34.1121], [-118.74751, 34.11234], [-118.74786, 34.11255], [-118.74806, 34.11265], [-118.74807, 34.11269], [-118.74931, 34.1132], [-118.74967, 34.1133], [-118.74997, 34.11334], [-118.75015, 34.11335], [-118.75044, 34.11334], [-118.751, 34.11325], [-118.75107, 34.11329], [-118.75119, 34.11388], [-118.75132, 34.11416], [-118.75141, 34.1143], [-118.75153, 34.11444], [-118.75174, 34.11462], [-118.75194, 34.11474], [-118.75272, 34.11516], [-118.75287, 34.11526], [-118.75301, 34.1154], [-118.75311, 34.11554], [-118.75319, 34.1157], [-118.75341, 34.11594], [-118.7535, 34.11609], [-118.75357, 34.11628], [-118.75359, 34.11659]]], [[[-118.77607, 34.11785], [-118.76678, 34.11932], [-118.76728, 34.12191], [-118.76876, 34.12926], [-118.76476, 34.12769], [-118.76177, 34.12647], [-118.7553, 34.1239], [-118.7547, 34.12542], [-118.75361, 34.12614], [-118.75344, 34.1262], [-118.75226, 34.12623], [-118.75129, 34.12637], [-118.75123, 34.1264], [-118.75109, 34.12625], [-118.75073, 34.12605], [-118.75065, 34.12435], [-118.75064, 34.12412], [-118.75066, 34.12391], [-118.75072, 34.1236], [-118.75078, 34.1234], [-118.7509, 34.12311], [-118.75116, 34.12269], [-118.75163, 34.12209], [-118.75163, 34.12207], [-118.75109, 34.12236], [-118.75089, 34.12262], [-118.75074, 34.12287], [-118.75063, 34.12308], [-118.75049, 34.12346], [-118.75039, 34.12397], [-118.75038, 34.12425], [-118.75045, 34.1259], [-118.7503, 34.12579], [-118.75011, 34.12558], [-118.75003, 34.12553], [-118.74997, 34.12547], [-118.74964, 34.12502], [-118.74958, 34.12489], [-118.74954, 34.12475], [-118.74954, 34.12464], [-118.74958, 34.1244], [-118.74962, 34.12424], [-118.74979, 34.12383], [-118.74986, 34.12354], [-118.75005, 34.12158], [-118.7503, 34.11964], [-118.75038, 34.11942], [-118.75053, 34.11922], [-118.75064, 34.11913], [-118.75205, 34.11825], [-118.75268, 34.11781], [-118.75281, 34.11776], [-118.7531, 34.11757], [-118.7533, 34.1174], [-118.75343, 34.11725], [-118.75362, 34.11696], [-118.75391, 34.11659], [-118.75394, 34.11651], [-118.75394, 34.11637], [-118.75391, 34.1163], [-118.75329, 34.11563], [-118.75303, 34.11515], [-118.75295, 34.11505], [-118.7528, 34.11493], [-118.75204, 34.11453], [-118.75192, 34.11445], [-118.75174, 34.1143], [-118.75162, 34.11416], [-118.7515, 34.11395], [-118.75145, 34.11383], [-118.75133, 34.11326], [-118.75134, 34.11321], [-118.75138, 34.11318], [-118.75272, 34.11295], [-118.75294, 34.11289], [-118.7532, 34.11277], [-118.75325, 34.11274], [-118.75324, 34.11272], [-118.75356, 34.11251], [-118.75449, 34.11172], [-118.75494, 34.11145], [-118.75563, 34.11112], [-118.76413, 34.11097], [-118.76663, 34.11356], [-118.77607, 34.11785]]]]} | Open Access 1 | 12705 | Paramount Ranch | 14261 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/samo/planyourvisit/paramountranch.htm | Los Angeles 6 | 753.198 | Paramount Ranch | 0 | Recreation Management Area 49 | 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]);