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 = 49 and LABEL_NAME = "Admiral Baker GC"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

DES_TP 1

  • Recreation Management 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
15677 15677 15676 {"type": "MultiPolygon", "coordinates": [[[[-117.10566, 32.79376], [-117.10471, 32.79491], [-117.10095, 32.79737], [-117.09926, 32.79946], [-117.09919, 32.80154], [-117.09938, 32.80248], [-117.10023, 32.80247], [-117.10057, 32.80525], [-117.09796, 32.8068], [-117.09627, 32.80827], [-117.09628, 32.80812], [-117.09632, 32.80799], [-117.0964, 32.80786], [-117.09665, 32.8076], [-117.09673, 32.80748], [-117.09679, 32.80731], [-117.09688, 32.80696], [-117.09698, 32.80677], [-117.09716, 32.80655], [-117.0972, 32.80644], [-117.09722, 32.80635], [-117.09721, 32.8062], [-117.09717, 32.80608], [-117.09689, 32.8056], [-117.09685, 32.80547], [-117.09686, 32.80531], [-117.09697, 32.8051], [-117.09705, 32.80484], [-117.097, 32.8045], [-117.097, 32.80439], [-117.09705, 32.80422], [-117.09705, 32.80407], [-117.097, 32.80394], [-117.09683, 32.80359], [-117.0968, 32.80341], [-117.09682, 32.80323], [-117.09692, 32.80297], [-117.09692, 32.80282], [-117.09688, 32.80262], [-117.09684, 32.8025], [-117.09599, 32.80251], [-117.09513, 32.8006], [-117.09522, 32.79697], [-117.09603, 32.7952], [-117.10024, 32.79307], [-117.10151, 32.79253], [-117.10383, 32.79159], [-117.10383, 32.7909], [-117.10444, 32.79089], [-117.10491, 32.79081], [-117.10498, 32.79113], [-117.10499, 32.79133], [-117.1049, 32.79146], [-117.10488, 32.79161], [-117.10515, 32.79234], [-117.10517, 32.79254], [-117.10517, 32.79275], [-117.10513, 32.79294], [-117.10508, 32.7931], [-117.105, 32.79328], [-117.10502, 32.79346], [-117.10508, 32.7935], [-117.10522, 32.79349], [-117.10566, 32.79376]]], [[[-117.09604, 32.80847], [-117.09592, 32.80858], [-117.09529, 32.80942], [-117.09358, 32.81096], [-117.09346, 32.8143], [-117.09266, 32.81502], [-117.09264, 32.81504], [-117.09251, 32.81505], [-117.0881, 32.8155], [-117.08204, 32.8097], [-117.08135, 32.80787], [-117.08322, 32.8068], [-117.0853, 32.80616], [-117.09164, 32.80733], [-117.09602, 32.80672], [-117.09604, 32.80847]]]]} Restricted Access 2 12871 Admiral Baker Golf Course 31857 198 United States Department of Defense 61 Federal 1 Federal Agency 1 http://www.defense.gov/ US Military/Defense 11 198 United States Department of Defense 504 Federal 1 Federal Agency 1 https://www.golfnow.com/courses/1027561-admiral-baker-golf-course-north-course-details San Diego 4 409.719 Admiral Baker GC 0 Recreation Management Area 49 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]);