units_with_maps

Table actions

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

9 rows where COUNTY = 3, LAYER = 2 and MNG_AGENCY = 291

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Los Alamitos, City of · 9 ✖

DES_TP 1

ACCESS_TYP 1

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
956 956 955 {"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.80503], [-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 6025 Oak Academy Park 22955 1185 Los Alamitos, City of 295 City 2 City Agency 2 http://cityoflosalamitos.org/ City 2 1185 Los Alamitos, City of 291 City 2 City Agency 2   Orange 3 12.254 Oak Academy Park 0 Local Park 2 4
3524 3524 3523 {"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 20594 Stansbury Park 25791 1185 Los Alamitos, City of 295 City 2 City Agency 2 http://cityoflosalamitos.org/ City 2 1185 Los Alamitos, City of 291 City 2 City Agency 2   Orange 3 0.677 Stansbury Park 0 Local Park 2 4
5152 5152 5151 {"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 24598 Little Cottonwood Park 21336 1185 Los Alamitos, City of 295 City 2 City Agency 2 http://cityoflosalamitos.org/ City 2 1185 Los Alamitos, City of 291 City 2 City Agency 2   Orange 3 5.885 Little Cottonwood Park 0 Local Park 2 4
5363 5363 5362 {"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 5684 Laurel Park 21100 1185 Los Alamitos, City of 295 City 2 City Agency 2 http://cityoflosalamitos.org/ City 2 1185 Los Alamitos, City of 291 City 2 City Agency 2   Orange 3 4.625 Laurel Park 0 Local Park 2 4
11912 11912 11911 {"type": "Polygon", "coordinates": [[[-118.069, 33.78494], [-118.06871, 33.78511], [-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 24513 Orville Lewis Park 23228 1185 Los Alamitos, City of 295 City 2 City Agency 2 http://cityoflosalamitos.org/ City 2 1185 Los Alamitos, City of 291 City 2 City Agency 2   Orange 3 1.681 Orville Lewis Park 0 Local Park 2 4
12630 12630 12629 {"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 48794 Roberts Park 33515 1185 Los Alamitos, City of 295 City 2 City Agency 2 http://cityoflosalamitos.org/ City 2 1185 Los Alamitos, City of 291 City 2 City Agency 2 https://cityoflosalamitos.org/recreation/events-facilities/facilities/parks-shelters/ Orange 3 0.094 Roberts Park 0 Local Park 2 4
12883 12883 12882 {"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 30334 Labourdette Park 20816 1185 Los Alamitos, City of 295 City 2 City Agency 2 http://cityoflosalamitos.org/ City 2 1185 Los Alamitos, City of 291 City 2 City Agency 2   Orange 3 0.43 Labourdette Park 0 Local Park 2 4
12884 12884 12883 {"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 30335 Soroptimist Park 25629 1185 Los Alamitos, City of 295 City 2 City Agency 2 http://cityoflosalamitos.org/ City 2 1185 Los Alamitos, City of 291 City 2 City Agency 2   Orange 3 0.179 Soroptimist Park 0 Local Park 2 4
12885 12885 12884 {"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 30336 Sterns Park 25836 1185 Los Alamitos, City of 295 City 2 City Agency 2 http://cityoflosalamitos.org/ City 2 1185 Los Alamitos, City of 291 City 2 City Agency 2   Orange 3 0.295 Sterns Park 0 Local Park 2 4

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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