units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where ACCESS_TYP = 2, COUNTY = 35 and MNG_AGENCY = 533
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7658 | 7658 | 7657 | {"type": "MultiPolygon", "coordinates": [[[[-121.33318, 38.77738], [-121.33108, 38.77841], [-121.33128, 38.77895], [-121.32992, 38.7806], [-121.32992, 38.78173], [-121.32873, 38.78173], [-121.32872, 38.78055], [-121.32156, 38.78053], [-121.32156, 38.78087], [-121.31946, 38.7809], [-121.31879, 38.78159], [-121.31752, 38.78178], [-121.31706, 38.78176], [-121.3164, 38.78152], [-121.31639, 38.78104], [-121.3168, 38.78104], [-121.3168, 38.7806], [-121.31722, 38.7806], [-121.31721, 38.78027], [-121.31757, 38.78019], [-121.31786, 38.78005], [-121.31832, 38.77973], [-121.31895, 38.77946], [-121.31997, 38.77946], [-121.32051, 38.77928], [-121.32092, 38.77882], [-121.32092, 38.77742], [-121.32062, 38.77657], [-121.32031, 38.77607], [-121.32023, 38.77564], [-121.32045, 38.77546], [-121.32045, 38.77538], [-121.32093, 38.77498], [-121.32143, 38.77515], [-121.32183, 38.77515], [-121.3221, 38.77615], [-121.32251, 38.77655], [-121.32444, 38.77695], [-121.32498, 38.77669], [-121.3249, 38.77644], [-121.32469, 38.77602], [-121.32503, 38.7745], [-121.32453, 38.77439], [-121.32468, 38.77396], [-121.32476, 38.7738], [-121.32488, 38.77368], [-121.32526, 38.77338], [-121.32555, 38.77359], [-121.32614, 38.77315], [-121.32665, 38.77183], [-121.32719, 38.77085], [-121.3268, 38.77069], [-121.32705, 38.77029], [-121.32804, 38.77073], [-121.32803, 38.77237], [-121.3275, 38.77302], [-121.32701, 38.77395], [-121.32698, 38.77427], [-121.32751, 38.77437], [-121.32754, 38.77479], [-121.32806, 38.77504], [-121.32944, 38.775], [-121.32978, 38.77527], [-121.3301, 38.77531], [-121.33058, 38.77524], [-121.33095, 38.77505], [-121.33119, 38.77532], [-121.33147, 38.7756], [-121.33217, 38.77619], [-121.33252, 38.77653], [-121.33288, 38.77695], [-121.33318, 38.77738]]], [[[-121.32686, 38.77028], [-121.32641, 38.77099], [-121.32599, 38.77096], [-121.32596, 38.77099], [-121.3258, 38.77099], [-121.32524, 38.7708], [-121.32443, 38.77075], [-121.32303, 38.77032], [-121.32255, 38.77025], [-121.32223, 38.7704], [-121.3222, 38.77056], [-121.32222, 38.77062], [-121.32204, 38.77086], [-121.32161, 38.77117], [-121.32166, 38.77172], [-121.32211, 38.77178], [-121.3224, 38.77186], [-121.32331, 38.77204], [-121.32351, 38.77226], [-121.32406, 38.77263], [-121.32457, 38.77327], [-121.32485, 38.77349], [-121.3247, 38.77361], [-121.32459, 38.77376], [-121.32404, 38.77348], [-121.32353, 38.77337], [-121.32313, 38.77319], [-121.32279, 38.77313], [-121.32193, 38.77286], [-121.32157, 38.77278], [-121.32101, 38.77276], [-121.32085, 38.77268], [-121.32073, 38.77252], [-121.3205, 38.77187], [-121.32023, 38.77153], [-121.31978, 38.77114], [-121.3196, 38.77066], [-121.31904, 38.77035], [-121.31941, 38.76996], [-121.31985, 38.76957], [-121.32034, 38.76922], [-121.32088, 38.76892], [-121.32141, 38.76868], [-121.32202, 38.76846], [-121.32265, 38.7683], [-121.32326, 38.76819], [-121.32342, 38.76966], [-121.32506, 38.76974], [-121.32589, 38.76986], [-121.32631, 38.77008], [-121.32686, 38.77028]]]]} | Restricted Access 2 | 20863 | Woodcreek Oaks Golf Course | 33075 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 208.072 | Woodcreek Oaks GC | 0 | Local Recreation Area 3 | 4 | |
14290 | 14290 | 14289 | {"type": "Polygon", "coordinates": [[[-121.35845, 38.79005], [-121.35832, 38.79005], [-121.35801, 38.78987], [-121.35768, 38.78982], [-121.35753, 38.78978], [-121.35739, 38.78972], [-121.35714, 38.78957], [-121.35687, 38.78944], [-121.35657, 38.78937], [-121.3568, 38.78856], [-121.35699, 38.78751], [-121.35759, 38.78756], [-121.35844, 38.78756], [-121.35845, 38.79005]]]} | Restricted Access 2 | 44224 | School House Park | 31647 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 8.706 | School House Park | 0 | Local Park 2 | 4 | |
15649 | 15649 | 15648 | {"type": "Polygon", "coordinates": [[[-121.3511, 38.76936], [-121.35087, 38.76985], [-121.35114, 38.77007], [-121.35125, 38.77023], [-121.3518, 38.77151], [-121.35183, 38.77167], [-121.35183, 38.77183], [-121.35163, 38.77305], [-121.35152, 38.77339], [-121.35119, 38.77436], [-121.35103, 38.77453], [-121.3508, 38.77497], [-121.35097, 38.77518], [-121.35045, 38.77584], [-121.35017, 38.77592], [-121.3503, 38.77639], [-121.3487, 38.77643], [-121.34813, 38.77596], [-121.34778, 38.77596], [-121.34696, 38.77662], [-121.34565, 38.77699], [-121.34531, 38.77704], [-121.34509, 38.77697], [-121.34401, 38.77703], [-121.34354, 38.77692], [-121.3426, 38.77646], [-121.3424, 38.77648], [-121.34228, 38.77598], [-121.34223, 38.77574], [-121.34219, 38.77504], [-121.34242, 38.77501], [-121.34265, 38.77495], [-121.34418, 38.77441], [-121.34435, 38.77437], [-121.34483, 38.77434], [-121.34527, 38.77444], [-121.34545, 38.77446], [-121.34613, 38.77434], [-121.34651, 38.77432], [-121.34796, 38.77444], [-121.34819, 38.77448], [-121.34814, 38.77413], [-121.34805, 38.77409], [-121.34806, 38.77403], [-121.34803, 38.77397], [-121.34812, 38.77392], [-121.34803, 38.77332], [-121.34794, 38.77328], [-121.34795, 38.77322], [-121.34792, 38.77316], [-121.348, 38.77311], [-121.34796, 38.77278], [-121.34722, 38.7729], [-121.34694, 38.77243], [-121.34714, 38.77234], [-121.34718, 38.77226], [-121.34716, 38.77217], [-121.34742, 38.77199], [-121.34759, 38.77214], [-121.34783, 38.77198], [-121.34783, 38.77188], [-121.34791, 38.77186], [-121.34796, 38.77182], [-121.34804, 38.77185], [-121.34818, 38.7718], [-121.34835, 38.77167], [-121.34835, 38.77163], [-121.34821, 38.77149], [-121.34799, 38.77136], [-121.34781, 38.77128], [-121.34737, 38.77115], [-121.34699, 38.77117], [-121.34702, 38.77149], [-121.34681, 38.77155], [-121.3467, 38.77143], [-121.34657, 38.77135], [-121.3464, 38.7714], [-121.34645, 38.77113], [-121.34612, 38.77108], [-121.34602, 38.77115], [-121.34596, 38.77111], [-121.34588, 38.77111], [-121.34581, 38.77113], [-121.34577, 38.77117], [-121.34556, 38.77108], [-121.34495, 38.7714], [-121.34472, 38.77144], [-121.34451, 38.7714], [-121.34301, 38.77062], [-121.34263, 38.77035], [-121.34226, 38.77003], [-121.34187, 38.76999], [-121.34189, 38.76971], [-121.34183, 38.76899], [-121.34193, 38.76886], [-121.34208, 38.76876], [-121.34193, 38.76852], [-121.34204, 38.76848], [-121.34208, 38.76844], [-121.34211, 38.76839], [-121.3421, 38.76833], [-121.34206, 38.76826], [-121.342, 38.76805], [-121.34199, 38.76805], [-121.34199, 38.768], [-121.34202, 38.76797], [-121.34264, 38.76781], [-121.34311, 38.76768], [-121.34345, 38.76756], [-121.34445, 38.76715], [-121.34543, 38.76681], [-121.34557, 38.76677], [-121.34566, 38.76677], [-121.34575, 38.7668], [-121.34581, 38.76686], [-121.34593, 38.76719], [-121.34607, 38.76739], [-121.34624, 38.76754], [-121.3465, 38.7677], [-121.34723, 38.76797], [-121.34801, 38.76839], [-121.34849, 38.76859], [-121.3511, 38.76936]]]} | Restricted Access 2 | 20859 | City of Roseville Public Golf Courses | 33074 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 139.53 | City of Roseville Public GC | 0 | Local Recreation Area 3 | 4 | |
15713 | 15713 | 15712 | {"type": "Polygon", "coordinates": [[[-121.2973, 38.77105], [-121.29627, 38.77371], [-121.29594, 38.77403], [-121.29577, 38.77402], [-121.29576, 38.77359], [-121.29542, 38.77352], [-121.29546, 38.77342], [-121.29591, 38.77321], [-121.29601, 38.77268], [-121.2955, 38.77257], [-121.29562, 38.77115], [-121.29349, 38.77107], [-121.29137, 38.77075], [-121.29084, 38.77092], [-121.29032, 38.77139], [-121.28966, 38.77215], [-121.28931, 38.77274], [-121.28892, 38.77308], [-121.28835, 38.77325], [-121.28818, 38.77293], [-121.28885, 38.77244], [-121.28935, 38.77178], [-121.28959, 38.77131], [-121.28809, 38.7716], [-121.28649, 38.77128], [-121.28652, 38.77291], [-121.28546, 38.77328], [-121.28462, 38.77144], [-121.28459, 38.76955], [-121.28436, 38.76929], [-121.28281, 38.77027], [-121.28139, 38.7708], [-121.28093, 38.7708], [-121.28071, 38.77166], [-121.28002, 38.77322], [-121.27909, 38.77296], [-121.27906, 38.77121], [-121.27965, 38.77107], [-121.27963, 38.76941], [-121.27856, 38.76711], [-121.27973, 38.76678], [-121.28008, 38.76721], [-121.28113, 38.76857], [-121.28131, 38.76955], [-121.28279, 38.76867], [-121.28443, 38.76812], [-121.28496, 38.76747], [-121.28522, 38.76753], [-121.28546, 38.76755], [-121.28633, 38.76749], [-121.28662, 38.7675], [-121.28693, 38.76756], [-121.28685, 38.76785], [-121.28844, 38.76817], [-121.29064, 38.76944], [-121.2926, 38.76935], [-121.29565, 38.76984], [-121.29572, 38.76949], [-121.29698, 38.76923], [-121.2973, 38.77105]]]} | Restricted Access 2 | 29458 | Diamond Oaks Golf Course | 33092 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 121.659 | Diamond Oaks GC | 0 | Local Recreation Area 3 | 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]);