units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, MNG_AGENCY = 533, MNG_AG_TYP = 2 and SUID_NMA = 24654
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13833 | 13833 | 13832 | {"type": "MultiPolygon", "coordinates": [[[[-121.26563, 38.75907], [-121.26557, 38.7593], [-121.2655, 38.75933], [-121.26527, 38.75949], [-121.26532, 38.75954], [-121.26548, 38.75949], [-121.26554, 38.75951], [-121.2656, 38.75956], [-121.2656, 38.76219], [-121.26264, 38.76212], [-121.26238, 38.76232], [-121.26236, 38.76614], [-121.26277, 38.76663], [-121.26083, 38.76664], [-121.2601, 38.76776], [-121.26007, 38.76784], [-121.26007, 38.76802], [-121.26014, 38.76828], [-121.26048, 38.76883], [-121.26044, 38.76961], [-121.26028, 38.77043], [-121.25966, 38.77028], [-121.25947, 38.77022], [-121.25929, 38.77014], [-121.25866, 38.76979], [-121.25872, 38.76979], [-121.25913, 38.76859], [-121.25831, 38.76752], [-121.25745, 38.76894], [-121.25746, 38.76946], [-121.25729, 38.76949], [-121.25656, 38.76967], [-121.2566, 38.76976], [-121.25733, 38.76959], [-121.25746, 38.76957], [-121.25746, 38.76959], [-121.25646, 38.76981], [-121.25603, 38.76986], [-121.25586, 38.76991], [-121.25581, 38.76991], [-121.25573, 38.76989], [-121.25566, 38.76979], [-121.25497, 38.76977], [-121.25568, 38.76893], [-121.25606, 38.76844], [-121.2565, 38.76781], [-121.25726, 38.76665], [-121.2574, 38.76664], [-121.25789, 38.76595], [-121.25836, 38.76526], [-121.25906, 38.76417], [-121.26115, 38.76082], [-121.26133, 38.76058], [-121.26153, 38.76035], [-121.26192, 38.76001], [-121.2623, 38.75976], [-121.26277, 38.75952], [-121.26323, 38.75935], [-121.2637, 38.75922], [-121.26419, 38.75914], [-121.26563, 38.75907]]], [[[-121.25747, 38.7696], [-121.25759, 38.76957], [-121.25774, 38.76958], [-121.2579, 38.7696], [-121.25807, 38.76965], [-121.25822, 38.76972], [-121.25931, 38.77031], [-121.25957, 38.77041], [-121.26025, 38.77057], [-121.26018, 38.77076], [-121.2601, 38.77085], [-121.26003, 38.77089], [-121.25963, 38.77103], [-121.25942, 38.77113], [-121.25923, 38.77128], [-121.25908, 38.77147], [-121.25878, 38.77197], [-121.25851, 38.77251], [-121.25829, 38.77354], [-121.25636, 38.7731], [-121.25634, 38.77292], [-121.25603, 38.77257], [-121.25652, 38.77212], [-121.25656, 38.77206], [-121.2558, 38.77165], [-121.25603, 38.77139], [-121.25627, 38.77142], [-121.25663, 38.77083], [-121.2564, 38.77022], [-121.25673, 38.77014], [-121.25661, 38.7698], [-121.25747, 38.7696]]]]} | Open Access 1 | 36423 | Roseville holding 34 | 24654 | 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 | 116.361 | Roseville holding 34 | 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]);