superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
7 rows where ACCESS_TYP = 2 and MNG_AG_TYP = 20 sorted by MNG_AG_ID
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12254 | 12254 | 12253 | {"type": "Polygon", "coordinates": [[[-120.13295, 34.59237], [-120.13291, 34.59524], [-120.12773, 34.5952], [-120.12768, 34.59802], [-120.12682, 34.59784], [-120.12694, 34.59711], [-120.12699, 34.59606], [-120.1268, 34.59601], [-120.12734, 34.59501], [-120.12844, 34.59417], [-120.12826, 34.59379], [-120.1283, 34.59233], [-120.13295, 34.59237]]]} | Restricted Access 2 | Santa Ines Mission Mill | http://www.sbthp.org/ | 30693 | 3372 | Santa Barbara Trust for Historic Preservation 706 | Non Profit 6 | Non Profit - Other 20 | http://www.sbthp.org/ | Non Governmental Organization 10 | 40.04 | Santa Ines Mission Mill | |
55 | 55 | 54 | {"type": "Polygon", "coordinates": [[[-117.77532, 34.12952], [-117.77504, 34.12945], [-117.77433, 34.1294], [-117.77405, 34.12932], [-117.77412, 34.12916], [-117.77405, 34.12898], [-117.77414, 34.12894], [-117.77434, 34.12867], [-117.77432, 34.1286], [-117.7742, 34.12857], [-117.77402, 34.12834], [-117.77396, 34.12824], [-117.77394, 34.12812], [-117.77421, 34.12798], [-117.77383, 34.12742], [-117.774, 34.1274], [-117.77418, 34.12741], [-117.77492, 34.12751], [-117.77483, 34.12784], [-117.77483, 34.12796], [-117.77491, 34.12831], [-117.77504, 34.12874], [-117.77512, 34.12876], [-117.77516, 34.12873], [-117.77532, 34.12952]]]} | Restricted Access 2 | La Verne Heritage Foundation | 31773 | 3382 | La Verne Heritage Foundation 888 | Non Profit 6 | Non Profit - Other 20 | https://www.laverneheritage.org/ | Non Governmental Organization 10 | 4.636 | La Verne Heritage Foundation | ||
13278 | 13278 | 13277 | {"type": "Polygon", "coordinates": [[[-121.81078, 39.71922], [-121.81078, 39.71922], [-121.8073, 39.71927], [-121.80736, 39.71921], [-121.80878, 39.71918], [-121.80878, 39.71845], [-121.81077, 39.71844], [-121.81078, 39.71922]]]} | Restricted Access 2 | Silver Dollar BMX | https://www.usabmx.com/tracks/1344/about | 33416 | 3395 | Silver Dollar BMX 929 | Non Profit 6 | Non Profit - Other 20 | https://www.usabmx.com/tracks/1344/about | Non Governmental Organization 10 | 3.943 | Silver Dollar BMX | |
440 | 440 | 439 | {"type": "Polygon", "coordinates": [[[-117.18941, 33.5381], [-117.18772, 33.53937], [-117.1867, 33.53844], [-117.18884, 33.53681], [-117.1892, 33.53738], [-117.18941, 33.5381]]]} | Restricted Access 2 | Murrieta Valley Pony Baseball | https://www.mvpb.org/ | 33498 | 3397 | Murrieta Valley PONY Baseball, Inc 992 | Non Profit 6 | Non Profit - Other 20 | https://www.mvpb.org/ | Non Governmental Organization 10 | 8.518 | Murrieta Valley Pony Baseball |
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]);