superunits_with_maps

Table actions

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

9 rows where MNG_AGENCY = 291 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 9 ✖

MNG_AGENCY 1

  • Los Alamitos, City of · 9 ✖

ACCESS_TYP 1

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
508 508 507 {"type": "Polygon", "coordinates": [[[-118.07687, 33.80434], [-118.07686, 33.8046], [-118.07673, 33.8046], [-118.07672, 33.80434], [-118.07687, 33.80434]]]} Open Access 1 Roberts Park https://cityoflosalamitos.org/recreation/events-facilities/facilities/parks-shelters/ 33515 1185 Los Alamitos, City of 291 City 2 City Agency 2 http://cityoflosalamitos.org/ City 2 0.094 Roberts Park  
5849 5849 5848 {"type": "Polygon", "coordinates": [[[-118.05595, 33.80071], [-118.05595, 33.80122], [-118.05562, 33.80122], [-118.05562, 33.80071], [-118.05595, 33.80071]]]} Open Access 1 Labourdette Park   20816 1185 Los Alamitos, City of 291 City 2 City Agency 2 http://cityoflosalamitos.org/ City 2 0.43 Labourdette Park  
6047 6047 6046 {"type": "Polygon", "coordinates": [[[-118.06303, 33.80332], [-118.06302, 33.80439], [-118.06143, 33.80437], [-118.06144, 33.80324], [-118.06294, 33.80323], [-118.06303, 33.80332]]]} Open Access 1 Laurel Park   21100 1185 Los Alamitos, City of 291 City 2 City Agency 2 http://cityoflosalamitos.org/ City 2 4.625 Laurel Park  
6267 6267 6266 {"type": "Polygon", "coordinates": [[[-118.0632, 33.79743], [-118.06318, 33.79926], [-118.06207, 33.79925], [-118.06212, 33.79687], [-118.0632, 33.79743]]]} Open Access 1 Little Cottonwood Park   21336 1185 Los Alamitos, City of 291 City 2 City Agency 2 http://cityoflosalamitos.org/ City 2 5.884 Little Cottonwood Park  
6590 6590 6589 {"type": "Polygon", "coordinates": [[[-118.069, 33.78494], [-118.06871, 33.78512], [-118.06894, 33.78539], [-118.06876, 33.78549], [-118.06852, 33.78522], [-118.06761, 33.78578], [-118.06762, 33.78493], [-118.069, 33.78494]]]} Open Access 1 Orville Lewis Park   23228 1185 Los Alamitos, City of 291 City 2 City Agency 2 http://cityoflosalamitos.org/ City 2 1.686 Orville Lewis Park  
7541 7541 7540 {"type": "Polygon", "coordinates": [[[-118.08093, 33.80552], [-118.07931, 33.80672], [-118.07818, 33.80671], [-118.07815, 33.80669], [-118.07818, 33.80571], [-118.07801, 33.80569], [-118.07802, 33.80503], [-118.07818, 33.80502], [-118.07818, 33.8046], [-118.0802, 33.8046], [-118.08035, 33.80468], [-118.08071, 33.80484], [-118.08081, 33.80492], [-118.08084, 33.80498], [-118.08093, 33.80552]]]} Open Access 1 Oak Academy Park   22955 1185 Los Alamitos, City of 291 City 2 City Agency 2 http://cityoflosalamitos.org/ City 2 12.256 Oak Academy Park  
8460 8460 8459 {"type": "Polygon", "coordinates": [[[-118.06529, 33.80004], [-118.06507, 33.80004], [-118.06506, 33.79953], [-118.06529, 33.79953], [-118.06529, 33.80004]]]} Open Access 1 Sterns Park   25836 1185 Los Alamitos, City of 291 City 2 City Agency 2 http://cityoflosalamitos.org/ City 2 0.295 Sterns Park  
9783 9783 9782 {"type": "Polygon", "coordinates": [[[-118.07043, 33.8054], [-118.07043, 33.80554], [-118.06993, 33.80554], [-118.06994, 33.8054], [-118.07043, 33.8054]]]} Open Access 1 Soroptimist Park   25629 1185 Los Alamitos, City of 291 City 2 City Agency 2 http://cityoflosalamitos.org/ City 2 0.179 Soroptimist Park  
9912 9912 9911 {"type": "Polygon", "coordinates": [[[-118.06897, 33.81678], [-118.06835, 33.81747], [-118.06758, 33.81747], [-118.06842, 33.81706], [-118.06897, 33.81678]]]} Open Access 1 Stansbury Park   25791 1185 Los Alamitos, City of 291 City 2 City Agency 2 http://cityoflosalamitos.org/ City 2 0.676 Stansbury Park  

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