calands: superunits_with_maps: 2 rows where ACCESS_TYP = 2 and MNG

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

2 rows where ACCESS_TYP = 2 and MNG_AGENCY = 474

Search:

descending

This data as json, copyable, CSV (advanced)

Link	rowid ▼	id	map	ACCESS_TYP	PARK_NAME	PARK_URL	SUID_NMA	MNG_AG_ID	MNG_AGENCY	MNG_AG_LEV	MNG_AG_TYP	AGNCY_WEB	LAYER	ACRES	LABEL_NAME	YR_EST
12308	12308	12307	{"type": "MultiPolygon", "coordinates": [[[[-117.94984, 35.13219], [-117.94919, 35.13247], [-117.9489, 35.13268], [-117.94835, 35.13286], [-117.9477, 35.13328], [-117.94715, 35.13328], [-117.94713, 35.13315], [-117.94567, 35.13316], [-117.94563, 35.13299], [-117.94471, 35.1329], [-117.94471, 35.13281], [-117.94476, 35.1327], [-117.94507, 35.1326], [-117.94504, 35.13243], [-117.94452, 35.1326], [-117.94441, 35.1326], [-117.94434, 35.13254], [-117.94422, 35.13229], [-117.94412, 35.13222], [-117.94339, 35.13198], [-117.94354, 35.13187], [-117.94361, 35.13167], [-117.94357, 35.13137], [-117.9434, 35.13101], [-117.94349, 35.13096], [-117.9435, 35.13093], [-117.94313, 35.13091], [-117.94315, 35.13046], [-117.9433, 35.13045], [-117.94332, 35.12994], [-117.94289, 35.12993], [-117.94286, 35.13016], [-117.94264, 35.13015], [-117.94267, 35.12929], [-117.94233, 35.12925], [-117.94229, 35.12918], [-117.94098, 35.12914], [-117.94092, 35.12908], [-117.94111, 35.12886], [-117.94107, 35.12882], [-117.94142, 35.12892], [-117.94213, 35.12881], [-117.94255, 35.12865], [-117.94255, 35.1284], [-117.94247, 35.12833], [-117.94236, 35.12785], [-117.94267, 35.1275], [-117.94311, 35.12732], [-117.94325, 35.12741], [-117.94311, 35.12771], [-117.94311, 35.12797], [-117.9434, 35.12807], [-117.94384, 35.12803], [-117.94422, 35.12792], [-117.94423, 35.12764], [-117.94412, 35.12743], [-117.94501, 35.12737], [-117.94523, 35.12746], [-117.94523, 35.12762], [-117.94495, 35.12785], [-117.9449, 35.1283], [-117.94442, 35.12849], [-117.94344, 35.12858], [-117.94331, 35.1287], [-117.94334, 35.12915], [-117.94312, 35.12929], [-117.94311, 35.12953], [-117.94375, 35.12968], [-117.94381, 35.12986], [-117.9437, 35.13002], [-117.9437, 35.1302], [-117.94384, 35.13032], [-117.94437, 35.13043], [-117.9447, 35.13062], [-117.94537, 35.13076], [-117.94551, 35.13094], [-117.94554, 35.13227], [-117.94546, 35.1323], [-117.94546, 35.13232], [-117.94558, 35.13231], [-117.94562, 35.13073], [-117.94666, 35.13073], [-117.94667, 35.13027], [-117.9477, 35.13027], [-117.94772, 35.13113], [-117.9478, 35.13123], [-117.9479, 35.13128], [-117.94815, 35.1313], [-117.94902, 35.13129], [-117.94923, 35.13128], [-117.94932, 35.13125], [-117.9494, 35.13119], [-117.94944, 35.13111], [-117.94945, 35.13026], [-117.94981, 35.13026], [-117.94971, 35.13033], [-117.94965, 35.13041], [-117.94966, 35.13115], [-117.94981, 35.13116], [-117.94984, 35.13219]]], [[[-117.95983, 35.12231], [-117.95872, 35.12232], [-117.95655, 35.12177], [-117.95527, 35.12204], [-117.95512, 35.12207], [-117.95498, 35.12215], [-117.95463, 35.12234], [-117.95354, 35.12419], [-117.95339, 35.12518], [-117.95338, 35.1258], [-117.95164, 35.1258], [-117.95164, 35.12565], [-117.95169, 35.12544], [-117.95179, 35.12528], [-117.9519, 35.12516], [-117.95197, 35.12482], [-117.95181, 35.12444], [-117.95159, 35.12419], [-117.95055, 35.12353], [-117.94994, 35.12329], [-117.94971, 35.12316], [-117.94946, 35.12327], [-117.9491, 35.12355], [-117.94868, 35.12484], [-117.94847, 35.12534], [-117.94855, 35.12537], [-117.9485, 35.12583], [-117.94503, 35.12583], [-117.94502, 35.12557], [-117.94396, 35.12425], [-117.94403, 35.1234], [-117.94411, 35.123], [-117.94433, 35.12284], [-117.94497, 35.12324], [-117.94504, 35.1241], [-117.94539, 35.12444], [-117.94632, 35.12517], [-117.94734, 35.12559], [-117.94869, 35.12353], [-117.9479, 35.12314], [-117.94735, 35.12303], [-117.94684, 35.12276], [-117.94475, 35.12249], [-117.94453, 35.12244], [-117.94455, 35.12223], [-117.94535, 35.12216], [-117.94711, 35.12197], [-117.94786, 35.12211], [-117.94949, 35.12295], [-117.94995, 35.12287], [-117.95071, 35.12241], [-117.95113, 35.12266], [-117.95203, 35.12267], [-117.95237, 35.12257], [-117.95337, 35.12203], [-117.95359, 35.12186], [-117.95369, 35.12163], [-117.95483, 35.12057], [-117.95504, 35.12008], [-117.95513, 35.11981], [-117.95503, 35.1193], [-117.95497, 35.11906], [-117.9549, 35.11863], [-117.95736, 35.11868], [-117.9566, 35.11915], [-117.9566, 35.11917], [-117.95706, 35.11977], [-117.95796, 35.12056], [-117.95832, 35.12077], [-117.95915, 35.12101], [-117.95961, 35.12121], [-117.95983, 35.12121], [-117.95983, 35.12231]]], [[[-117.96166, 35.13066], [-117.96126, 35.13091], [-117.96113, 35.13092], [-117.96104, 35.1309], [-117.96099, 35.13085], [-117.96056, 35.1304], [-117.95966, 35.13056], [-117.95925, 35.13016], [-117.95911, 35.12989], [-117.95782, 35.13009], [-117.9568, 35.13035], [-117.95606, 35.13048], [-117.95568, 35.13035], [-117.95516, 35.13034], [-117.95499, 35.13029], [-117.95449, 35.12986], [-117.95416, 35.12995], [-117.95384, 35.13031], [-117.95312, 35.1307], [-117.95258, 35.13121], [-117.95206, 35.13153], [-117.95173, 35.1316], [-117.95015, 35.13225], [-117.95013, 35.13111], [-117.95031, 35.13108], [-117.95081, 35.13083], [-117.95114, 35.13004], [-117.95112, 35.13003], [-117.95094, 35.13012], [-117.95063, 35.13023], [-117.95045, 35.13028], [-117.95022, 35.13031], [-117.95015, 35.13031], [-117.95013, 35.13014], [-117.95051, 35.13009], [-117.95062, 35.13004], [-117.9507, 35.13003], [-117.95098, 35.12992], [-117.95126, 35.12971], [-117.95141, 35.12956], [-117.95159, 35.12926], [-117.95161, 35.12918], [-117.95165, 35.12888], [-117.95164, 35.12853], [-117.95162, 35.12612], [-117.95344, 35.12612], [-117.95338, 35.12702], [-117.95347, 35.12749], [-117.95333, 35.12797], [-117.95298, 35.12825], [-117.95271, 35.1286], [-117.95263, 35.12887], [-117.95265, 35.1292], [-117.95372, 35.12922], [-117.95375, 35.12895], [-117.95428, 35.12885], [-117.95586, 35.12844], [-117.95667, 35.12839], [-117.95727, 35.12848], [-117.95813, 35.12838], [-117.95863, 35.12857], [-117.95895, 35.12859], [-117.96003, 35.12813], [-117.96003, 35.12819], [-117.96011, 35.12839], [-117.9602, 35.12869], [-117.96041, 35.12912], [-117.96055, 35.12933], [-117.96083, 35.12974], [-117.96166, 35.13066]]]]}	Restricted Access 2	Tierra Del Sol Golf		33049	1041	California City, City of 474	City 2	City Agency 2	http://californiacity.com/index.html	City 2	178.183	Tierra Del Sol Golf
13175	13175	13174	{"type": "MultiPolygon", "coordinates": [[[[-117.94979, 35.1278], [-117.94897, 35.12779], [-117.9487, 35.12788], [-117.94845, 35.1281], [-117.94846, 35.13001], [-117.94782, 35.13002], [-117.94782, 35.12984], [-117.9478, 35.12855], [-117.94753, 35.12829], [-117.94728, 35.12823], [-117.94692, 35.12838], [-117.94679, 35.12856], [-117.94677, 35.12887], [-117.94677, 35.13003], [-117.94655, 35.13003], [-117.94636, 35.12998], [-117.94627, 35.12999], [-117.9462, 35.13003], [-117.94617, 35.13008], [-117.94615, 35.13017], [-117.94619, 35.13027], [-117.94625, 35.13031], [-117.94633, 35.13033], [-117.94653, 35.13028], [-117.94667, 35.13027], [-117.94667, 35.13073], [-117.94562, 35.13074], [-117.94558, 35.13233], [-117.94541, 35.13232], [-117.94554, 35.13225], [-117.94551, 35.13095], [-117.94538, 35.13076], [-117.9447, 35.13062], [-117.94436, 35.13043], [-117.94384, 35.13032], [-117.9437, 35.1302], [-117.9437, 35.13002], [-117.94381, 35.12986], [-117.94375, 35.12968], [-117.94311, 35.12954], [-117.94311, 35.12929], [-117.94333, 35.12915], [-117.94331, 35.12869], [-117.94345, 35.12858], [-117.94442, 35.12849], [-117.94489, 35.12831], [-117.94495, 35.12785], [-117.94523, 35.12762], [-117.94522, 35.12745], [-117.945, 35.12737], [-117.94413, 35.12743], [-117.94413, 35.12745], [-117.94423, 35.12764], [-117.94423, 35.12791], [-117.94384, 35.12803], [-117.94339, 35.12807], [-117.94311, 35.12798], [-117.94311, 35.12771], [-117.94325, 35.12742], [-117.9431, 35.12732], [-117.94267, 35.1275], [-117.94236, 35.12784], [-117.94247, 35.12833], [-117.94255, 35.1284], [-117.94255, 35.12865], [-117.94214, 35.12881], [-117.94141, 35.12892], [-117.94102, 35.12879], [-117.94103, 35.12755], [-117.94109, 35.12738], [-117.9412, 35.12699], [-117.94123, 35.12672], [-117.94124, 35.12613], [-117.94977, 35.12613], [-117.94979, 35.1278]]], [[[-117.94286, 35.13016], [-117.94286, 35.13018], [-117.94264, 35.13018], [-117.94264, 35.13015], [-117.94286, 35.13016]]], [[[-117.94567, 35.13316], [-117.94481, 35.1331], [-117.94404, 35.133], [-117.94334, 35.13283], [-117.94307, 35.13275], [-117.94334, 35.13215], [-117.94332, 35.13203], [-117.94339, 35.13198], [-117.94412, 35.13222], [-117.94422, 35.13229], [-117.94434, 35.13254], [-117.94441, 35.1326], [-117.94452, 35.1326], [-117.94504, 35.13242], [-117.94508, 35.1326], [-117.94476, 35.1327], [-117.94471, 35.13281], [-117.94471, 35.1329], [-117.94564, 35.13299], [-117.94567, 35.13316]]], [[[-117.94352, 35.13092], [-117.94349, 35.13096], [-117.9434, 35.13101], [-117.94331, 35.13102], [-117.9432, 35.13099], [-117.94313, 35.13092], [-117.94352, 35.13092]]]]}	Restricted Access 2	California City Central Park/Tierra Del Sol Golf		33388	1041	California City, City of 474	City 2	City Agency 2	http://californiacity.com/index.html	City 2	67.762	California City Central Park/Tierra Del Sol Golf

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE superunits_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  PARK_NAME TEXT,
  PARK_URL TEXT,
  SUID_NMA INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
    ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
    ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
    ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
    ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
    ON [superunits_with_maps] ([ACCESS_TYP]);