units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where LABEL_NAME = "Secret Ravine 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12642 | 12642 | 12641 | {"type": "Polygon", "coordinates": [[[-121.23375, 38.76677], [-121.23373, 38.76704], [-121.2333, 38.76698], [-121.23292, 38.76735], [-121.23232, 38.76763], [-121.2317, 38.76788], [-121.23105, 38.76811], [-121.22949, 38.76852], [-121.22919, 38.76864], [-121.22843, 38.7688], [-121.22828, 38.76894], [-121.22805, 38.76934], [-121.22789, 38.7695], [-121.2274, 38.76968], [-121.22692, 38.76968], [-121.22675, 38.76998], [-121.22677, 38.77033], [-121.22568, 38.77034], [-121.22612, 38.76974], [-121.2261, 38.76952], [-121.22446, 38.76905], [-121.22456, 38.76889], [-121.2247, 38.76876], [-121.22482, 38.76862], [-121.22494, 38.76845], [-121.22497, 38.76835], [-121.22497, 38.76821], [-121.22493, 38.76808], [-121.22472, 38.76779], [-121.22505, 38.76765], [-121.22532, 38.76804], [-121.22568, 38.76821], [-121.22575, 38.76826], [-121.22585, 38.76841], [-121.22598, 38.76882], [-121.22593, 38.76886], [-121.22621, 38.76924], [-121.22715, 38.76899], [-121.2277, 38.76851], [-121.22791, 38.76837], [-121.22838, 38.76813], [-121.22865, 38.76804], [-121.22891, 38.76798], [-121.23007, 38.7678], [-121.23105, 38.76724], [-121.23083, 38.76692], [-121.23118, 38.76679], [-121.23147, 38.76718], [-121.23193, 38.76712], [-121.23215, 38.76691], [-121.23228, 38.76661], [-121.23231, 38.7665], [-121.23236, 38.76643], [-121.23263, 38.76653], [-121.23299, 38.76663], [-121.23335, 38.76671], [-121.23375, 38.76677]]]} | Open Access 1 | 29469 | Secret Ravine Park | 25281 | 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 | 18.508 | Secret Ravine 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]);