units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where DES_TP = 132, MNG_AGENCY = 47 and YR_EST = 1979
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- California Department of Parks and Recreation · 2 ✖
DES_TP 1
- State Historic or Cultural Area · 2 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10187 | 10187 | 10186 | {"type": "Polygon", "coordinates": [[[-117.85853, 34.65237], [-117.8541, 34.65233], [-117.8541, 34.65325], [-117.84522, 34.65319], [-117.84517, 34.64597], [-117.85295, 34.64602], [-117.85297, 34.64956], [-117.85408, 34.64957], [-117.85409, 34.65141], [-117.85853, 34.65145], [-117.85853, 34.65237]]]} | Open Access 1 | 17805 | Antelope Valley Indian Museum | 1397 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.avim.parks.ca.gov | Los Angeles 6 | 161.598 | Antelope Valley Indian Museum | 1979 | State Historic or Cultural Area 132 | 4 |
16503 | 16503 | 16502 | {"type": "MultiPolygon", "coordinates": [[[[-118.61694, 34.26081], [-118.61694, 34.2613], [-118.61667, 34.26137], [-118.61641, 34.26147], [-118.6162, 34.26158], [-118.61588, 34.26177], [-118.61587, 34.26159], [-118.61481, 34.26138], [-118.61481, 34.26029], [-118.61515, 34.2603], [-118.61694, 34.26081]]], [[[-118.63273, 34.26909], [-118.63271, 34.26914], [-118.6327, 34.2694], [-118.63235, 34.26985], [-118.63184, 34.27006], [-118.63121, 34.27053], [-118.63107, 34.27118], [-118.63031, 34.27169], [-118.62991, 34.27176], [-118.62981, 34.27151], [-118.62978, 34.27128], [-118.62981, 34.27107], [-118.62984, 34.271], [-118.62989, 34.27093], [-118.62996, 34.27088], [-118.63022, 34.27075], [-118.63047, 34.27059], [-118.63057, 34.27056], [-118.6308, 34.27054], [-118.63094, 34.27049], [-118.63144, 34.27012], [-118.63178, 34.26995], [-118.63188, 34.26988], [-118.63198, 34.26977], [-118.63205, 34.26965], [-118.63208, 34.26952], [-118.63208, 34.2692], [-118.63211, 34.26914], [-118.63219, 34.26899], [-118.63228, 34.26888], [-118.63239, 34.26879], [-118.63271, 34.26864], [-118.63273, 34.26909]]], [[[-118.62962, 34.27234], [-118.62893, 34.27242], [-118.62828, 34.27213], [-118.62794, 34.27236], [-118.62792, 34.27241], [-118.62782, 34.27249], [-118.62782, 34.27121], [-118.62761, 34.2712], [-118.6278, 34.2711], [-118.62803, 34.27104], [-118.62817, 34.27104], [-118.6283, 34.2711], [-118.62876, 34.2715], [-118.62885, 34.27161], [-118.62895, 34.27179], [-118.62917, 34.27202], [-118.62935, 34.27211], [-118.62956, 34.27214], [-118.62962, 34.27234]]], [[[-118.63271, 34.26846], [-118.63228, 34.26865], [-118.63215, 34.26875], [-118.63205, 34.26886], [-118.63194, 34.26904], [-118.6319, 34.26916], [-118.63188, 34.2695], [-118.63186, 34.26958], [-118.63181, 34.26968], [-118.63174, 34.26975], [-118.63132, 34.27], [-118.63084, 34.27034], [-118.63074, 34.27038], [-118.63055, 34.2704], [-118.63038, 34.27045], [-118.6301, 34.27062], [-118.62981, 34.27077], [-118.62971, 34.27085], [-118.62962, 34.27101], [-118.62958, 34.27126], [-118.62961, 34.27149], [-118.62973, 34.27184], [-118.62971, 34.27191], [-118.62966, 34.27196], [-118.62959, 34.27198], [-118.62948, 34.27198], [-118.62941, 34.27196], [-118.62931, 34.27192], [-118.62911, 34.27169], [-118.62902, 34.27152], [-118.62887, 34.27136], [-118.62848, 34.27101], [-118.62836, 34.27094], [-118.62824, 34.27089], [-118.62804, 34.27087], [-118.6278, 34.27093], [-118.62756, 34.27103], [-118.62721, 34.27123], [-118.62702, 34.2714], [-118.62684, 34.27164], [-118.62675, 34.27174], [-118.62662, 34.27183], [-118.6264, 34.27194], [-118.62628, 34.27205], [-118.62623, 34.27213], [-118.62621, 34.27221], [-118.6262, 34.27256], [-118.62617, 34.27271], [-118.6261, 34.27287], [-118.62599, 34.273], [-118.62592, 34.27314], [-118.62587, 34.27328], [-118.62585, 34.27343], [-118.62582, 34.27354], [-118.62574, 34.27364], [-118.62566, 34.27371], [-118.62555, 34.27377], [-118.62544, 34.27381], [-118.62528, 34.27383], [-118.62513, 34.27381], [-118.62448, 34.2736], [-118.62509, 34.27343], [-118.62472, 34.27246], [-118.62362, 34.27224], [-118.62331, 34.27234], [-118.62191, 34.27233], [-118.62238, 34.27325], [-118.62244, 34.27375], [-118.62279, 34.27423], [-118.62259, 34.27429], [-118.62245, 34.27427], [-118.62218, 34.27414], [-118.62195, 34.27409], [-118.62158, 34.27409], [-118.6212, 34.27412], [-118.621, 34.27411], [-118.6208, 34.27404], [-118.62058, 34.27392], [-118.62048, 34.27385], [-118.6204, 34.27375], [-118.62036, 34.27365], [-118.6203, 34.27336], [-118.62024, 34.2732], [-118.62014, 34.27302], [-118.61999, 34.27284], [-118.61976, 34.27268], [-118.6196, 34.27262], [-118.61938, 34.27255], [-118.61924, 34.27248], [-118.61911, 34.27238], [-118.61895, 34.27215], [-118.61879, 34.272], [-118.6186, 34.27186], [-118.61841, 34.27179], [-118.61821, 34.27175], [-118.618, 34.27176], [-118.6176, 34.27183], [-118.61692, 34.27193], [-118.61662, 34.27201], [-118.61607, 34.27224], [-118.61587, 34.27231], [-118.61564, 34.27236], [-118.61524, 34.2724], [-118.61572, 34.27147], [-118.61612, 34.27122], [-118.6168, 34.27122], [-118.6168, 34.27111], [-118.61697, 34.2711], [-118.61715, 34.27104], [-118.61732, 34.27093], [-118.61742, 34.27081], [-118.61747, 34.27082], [-118.61785, 34.27077], [-118.61832, 34.27022], [-118.6199, 34.27018], [-118.6191, 34.2679], [-118.6181, 34.26791], [-118.61738, 34.26734], [-118.61718, 34.26734], [-118.61717, 34.26731], [-118.61481, 34.26733], [-118.6148, 34.26365], [-118.61526, 34.26364], [-118.61526, 34.26288], [-118.61531, 34.26284], [-118.61521, 34.26248], [-118.61562, 34.26213], [-118.61562, 34.2621], [-118.61624, 34.26172], [-118.61635, 34.26172], [-118.61664, 34.26157], [-118.61694, 34.26147], [-118.61694, 34.26401], [-118.61806, 34.26401], [-118.61928, 34.2637], [-118.61928, 34.26399], [-118.61935, 34.264], [-118.6205, 34.2637], [-118.62092, 34.26362], [-118.62087, 34.26334], [-118.62136, 34.26332], [-118.6219, 34.26334], [-118.62732, 34.26397], [-118.62944, 34.26394], [-118.62943, 34.26393], [-118.62353, 34.26325], [-118.62354, 34.26226], [-118.62411, 34.26234], [-118.6242, 34.26194], [-118.6239, 34.26154], [-118.62356, 34.26119], [-118.6234, 34.26122], [-118.62332, 34.26138], [-118.62027, 34.25826], [-118.61812, 34.25972], [-118.61706, 34.25972], [-118.61543, 34.25721], [-118.61484, 34.25721], [-118.61484, 34.2567], [-118.61916, 34.2567], [-118.61917, 34.25526], [-118.62236, 34.25526], [-118.62237, 34.25075], [-118.62195, 34.2504], [-118.62176, 34.25026], [-118.62146, 34.25008], [-118.62114, 34.24994], [-118.6208, 34.24983], [-118.6204, 34.24975], [-118.62009, 34.24971], [-118.61963, 34.24971], [-118.61982, 34.2495], [-118.62095, 34.24951], [-118.62096, 34.24964], [-118.62204, 34.24965], [-118.62205, 34.24993], [-118.6232, 34.24993], [-118.62321, 34.2501], [-118.62412, 34.2501], [-118.62412, 34.24991], [-118.625, 34.24991], [-118.625, 34.24946], [-118.63265, 34.24941], [-118.63262, 34.25305], [-118.62805, 34.25307], [-118.62803, 34.2567], [-118.62797, 34.25671], [-118.62795, 34.2585], [-118.62796, 34.25851], [-118.62932, 34.25851], [-118.6289, 34.26033], [-118.63152, 34.26032], [-118.6316, 34.26052], [-118.63173, 34.26058], [-118.6322, 34.26064], [-118.63215, 34.26088], [-118.63221, 34.26102], [-118.63255, 34.26139], [-118.63255, 34.26343], [-118.63271, 34.26846]]]]} | Open Access 1 | 11657 | Santa Susana Pass State Historic Park | 1739 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=611 | Los Angeles 6 | 682.297 | Santa Susana Pass SHP | 1979 | State Historic or Cultural Area 132 | 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]);