superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 2 and PARK_URL = "https://ucnrs.org/reserves/scripps-coastal-reserve/"
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11555 | 11555 | 11554 | {"type": "Polygon", "coordinates": [[[-117.2527, 32.88267], [-117.25219, 32.88308], [-117.25093, 32.88102], [-117.25092, 32.8805], [-117.25072, 32.87991], [-117.25069, 32.8786], [-117.2482, 32.87836], [-117.2474, 32.87945], [-117.2474, 32.88002], [-117.2469, 32.88002], [-117.24693, 32.87969], [-117.24709, 32.87868], [-117.24607, 32.8791], [-117.24514, 32.87867], [-117.24523, 32.87852], [-117.2461, 32.87868], [-117.24655, 32.87781], [-117.24682, 32.87579], [-117.24672, 32.87495], [-117.24681, 32.87494], [-117.24723, 32.87426], [-117.2517, 32.8743], [-117.25132, 32.87552], [-117.2513, 32.87633], [-117.25175, 32.87822], [-117.25186, 32.8795], [-117.25195, 32.88019], [-117.25209, 32.88089], [-117.25248, 32.88219], [-117.2527, 32.88267]]]} | Restricted Access 2 | Scripps Coastal Reserve | https://ucnrs.org/reserves/scripps-coastal-reserve/ | 33194 | 217 | University of California 51 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 67.657 | Scripps Coastal Reserve |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);