units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where AGNCY_NAME = 594 and DES_TP = 80
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16991 | 16991 | 16990 | {"type": "MultiPolygon", "coordinates": [[[[-116.47773, 33.74318], [-116.47769, 33.75611], [-116.47746, 33.75617], [-116.47731, 33.75678], [-116.47668, 33.75743], [-116.47654, 33.75765], [-116.47769, 33.75766], [-116.47768, 33.75939], [-116.47499, 33.76165], [-116.47293, 33.76164], [-116.47262, 33.76235], [-116.47263, 33.76253], [-116.47266, 33.76263], [-116.47272, 33.76274], [-116.47272, 33.76285], [-116.47266, 33.76298], [-116.47254, 33.76307], [-116.47245, 33.7631], [-116.47232, 33.7631], [-116.47218, 33.76307], [-116.47209, 33.763], [-116.472, 33.76286], [-116.47192, 33.76235], [-116.47188, 33.76229], [-116.4718, 33.76222], [-116.47171, 33.76219], [-116.47163, 33.76219], [-116.47152, 33.76223], [-116.47143, 33.76232], [-116.47142, 33.76245], [-116.47148, 33.76254], [-116.47173, 33.76276], [-116.47175, 33.76281], [-116.47175, 33.7629], [-116.47172, 33.76297], [-116.47137, 33.76323], [-116.47064, 33.76344], [-116.47038, 33.76402], [-116.47033, 33.76408], [-116.47025, 33.7641], [-116.47016, 33.76405], [-116.47005, 33.76374], [-116.47, 33.7637], [-116.46995, 33.76369], [-116.46987, 33.76372], [-116.46932, 33.7644], [-116.46774, 33.76437], [-116.46748, 33.76383], [-116.46741, 33.76379], [-116.46732, 33.76376], [-116.46718, 33.76377], [-116.46707, 33.76382], [-116.46703, 33.76388], [-116.46677, 33.76472], [-116.46677, 33.76481], [-116.46682, 33.7649], [-116.46692, 33.76498], [-116.46701, 33.76501], [-116.46797, 33.76511], [-116.46806, 33.76509], [-116.4682, 33.76502], [-116.46837, 33.76486], [-116.46847, 33.76481], [-116.46853, 33.76479], [-116.46869, 33.76479], [-116.46883, 33.76485], [-116.46888, 33.76488], [-116.46895, 33.76498], [-116.46893, 33.76543], [-116.46872, 33.76557], [-116.46837, 33.76548], [-116.46823, 33.76548], [-116.4681, 33.76555], [-116.46804, 33.76564], [-116.46804, 33.76572], [-116.46806, 33.76577], [-116.46815, 33.76585], [-116.46823, 33.76588], [-116.46858, 33.76587], [-116.46868, 33.76588], [-116.46877, 33.76595], [-116.46879, 33.76606], [-116.46873, 33.76615], [-116.46864, 33.76619], [-116.46818, 33.76616], [-116.4679, 33.76644], [-116.46781, 33.76647], [-116.46771, 33.76647], [-116.46758, 33.76642], [-116.46751, 33.76633], [-116.4675, 33.76604], [-116.46748, 33.766], [-116.46743, 33.76594], [-116.46733, 33.7659], [-116.46722, 33.7659], [-116.46714, 33.76592], [-116.46707, 33.76598], [-116.46705, 33.76602], [-116.46692, 33.76643], [-116.46745, 33.7669], [-116.46725, 33.76737], [-116.46729, 33.7679], [-116.46688, 33.76798], [-116.46673, 33.76805], [-116.46668, 33.76811], [-116.46663, 33.7682], [-116.46663, 33.76833], [-116.46668, 33.76842], [-116.46678, 33.76852], [-116.46585, 33.7691], [-116.46571, 33.76915], [-116.46562, 33.76915], [-116.46546, 33.76909], [-116.46538, 33.76901], [-116.46512, 33.76855], [-116.46482, 33.76838], [-116.46406, 33.76692], [-116.46401, 33.76687], [-116.46389, 33.76682], [-116.46381, 33.76682], [-116.46372, 33.76685], [-116.46365, 33.7669], [-116.46361, 33.76696], [-116.46324, 33.76793], [-116.46324, 33.76811], [-116.46333, 33.76831], [-116.4634, 33.76838], [-116.46349, 33.76846], [-116.4637, 33.76856], [-116.46028, 33.76854], [-116.46029, 33.76782], [-116.46185, 33.76782], [-116.46227, 33.76738], [-116.4624, 33.76697], [-116.46243, 33.76691], [-116.46253, 33.76683], [-116.46266, 33.76679], [-116.46337, 33.76674], [-116.46352, 33.76668], [-116.46365, 33.76659], [-116.4637, 33.76652], [-116.46375, 33.76642], [-116.46385, 33.76592], [-116.46426, 33.76558], [-116.46447, 33.76492], [-116.46455, 33.76473], [-116.46469, 33.76464], [-116.46482, 33.7645], [-116.46487, 33.76438], [-116.4649, 33.76428], [-116.46487, 33.76369], [-116.46455, 33.7631], [-116.46376, 33.76273], [-116.46365, 33.76266], [-116.46356, 33.76252], [-116.46354, 33.76246], [-116.46354, 33.7623], [-116.46359, 33.76218], [-116.4638, 33.76188], [-116.46381, 33.76175], [-116.46379, 33.76169], [-116.46373, 33.76162], [-116.46363, 33.76156], [-116.46337, 33.76151], [-116.46325, 33.76146], [-116.46319, 33.76141], [-116.4631, 33.76131], [-116.46305, 33.76118], [-116.46305, 33.76104], [-116.46332, 33.75978], [-116.46336, 33.75967], [-116.46343, 33.75956], [-116.46356, 33.75941], [-116.46407, 33.75905], [-116.46414, 33.75892], [-116.46414, 33.75883], [-116.4641, 33.75873], [-116.46371, 33.75833], [-116.46366, 33.75826], [-116.46361, 33.75811], [-116.46362, 33.75789], [-116.46338, 33.75766], [-116.46034, 33.75767], [-116.46032, 33.74316], [-116.46034, 33.74322], [-116.47772, 33.74322], [-116.47773, 33.74318]], [[-116.46548, 33.7667], [-116.46549, 33.76669], [-116.46545, 33.76493], [-116.46459, 33.76492], [-116.4646, 33.7667], [-116.46548, 33.7667]], [[-116.47653, 33.75767], [-116.47652, 33.75766], [-116.47486, 33.75766], [-116.47484, 33.7578], [-116.47532, 33.75803], [-116.47556, 33.75828], [-116.47556, 33.75855], [-116.47521, 33.75965], [-116.47555, 33.76053], [-116.47559, 33.76059], [-116.47565, 33.76062], [-116.47571, 33.76063], [-116.47578, 33.76061], [-116.47583, 33.76058], [-116.47586, 33.76053], [-116.47611, 33.75981], [-116.47607, 33.75932], [-116.4761, 33.75914], [-116.47618, 33.75897], [-116.47635, 33.75877], [-116.47638, 33.75864], [-116.47637, 33.75857], [-116.47634, 33.75851], [-116.47622, 33.75841], [-116.47609, 33.75837], [-116.47588, 33.75837], [-116.47576, 33.75831], [-116.4757, 33.75822], [-116.47571, 33.75813], [-116.47576, 33.75805], [-116.47587, 33.75799], [-116.47597, 33.75798], [-116.47615, 33.75802], [-116.47624, 33.75801], [-116.47631, 33.75799], [-116.4764, 33.75791], [-116.47653, 33.75767]]], [[[-116.46033, 33.75769], [-116.46031, 33.76137], [-116.45967, 33.76136], [-116.4594, 33.76151], [-116.45945, 33.76134], [-116.45948, 33.76129], [-116.45955, 33.76122], [-116.45982, 33.761], [-116.45986, 33.76095], [-116.45992, 33.76086], [-116.45993, 33.76074], [-116.45992, 33.76069], [-116.45979, 33.76047], [-116.45977, 33.76041], [-116.45978, 33.76023], [-116.45974, 33.76016], [-116.45972, 33.76014], [-116.45972, 33.75968], [-116.45907, 33.75968], [-116.45906, 33.7602], [-116.45964, 33.76022], [-116.45969, 33.76028], [-116.45969, 33.76042], [-116.45983, 33.76071], [-116.45983, 33.76084], [-116.45978, 33.76094], [-116.45973, 33.76099], [-116.45947, 33.76119], [-116.45941, 33.76126], [-116.45937, 33.76132], [-116.45929, 33.76157], [-116.45881, 33.76183], [-116.45805, 33.76228], [-116.45689, 33.76305], [-116.45646, 33.76411], [-116.45621, 33.76429], [-116.45592, 33.76487], [-116.45604, 33.76523], [-116.45589, 33.76574], [-116.45529, 33.76574], [-116.45361, 33.76668], [-116.45361, 33.76744], [-116.45385, 33.76757], [-116.45466, 33.7681], [-116.45591, 33.76952], [-116.45478, 33.7695], [-116.45458, 33.76948], [-116.4531, 33.76921], [-116.45292, 33.76921], [-116.45271, 33.76925], [-116.45157, 33.76905], [-116.45132, 33.76962], [-116.45093, 33.7698], [-116.4505, 33.77022], [-116.44985, 33.77058], [-116.44902, 33.77053], [-116.44885, 33.77129], [-116.44869, 33.77131], [-116.44856, 33.77134], [-116.44841, 33.7714], [-116.44826, 33.77149], [-116.44818, 33.77156], [-116.44807, 33.77168], [-116.44797, 33.77185], [-116.44787, 33.77198], [-116.44771, 33.77211], [-116.44777, 33.77202], [-116.4478, 33.77194], [-116.44781, 33.77158], [-116.44788, 33.77142], [-116.448, 33.77129], [-116.44804, 33.77126], [-116.4482, 33.77118], [-116.44832, 33.77115], [-116.44835, 33.77105], [-116.44692, 33.77066], [-116.44646, 33.76922], [-116.44629, 33.76878], [-116.44707, 33.76846], [-116.44718, 33.76852], [-116.44756, 33.76911], [-116.44915, 33.76842], [-116.44875, 33.76773], [-116.44911, 33.76757], [-116.45082, 33.76739], [-116.45078, 33.76707], [-116.45081, 33.76703], [-116.45074, 33.76686], [-116.45069, 33.76649], [-116.45022, 33.7662], [-116.4484, 33.76641], [-116.44751, 33.76619], [-116.44673, 33.76652], [-116.44637, 33.76594], [-116.44632, 33.76583], [-116.44628, 33.76568], [-116.44625, 33.76547], [-116.44625, 33.76525], [-116.44628, 33.76505], [-116.44624, 33.76501], [-116.44852, 33.76405], [-116.4499, 33.7623], [-116.44989, 33.76216], [-116.44977, 33.76144], [-116.44927, 33.76055], [-116.44859, 33.75994], [-116.44718, 33.76017], [-116.44713, 33.76006], [-116.44631, 33.7602], [-116.4458, 33.75985], [-116.44525, 33.75965], [-116.44501, 33.75957], [-116.44467, 33.75969], [-116.44419, 33.75944], [-116.44414, 33.7594], [-116.44404, 33.75928], [-116.44372, 33.75859], [-116.44293, 33.75858], [-116.44293, 33.75769], [-116.46033, 33.75769]], [[-116.45332, 33.769], [-116.4543, 33.76917], [-116.45443, 33.76864], [-116.4532, 33.76842], [-116.45332, 33.769]]], [[[-116.46027, 33.77149], [-116.46026, 33.77245], [-116.45811, 33.77254], [-116.4581, 33.77241], [-116.44763, 33.77245], [-116.44755, 33.77239], [-116.44757, 33.77232], [-116.44784, 33.77218], [-116.448, 33.77204], [-116.44806, 33.77198], [-116.44819, 33.77176], [-116.44835, 33.77159], [-116.44843, 33.77153], [-116.44861, 33.77145], [-116.44883, 33.77141], [-116.44913, 33.77143], [-116.44955, 33.77156], [-116.44975, 33.7716], [-116.44996, 33.77159], [-116.45011, 33.77157], [-116.45037, 33.77146], [-116.4505, 33.77137], [-116.45065, 33.77122], [-116.451, 33.77072], [-116.45114, 33.77055], [-116.45147, 33.77021], [-116.45172, 33.77], [-116.45261, 33.76941], [-116.45275, 33.76936], [-116.453, 33.76932], [-116.45318, 33.76934], [-116.45456, 33.76959], [-116.45485, 33.76962], [-116.45602, 33.76963], [-116.45635, 33.76959], [-116.45661, 33.7695], [-116.45698, 33.76978], [-116.45704, 33.77035], [-116.45764, 33.77136], [-116.45769, 33.7719], [-116.45777, 33.77201], [-116.45841, 33.77207], [-116.45873, 33.7718], [-116.4597, 33.77182], [-116.46027, 33.77149]]]]} | Open Access 1 | 11569 | Santa Rosa and San Jacinto Mountains National Monument | 8932 | 1264 | Rancho Mirage, City of 594 | City 2 | City Agency 2 | http://www.ranchomirageca.gov/residents/parks-trails/ | City 2 | 1264 | Rancho Mirage, City of 584 | City 2 | City Agency 2 | Riverside 10 | 1207.988 | Santa Rosa and San Jacinto Mtns. NM | 2000 | 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]);