units_with_maps

Table actions

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

1 row where ACCESS_TYP = 2, AGNCY_NAME = 120 and DES_TP = 3

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
7408 7408 7407 {"type": "Polygon", "coordinates": [[[-117.04334, 32.65988], [-117.04285, 32.66126], [-117.0421, 32.66117], [-117.0413, 32.66018], [-117.0412, 32.66015], [-117.04094, 32.66055], [-117.04015, 32.66116], [-117.03857, 32.66186], [-117.03858, 32.66188], [-117.04059, 32.66212], [-117.0408, 32.66229], [-117.04084, 32.66253], [-117.04076, 32.6627], [-117.04062, 32.66285], [-117.04042, 32.66298], [-117.0394, 32.6633], [-117.03913, 32.66334], [-117.03859, 32.66336], [-117.03512, 32.66317], [-117.03443, 32.66331], [-117.03443, 32.66338], [-117.03373, 32.66363], [-117.03301, 32.66462], [-117.03291, 32.6647], [-117.03277, 32.66475], [-117.03263, 32.66475], [-117.0325, 32.66471], [-117.03167, 32.6642], [-117.03148, 32.66413], [-117.03126, 32.66409], [-117.03101, 32.6641], [-117.03087, 32.66414], [-117.03072, 32.66419], [-117.02943, 32.66491], [-117.02923, 32.66453], [-117.02836, 32.66501], [-117.02643, 32.66623], [-117.02661, 32.66667], [-117.02554, 32.66792], [-117.02303, 32.66863], [-117.02316, 32.66727], [-117.02417, 32.66612], [-117.02392, 32.66566], [-117.02415, 32.66546], [-117.02459, 32.66513], [-117.02715, 32.66335], [-117.0274, 32.66315], [-117.02752, 32.66308], [-117.02757, 32.66312], [-117.02804, 32.66286], [-117.0291, 32.66239], [-117.03265, 32.66094], [-117.03297, 32.66083], [-117.0334, 32.66074], [-117.03377, 32.66071], [-117.03417, 32.66071], [-117.03416, 32.66077], [-117.03466, 32.66116], [-117.03456, 32.6616], [-117.03457, 32.66161], [-117.03539, 32.66154], [-117.03567, 32.66154], [-117.03594, 32.66152], [-117.03618, 32.66147], [-117.03638, 32.66141], [-117.03682, 32.66123], [-117.03705, 32.66111], [-117.03713, 32.66119], [-117.04058, 32.65915], [-117.04032, 32.65881], [-117.04048, 32.65871], [-117.04051, 32.65874], [-117.0416, 32.65884], [-117.04165, 32.65879], [-117.04334, 32.65988]]]} Restricted Access 2 7602 Chula Vista Municipal Golf Course 33025 1056 Chula Vista, City of 120 City 2 City Agency 2 http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp City 2 1056 Chula Vista, City of 117 City 2 City Agency 2 http://www.chulavistagc.com/ San Diego 4 128.631 Chula Vista Municipal 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]);