units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 54, LAYER = 4 and MNG_AGENCY = 27
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- Mountains Recreation and Conservation Authority · 1 ✖
DES_TP 1
- National Recreation Area · 1 ✖
ACCESS_TYP 1
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 |
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]);