units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, DES_TP = 1402 and MNG_AGENCY = 180
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP, DES_TP
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16436 | 16436 | 16435 | {"type": "MultiPolygon", "coordinates": [[[[-118.51739, 34.02521], [-118.51653, 34.02589], [-118.51439, 34.02481], [-118.51406, 34.02525], [-118.5134, 34.02491], [-118.51238, 34.02435], [-118.51199, 34.02412], [-118.51237, 34.0237], [-118.51161, 34.0232], [-118.5112, 34.0236], [-118.51097, 34.02344], [-118.51137, 34.02304], [-118.50904, 34.02123], [-118.50859, 34.02159], [-118.50852, 34.02154], [-118.50853, 34.0215], [-118.50769, 34.02085], [-118.50809, 34.02048], [-118.50677, 34.01947], [-118.50634, 34.01983], [-118.50632, 34.01982], [-118.50673, 34.01945], [-118.50659, 34.01933], [-118.50617, 34.0197], [-118.50581, 34.01942], [-118.50622, 34.01905], [-118.50587, 34.01877], [-118.50545, 34.01913], [-118.50524, 34.01897], [-118.50565, 34.0186], [-118.50523, 34.01825], [-118.5048, 34.01862], [-118.50458, 34.01846], [-118.50501, 34.01807], [-118.50473, 34.01785], [-118.5043, 34.01822], [-118.50403, 34.01802], [-118.50448, 34.01765], [-118.50435, 34.01754], [-118.50388, 34.01791], [-118.50193, 34.01637], [-118.50222, 34.01612], [-118.50373, 34.01741], [-118.50378, 34.01738], [-118.50123, 34.01521], [-118.50097, 34.01506], [-118.49608, 34.0106], [-118.49497, 34.00952], [-118.49503, 34.00947], [-118.49498, 34.00936], [-118.4947, 34.0091], [-118.49465, 34.00908], [-118.49457, 34.00914], [-118.49188, 34.00657], [-118.49169, 34.00641], [-118.49144, 34.00614], [-118.49146, 34.00611], [-118.49135, 34.006], [-118.49133, 34.006], [-118.48736, 34.00198], [-118.48698, 34.00157], [-118.48726, 34.0014], [-118.48792, 34.00211], [-118.48814, 34.00196], [-118.48693, 34.00069], [-118.48689, 34.0007], [-118.48681, 34.00062], [-118.48676, 34.00061], [-118.48666, 34.00053], [-118.48649, 34.00059], [-118.48639, 34.00049], [-118.48652, 34.00037], [-118.48642, 34.00027], [-118.48646, 34.00024], [-118.48635, 34.00013], [-118.48638, 34.0001], [-118.48629, 33.99999], [-118.48636, 33.99995], [-118.48622, 33.99979], [-118.48628, 33.99974], [-118.4861, 33.99955], [-118.48549, 33.99996], [-118.48409, 33.99847], [-118.48355, 33.99794], [-118.48411, 33.99757], [-118.48411, 33.99755], [-118.48402, 33.99748], [-118.48387, 33.99748], [-118.48347, 33.99773], [-118.48336, 33.99775], [-118.48265, 33.99704], [-118.48266, 33.99682], [-118.48261, 33.99671], [-118.48254, 33.99663], [-118.48245, 33.99655], [-118.48212, 33.99647], [-118.48193, 33.99627], [-118.482, 33.99621], [-118.48163, 33.99581], [-118.48214, 33.99547], [-118.48257, 33.99589], [-118.48352, 33.99534], [-118.48429, 33.99629], [-118.48542, 33.99756], [-118.48626, 33.9987], [-118.48672, 33.99921], [-118.48679, 33.99935], [-118.48711, 33.99973], [-118.48732, 33.99988], [-118.48764, 34.00019], [-118.48802, 34.00047], [-118.48827, 34.00069], [-118.48869, 34.00121], [-118.48893, 34.00156], [-118.48981, 34.00261], [-118.49033, 34.00315], [-118.49117, 34.00405], [-118.49219, 34.00526], [-118.49346, 34.00642], [-118.49466, 34.00733], [-118.49572, 34.00794], [-118.49658, 34.00837], [-118.49746, 34.00864], [-118.49796, 34.00895], [-118.49851, 34.00949], [-118.49904, 34.0098], [-118.49966, 34.00998], [-118.50024, 34.0104], [-118.501, 34.01129], [-118.50147, 34.01199], [-118.50289, 34.01419], [-118.50413, 34.01521], [-118.50517, 34.0161], [-118.50641, 34.0172], [-118.50874, 34.01906], [-118.50938, 34.01951], [-118.51008, 34.02018], [-118.51093, 34.02084], [-118.51237, 34.02183], [-118.51313, 34.02238], [-118.51402, 34.02295], [-118.51468, 34.0234], [-118.51565, 34.02398], [-118.51729, 34.02516], [-118.51739, 34.02521]]], [[[-118.49294, 34.00767], [-118.49265, 34.00791], [-118.49195, 34.00725], [-118.49225, 34.00701], [-118.49294, 34.00767]]], [[[-118.49444, 34.0091], [-118.49414, 34.00934], [-118.49379, 34.00901], [-118.49409, 34.00877], [-118.49444, 34.0091]]], [[[-118.49478, 34.00943], [-118.49449, 34.00967], [-118.49432, 34.0095], [-118.49461, 34.00926], [-118.49478, 34.00943]]], [[[-118.49544, 34.01006], [-118.49512, 34.01031], [-118.49465, 34.00986], [-118.49496, 34.0096], [-118.49544, 34.01006]]], [[[-118.49751, 34.01198], [-118.49725, 34.01217], [-118.497, 34.01196], [-118.49725, 34.01176], [-118.49751, 34.01198]]], [[[-118.49825, 34.01266], [-118.49801, 34.01286], [-118.4974, 34.01231], [-118.49766, 34.01212], [-118.49825, 34.01266]]], [[[-118.50218, 34.01609], [-118.50188, 34.01633], [-118.50134, 34.0159], [-118.50043, 34.01511], [-118.5007, 34.01489], [-118.50095, 34.01512], [-118.50119, 34.01525], [-118.50218, 34.01609]]]]} | Open Access 1 | 6337 | Santa Monica State Beach | 1737 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | http://www.smgov.net/portals/beach/ | Los Angeles 6 | 204.076 | Santa Monica SB | 1948 | None 1402 |
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]);