units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where AGNCY_NAME = 182 and DES_TP = 4
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9241 | 9241 | 9240 | {"type": "MultiPolygon", "coordinates": [[[[-117.65602, 33.64685], [-117.65577, 33.6472], [-117.65581, 33.64737], [-117.65578, 33.64761], [-117.65568, 33.64788], [-117.65527, 33.64851], [-117.65552, 33.64862], [-117.65563, 33.64846], [-117.65581, 33.6485], [-117.65582, 33.64875], [-117.65566, 33.64879], [-117.65543, 33.6489], [-117.65525, 33.64901], [-117.65514, 33.64912], [-117.65511, 33.64913], [-117.655, 33.6491], [-117.65427, 33.64871], [-117.65397, 33.64853], [-117.65385, 33.64864], [-117.65377, 33.6486], [-117.65374, 33.64861], [-117.65368, 33.64897], [-117.6536, 33.64897], [-117.65352, 33.64868], [-117.6535, 33.64863], [-117.65348, 33.64862], [-117.65344, 33.64863], [-117.65303, 33.64899], [-117.65296, 33.64893], [-117.65396, 33.64811], [-117.65438, 33.64772], [-117.6548, 33.64725], [-117.65505, 33.64691], [-117.65527, 33.64659], [-117.65534, 33.64657], [-117.65602, 33.64685]]], [[[-117.65926, 33.63996], [-117.6591, 33.64019], [-117.65911, 33.6402], [-117.659, 33.64038], [-117.65902, 33.6404], [-117.65893, 33.64059], [-117.65895, 33.6406], [-117.65886, 33.64077], [-117.65882, 33.64114], [-117.65877, 33.64134], [-117.65879, 33.64139], [-117.65884, 33.64141], [-117.65895, 33.64162], [-117.65871, 33.64171], [-117.65825, 33.64227], [-117.6586, 33.64257], [-117.65845, 33.6427], [-117.65832, 33.64286], [-117.658, 33.64342], [-117.65766, 33.64417], [-117.65752, 33.64439], [-117.65724, 33.64474], [-117.65704, 33.64529], [-117.65678, 33.64577], [-117.65652, 33.6464], [-117.65642, 33.6466], [-117.6563, 33.64678], [-117.6554, 33.64642], [-117.65537, 33.64636], [-117.65561, 33.64584], [-117.65623, 33.64443], [-117.65684, 33.64276], [-117.65686, 33.64262], [-117.657, 33.64229], [-117.65718, 33.64176], [-117.6574, 33.64125], [-117.65763, 33.64082], [-117.65795, 33.64035], [-117.65815, 33.64011], [-117.6584, 33.63983], [-117.65868, 33.63958], [-117.65875, 33.63958], [-117.65926, 33.63996]]], [[[-117.66255, 33.63664], [-117.66237, 33.63666], [-117.66223, 33.63685], [-117.66224, 33.63686], [-117.66215, 33.63702], [-117.66215, 33.63703], [-117.66203, 33.63719], [-117.66205, 33.63721], [-117.66193, 33.63736], [-117.66194, 33.63738], [-117.66182, 33.63755], [-117.66183, 33.63756], [-117.6616, 33.63787], [-117.66161, 33.63789], [-117.66151, 33.63804], [-117.66143, 33.63823], [-117.66144, 33.63825], [-117.66136, 33.63842], [-117.66138, 33.63844], [-117.66125, 33.63876], [-117.66116, 33.63892], [-117.66117, 33.63894], [-117.66078, 33.63952], [-117.66027, 33.64019], [-117.65953, 33.63993], [-117.65938, 33.63986], [-117.65876, 33.63943], [-117.65876, 33.63935], [-117.6596, 33.63853], [-117.65998, 33.63812], [-117.66067, 33.63733], [-117.66119, 33.63663], [-117.66142, 33.63625], [-117.66149, 33.63622], [-117.66186, 33.63631], [-117.66249, 33.63632], [-117.66252, 33.63637], [-117.66255, 33.63664]]], [[[-117.66643, 33.62971], [-117.66574, 33.63028], [-117.66575, 33.63037], [-117.66593, 33.63051], [-117.66584, 33.6309], [-117.66574, 33.63095], [-117.66569, 33.63106], [-117.66536, 33.63095], [-117.66491, 33.63181], [-117.66458, 33.63227], [-117.66446, 33.63238], [-117.66447, 33.6324], [-117.66433, 33.63257], [-117.66433, 33.63259], [-117.66425, 33.63279], [-117.66427, 33.63281], [-117.66418, 33.63301], [-117.66419, 33.63303], [-117.66407, 33.63319], [-117.66407, 33.63322], [-117.66408, 33.63322], [-117.66405, 33.63344], [-117.6641, 33.63369], [-117.66428, 33.63378], [-117.66386, 33.63445], [-117.66404, 33.63467], [-117.66416, 33.63475], [-117.66415, 33.63486], [-117.66421, 33.63495], [-117.66432, 33.63498], [-117.66452, 33.63502], [-117.665, 33.63521], [-117.66521, 33.63524], [-117.66523, 33.63529], [-117.66523, 33.63542], [-117.66516, 33.6356], [-117.66507, 33.63574], [-117.66505, 33.63576], [-117.66501, 33.63576], [-117.66435, 33.63546], [-117.66426, 33.63544], [-117.66405, 33.63542], [-117.66388, 33.63544], [-117.66371, 33.63549], [-117.66349, 33.63561], [-117.66294, 33.63608], [-117.66272, 33.63614], [-117.66239, 33.63617], [-117.66205, 33.63617], [-117.66181, 33.63614], [-117.66155, 33.63608], [-117.66153, 33.63601], [-117.66154, 33.63598], [-117.66206, 33.63481], [-117.66288, 33.63343], [-117.66318, 33.63287], [-117.66403, 33.63097], [-117.66433, 33.6304], [-117.66464, 33.62993], [-117.66498, 33.62953], [-117.66538, 33.62977], [-117.66575, 33.62935], [-117.66594, 33.62946], [-117.66643, 33.62971]]], [[[-117.67486, 33.62716], [-117.67396, 33.6271], [-117.67373, 33.62765], [-117.6732, 33.62749], [-117.67304, 33.62788], [-117.67241, 33.62791], [-117.67208, 33.62803], [-117.67195, 33.62805], [-117.67182, 33.62805], [-117.67171, 33.628], [-117.67126, 33.62757], [-117.67114, 33.62749], [-117.67102, 33.62745], [-117.67087, 33.62746], [-117.67077, 33.62754], [-117.67055, 33.62779], [-117.6702, 33.62805], [-117.67013, 33.62808], [-117.67013, 33.6281], [-117.67027, 33.6282], [-117.66999, 33.6284], [-117.66917, 33.62841], [-117.66887, 33.62855], [-117.66869, 33.62859], [-117.66854, 33.62857], [-117.66814, 33.6288], [-117.66787, 33.62885], [-117.66757, 33.6288], [-117.6675, 33.62897], [-117.66691, 33.62916], [-117.66646, 33.62943], [-117.66589, 33.62912], [-117.66563, 33.62896], [-117.66563, 33.62885], [-117.66586, 33.62865], [-117.66622, 33.62837], [-117.66679, 33.62801], [-117.6669, 33.62813], [-117.66721, 33.62828], [-117.66726, 33.62828], [-117.66777, 33.62805], [-117.66779, 33.62802], [-117.66787, 33.6279], [-117.66811, 33.62779], [-117.66876, 33.62779], [-117.66891, 33.62766], [-117.66904, 33.62761], [-117.66913, 33.6276], [-117.66926, 33.62763], [-117.66977, 33.62783], [-117.67001, 33.62745], [-117.67005, 33.62729], [-117.67006, 33.62712], [-117.67001, 33.62696], [-117.67017, 33.62694], [-117.67361, 33.62681], [-117.674, 33.6268], [-117.67443, 33.62682], [-117.67482, 33.62684], [-117.67491, 33.62687], [-117.67492, 33.62696], [-117.67486, 33.62716]]]]} | Open Access 1 | 15361 | Wilderness Glen Park | 27508 | 1207 | Mission Viejo, City of 182 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | Orange 3 | 90.299 | Wilderness Glen Park | 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]);