units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where GAP_STS = 2 and MNG_AGENCY = 866
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8399 | 8399 | 8398 | {"type": "MultiPolygon", "coordinates": [[[[-117.25509, 33.42391], [-117.25507, 33.42577], [-117.25286, 33.42579], [-117.25273, 33.43184], [-117.24942, 33.4319], [-117.25152, 33.43492], [-117.252, 33.43574], [-117.25059, 33.43576], [-117.24973, 33.43469], [-117.24851, 33.43454], [-117.24779, 33.43513], [-117.2476, 33.43454], [-117.24771, 33.43361], [-117.24702, 33.43192], [-117.24698, 33.43184], [-117.24686, 33.4317], [-117.24681, 33.43162], [-117.24676, 33.43134], [-117.24664, 33.43092], [-117.2459, 33.43091], [-117.2441, 33.43197], [-117.24414, 33.43116], [-117.24436, 33.43085], [-117.24534, 33.42972], [-117.24615, 33.42945], [-117.24678, 33.42915], [-117.24696, 33.42886], [-117.24702, 33.4284], [-117.24745, 33.4284], [-117.24782, 33.42813], [-117.24852, 33.42754], [-117.24812, 33.42723], [-117.24751, 33.42724], [-117.24704, 33.42665], [-117.24677, 33.42611], [-117.24752, 33.42605], [-117.24752, 33.42553], [-117.24685, 33.42478], [-117.2467, 33.42393], [-117.2455, 33.42393], [-117.24662, 33.42307], [-117.2465, 33.42189], [-117.24605, 33.4206], [-117.24457, 33.42331], [-117.24486, 33.41718], [-117.24236, 33.41935], [-117.2399, 33.41965], [-117.23991, 33.41736], [-117.23931, 33.41655], [-117.23894, 33.41655], [-117.23738, 33.41734], [-117.23721, 33.41772], [-117.2373, 33.41852], [-117.23646, 33.41851], [-117.23622, 33.4189], [-117.23614, 33.4203], [-117.236, 33.42051], [-117.23549, 33.42086], [-117.2332, 33.42063], [-117.23378, 33.41972], [-117.23407, 33.41937], [-117.23428, 33.41916], [-117.23335, 33.4184], [-117.23368, 33.41792], [-117.23382, 33.41693], [-117.23352, 33.41659], [-117.23368, 33.41658], [-117.23519, 33.41582], [-117.23477, 33.41483], [-117.23423, 33.41477], [-117.23353, 33.41511], [-117.23288, 33.4157], [-117.23222, 33.4144], [-117.23277, 33.41441], [-117.23322, 33.41397], [-117.2329, 33.41341], [-117.23326, 33.41297], [-117.23326, 33.41296], [-117.23302, 33.41296], [-117.23256, 33.41337], [-117.23179, 33.41343], [-117.23062, 33.41386], [-117.23029, 33.41339], [-117.22974, 33.41406], [-117.22768, 33.41368], [-117.22766, 33.41316], [-117.22758, 33.41343], [-117.22758, 33.41368], [-117.22527, 33.41322], [-117.22527, 33.41192], [-117.22604, 33.41159], [-117.22617, 33.4115], [-117.22629, 33.41139], [-117.22719, 33.41042], [-117.22762, 33.40973], [-117.22762, 33.40945], [-117.22444, 33.40946], [-117.22349, 33.40961], [-117.22213, 33.41032], [-117.22076, 33.41071], [-117.21932, 33.41271], [-117.21896, 33.41299], [-117.21774, 33.41308], [-117.21644, 33.41474], [-117.21702, 33.41563], [-117.21594, 33.41659], [-117.21385, 33.41852], [-117.21129, 33.41814], [-117.21055, 33.41853], [-117.21011, 33.41882], [-117.2099, 33.41899], [-117.20947, 33.41944], [-117.207, 33.42027], [-117.20594, 33.42169], [-117.20646, 33.42219], [-117.20604, 33.42298], [-117.20624, 33.42356], [-117.20525, 33.42514], [-117.20514, 33.42791], [-117.20073, 33.42797], [-117.19932, 33.42801], [-117.19721, 33.42851], [-117.19685, 33.429], [-117.19525, 33.42933], [-117.19537, 33.42845], [-117.19556, 33.42806], [-117.19593, 33.42745], [-117.19672, 33.42693], [-117.19772, 33.42653], [-117.19837, 33.42617], [-117.19885, 33.4263], [-117.19919, 33.42637], [-117.19993, 33.4263], [-117.2004, 33.42604], [-117.20153, 33.42545], [-117.20215, 33.42477], [-117.20225, 33.42481], [-117.2025, 33.42438], [-117.2025, 33.42416], [-117.20231, 33.42401], [-117.20283, 33.42333], [-117.20327, 33.42289], [-117.20342, 33.42241], [-117.20295, 33.42201], [-117.20339, 33.4218], [-117.20385, 33.42105], [-117.20471, 33.42044], [-117.20594, 33.41899], [-117.20611, 33.41841], [-117.20696, 33.41799], [-117.20765, 33.41759], [-117.20767, 33.41674], [-117.20997, 33.41674], [-117.20997, 33.41493], [-117.21132, 33.4149], [-117.21179, 33.41458], [-117.2137, 33.41181], [-117.21313, 33.411], [-117.21023, 33.41193], [-117.20983, 33.41151], [-117.20953, 33.41087], [-117.20855, 33.41062], [-117.20832, 33.41026], [-117.20857, 33.4101], [-117.21083, 33.41009], [-117.21126, 33.40946], [-117.21146, 33.40946], [-117.21206, 33.40839], [-117.21285, 33.40648], [-117.21303, 33.40595], [-117.2143, 33.40738], [-117.21505, 33.40782], [-117.21727, 33.4079], [-117.21877, 33.40592], [-117.21866, 33.40206], [-117.22354, 33.40206], [-117.22373, 33.40177], [-117.22472, 33.40101], [-117.22477, 33.40099], [-117.22477, 33.40111], [-117.22469, 33.40125], [-117.22436, 33.40193], [-117.2244, 33.40236], [-117.22463, 33.40283], [-117.22482, 33.4037], [-117.22515, 33.40437], [-117.22525, 33.40477], [-117.22524, 33.40504], [-117.22511, 33.40524], [-117.22472, 33.40539], [-117.22411, 33.40544], [-117.22362, 33.40558], [-117.22325, 33.40576], [-117.2228, 33.4061], [-117.22244, 33.40669], [-117.22072, 33.40777], [-117.22023, 33.40797], [-117.2197, 33.40804], [-117.21918, 33.40848], [-117.21885, 33.40867], [-117.21885, 33.40876], [-117.21886, 33.40876], [-117.21922, 33.40856], [-117.21972, 33.40814], [-117.22026, 33.40806], [-117.22075, 33.40785], [-117.2225, 33.40675], [-117.22286, 33.40617], [-117.22327, 33.40586], [-117.22366, 33.40567], [-117.22412, 33.40553], [-117.22477, 33.40547], [-117.22514, 33.40531], [-117.22532, 33.40508], [-117.22533, 33.40505], [-117.22533, 33.40477], [-117.22522, 33.40436], [-117.22492, 33.4037], [-117.22472, 33.40278], [-117.2245, 33.40234], [-117.22446, 33.40196], [-117.22488, 33.40108], [-117.22487, 33.40095], [-117.22492, 33.40093], [-117.22492, 33.40086], [-117.22518, 33.40065], [-117.2252, 33.40067], [-117.2258, 33.40384], [-117.22622, 33.40402], [-117.22731, 33.40361], [-117.22776, 33.40329], [-117.22772, 33.40377], [-117.22729, 33.40412], [-117.2279, 33.40412], [-117.2279, 33.40422], [-117.22751, 33.4043], [-117.22737, 33.40445], [-117.22709, 33.40521], [-117.22709, 33.40523], [-117.22744, 33.40534], [-117.22784, 33.40535], [-117.22853, 33.40476], [-117.23007, 33.40526], [-117.23064, 33.40534], [-117.23333, 33.40613], [-117.23355, 33.40699], [-117.23408, 33.40723], [-117.23414, 33.40566], [-117.2354, 33.40563], [-117.23556, 33.40492], [-117.23618, 33.40304], [-117.23813, 33.4025], [-117.2391, 33.40374], [-117.24061, 33.40553], [-117.24062, 33.40673], [-117.24143, 33.40775], [-117.24141, 33.40901], [-117.24137, 33.40924], [-117.24158, 33.40981], [-117.24256, 33.41119], [-117.24329, 33.41148], [-117.24371, 33.41134], [-117.24446, 33.41048], [-117.24467, 33.41009], [-117.24499, 33.40889], [-117.24516, 33.40741], [-117.24625, 33.40749], [-117.24633, 33.40767], [-117.24793, 33.40884], [-117.24795, 33.40995], [-117.2492, 33.40993], [-117.24916, 33.41271], [-117.25324, 33.41265], [-117.25326, 33.41662], [-117.25018, 33.41663], [-117.2501, 33.42028], [-117.2528, 33.42029], [-117.25283, 33.42212], [-117.25509, 33.42211], [-117.25509, 33.42391]], [[-117.24494, 33.4121], [-117.24494, 33.41189], [-117.24384, 33.41259], [-117.24369, 33.41273], [-117.2435, 33.41295], [-117.24313, 33.41333], [-117.24302, 33.41341], [-117.2429, 33.41348], [-117.24273, 33.41353], [-117.24257, 33.41356], [-117.24181, 33.41353], [-117.24163, 33.41356], [-117.24154, 33.4136], [-117.24143, 33.41368], [-117.24054, 33.41454], [-117.24047, 33.41457], [-117.24041, 33.41457], [-117.24035, 33.41454], [-117.23968, 33.41387], [-117.23954, 33.41362], [-117.23945, 33.41349], [-117.23935, 33.41338], [-117.23919, 33.41325], [-117.23908, 33.41312], [-117.23899, 33.41304], [-117.23876, 33.41294], [-117.23855, 33.4129], [-117.23833, 33.41293], [-117.23812, 33.41301], [-117.23796, 33.41314], [-117.23785, 33.41331], [-117.23746, 33.41479], [-117.23693, 33.4159], [-117.23676, 33.41636], [-117.23659, 33.41665], [-117.23651, 33.41672], [-117.2363, 33.41687], [-117.23615, 33.41703], [-117.23605, 33.4172], [-117.23616, 33.41726], [-117.23629, 33.41705], [-117.2364, 33.41693], [-117.2366, 33.4168], [-117.23669, 33.41672], [-117.23686, 33.41645], [-117.23693, 33.41631], [-117.23706, 33.41594], [-117.23735, 33.41533], [-117.23764, 33.41482], [-117.23805, 33.41332], [-117.23812, 33.41323], [-117.2382, 33.41316], [-117.23831, 33.41311], [-117.23842, 33.41308], [-117.23855, 33.41307], [-117.23866, 33.41308], [-117.23883, 33.41314], [-117.2389, 33.41319], [-117.23904, 33.41336], [-117.2393, 33.4136], [-117.23953, 33.41399], [-117.24102, 33.41547], [-117.24114, 33.41556], [-117.24126, 33.41562], [-117.24257, 33.41613], [-117.24277, 33.41617], [-117.24397, 33.41603], [-117.24407, 33.416], [-117.24438, 33.41586], [-117.24484, 33.41572], [-117.24496, 33.41567], [-117.24505, 33.41559], [-117.24513, 33.41551], [-117.24518, 33.41542], [-117.24524, 33.41528], [-117.24529, 33.41506], [-117.24529, 33.41497], [-117.24527, 33.41486], [-117.24522, 33.41476], [-117.24515, 33.41468], [-117.24504, 33.41462], [-117.24427, 33.41434], [-117.24413, 33.41425], [-117.24402, 33.41416], [-117.2438, 33.41391], [-117.24351, 33.41367], [-117.24334, 33.41346], [-117.24333, 33.41342], [-117.24335, 33.41337], [-117.24365, 33.41307], [-117.2438, 33.41287], [-117.24393, 33.41275], [-117.24494, 33.4121]]], [[[-117.24492, 33.41475], [-117.24499, 33.41478], [-117.24506, 33.41485], [-117.24509, 33.41492], [-117.2451, 33.41499], [-117.24506, 33.41518], [-117.245, 33.41535], [-117.24494, 33.41545], [-117.24484, 33.41552], [-117.24474, 33.41557], [-117.24428, 33.41571], [-117.24393, 33.41587], [-117.24277, 33.416], [-117.24263, 33.41598], [-117.24127, 33.41543], [-117.24117, 33.41536], [-117.24064, 33.41482], [-117.24061, 33.41475], [-117.24064, 33.41469], [-117.24158, 33.41379], [-117.24167, 33.41373], [-117.24181, 33.4137], [-117.24242, 33.41373], [-117.24262, 33.41372], [-117.24286, 33.41367], [-117.24314, 33.41356], [-117.24321, 33.41359], [-117.24336, 33.41377], [-117.24364, 33.414], [-117.24388, 33.41427], [-117.24404, 33.4144], [-117.24419, 33.41448], [-117.24492, 33.41475]]]]} | Open Access 1 | 47790 | Santa Margarita River Preserve | 31668 | 2034 | Fallbrook Public Utility District 870 | Special District 4 | Water District 13 | https://www.fpud.com/ | Special District 4 | 2034 | Fallbrook Public Utility District 866 | Special District 4 | Water District 13 | San Diego 4 | 1377.733 | Santa Margarita River Preserve | 0 | Local Conservation Area 4 | 2 |
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]);