units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, DES_TP = 39, MNG_AG_TYP = 5 and UNIT_NAME = "Sepulveda Pass Open Space"
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16037 | 16037 | 16036 | {"type": "MultiPolygon", "coordinates": [[[[-118.47379, 34.11883], [-118.47326, 34.11941], [-118.47303, 34.11957], [-118.47276, 34.11975], [-118.47204, 34.12015], [-118.47168, 34.12021], [-118.47141, 34.12044], [-118.47103, 34.121], [-118.47095, 34.12157], [-118.47069, 34.12207], [-118.47006, 34.12207], [-118.46864, 34.12065], [-118.46861, 34.1202], [-118.46897, 34.11989], [-118.46913, 34.11978], [-118.46976, 34.11975], [-118.46964, 34.11889], [-118.46862, 34.11808], [-118.46955, 34.11752], [-118.46967, 34.11702], [-118.46901, 34.11611], [-118.47059, 34.11472], [-118.47023, 34.11295], [-118.47214, 34.11242], [-118.47117, 34.11334], [-118.47167, 34.11398], [-118.47124, 34.1144], [-118.47183, 34.11478], [-118.47232, 34.11719], [-118.47311, 34.1178], [-118.47357, 34.11818], [-118.47367, 34.11835], [-118.47379, 34.11883]]], [[[-118.48147, 34.11327], [-118.4814, 34.11406], [-118.48, 34.11497], [-118.48007, 34.11524], [-118.48135, 34.11636], [-118.47969, 34.11812], [-118.48042, 34.11931], [-118.47895, 34.11977], [-118.47784, 34.12046], [-118.47783, 34.12193], [-118.47832, 34.12196], [-118.47826, 34.12206], [-118.47801, 34.12212], [-118.47786, 34.12238], [-118.47774, 34.12241], [-118.47761, 34.1225], [-118.47699, 34.12316], [-118.47673, 34.12322], [-118.47615, 34.12347], [-118.47611, 34.1237], [-118.47616, 34.12406], [-118.47615, 34.12409], [-118.47576, 34.12458], [-118.47573, 34.12467], [-118.47493, 34.12552], [-118.47465, 34.12536], [-118.47439, 34.12544], [-118.4736, 34.12454], [-118.4734, 34.12404], [-118.47391, 34.1239], [-118.47416, 34.12356], [-118.47471, 34.12261], [-118.47443, 34.12237], [-118.47431, 34.12115], [-118.47389, 34.1209], [-118.474, 34.12041], [-118.47445, 34.12019], [-118.47494, 34.12016], [-118.47524, 34.12005], [-118.47551, 34.11982], [-118.47543, 34.11972], [-118.47512, 34.11941], [-118.4751, 34.11895], [-118.47527, 34.11871], [-118.47538, 34.1184], [-118.47557, 34.11818], [-118.47609, 34.11772], [-118.47623, 34.11743], [-118.47645, 34.11761], [-118.47661, 34.11756], [-118.4764, 34.11711], [-118.47637, 34.11689], [-118.47698, 34.11676], [-118.47679, 34.11616], [-118.47731, 34.11613], [-118.47841, 34.11531], [-118.47956, 34.11471], [-118.47971, 34.11423], [-118.48015, 34.11368], [-118.48009, 34.11316], [-118.48028, 34.11289], [-118.48147, 34.11327]]]]} | Open Access 1 | 6370 | Sepulveda Pass Open Space | 25305 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 215 | Santa Monica Mountains Conservancy 303 | State 5 | State Agency 5 | Los Angeles 6 | 153.038 | Sepulveda Pass OS | 0 | State Recreation Area 39 | 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]);