units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where COUNTY = 3, LAYER = 2 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9944 | 9944 | 9943 | {"type": "MultiPolygon", "coordinates": [[[[-117.76222, 33.57793], [-117.76221, 33.57794], [-117.76006, 33.57795], [-117.76026, 33.57771], [-117.76114, 33.57773], [-117.76143, 33.57793], [-117.76222, 33.57793]]], [[[-117.77259, 33.55359], [-117.77256, 33.55666], [-117.77201, 33.55663], [-117.76932, 33.56064], [-117.76878, 33.56109], [-117.76727, 33.56041], [-117.7667, 33.56206], [-117.76664, 33.56205], [-117.7666, 33.56215], [-117.7658, 33.56183], [-117.76493, 33.56185], [-117.76466, 33.56149], [-117.76455, 33.56156], [-117.76453, 33.5622], [-117.76368, 33.56271], [-117.76348, 33.56293], [-117.76318, 33.56274], [-117.76278, 33.56327], [-117.76256, 33.56377], [-117.76247, 33.56426], [-117.76112, 33.5641], [-117.76072, 33.56636], [-117.76207, 33.56653], [-117.75923, 33.56645], [-117.75918, 33.56686], [-117.76061, 33.56704], [-117.76061, 33.56707], [-117.76069, 33.56713], [-117.76069, 33.56718], [-117.76067, 33.56722], [-117.76039, 33.56743], [-117.76027, 33.56759], [-117.76019, 33.56759], [-117.76035, 33.56791], [-117.76016, 33.56896], [-117.76133, 33.56911], [-117.76097, 33.56993], [-117.7611, 33.57], [-117.76118, 33.57007], [-117.7615, 33.57067], [-117.76154, 33.57078], [-117.76156, 33.5709], [-117.76155, 33.57102], [-117.76141, 33.57135], [-117.7614, 33.57142], [-117.76142, 33.57148], [-117.7615, 33.57156], [-117.76215, 33.57203], [-117.76225, 33.57214], [-117.76232, 33.57226], [-117.76235, 33.57238], [-117.76235, 33.57277], [-117.76007, 33.57278], [-117.76007, 33.57432], [-117.75934, 33.57433], [-117.7592, 33.57794], [-117.7612, 33.57802], [-117.76104, 33.57874], [-117.76203, 33.57874], [-117.76191, 33.57929], [-117.7609, 33.57931], [-117.76069, 33.58024], [-117.75555, 33.5803], [-117.75557, 33.58188], [-117.74937, 33.58194], [-117.74941, 33.5563], [-117.75694, 33.55625], [-117.75696, 33.55673], [-117.75807, 33.55671], [-117.75809, 33.55692], [-117.75932, 33.55689], [-117.75975, 33.5562], [-117.76386, 33.55613], [-117.767, 33.55632], [-117.76702, 33.555], [-117.76729, 33.555], [-117.76729, 33.55468], [-117.76928, 33.55469], [-117.76931, 33.55466], [-117.76913, 33.55443], [-117.76888, 33.55429], [-117.76859, 33.55416], [-117.76841, 33.554], [-117.76854, 33.55404], [-117.76864, 33.55404], [-117.76911, 33.55386], [-117.76921, 33.5538], [-117.76934, 33.55369], [-117.76926, 33.55357], [-117.76982, 33.5536], [-117.77029, 33.55356], [-117.77069, 33.5535], [-117.77127, 33.55354], [-117.77125, 33.55326], [-117.77142, 33.55327], [-117.77259, 33.55359]], [[-117.75922, 33.57949], [-117.75919, 33.57946], [-117.7588, 33.57963], [-117.75901, 33.57998], [-117.75941, 33.57981], [-117.75922, 33.57949]], [[-117.75533, 33.57725], [-117.75514, 33.57779], [-117.75556, 33.5779], [-117.75572, 33.57773], [-117.75573, 33.57765], [-117.75563, 33.57732], [-117.75533, 33.57725]], [[-117.75784, 33.57433], [-117.75754, 33.57433], [-117.75754, 33.57464], [-117.75784, 33.57464], [-117.75784, 33.57433]], [[-117.76033, 33.55702], [-117.76033, 33.55718], [-117.7603, 33.55734], [-117.76024, 33.55749], [-117.76015, 33.55763], [-117.76026, 33.55783], [-117.76039, 33.55798], [-117.76058, 33.55808], [-117.76073, 33.55812], [-117.76088, 33.55812], [-117.76102, 33.5581], [-117.76116, 33.55805], [-117.76128, 33.55798], [-117.76138, 33.55788], [-117.76147, 33.55771], [-117.76149, 33.55753], [-117.76143, 33.55735], [-117.76131, 33.55719], [-117.76113, 33.55708], [-117.76099, 33.55704], [-117.76084, 33.55702], [-117.76033, 33.55702]]]]} | Open Access 1 | 47960 | Aliso and Wood Canyons Wilderness Park | 8041 | 1164 | Laguna Beach, City of 181 | City 2 | City Agency 2 | http://www.lagunabeachcity.net/cityhall/pw/parks.asp | City 2 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://www.ocparks.com/parks/aliso | Orange 3 | 885.097 | Aliso and Wood Canyons Wilderness Park | 0 | Local Conservation Area 4 | 2 |
| 9945 | 9945 | 9944 | {"type": "Polygon", "coordinates": [[[-117.75367, 33.87309], [-117.7534, 33.8731], [-117.75323, 33.87313], [-117.75305, 33.87321], [-117.75276, 33.87329], [-117.75249, 33.8734], [-117.7522, 33.87353], [-117.75193, 33.87367], [-117.75157, 33.87392], [-117.75115, 33.87428], [-117.75095, 33.87452], [-117.7508, 33.87474], [-117.7507, 33.87478], [-117.74982, 33.87457], [-117.75063, 33.8741], [-117.75188, 33.87343], [-117.75274, 33.87301], [-117.75361, 33.87262], [-117.75367, 33.87309]]]} | Open Access 1 | 47963 | Yorba Regional Park | 27778 | 1006 | Anaheim, City of 59 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://www.ocparks.com/parks/yorba | Orange 3 | 3.53 | Yorba RP | 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]);