units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, ACRES = "42.189" and DES_TP = 14
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP, DES_TP
MNG_AGENCY 1
ACCESS_TYP 1
- Open Access · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13869 | 13869 | 13868 | {"type": "MultiPolygon", "coordinates": [[[[-121.26734, 38.7323], [-121.26626, 38.7326], [-121.26625, 38.73285], [-121.26643, 38.73321], [-121.26695, 38.7334], [-121.26695, 38.73389], [-121.26687, 38.73422], [-121.26683, 38.73463], [-121.26662, 38.73479], [-121.26642, 38.73489], [-121.2661, 38.73498], [-121.26588, 38.735], [-121.2656, 38.73506], [-121.26536, 38.73519], [-121.26518, 38.73538], [-121.26504, 38.7356], [-121.26456, 38.73555], [-121.26417, 38.73571], [-121.2637, 38.73577], [-121.26275, 38.73606], [-121.26275, 38.7363], [-121.26205, 38.73631], [-121.26201, 38.73654], [-121.26195, 38.73667], [-121.26189, 38.73678], [-121.26155, 38.73663], [-121.26131, 38.73684], [-121.26071, 38.73684], [-121.26006, 38.7365], [-121.26008, 38.73647], [-121.26008, 38.73646], [-121.25969, 38.73628], [-121.25954, 38.73614], [-121.25938, 38.73601], [-121.25921, 38.73594], [-121.25879, 38.73604], [-121.2587, 38.73599], [-121.25866, 38.736], [-121.2586, 38.73321], [-121.25835, 38.73203], [-121.25829, 38.73203], [-121.25828, 38.73172], [-121.25832, 38.73171], [-121.2584, 38.73192], [-121.25855, 38.73214], [-121.25874, 38.73236], [-121.25952, 38.73293], [-121.25993, 38.73321], [-121.26032, 38.73321], [-121.26032, 38.73389], [-121.26149, 38.73473], [-121.2641, 38.73471], [-121.26476, 38.73468], [-121.26522, 38.73462], [-121.26573, 38.73442], [-121.26609, 38.73404], [-121.26621, 38.73359], [-121.26577, 38.73271], [-121.26574, 38.7325], [-121.26587, 38.73238], [-121.26653, 38.73211], [-121.26708, 38.73196], [-121.26734, 38.73194], [-121.26734, 38.7323]]], [[[-121.2719, 38.73376], [-121.2719, 38.73406], [-121.27145, 38.73404], [-121.27076, 38.73392], [-121.27048, 38.73382], [-121.27028, 38.7338], [-121.27019, 38.73376], [-121.27008, 38.73362], [-121.27001, 38.73356], [-121.26982, 38.73349], [-121.2697, 38.7334], [-121.2697, 38.73335], [-121.26936, 38.73299], [-121.2688, 38.73266], [-121.26767, 38.73227], [-121.26751, 38.73229], [-121.2675, 38.73197], [-121.26792, 38.73205], [-121.26829, 38.73216], [-121.26864, 38.73226], [-121.26942, 38.73267], [-121.26975, 38.73293], [-121.26994, 38.73315], [-121.27049, 38.73359], [-121.27092, 38.73362], [-121.27126, 38.7335], [-121.27152, 38.73374], [-121.2719, 38.73376]]]]} | Open Access 1 | 36460 | Roseville holding 19 | 24637 | 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 | 42.189 | Roseville holding 19 | 0 | Local Other or Unknown 14 | 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]);