units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where LABEL_NAME = "Dr Paul J Dugan Park" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12632 | 12632 | 12631 | {"type": "Polygon", "coordinates": [[[-121.33004, 38.80349], [-121.33001, 38.80378], [-121.32951, 38.80379], [-121.3295, 38.80433], [-121.32959, 38.80456], [-121.32963, 38.80473], [-121.32929, 38.80473], [-121.32924, 38.80477], [-121.32924, 38.80497], [-121.32934, 38.80541], [-121.32933, 38.80565], [-121.329, 38.80558], [-121.32867, 38.80546], [-121.32716, 38.80474], [-121.32736, 38.80433], [-121.32762, 38.80403], [-121.32763, 38.80357], [-121.32678, 38.803], [-121.32671, 38.80301], [-121.32645, 38.80325], [-121.32646, 38.80331], [-121.32634, 38.80335], [-121.32604, 38.80315], [-121.32597, 38.80315], [-121.32549, 38.80367], [-121.32526, 38.80412], [-121.32454, 38.80436], [-121.32429, 38.80448], [-121.32406, 38.80461], [-121.32365, 38.80493], [-121.32348, 38.80511], [-121.32333, 38.8053], [-121.32283, 38.80627], [-121.3226, 38.80646], [-121.32225, 38.80658], [-121.32206, 38.8068], [-121.32204, 38.80704], [-121.32242, 38.80776], [-121.32257, 38.8078], [-121.32256, 38.80784], [-121.32257, 38.80789], [-121.32265, 38.80794], [-121.32258, 38.80806], [-121.32274, 38.80834], [-121.323, 38.80861], [-121.32324, 38.80865], [-121.32327, 38.80863], [-121.32337, 38.80866], [-121.32344, 38.80865], [-121.32351, 38.8086], [-121.32354, 38.80852], [-121.32357, 38.80848], [-121.32375, 38.80834], [-121.32381, 38.80832], [-121.32415, 38.80851], [-121.32439, 38.80861], [-121.32468, 38.80869], [-121.32494, 38.80874], [-121.32532, 38.80876], [-121.32666, 38.8087], [-121.32671, 38.80873], [-121.32672, 38.80881], [-121.32671, 38.80922], [-121.32668, 38.80928], [-121.32668, 38.80934], [-121.32673, 38.80942], [-121.32679, 38.80945], [-121.32685, 38.80946], [-121.32675, 38.80972], [-121.3268, 38.80977], [-121.32693, 38.80985], [-121.3271, 38.80988], [-121.32987, 38.80987], [-121.32987, 38.81003], [-121.32676, 38.81004], [-121.32606, 38.80908], [-121.32259, 38.80908], [-121.32238, 38.80893], [-121.32239, 38.80784], [-121.32198, 38.80731], [-121.32199, 38.80648], [-121.32291, 38.80567], [-121.32329, 38.80496], [-121.32275, 38.80452], [-121.32311, 38.80415], [-121.32451, 38.8043], [-121.32502, 38.80412], [-121.32596, 38.80303], [-121.32666, 38.80275], [-121.32756, 38.80283], [-121.32831, 38.80358], [-121.32981, 38.80359], [-121.32983, 38.80315], [-121.33004, 38.80349]]]} | Open Access 1 | 29452 | Dr Paul J Dugan Park | 18263 | 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 | 22.134 | Dr Paul J Dugan Park | 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]);