units_with_maps

Table actions

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

5 rows where DES_TP = 3, MNG_AGENCY = 326 and MNG_AG_LEV = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Murrieta, City of · 5 ✖

DES_TP 1

  • Local Recreation Area · 5 ✖

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
7468 7468 7467 {"type": "Polygon", "coordinates": [[[-117.17186, 33.58817], [-117.17183, 33.58826], [-117.17163, 33.58838], [-117.17032, 33.58931], [-117.17034, 33.58934], [-117.17035, 33.58943], [-117.17025, 33.58954], [-117.16981, 33.58985], [-117.16963, 33.59001], [-117.16933, 33.59032], [-117.16911, 33.59059], [-117.16721, 33.59059], [-117.1671, 33.58461], [-117.16875, 33.58397], [-117.16822, 33.58131], [-117.16898, 33.58084], [-117.16936, 33.58054], [-117.16969, 33.58023], [-117.1703, 33.57954], [-117.17055, 33.5793], [-117.17085, 33.57906], [-117.17128, 33.57943], [-117.17143, 33.5796], [-117.17156, 33.57979], [-117.17156, 33.58], [-117.17162, 33.5802], [-117.17165, 33.58037], [-117.17165, 33.58302], [-117.17156, 33.58303], [-117.17156, 33.58371], [-117.17161, 33.58392], [-117.17169, 33.58411], [-117.17178, 33.58427], [-117.17198, 33.58456], [-117.17208, 33.58477], [-117.17215, 33.58502], [-117.17218, 33.58522], [-117.17216, 33.58551], [-117.17209, 33.58576], [-117.17199, 33.58597], [-117.17178, 33.58631], [-117.17168, 33.58652], [-117.17162, 33.58668], [-117.17157, 33.58698], [-117.17157, 33.58729], [-117.17162, 33.58762], [-117.17172, 33.5879], [-117.17186, 33.58817]]]} Open Access 1 48447 Los Alamos Hills Sports Park 33152 1391 Murrieta, City of 329 City 2 City Agency 2 http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA City 2 1391 Murrieta, City of 326 City 2 City Agency 2   Riverside 10 100.636 Los Alamos Hills Sports Park 0 Local Recreation Area 3 4
7597 7597 7596 {"type": "MultiPolygon", "coordinates": [[[[-117.22221, 33.54749], [-117.22073, 33.54861], [-117.21897, 33.54699], [-117.21941, 33.54668], [-117.21955, 33.54662], [-117.21987, 33.54665], [-117.2202, 33.54656], [-117.22029, 33.54648], [-117.22065, 33.54637], [-117.22161, 33.54644], [-117.22161, 33.54667], [-117.2217, 33.54685], [-117.22176, 33.54708], [-117.22221, 33.54749]]], [[[-117.22279, 33.54811], [-117.22136, 33.5492], [-117.22085, 33.54874], [-117.22226, 33.54767], [-117.2223, 33.54766], [-117.22279, 33.54811]]], [[[-117.22382, 33.54626], [-117.22228, 33.54743], [-117.22191, 33.54709], [-117.22182, 33.54694], [-117.2218, 33.54683], [-117.22184, 33.54663], [-117.22178, 33.54645], [-117.22192, 33.54646], [-117.2223, 33.54634], [-117.22307, 33.54616], [-117.22355, 33.54601], [-117.22382, 33.54626]]], [[[-117.22344, 33.54591], [-117.22303, 33.54604], [-117.22264, 33.54612], [-117.22238, 33.54527], [-117.22242, 33.54525], [-117.2226, 33.54513], [-117.22344, 33.54591]]], [[[-117.22405, 33.54715], [-117.22295, 33.54799], [-117.22246, 33.54754], [-117.22248, 33.5475], [-117.22355, 33.54669], [-117.22405, 33.54715]]]]} Open Access 1 48452 Murrieta Equestrian Park 33165 1391 Murrieta, City of 329 City 2 City Agency 2 http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA City 2 1391 Murrieta, City of 326 City 2 City Agency 2   Riverside 10 20.623 Murrieta Equestrian Park 0 Local Recreation Area 3 4
10729 10729 10728 {"type": "Polygon", "coordinates": [[[-117.1804, 33.56326], [-117.18038, 33.5638], [-117.17812, 33.56374], [-117.17802, 33.5637], [-117.17809, 33.56352], [-117.17634, 33.56183], [-117.17657, 33.56166], [-117.17692, 33.56134], [-117.17717, 33.56151], [-117.17741, 33.56171], [-117.1775, 33.56165], [-117.17861, 33.56269], [-117.1804, 33.56326]]]} Open Access 1 19946 Alta Murrieta Sports Park 15418 1391 Murrieta, City of 329 City 2 City Agency 2 http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA City 2 1391 Murrieta, City of 326 City 2 City Agency 2   Riverside 10 9.771 Alta Murrieta Sports Park 0 Local Recreation Area 3 4
10739 10739 10738 {"type": "Polygon", "coordinates": [[[-117.20326, 33.57243], [-117.20225, 33.57341], [-117.20195, 33.57373], [-117.20174, 33.574], [-117.20157, 33.57426], [-117.20142, 33.57453], [-117.20127, 33.57485], [-117.20118, 33.5749], [-117.20045, 33.57472], [-117.20015, 33.57462], [-117.1999, 33.57452], [-117.1994, 33.57426], [-117.19906, 33.57404], [-117.19884, 33.57386], [-117.20118, 33.57207], [-117.20032, 33.57135], [-117.19978, 33.57111], [-117.1998, 33.57108], [-117.20135, 33.57177], [-117.20137, 33.57176], [-117.20142, 33.57136], [-117.20163, 33.57136], [-117.20326, 33.57243]]]} Open Access 1 19960 California Oaks Sports Park 16720 1391 Murrieta, City of 329 City 2 City Agency 2 http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA City 2 1391 Murrieta, City of 326 City 2 City Agency 2   Riverside 10 18.707 California Oaks Sports Park 0 Local Recreation Area 3 4
16328 16328 16327 {"type": "Polygon", "coordinates": [[[-117.21238, 33.55493], [-117.21088, 33.55607], [-117.21015, 33.55539], [-117.21164, 33.55425], [-117.21238, 33.55493]]]} Open Access 1 24646 Community Center/Hunt Field 17567 1391 Murrieta, City of 329 City 2 City Agency 2 http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA City 2 1391 Murrieta, City of 326 City 2 City Agency 2   Riverside 10 4.726 Community Ctr./Hunt Field 0 Local Recreation Area 3 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]);