superunits_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

7 rows where ACCESS_TYP = 2, LAYER = 10 and MNG_AG_TYP = 20

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Non Profit - Other · 7 ✖

ACCESS_TYP 1

  • Restricted Access · 7 ✖
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
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  
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  
572 572 571 {"type": "Polygon", "coordinates": [[[-119.54118, 36.51798], [-119.54116, 36.52003], [-119.54018, 36.52002], [-119.54021, 36.51798], [-119.54118, 36.51798]]]} Restricted Access 2 Kingsburg Historical Park http://kingsburghistoricalpark.org/ 32675 3138 Kingsburg Historical Society 795 Non Profit 6 Non Profit - Other 20 http://www.kingsburghistoricalpark.org/ Non Governmental Organization 10 4.887 Kingsburg Historical Park  
4234 4234 4233 {"type": "Polygon", "coordinates": [[[-122.33796, 37.45405], [-122.33784, 37.45482], [-122.3369, 37.45579], [-122.33616, 37.45669], [-122.33589, 37.45776], [-122.33615, 37.45885], [-122.33668, 37.45965], [-122.31809, 37.47368], [-122.31806, 37.47368], [-122.3133, 37.47728], [-122.30701, 37.47208], [-122.30872, 37.47077], [-122.30803, 37.46999], [-122.30845, 37.46868], [-122.30961, 37.46678], [-122.31148, 37.46868], [-122.31435, 37.46651], [-122.3146, 37.46658], [-122.31482, 37.46659], [-122.31542, 37.46654], [-122.3156, 37.46558], [-122.33576, 37.45033], [-122.33575, 37.45149], [-122.33668, 37.45179], [-122.33796, 37.45405]]]} Restricted Access 2 Filoli Center   18900 3047 National Trust for Historic Preservation 1122 Non Profit 6 Non Profit - Other 20 http://www.preservationnation.org/ Non Governmental Organization 10 657.366 Filoli Ctr. 1975
10306 10306 10305 {"type": "MultiPolygon", "coordinates": [[[[-116.31558, 33.3251], [-116.31551, 33.33963], [-116.29816, 33.3395], [-116.29841, 33.32503], [-116.31558, 33.3251]]], [[[-116.62024, 32.8546], [-116.62023, 32.85532], [-116.61829, 32.85533], [-116.61829, 32.85491], [-116.618, 32.85491], [-116.61799, 32.85435], [-116.61875, 32.85434], [-116.61914, 32.85341], [-116.61924, 32.85343], [-116.6193, 32.85399], [-116.61991, 32.8542], [-116.6198, 32.85446], [-116.62024, 32.8546]]]]} Restricted Access 2 Unnamed site - Nonprofit Organization - Unknown   28649 3048 Nonprofit Organization - Unknown 746 Non Profit 6 Non Profit - Other 20   Non Governmental Organization 10 645.108    
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  
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  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);