units_with_maps

Table actions

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

1 row where ACCESS_TYP = 2, MNG_AGENCY = 49 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 1 ✖

MNG_AGENCY 1

  • National City, City of · 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
16999 16999 16998 {"type": "Polygon", "coordinates": [[[-117.08636, 32.67074], [-117.08572, 32.67093], [-117.08582, 32.67118], [-117.08573, 32.67122], [-117.08603, 32.67197], [-117.08511, 32.67223], [-117.08447, 32.67064], [-117.0844, 32.67041], [-117.08492, 32.67018], [-117.08489, 32.67002], [-117.08482, 32.66984], [-117.08427, 32.66905], [-117.08443, 32.66849], [-117.08422, 32.66785], [-117.08404, 32.66769], [-117.08384, 32.66761], [-117.08371, 32.6675], [-117.08355, 32.66707], [-117.08333, 32.66713], [-117.08273, 32.66557], [-117.08427, 32.66427], [-117.08404, 32.66366], [-117.0844, 32.66355], [-117.08441, 32.66354], [-117.08422, 32.66306], [-117.08384, 32.66316], [-117.08331, 32.66173], [-117.08333, 32.66158], [-117.08332, 32.66141], [-117.08338, 32.66155], [-117.08402, 32.66148], [-117.08389, 32.66116], [-117.08432, 32.66108], [-117.08434, 32.66111], [-117.08484, 32.66105], [-117.08498, 32.6614], [-117.08472, 32.66148], [-117.08523, 32.66214], [-117.08519, 32.66216], [-117.08526, 32.66235], [-117.08537, 32.66232], [-117.08551, 32.66251], [-117.08534, 32.66256], [-117.08548, 32.66294], [-117.08587, 32.66283], [-117.08605, 32.66334], [-117.0857, 32.66314], [-117.08558, 32.66317], [-117.0855, 32.66323], [-117.08543, 32.66339], [-117.08537, 32.66373], [-117.08519, 32.66397], [-117.08517, 32.66406], [-117.08518, 32.66425], [-117.08503, 32.66473], [-117.08481, 32.66525], [-117.08482, 32.66527], [-117.0849, 32.66524], [-117.08476, 32.66557], [-117.08586, 32.66839], [-117.08577, 32.66839], [-117.0856, 32.66846], [-117.08555, 32.6685], [-117.08549, 32.6686], [-117.08548, 32.66869], [-117.08549, 32.66885], [-117.08552, 32.66896], [-117.0857, 32.66942], [-117.08582, 32.66962], [-117.08586, 32.66983], [-117.08587, 32.6701], [-117.08584, 32.67017], [-117.08573, 32.67028], [-117.08567, 32.67029], [-117.08566, 32.67031], [-117.08576, 32.67055], [-117.08624, 32.67042], [-117.08636, 32.67074]]]} Restricted Access 2 47891 National City Golf Course 31838 1219 National City, City of 51 City 2 City Agency 2 http://www.ci.national-city.ca.us/index.aspx?page=152 City 2 1219 National City, City of 49 City 2 City Agency 2   San Diego 4 41.144 Nat. City 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]);