units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 4, DES_TP = 80 and MNG_AG_LEV = 3
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
DES_TP 1
- National Monument or Landmark · 1 ✖
ACCESS_TYP 1
- Unknown 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15772 | 15772 | 15771 | {"type": "Polygon", "coordinates": [[[-121.75829, 36.65049], [-121.75826, 36.65096], [-121.75819, 36.65109], [-121.75816, 36.6512], [-121.75807, 36.65183], [-121.75806, 36.65201], [-121.75811, 36.65229], [-121.75831, 36.65285], [-121.75843, 36.65362], [-121.75848, 36.65401], [-121.75847, 36.65412], [-121.75819, 36.65486], [-121.75817, 36.65494], [-121.7579, 36.65558], [-121.75703, 36.65555], [-121.7571, 36.65542], [-121.75709, 36.6554], [-121.75624, 36.65543], [-121.74772, 36.65543], [-121.74657, 36.6554], [-121.74183, 36.65517], [-121.74167, 36.65507], [-121.74157, 36.65493], [-121.74153, 36.6547], [-121.74153, 36.65457], [-121.74156, 36.65448], [-121.74185, 36.65405], [-121.74188, 36.65398], [-121.74188, 36.65391], [-121.74182, 36.6538], [-121.74175, 36.65374], [-121.7415, 36.65361], [-121.74136, 36.65358], [-121.7414, 36.65302], [-121.74138, 36.65188], [-121.7413, 36.6513], [-121.74126, 36.65109], [-121.7412, 36.65089], [-121.74076, 36.651], [-121.73974, 36.65121], [-121.73931, 36.65132], [-121.73901, 36.65136], [-121.7388, 36.65134], [-121.73865, 36.65131], [-121.73791, 36.65105], [-121.73768, 36.65101], [-121.73745, 36.651], [-121.73629, 36.64792], [-121.73691, 36.64783], [-121.73739, 36.64771], [-121.73761, 36.64764], [-121.73829, 36.64735], [-121.73875, 36.64718], [-121.73943, 36.64698], [-121.73976, 36.64691], [-121.73998, 36.64689], [-121.74017, 36.6469], [-121.74104, 36.64702], [-121.74115, 36.64706], [-121.74168, 36.64713], [-121.74321, 36.64687], [-121.74484, 36.64683], [-121.74556, 36.64678], [-121.74671, 36.6468], [-121.74781, 36.64724], [-121.74861, 36.64695], [-121.74939, 36.64676], [-121.75021, 36.64666], [-121.75056, 36.64656], [-121.75106, 36.64636], [-121.75164, 36.64623], [-121.75172, 36.6462], [-121.75216, 36.64585], [-121.75221, 36.64584], [-121.75256, 36.64579], [-121.75285, 36.6457], [-121.75302, 36.64571], [-121.75319, 36.64569], [-121.75354, 36.64548], [-121.754, 36.64537], [-121.75433, 36.64539], [-121.75485, 36.64523], [-121.75516, 36.64547], [-121.75558, 36.64614], [-121.75605, 36.6466], [-121.7564, 36.64714], [-121.75641, 36.64714], [-121.75651, 36.64702], [-121.75654, 36.64705], [-121.75668, 36.64717], [-121.75683, 36.64733], [-121.75708, 36.64767], [-121.75727, 36.64819], [-121.75747, 36.64839], [-121.75753, 36.64849], [-121.75766, 36.64884], [-121.75789, 36.64906], [-121.75795, 36.64914], [-121.75795, 36.64921], [-121.75785, 36.64936], [-121.75786, 36.64948], [-121.75811, 36.64986], [-121.75814, 36.64996], [-121.75815, 36.6501], [-121.75825, 36.65034], [-121.75826, 36.65042], [-121.75829, 36.65049]]]} | Unknown Access 4 | 15914 | Fort Ord National Monument | 19009 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | Monterey 14 | 401.403 | Fort Ord NM | 2012 | National Monument or Landmark 80 | 3 |
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]);