units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where ACCESS_TYP = 2, AGNCY_ID = 104 and AGNCY_TYP = 1
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2309 | 2309 | 2308 | {"type": "Polygon", "coordinates": [[[-121.93508, 36.63686], [-121.9352, 36.63631], [-121.93434, 36.63622], [-121.93403, 36.63597], [-121.93388, 36.63682], [-121.93373, 36.6367], [-121.93358, 36.63661], [-121.93345, 36.63655], [-121.93323, 36.63651], [-121.93265, 36.63645], [-121.93242, 36.63646], [-121.93198, 36.63652], [-121.93186, 36.63652], [-121.93169, 36.63648], [-121.93134, 36.63634], [-121.93112, 36.63628], [-121.93293, 36.63126], [-121.93296, 36.63122], [-121.93303, 36.63118], [-121.93313, 36.63118], [-121.93652, 36.63197], [-121.93658, 36.63201], [-121.93667, 36.63215], [-121.93684, 36.63233], [-121.93807, 36.63346], [-121.93815, 36.63355], [-121.9382, 36.63364], [-121.93822, 36.63377], [-121.93822, 36.63386], [-121.9382, 36.63394], [-121.93815, 36.63403], [-121.93806, 36.63412], [-121.93782, 36.63431], [-121.93772, 36.63442], [-121.93748, 36.63485], [-121.93724, 36.63514], [-121.93701, 36.63548], [-121.93691, 36.63556], [-121.93657, 36.63575], [-121.93643, 36.63587], [-121.93631, 36.63603], [-121.93599, 36.63655], [-121.93587, 36.63669], [-121.93578, 36.63676], [-121.93565, 36.63681], [-121.93508, 36.63686]]]} | Restricted Access 2 | 18342 | Pacific Grove Golf Links / Lighthouse Reservation | 33065 | 104 | United States Coast Guard 511 | Federal 1 | Federal Agency 1 | http://www.uscg.mil/ | Other Federal 13 | 104 | United States Coast Guard 503 | Federal 1 | Federal Agency 1 | Monterey 14 | 63.831 | Pacific Grove Golf Links / Lighthouse Reservation | None 192 | |||
| 4135 | 4135 | 4134 | {"type": "Polygon", "coordinates": [[[-122.52305, 38.05524], [-122.52194, 38.05549], [-122.52181, 38.05532], [-122.52157, 38.05523], [-122.52156, 38.0552], [-122.52157, 38.05504], [-122.52156, 38.05494], [-122.52152, 38.05472], [-122.52145, 38.05448], [-122.52158, 38.05436], [-122.52177, 38.05425], [-122.52233, 38.05409], [-122.52305, 38.05524]]]} | Restricted Access 2 | 47183 | United States Coast Guard Park | 30875 | 104 | United States Coast Guard 511 | Federal 1 | Federal Agency 1 | http://www.uscg.mil/ | Other Federal 13 | 104 | United States Coast Guard 503 | Federal 1 | Federal Agency 1 | Marin 23 | 3.383 | United States Coast Guard Park | 0 | Recreation Management Area 49 | 4 | |
| 6977 | 6977 | 6976 | {"type": "Polygon", "coordinates": [[[-118.41157, 33.74115], [-118.41151, 33.74127], [-118.41156, 33.74174], [-118.41107, 33.74267], [-118.411, 33.74311], [-118.41042, 33.74286], [-118.40949, 33.74479], [-118.40945, 33.74479], [-118.40949, 33.74466], [-118.40952, 33.74448], [-118.40953, 33.74416], [-118.40949, 33.74392], [-118.40945, 33.74375], [-118.40938, 33.74359], [-118.40928, 33.74339], [-118.40898, 33.74301], [-118.4087, 33.74277], [-118.40857, 33.74268], [-118.40821, 33.74249], [-118.40792, 33.74239], [-118.40764, 33.7423], [-118.40706, 33.74218], [-118.40653, 33.74213], [-118.40563, 33.74215], [-118.4052, 33.74214], [-118.4052, 33.74212], [-118.40655, 33.74204], [-118.40774, 33.74166], [-118.40774, 33.74164], [-118.40704, 33.74132], [-118.40726, 33.74131], [-118.40832, 33.74109], [-118.40952, 33.74099], [-118.41079, 33.74097], [-118.41157, 33.74115]]]} | Restricted Access 2 | 5900 | Point Vicente Lighthouse | 23867 | 104 | United States Coast Guard 511 | Federal 1 | Federal Agency 1 | http://www.uscg.mil/ | Other Federal 13 | 104 | United States Coast Guard 503 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 20.729 | Point Vicente Lighthouse | None 570 |
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]);