units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
8 rows where DES_TP = 54 and UNIT_NAME = "Santa Monica Mountains National Recreation Area"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16976 | 16976 | 16975 | {"type": "MultiPolygon", "coordinates": [[[[-118.65225, 34.0711], [-118.65226, 34.07125], [-118.65231, 34.0714], [-118.65249, 34.07175], [-118.65253, 34.07189], [-118.65254, 34.07204], [-118.65249, 34.07225], [-118.65236, 34.07244], [-118.65218, 34.07259], [-118.65163, 34.07282], [-118.65151, 34.07289], [-118.65142, 34.07298], [-118.65135, 34.07309], [-118.6513, 34.07327], [-118.65132, 34.07344], [-118.6514, 34.07361], [-118.65181, 34.074], [-118.65194, 34.07421], [-118.65209, 34.07457], [-118.6521, 34.07471], [-118.65207, 34.0748], [-118.65102, 34.0748], [-118.65078, 34.07472], [-118.64998, 34.07457], [-118.64993, 34.0711], [-118.65225, 34.0711]]], [[[-118.65033, 34.0748], [-118.64998, 34.07481], [-118.64998, 34.07474], [-118.64998, 34.07474], [-118.65033, 34.0748]]], [[[-118.65437, 34.07479], [-118.65228, 34.0748], [-118.6523, 34.07469], [-118.65228, 34.07452], [-118.6521, 34.07408], [-118.65195, 34.07388], [-118.65159, 34.07355], [-118.65153, 34.07346], [-118.6515, 34.07336], [-118.6515, 34.07326], [-118.65153, 34.07316], [-118.65158, 34.07307], [-118.65172, 34.07297], [-118.65211, 34.07282], [-118.65235, 34.07269], [-118.65254, 34.07252], [-118.65267, 34.07231], [-118.65273, 34.07208], [-118.65273, 34.07185], [-118.65268, 34.07169], [-118.65249, 34.07135], [-118.65246, 34.07122], [-118.65245, 34.0711], [-118.65434, 34.0711], [-118.65437, 34.07479]]], [[[-118.67145, 34.04751], [-118.66507, 34.04751], [-118.66312, 34.0475], [-118.66404, 34.0463], [-118.67144, 34.04627], [-118.67145, 34.04751]]], [[[-118.69063, 34.07447], [-118.68991, 34.07513], [-118.68976, 34.07506], [-118.6896, 34.07504], [-118.68949, 34.07507], [-118.68927, 34.07517], [-118.6892, 34.07518], [-118.6891, 34.07517], [-118.68854, 34.0749], [-118.68838, 34.07485], [-118.6882, 34.07486], [-118.68809, 34.07491], [-118.68789, 34.07503], [-118.68781, 34.07505], [-118.68774, 34.07504], [-118.68685, 34.07452], [-118.68675, 34.07449], [-118.68659, 34.07447], [-118.69063, 34.07447]]], [[[-118.68956, 34.07552], [-118.68909, 34.07535], [-118.68909, 34.07535], [-118.6892, 34.07536], [-118.68931, 34.07534], [-118.6896, 34.07522], [-118.6897, 34.07523], [-118.68978, 34.07527], [-118.68982, 34.07532], [-118.68983, 34.07537], [-118.68982, 34.07542], [-118.6898, 34.07547], [-118.68969, 34.07553], [-118.68956, 34.07552]]], [[[-118.8886, 34.10378], [-118.8874, 34.10378], [-118.8874, 34.10196], [-118.88855, 34.10196], [-118.8886, 34.10217], [-118.88879, 34.10254], [-118.88884, 34.10276], [-118.88881, 34.10297], [-118.8886, 34.10342], [-118.88857, 34.10352], [-118.88856, 34.10363], [-118.8886, 34.10378]]], [[[-118.8896, 34.10379], [-118.88883, 34.10379], [-118.88878, 34.10371], [-118.88876, 34.10362], [-118.88877, 34.10352], [-118.88899, 34.10302], [-118.88903, 34.10279], [-118.889, 34.10255], [-118.88894, 34.10241], [-118.88878, 34.10212], [-118.88874, 34.10196], [-118.88959, 34.10196], [-118.8896, 34.10379]]]]} | Open Access 1 | 12629 | Santa Monica Mountains National Recreation Area | 25123 | 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.nps.gov/samo/index.htm | Los Angeles 6 | 76.823 | Santa Monica Mtns. NRA | 0 | National Recreation Area 54 | 3 |
16977 | 16977 | 16976 | {"type": "MultiPolygon", "coordinates": [[[[-118.84099, 34.03147], [-118.84086, 34.03173], [-118.84061, 34.03194], [-118.84025, 34.0323], [-118.83984, 34.03207], [-118.83969, 34.03215], [-118.83948, 34.03177], [-118.83948, 34.03175], [-118.84002, 34.03097], [-118.84007, 34.03095], [-118.84025, 34.03101], [-118.84091, 34.03137], [-118.84099, 34.03144], [-118.84099, 34.03147]]], [[[-118.6455, 34.0647], [-118.64521, 34.06475], [-118.64515, 34.06475], [-118.64514, 34.06482], [-118.64468, 34.06482], [-118.64408, 34.0644], [-118.64373, 34.06468], [-118.64345, 34.06439], [-118.64344, 34.0637], [-118.64549, 34.0637], [-118.6455, 34.0647]]], [[[-118.88242, 34.07511], [-118.88231, 34.07515], [-118.88199, 34.0755], [-118.88194, 34.07559], [-118.88191, 34.07512], [-118.88242, 34.07511]]], [[[-118.78593, 34.08571], [-118.78527, 34.08571], [-118.78526, 34.08543], [-118.78592, 34.08543], [-118.78593, 34.08571]]], [[[-118.8164, 34.08675], [-118.81639, 34.08698], [-118.81615, 34.08708], [-118.81592, 34.08698], [-118.81596, 34.08694], [-118.81598, 34.0866], [-118.81614, 34.08661], [-118.81627, 34.0866], [-118.8164, 34.08675]]], [[[-118.6366, 34.09173], [-118.6366, 34.09229], [-118.63533, 34.09228], [-118.63534, 34.09172], [-118.6366, 34.09173]]], [[[-118.64119, 34.09076], [-118.64116, 34.09264], [-118.63683, 34.09264], [-118.63685, 34.09076], [-118.64119, 34.09076]]], [[[-118.81072, 34.09664], [-118.80911, 34.09666], [-118.80913, 34.09612], [-118.80983, 34.09617], [-118.81071, 34.0963], [-118.81072, 34.09664]]], [[[-118.69806, 34.10871], [-118.69798, 34.10898], [-118.6979, 34.10914], [-118.69776, 34.10932], [-118.69767, 34.10935], [-118.69652, 34.1095], [-118.69623, 34.10958], [-118.69604, 34.10965], [-118.69574, 34.10983], [-118.695, 34.11048], [-118.69478, 34.11061], [-118.69437, 34.11077], [-118.69385, 34.11089], [-118.69352, 34.11092], [-118.69352, 34.11074], [-118.69419, 34.11062], [-118.69478, 34.11036], [-118.69495, 34.11024], [-118.69568, 34.10959], [-118.696, 34.10943], [-118.69628, 34.10933], [-118.69711, 34.10922], [-118.69758, 34.10915], [-118.69768, 34.10905], [-118.69776, 34.10893], [-118.69787, 34.10865], [-118.69806, 34.10871]]], [[[-118.70429, 34.11225], [-118.70429, 34.11263], [-118.70419, 34.11263], [-118.70419, 34.11222], [-118.70429, 34.11225]]], [[[-118.7045, 34.11106], [-118.70449, 34.11198], [-118.7044, 34.11181], [-118.70415, 34.1119], [-118.7041, 34.11181], [-118.7038, 34.11192], [-118.70397, 34.11214], [-118.70383, 34.11263], [-118.70234, 34.11262], [-118.70232, 34.1108], [-118.70394, 34.11081], [-118.70406, 34.11106], [-118.7045, 34.11106]], [[-118.70327, 34.11173], [-118.70327, 34.11172], [-118.70304, 34.11146], [-118.70296, 34.11148], [-118.70296, 34.1115], [-118.70308, 34.11163], [-118.70287, 34.11176], [-118.70289, 34.11196], [-118.7029, 34.11196], [-118.70327, 34.11173]], [[-118.70346, 34.11131], [-118.70343, 34.11129], [-118.70313, 34.11142], [-118.70336, 34.11168], [-118.70361, 34.11153], [-118.70357, 34.11144], [-118.70346, 34.11131]], [[-118.70377, 34.11112], [-118.70378, 34.1111], [-118.70374, 34.11104], [-118.70335, 34.11118], [-118.7034, 34.11124], [-118.70377, 34.11112]]], [[[-118.63479, 34.12505], [-118.63468, 34.12534], [-118.63451, 34.12535], [-118.63435, 34.12547], [-118.63414, 34.12555], [-118.63391, 34.12558], [-118.63343, 34.12556], [-118.63244, 34.1257], [-118.63244, 34.12536], [-118.63308, 34.12535], [-118.63308, 34.12466], [-118.63318, 34.12472], [-118.6333, 34.12476], [-118.6334, 34.12477], [-118.63361, 34.12474], [-118.63373, 34.12474], [-118.63449, 34.12491], [-118.63461, 34.12495], [-118.63479, 34.12505]]]]} | Open Access 1 | 3390 | Santa Monica Mountains National Recreation Area | 6093 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://www.nps.gov/samo/index.htm | Los Angeles 6 | 47.755 | Santa Monica Mtns. NRA | 0 | National Recreation Area 54 | 3 |
16978 | 16978 | 16977 | {"type": "MultiPolygon", "coordinates": [[[[-118.58004, 34.11729], [-118.57961, 34.11728], [-118.57962, 34.1172], [-118.57942, 34.11719], [-118.57942, 34.11703], [-118.57963, 34.11702], [-118.57964, 34.11711], [-118.57997, 34.11712], [-118.57999, 34.11721], [-118.58004, 34.11729]]], [[[-118.58026, 34.11707], [-118.57996, 34.11707], [-118.57993, 34.11699], [-118.58026, 34.11699], [-118.58026, 34.11707]]], [[[-118.59209, 34.11758], [-118.59199, 34.11758], [-118.592, 34.11732], [-118.59205, 34.11731], [-118.59209, 34.11758]]], [[[-118.59243, 34.11621], [-118.59243, 34.11664], [-118.59225, 34.11664], [-118.5922, 34.1162], [-118.59243, 34.11621]]], [[[-118.60509, 34.13834], [-118.60509, 34.1393], [-118.60406, 34.13931], [-118.60406, 34.13835], [-118.60509, 34.13834]]]]} | Open Access 1 | 12672 | Santa Monica Mountains National Recreation Area | 32641 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.nps.gov/samo/index.htm | Los Angeles 6 | 3.089 | Santa Monica Mtns. NRA | 0 | National Recreation Area 54 | 3 |
16988 | 16988 | 16987 | {"type": "MultiPolygon", "coordinates": [[[[-118.60622, 34.13649], [-118.6062, 34.14086], [-118.60603, 34.14081], [-118.60602, 34.14045], [-118.60406, 34.14047], [-118.60406, 34.13931], [-118.60508, 34.1393], [-118.60509, 34.13835], [-118.60406, 34.13835], [-118.60407, 34.13649], [-118.60622, 34.13649]]], [[[-118.60615, 34.14108], [-118.60605, 34.14107], [-118.60596, 34.14103], [-118.60596, 34.14103], [-118.60615, 34.14108]]], [[[-118.71152, 34.10937], [-118.70916, 34.10902], [-118.7077, 34.11069], [-118.70769, 34.11083], [-118.70668, 34.11082], [-118.70667, 34.10715], [-118.71106, 34.10717], [-118.71101, 34.10405], [-118.7114, 34.10383], [-118.71148, 34.10394], [-118.71167, 34.10448], [-118.71179, 34.10496], [-118.71183, 34.10529], [-118.7118, 34.10569], [-118.71168, 34.10609], [-118.71152, 34.10646], [-118.71139, 34.10693], [-118.71135, 34.10727], [-118.7114, 34.10757], [-118.71151, 34.10801], [-118.71163, 34.10829], [-118.71169, 34.10888], [-118.71152, 34.10937]]]]} | Open Access 1 | 3237 | Santa Monica Mountains National Recreation Area | 25122 | 1040 | Calabasas, City of 313 | City 2 | City Agency 2 | http://www.cityofcalabasas.com/recreation.html | City 2 | 1040 | Calabasas, City of 310 | City 2 | City Agency 2 | http://www.nps.gov/samo/index.htm | Los Angeles 6 | 56.022 | Santa Monica Mtns. NRA | 0 | National Recreation Area 54 | 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]);