units_with_maps

Table actions

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

1 row where ACCESS_TYP = 2, DES_TP = 3 and LABEL_NAME = "Torrey Pines GC"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

DES_TP 1

  • Local Recreation Area · 1 ✖

ACCESS_TYP 1

  • Restricted Access · 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
15624 15624 15623 {"type": "Polygon", "coordinates": [[[-117.25401, 32.90718], [-117.25377, 32.90874], [-117.25262, 32.90918], [-117.24994, 32.90895], [-117.24794, 32.9092], [-117.24821, 32.91061], [-117.24923, 32.91094], [-117.25048, 32.91053], [-117.25122, 32.91156], [-117.24972, 32.91275], [-117.24806, 32.91462], [-117.24673, 32.91482], [-117.24619, 32.91416], [-117.24559, 32.91285], [-117.24534, 32.91288], [-117.24527, 32.91268], [-117.24423, 32.90787], [-117.24323, 32.90302], [-117.24456, 32.90286], [-117.24504, 32.90279], [-117.245, 32.90244], [-117.24482, 32.90135], [-117.24476, 32.90057], [-117.24393, 32.90056], [-117.24393, 32.89928], [-117.24361, 32.89931], [-117.24339, 32.89538], [-117.24311, 32.89479], [-117.243, 32.89303], [-117.2429, 32.89074], [-117.24399, 32.89061], [-117.24399, 32.89004], [-117.24568, 32.89008], [-117.2485, 32.8908], [-117.24981, 32.89148], [-117.24979, 32.89123], [-117.24893, 32.89001], [-117.24905, 32.88967], [-117.24895, 32.88953], [-117.24912, 32.88945], [-117.24949, 32.88918], [-117.24956, 32.88871], [-117.24948, 32.88821], [-117.24675, 32.88752], [-117.24675, 32.88716], [-117.24929, 32.88717], [-117.24931, 32.88608], [-117.25316, 32.88609], [-117.25325, 32.88745], [-117.25336, 32.8895], [-117.25341, 32.89232], [-117.25347, 32.89308], [-117.25341, 32.89309], [-117.25342, 32.89313], [-117.25326, 32.89416], [-117.25312, 32.89498], [-117.25313, 32.89595], [-117.2531, 32.89605], [-117.25307, 32.89665], [-117.25207, 32.8971], [-117.24992, 32.89617], [-117.24919, 32.89482], [-117.24868, 32.89411], [-117.2478, 32.89401], [-117.24696, 32.89485], [-117.24697, 32.89486], [-117.24824, 32.89499], [-117.2483, 32.89632], [-117.24733, 32.89745], [-117.24658, 32.89793], [-117.24674, 32.89866], [-117.248, 32.89905], [-117.24715, 32.90058], [-117.24714, 32.90063], [-117.24882, 32.90056], [-117.24967, 32.89857], [-117.25065, 32.89747], [-117.25183, 32.89836], [-117.25235, 32.90141], [-117.25196, 32.90284], [-117.25085, 32.90429], [-117.24791, 32.90569], [-117.24852, 32.90688], [-117.24931, 32.9069], [-117.2531, 32.90488], [-117.2532, 32.90552], [-117.25401, 32.90718]]]} Restricted Access 2 12118 Torrey Pines Golf Course 33030 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 1297 San Diego, City of 4 City 2 City Agency 2   San Diego 4 484.153 Torrey Pines GC 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]);