units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, ACRES = "2255.223" and DES_TP = 2
This data as json, copyable, CSV (advanced)
These facets timed out: 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16321 | 16321 | 16320 | {"type": "MultiPolygon", "coordinates": [[[[-118.60322, 34.29097], [-118.60322, 34.29117], [-118.60289, 34.29117], [-118.60289, 34.29097], [-118.60322, 34.29097]]], [[[-118.62363, 34.30476], [-118.61925, 34.30478], [-118.61906, 34.30007], [-118.62344, 34.30007], [-118.62363, 34.30476]]], [[[-118.63625, 34.3355], [-118.63213, 34.33544], [-118.63227, 34.34286], [-118.6264, 34.34308], [-118.62646, 34.34651], [-118.62352, 34.34658], [-118.6233, 34.34319], [-118.62354, 34.3353], [-118.62347, 34.33179], [-118.60645, 34.332], [-118.60635, 34.32843], [-118.60631, 34.32392], [-118.60591, 34.32391], [-118.60233, 34.32393], [-118.60223, 34.32031], [-118.60626, 34.3203], [-118.60618, 34.31319], [-118.59365, 34.31321], [-118.59359, 34.30953], [-118.60192, 34.30957], [-118.60178, 34.30241], [-118.59753, 34.30234], [-118.59745, 34.2991], [-118.59818, 34.2995], [-118.59895, 34.30037], [-118.60019, 34.30079], [-118.60115, 34.30136], [-118.60115, 34.30172], [-118.60176, 34.30173], [-118.60172, 34.29885], [-118.60598, 34.29885], [-118.60594, 34.29533], [-118.59291, 34.29526], [-118.5931, 34.29467], [-118.59311, 34.29454], [-118.59299, 34.29416], [-118.59299, 34.29404], [-118.59302, 34.2938], [-118.59301, 34.29365], [-118.59294, 34.29351], [-118.59277, 34.29329], [-118.59281, 34.29327], [-118.593, 34.29325], [-118.59353, 34.2934], [-118.59398, 34.29296], [-118.59336, 34.29015], [-118.59338, 34.28933], [-118.59191, 34.28934], [-118.59196, 34.28922], [-118.5915, 34.28857], [-118.59172, 34.28814], [-118.59165, 34.28736], [-118.59203, 34.28678], [-118.59139, 34.28607], [-118.59135, 34.28578], [-118.59728, 34.28578], [-118.59729, 34.28941], [-118.6016, 34.28942], [-118.60155, 34.29301], [-118.60263, 34.29301], [-118.60265, 34.29208], [-118.60319, 34.29208], [-118.60319, 34.29301], [-118.6059, 34.293], [-118.60594, 34.28937], [-118.61018, 34.28937], [-118.6101, 34.29302], [-118.6143, 34.29304], [-118.61462, 34.30007], [-118.606, 34.30008], [-118.6061, 34.30718], [-118.61052, 34.30718], [-118.61054, 34.3107], [-118.61491, 34.31068], [-118.61492, 34.31111], [-118.61927, 34.31109], [-118.61923, 34.31361], [-118.62356, 34.31359], [-118.62372, 34.30709], [-118.62365, 34.30535], [-118.62584, 34.30535], [-118.62591, 34.3071], [-118.62808, 34.30711], [-118.62793, 34.31414], [-118.6323, 34.31415], [-118.63214, 34.32116], [-118.62777, 34.32117], [-118.62777, 34.32827], [-118.63602, 34.32832], [-118.63625, 34.3355]], [[-118.61911, 34.32477], [-118.61911, 34.3283], [-118.6234, 34.32826], [-118.62339, 34.32118], [-118.61484, 34.32129], [-118.61483, 34.32482], [-118.61911, 34.32477]], [[-118.61145, 34.31362], [-118.61114, 34.31282], [-118.61128, 34.31227], [-118.61057, 34.31214], [-118.60993, 34.31138], [-118.60903, 34.31115], [-118.60701, 34.31115], [-118.60592, 34.31207], [-118.60592, 34.31293], [-118.6062, 34.31315], [-118.60668, 34.31315], [-118.60788, 34.31248], [-118.609, 34.31303], [-118.6104, 34.31348], [-118.61051, 34.3137], [-118.61115, 34.31403], [-118.61124, 34.3142], [-118.61169, 34.31406], [-118.6115, 34.31361], [-118.61145, 34.31362]]]]} | Open Access 1 | 5332 | Michael D. Antonovich Regional Park at Joughin Ranch | 7184 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.lamountains.com/parks.asp?parkid=36 | Los Angeles 6 | 2255.223 | Michael D. Antonovich RP at Joughin Ranch | 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]);