units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, MNG_AG_TYP = 3 and UNIT_NAME = "Mather Regional Park"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13639 | 13639 | 13638 | {"type": "Polygon", "coordinates": [[[-121.26874, 38.53018], [-121.2687, 38.53502], [-121.26111, 38.53501], [-121.26109, 38.54475], [-121.26089, 38.54464], [-121.26088, 38.54413], [-121.25886, 38.54414], [-121.25633, 38.54454], [-121.25597, 38.54464], [-121.25564, 38.54479], [-121.25542, 38.54493], [-121.25426, 38.54579], [-121.2541, 38.54594], [-121.25402, 38.54608], [-121.25397, 38.54623], [-121.25397, 38.54664], [-121.25227, 38.54904], [-121.2513, 38.55025], [-121.25199, 38.55103], [-121.25238, 38.55116], [-121.25363, 38.55257], [-121.25416, 38.55259], [-121.25423, 38.55434], [-121.25474, 38.55457], [-121.25778, 38.55443], [-121.25843, 38.55461], [-121.25845, 38.55481], [-121.25864, 38.55486], [-121.25868, 38.55468], [-121.25898, 38.55476], [-121.25975, 38.55439], [-121.26094, 38.5544], [-121.26093, 38.55672], [-121.26216, 38.55957], [-121.26093, 38.55956], [-121.26092, 38.55945], [-121.25463, 38.5594], [-121.25465, 38.55926], [-121.25464, 38.55909], [-121.2546, 38.55895], [-121.25454, 38.55879], [-121.25444, 38.55864], [-121.25434, 38.55852], [-121.2542, 38.55839], [-121.25404, 38.55828], [-121.25374, 38.55814], [-121.25337, 38.55805], [-121.2528, 38.55794], [-121.251, 38.55763], [-121.25056, 38.5575], [-121.25019, 38.55734], [-121.24995, 38.55721], [-121.24972, 38.55706], [-121.24562, 38.55413], [-121.24536, 38.5539], [-121.24523, 38.55376], [-121.24482, 38.55281], [-121.24492, 38.55137], [-121.24467, 38.54633], [-121.24474, 38.5401], [-121.2446, 38.53844], [-121.24457, 38.52893], [-121.24472, 38.52761], [-121.24488, 38.52634], [-121.24503, 38.52572], [-121.25171, 38.52563], [-121.25181, 38.52564], [-121.26099, 38.52833], [-121.26874, 38.53018]]]} | Open Access 1 | 36000 | Mather Regional Park | 9992 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.regionalparks.saccounty.net/Parks/RegionalParksDetails/Pages/MatherRegionalPark.aspx | Sacramento 41 | 1144.635 | Mather RP | 0 | Local Park 2 | 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]);